Extensive Training for SQL—Basics to Advanced
Live instructor-led
5 Days/Lecture & Lab
Local Classroom and Virtual Anywhere
Guaranteed-to-Run
SQL Basic to Advanced—Virtual and In-Person
What you’ll learn:
- Master the basics of relational concepts and data retrieval with SQL.
- Get SQL experience with hands-on workshops, including Db2 for z/OS and Oracle Database.
- Learn how to code queries from simple to intermediate complexity and retrieve data.
- Solve complicated problems with SQL and learn how to read pre-written code.
Upskill in SQL by learning about set processing, advanced grouping, table expressions, recursion and more
Enroll in This Course
Dates:
OCT 24 - 28 10:00 AM - 5:00 PM ET
$2,995.00 USD Add to Cart
JAN 9 - 13, 2023 10:00 AM - 5:00 PM ET
$2,995.00 USD Add to Cart
JAN 9 - 13, 2023 10:00 AM - 5:00 PM ET
$2,995.00 USD Add to Cart
MAY 1 - 5, 2023 10:00 AM - 5:00 PM ET
$2,995.00 USD Add to Cart
MAY 1 - 5, 2023 10:00 AM - 5:00 PM ET
$2,995.00 USD Add to Cart
Companies that took this course
Additional Course Details
Prerequisites
There are no prerequisites for this course.
Audience
This course is designed for programmers, analysts, database administrators, end users, and IT managers. You should work with data stored in a relational database.
Topics Covered
- 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
Save 20% On Your First Course
Upskill and save when you enroll in your first course.
The IT Training Provider Trusted by By Fortune 500 Business Leaders
1,112,426+
IT professionals upskilled with ProTech
30 Years
Providing leading IT training
1,500+
Courses to level up your knowledge
Fortune 500
The go-to IT training choice for 60% of Fortune 500 companies