SQL Programming ... 4 days

Structured Query Language (SQL) is the standard for accessing data in relational databases. Now, in just four days, you can become fluent in this indispensable language. Our training emphasizes the use of SQL to solve nontrivial business problems by ‘thinking in SQL.’ Our strategy is to teach syntax early and then concentrate on applying SQL to business questions.

Creative Data’s SQL Programming class includes a suite of hands-on lab exercises that reinforce the concepts and technology. You learn from professionals with real-world experience developing and enhancing applications using SQL. You work at your own computer connected to a relational database.

At the completion of the labs, you’ll have worked with all the major concepts and tools of SQL. You’ll leave the course able to use SQL to generate business intelligence as you retrieve data, create queries, generate reports, and program applications.

Course Topics
• The nonprocedural nature of SQL - Getting used to it!
• Simple queries - THE SELECT statement
• Data types
• Expressions
• Row filters - The WHERE clause
• Joins - Inner and outer
• Subqueries
• Aggregation - The GROUP BY clause
• Advanced and complex queries
• Stored procedures and temporary tables

Who Should Take this Class?
This class is for business analysts and system developers who want to raise their knowledge of SQL to an expert level. Prerequisites include a working knowledge of databases and some programming experience (Visual Basic, VBScript, or Microsoft Access, for example).

What Do You Take Home?
Participants in Creative Data’s SQL training receive a bound copy of the course presentation materials, including the lab exercises and answers. They also keep all SQL code they created in the labs.

Go to the detailed course outline.

Contact us to schedule a class. We offer public classes at our locations, or private on-site classes at your location.

Why learn about technology from a consulting company?