Hi, since yesterday, I even wrote my final exam and have found very little on the internet to prepare, here are some tips to prepare:
things you should know: GH1 FIAE:
The most important leading to 80% in the tests are found in the GH1 databases and SQL queries. The components of databases is (also a simplified version in GH2 ones):
ER model with N to M or 1 to N relationship
Datenbankmodelierung with / without drawing of cardinalities, identification of Primary Key and Foreign Key. For databases, it is sometimes specified that it extends only to the PK and FK draw in no attributes, if you can survive this, it cost you in the exam time, so read well.
select multiple columns defined in 1ner or more tables
Where clauses can can associate with Between's, Like's, and's
triage of meheren tables 
Group by / order by ASC / DESC
insert into 
insert into from another table update
delete from
- drop
- if subselect
- EPK
- flowchart
- activity diagram
- UML / Class Diagram
- sequence diagram use case diagram
- or also called use-case diagram.
- One of these diagrams and models is always there, so it is an advantage if you currently rules this
- from the FF and "Paint on" can. It is also helpful just to go through the tests times, and then look at the solutions, because there you can see what the Chamber of Commerce and Reviewed
- what these respects.
- additional knowledge (coming too so in GH2!)
- pseudocode
- structured program schedule (PAP)
- tasks take. Also, should you have Intus like a structure chart is set up or PAP and pseudo code is written, as it occurs during the test time you have all this taking to
- only in memory.
- GH2 FIAE / FISI:
- is often in these parts of the examination before:
- network
- here it is useful to you some audit tasks to view and indicated there
costing
- -> + - * / and you should already know all great:)
- computing tasks
- Used as storage , an online UPS, subnetting, keeping power consumption of storage media, etc. Some of these tasks are fairly simple, others are in turn difficult.
- WARNING: when information is likely to MB with 1000 MiB are 1024 the size! (You'll even see it in the computational tasks), if you do not know the difference, inform you so that you are aware of the MB! = MiB is
SQL
mentioned above
- database modeling
- here to ask questions such as: speed of WLAN
- What the 1000 base CX cables etc.
- AND: normally be asked questions not already taken turn again, but rarely are of earlier tests similar questions turn brought (GH1 and GH2 I mean)
- GH3 FIAE / FISI: The best and only risky wircklich much meaning to the tip I can give you:
- achja and often moves on to an income tax bill, which will be good to look at how your gross wages calculated and of the net as it can be calculated, which can bring you good points
- total of tips.
- the IT manual is your friend
- You will prepare to 2 years, the IT manual bought? Do not be selfish and buy yourself time before the test came out the new IT Catalogue, which should be 30 € about it you are wircklich
- I can say from personal experience that two years elapse between the manuals, bring many changes, for example, owns
- IT Manual 2007 vs 2009 2007 no
- mentioned above
- diagrams
- English
- book tasks:
- WISO do the tests of previous years by, over and over again, it comes to 90% of the same material turn of the previous years (but that will recognize yourself in the competitions you are going through) ;
- value. Why?
2007 has not many definitions of terms such as integrity / authenticity, etc.
2007 has many plot (as mentioned above), and if one is inside, then no picture or an exact explanation
2007 has newer hardware components such as USB 3.0 or not Blueray
- So you see!, a new purchase is worth the 30 € are really worth it.
- etc.
- better overview
faster retrieval of pages
one may label the flags (eg so you can write down their own definitions, as one might call the subject, for example, instead of WLAN / Ethernet -> network components or so)
you make yourself familiar with the book
- social studies
- Yellow = SQL
- etc.
- most importantly, when you think of the final examinations previous years by working, participating
- different colors of the flag to emphasize several Group?
- Green = Blue = Business
but see what is stated in the letter from the Chamber of Commerce!, Usually you are allowed only in Part 1 and
Part 2 of the IT manual use and in part 3 (Economic and Social Studies) not!
- forget the calculator does not
- there are usually 1-2 tasks that can only be solved with a calculator, unless of course you are a total
- Math Brain and do not need a calculator:). Also in: Watch what is stated in the letter of Chamber of Commerce, usually only one Netzunabhäniger unprogrammable and calculators are used
- !
- les questions announced prefer twice so that you do not forget anything about crashes
- an instruction step wegzustreichen (GH1 and GH2) provided that where is
- diagrams I would first draw on the concept paper and then on the sheet
- If you believe in a task hanging and despair: editing rather the next and labeled you that you that still have not filled
- participating with you a clock, this year s with me as the remaining time is not
hollow enough sleep
eat breakfast a clever
organizing Stickerwust not in your book up (so you fear your own sticker because you have to not durchsteigst)
write properly, everything that can not read the IHK -> false
- most important laws: the benefit of the doubt that a question is wrongly formulated or vague, and basically you give the correct answer is given you the points (not in doubt for the trainee / examinee)
- Forget your first name / last name / UUT GH1/GH2/GH3 entered on the front (normal white top, where in the header)
auchmal do a test run with the clock, before you take 90 for GH1, GH2 90 for before and 60 minutes for GH3 and see how you Time pakst it (possibly other times depending on what is on the invitation of the Chamber of Commerce)
phones make up during the exam!
Better a few more Kullis (if I know no fillers may be used!) With you if one gives up the service and a set square and ruler for drawing
- not until 1 week before the test, the study outset, then, pretty close to, 2 weeks, it should already sein, jeden tag 1-3 Stunden sollte schon drinnen sein, aber wichtig: Falls du nicht mehr kannst, mach lieber Pause und mach am nächsten Tag weiter, nicht alles in deinen Kopf reinprügeln, dass ist sinnfrei(meine Meinung).
- UND DAS WICHTIGSTE: Alle Angaben die ich hier mache müssen nicht Zutreffen, es sind Tipps von meiner Seite, wie ich es gemacht habe, keiner kann sich auf diese Tipps Berufen oder mich Anklagen dass ich falsche Informationen gegeben habe, dies hier soll nur eine Leitlinie für euere bevorstehende Prüfung sein und kein: "Der hat das aber so geschrieben also muss es richtig sein Gesetz"
- Alle Rechtswege sind hiermit ausgeschlossen, ich übernehme keinerlei Haftung für my given information as it correctly during the creation of my knowledge was.
- way ... all spelling mistakes must be kept:) I hope you have
- make the audit appear a bit easier, just ask for a comment here and share among them.
- mfg
- Graphefruit
