BOOTCAMP: Relational Database Design
Posted on March 6, 2008 by Univ.-Doz. Dr. Schneider
Filed Under Bootcamps, Certification acc. to ISO/IEC 17024, IITAC Bootcamps, Live Bootcamp, Software Development, Software Engineering, Training
| May 15, 2008 9:00 am | to | May 16, 2008 4:00 pm |
| July 17, 2008 9:00 am | to | July 18, 2008 4:00 pm |
| September 4, 2008 9:00 am | to | September 5, 2008 4:00 pm |
| November 13, 2008 9:00 am | to | November 14, 2008 4:00 pm |
Attempting to create a database for your application without understanding the relational model or foundations is like driving a car during rush hour without ever learning how to drive. Sooner or later, you will crash. This course lays the foundations of relational database design, the basics and foundational principles of a solid database. You will learn about:
- Logical data modeling and sound design
- Building blocks of a relational database
- Normalizing your data
- Keys, indexes, views, stored procedures
- Field specifications, table relationships
- Business rules and data integrity
- Avoiding mistakes and troubleshooting
If you have little or no experience with database design and need to create a database for your application, this class should be a requirement.
How You Benefit
The demand for SQL developers as highly increased during the recent past years, leading toward a more recognised profession. Software developers are highly regarded in the world of IT, with an ever-growing need for more qualified and experienced experts. Getting a better-understanding of the inner workings of the software system and application-level debugging is time-saving during software development. Knowing how to find more detailed information about bugs and solving them yourself, giving you the knowledge to draw more accurate conclusions based on programming knowledge rather than seeking the web for an hypothetical answer. By getting training with real-world problems and the latest tools and techniques, you will stay a step ahead of the others when competing for the same position. SQL will always an ace in your sleeve that will be used on a day-to-day basis quite rapidly.
How the Course is Run
This course is by no means a 2-day lecture. Instead, you will be engaged in a number of individual and group hands-on exercises to reinforce and solidify everything that is taught in the class. Some of the exercises are held in a competitive nature, followed by class discussion to pin point elegant approaches and solutions that various individuals or groups may have used. Despite the fact that the course is held in Italy, Germany or Canada, take home exercises will be available for the type-A personalities attending the course. The course can be available in alternate languages depending on the selected location.
What’s Included
- 2 Days of Expert Instruction from a senior instructor with real-world experience and deep knowledge of course content.
- Guaranteed small class size (less than 12 Students), you get an intimate learning setting not offered at any of our competitors.
- IITAC Development DVD. Includes every program covered in the course for at home study, development tools, Reverse Code Engineering Tools, training files.
- Snacks and refreshments included.
- IITAC Certified Relational Database Professional exam fees for the certification according to ISO/IEC 17024.
- Lecture and Lab Exercises.
Who Should Attend
If you are interested in the field of software development, want to learn how to dissect problems and algorithms, search for security vulnerabilities and bugs, want to discuss cutting edge technologies, techniques and ideas then this class is for you.
Learning Environment
Against to direct class materials, slides and hands-on exercises, students will have many opportunities to engage in one-on-one questions with instructors. Students get trained the practical way with intensive supervision. As students bring their own laptop, work done during the bootcamp gets not lost. Furthermore, students will be divided into groups by experience to foster student-student knowledge transfer as well.
What to bring
Students must bring their own laptop running an installation of Linux, Microsoft® Windows® 2000, XP, Vista or 2003 either natively or within a virtual machine. Students should have Delphi installed. VMWare Desktop with already configured Windows and Linux virtual machines is optional. All other tools will be provided for the students in the class room. Prospective students should be comfortable operating Microsoft Windows and have a basic understanding of programming concepts.
Pricing
Bootcamp pricing is 1.199 Euro per Person. Minimum of 5 participiants, maximum of 12 participiants.

