Course Description
In this 5-day SQL basics to advanced bootcamp training, students come prepared to learn the Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course.
The training begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops. Examples and workshops are provided for multiple platforms such as Microsoft SQL Server, Azure SQL, Oracle Database and PostgreSQL. Differences between the RDBMSs are highlighted throughout the material and especially the SQL workshops. After the first three days, students will have the ability to code queries involving simple to intermediate complexity.
The last two days are more advanced and take you to the next level to become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you. Come prepared to master the Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. We begin with a review of joins and move quickly to more complex operations involving set processing, advanced grouping, table expressions, recursion and more.
18 Module Course Outline Below
Course Summary
| Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Audience | Programmers, Analysts, Database Administrators, End Users and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database. |
| Available Formats |
|
Course Modules
Agenda
- Introduction
- SQL and Relational Databases Overview
- SELECT Statements
- SELECT WHERE Clause Operators
- SELECT ORDER BY Clause
- SQL Case Logic
- SQL Built-in/Supplied Functions
- SQL Aggregate Functions/Group By, Having Clauses
- Insert, Update, Delete, Merge, Truncate Statements
- Inner/Outer Joins
- Basic Subqueries
- Review Inner/Outer Joins
- Subquery Table Expressions
- Set Operations
- Advanced Grouping with the CUBE, ROLLUP and GROUPING SETS Extensions
- Solving Complex Problems with SQL
- PIVOT and UNPIVOT Operations
- Using Temporary Tables and Views
Testimonials
“Without a doubt one of the best professional development courses I’ve taken. I would highly recommend.”
★★★★★
- Blaine Clark, KPERS
“The trainer was INCREDIBLE. He was extremely passionate, made sure to consistently ask if anybody needed help, logged on early to answer any questions, and was an overall great human being.”
★★★★★
- Salvatore, Hilton Grand Vacations
“Mahesh was an EXCELLENT trainer. Very gifted instructor. Able to clearly communicate and teach objectives. Very engaging made you want to keep learning, and was so patient and kind to all students. Would love to be taught by him anytime.
★★★★★
- Jackie Calvo, Quality Improvement Manager, Horizon Health Center
