BOOTCAMP: Introduction to SQL Programming
Posted on March 6, 2008 by Univ.-Doz. Dr. Schneider
Filed Under Bootcamps, IITAC Bootcamps, Live Bootcamp, Software Development, Software Engineering, Training
| August 13, 2008 9:00 am | to | August 16, 2008 4:00 pm |
| October 15, 2008 9:00 am | to | October 18, 2008 4:00 pm |
SQL (Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management. SQL is a standard interactive and programming language for querying and modifying data and managing databases. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. The core of SQL is formed by a command language that allows you to retrieve, insert, update, and delete data, and perform management and administrative functions. SQL also includes a call-level interface (SQL/CLI) for accessing and managing data and databases remotely.
Day 1 - Introduction to SQL
- Understanding Relational Databases
- Designing a database
- Understanding data entities and relationships
- Guidelines for Normalization in design
- Creating the database and objects with SQL
- Understanding SQL syntax
- Creating tables and indexes
- Understanding SQL-92 constraints
- Modifying and deleting databases and objects
- Populating databases
- Modifying and deleting existing data
Day 2 - SQL - Selecting and Presenting Data
- Elements of a select statement
- Narrowing down specific selections
- Sorting your query results
- Eliminating duplicate rows
- Aggregates
- Grouping data
- Null values
- Working with multiple tables
- Joins and their uses
- Working with joins
Day 3 - SQL: Structuring Queries & Views
- Understanding subqueries, their need and how they work
- Joins vs. Subqueries - Know the difference
- Stick to the rules
- Evaluating different return values with subqueries
- Nesting of queries
- Introducing Views and their advantages
- Understanding how views work
- Modifying data through views
- Copying data
- Administration pitfalls
Day 4 - SQL - Real Business Solutions
- Database Management in the Real World
- Data security issues
- Transaction processing and handling
- Performance considerations
- Maintaining data integrity
- Formatting data for reports
- Understanding patterns
- Complex joins and subqueries
- Common mistakes, how to spot them and avoid them
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 4-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
- 4 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 Software Development Professional (SQL) 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.799 Euro per Person. Minimum of 5 participiants, maximum of 12 participiants.
Comments
-
News
-
Security Labs Blog
-
Damn Vulnerable Linux
-
Get in touch
-
Get your free copy!
-
Security Consulting
IITAC offers additional services such as Secure Software Development, Binary Auditing, Copy Protection, Digital Rights Management, Security Concepts and Security Consulting!Scientific Hacking™
Go far beyond classical ethical hacking! Instead of using tools only look under the hood, instead of making multiple choice tests only get certified by true practical assessments!IDA Pro Training
Get trained to analyze malware, vulnerability or copy protections with the no. 1 binary analysis tool IDA Pro!
Cognitive Debugging™
The debugging skill of the programmer is probably the biggest factor in the ability to debug a problem, but the difficulty of software debugging varies. Cognitive Debugging™ trains debugging with respect to brain and mental abilities! Both combined result is most powerful debugging results!Action-based Training™
IITAC professional bootcamps enhances your qualification. We provide courses, seminars, trainings and workshops in the field of IT Security, Secure Software Engineering and Software Engineering. Online training activities are supported by training videos or live online events.Certification acc. ISO 17024
Get certified according to ISO/IEC 17024 100% online! No need to travel around! Learn whenever you want, where you want! Get certified home exercise like… without time pressure!