SQL Basic to Advanced

Extensive Training for SQL—Basics to Advanced

Improve your data management skills with Structured Query Language (SQL) training—from the basics to advanced skills development.
  

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.
  • Learn how to integrate concepts from IT best practices such as Lean, Agile and DevOps.
  • 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

 

Live instructor-led

5 Days/Lecture & Lab

Local Classroom and Virtual Anywhere

Guaranteed-to-Run

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 Up to 20% Off 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

Fortune 500

The go-to IT training choice for 60% of Fortune 500 companies

1,500+

Courses to level up your knowledge

Related Courses

See What Our Clients Say

Expand your IT skill set when you learn from ProTech Training.

Terrific course! Efficiently presents SQL programming in a clear and methodical manner, with a strong focus on those techniques most useful for reporting and application development.

Travis C.

I have got to learn a lot of new SQL functionalities with this course. The work out examples provided by the instructor helps a lot to practice. The additional comments in the examples were really helpful. The instructor is really knowledgeable and was patient enough to get back to our doubts.

Dhanya S.

 
 
 

Companies That Have Worked With Us

client logoclient logoclient logoclient logo
PT27354
Summary
Come prepared to learn the Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. The course 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 Db2 for z/OS, Db2 for Linux, Unix & Windows, Oracle Database, Microsoft SQL Server, and PostgreSQL. Differences between the RDBMSs are highlighted throughout the material and especially the SQL workshops. Students will leave with the ability to code queries involving simple to intermediate complexity. Get ready to go to the next level with the Structured Query Language (SQL) and 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. Each topic is reinforced with hands-on workshops. Examples and workshops are provided for multiple platforms, such as Db2 for z/OS, Db2 for Linux, Unix & Windows, Oracle, SQL Server or PostgreSQL, with discussion of the relevant differences.
Prerequisites
There are no prerequisites for this course.
Duration
5 Days/Lecture & Lab
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.
Topics
  • 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

Related Scheduled Courses