SQL Courseware

Find your courseware here to deliver great SQL classes.

Our catalog is constantly updated, but if you don’t find what you’re looking for, let us know and we’ll try to find it.

Introduction to SQL Databases

Introduction to SQL Databases (10985WV)

2 days

This 2-day entry-level course examines the services and features of Microsoft SQL 2022. The content focuses on database tables, adding and changing data, creating and using stored procedures, entity relationships, and indexes. 

There are instructor materials available for this course. 

Audience profile 

This course is designed for novices and professionals who are interested in interacting with databases using the SQL language. This audience typically includes people who are moving into a database role or expect their role to require interacting with a database server that uses SQL. As an introductory course, it doesn’t require any previous knowledge of SQL, databases, …

SQL Server Integration Services

SQL Server Integration Services (55321AC)

5 days

The SQL Server Integration Services (SSIS) course provides a comprehensive overview of SSIS, a powerful data integration and workflow application platform for SQL Server. Students will learn to use the Import/Export Wizard, work with solutions and projects, understand basic control flow, and explore common tasks. The course delves into data flow sources, destinations, transformations, dynamic package creation, containers, troubleshooting, and package reliability. Additionally, students will learn how to deploy to the SSIS Catalog, install and administer SSIS, and secure the SSIS Catalog. Throughout the course, hands-on labs help students gain practical experience and apply their knowledge to real-world scenarios.

This …

Oracle SQL

Oracle SQL (ORA100)

4 days

This Oracle SQL course is designed for beginners who want to learn the fundamentals of SQL using Oracle Database. The course covers topics such as relational database basics, creating tables, basic selects, Oracle SQL functions, aggregate functions, joins, subqueries, set operators, conditional processing with CASE, Data Manipulation Language (DML), and creating views. Through practical exercises and real-world examples, students will gain a strong foundation in SQL and learn how to create, manipulate, and retrieve data from Oracle databases efficiently and effectively.

Oracle PL/SQL

Oracle PL/SQL (ORA200)

5 days

This Oracle PL/SQL course is designed for people who are already familiar with Oracle SQL and want to learn the fundamentals of PL/SQL programming in Oracle Database. The course covers topics such as PL/SQL basics, subprograms, conditional processing, exceptions, cursors, packages, and triggers. Through practical exercises and real-world examples, students will gain a strong foundation in PL/SQL and learn how to create efficient, maintainable, and secure applications in Oracle databases.

Introduction to SQL Using PostgreSQL

Introduction to SQL Using PostgreSQL (SQL106)

2 days

The Introduction to SQL with PostgreSQL course provides an in-depth introduction to SQL and relational databases, focusing on PostgreSQL as the database management system. The course covers essential topics such as querying and sorting data, filtering records with WHERE, advanced SELECT statements, subqueries, joins, unions, and conditional processing using CASE. Students will also learn to insert, update, and delete records, and create tables in PostgreSQL. Through hands-on exercises and real-world examples, learners will gain the skills necessary to perform effective data analysis using SQL and PostgreSQL.

Introduction to SQL

Introduction to SQL (SQL101)

2 days

The Introduction to SQL course offers a comprehensive exploration of the fundamentals of SQL, a powerful query language used to interact with relational databases. Students will learn about the history of SQL, relational databases, popular database systems, and basic SQL statements. The course guides learners through simple SELECT statements, advanced SELECT queries, and the use of subqueries, joins, and unions. Additionally, students will explore conditional processing with CASE and learn how to insert, update, and delete records. Throughout the course, practical examples and hands-on exercises are used to reinforce learning and help students apply their knowledge to real-world scenarios.

Intermediate SQL for Microsoft SQL Server

Intermediate SQL for Microsoft SQL Server (SQLINT)

1 day

The Intermediate SQL for Microsoft SQL Server course is intended for SQL users in programming roles who have taken an Introduction to SQL course. This course covers creating CTEs, using a Windows function, creating and using Global Variables, and pivoting data. This course is applicable to Microsoft SQL Server. Some topics may be applicable to other Database Management Systems, but most topics will not be supported in other DBMSs. 

This course use data from the Adventureworks and OGCBOOKS databases.

Delivering High-Quality Databases Using Visual Studio 2022

Delivering High-Quality Databases Using Visual Studio 2022 (SSDT2022)

2 days

This two-day, instructor-led course provides students with the knowledge and skills to effectively develop, test, and deliver modern SQL Server databases. Students will experience how to manage changes to a database schema, ensure quality through T-SQL unit testing and static code analysis, and automate the build and deployment of SQL Server and Azure SQL databases.

Who should take this class?
This course is intended for database developers and administrators working with modern versions of SQL Server or Azure SQL. Application developers who are involved with writing and testing T-SQL code and working with test data will also find value.
 

Querying Microsoft SQL Server with Transact-SQL

Querying Microsoft SQL Server with Transact-SQL (55366AC)

5 days

This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.

This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have …

Provisioning Databases on SQL Server

Provisioning Databases on SQL Server (55369AC)

5 days

This five-day course provides a comprehensive understanding of SQL Server and its various components. Students will learn about the SQL Server platform, its architecture, and how to configure services, accounts, and networking. The course covers topics such as installation, upgrade strategies, and configuring databases and data files.

Students will gain knowledge about maintaining databases for long-term performance, using techniques like CHECKDB and index rebuilding. The course also delves into optimizing SQL Server performance through storage configuration, including options like fileshares, local storage, and cloud storage, along with the use of SQL Server Stretch Databases.

Additionally, the course explores cloud-based installations …

SQL Queries for Analysts

SQL Queries for Analysts (SQLQFA101)

4 days

This 4-day SQL Server course, Introduction to SQL for Analysts, is designed to teach attendees both beginning and intermediate Transact-SQL (T-SQL). The course covers writing simple and complex queries, working with data types, using built-in functions, and more. Students will also learn how to combine data from multiple tables and result sets using JOIN operations, subqueries, and temporary objects. The course is structured to provide a comprehensive understanding of the Microsoft SQL Server query language and its capabilities. By the end of the course, students will be able to write advanced queries and manipulate data using Data Manipulation Language. The course …

Administering a SQL Database Infrastructure

Administering a SQL Database Infrastructure (55353AC)

5 days

This is a five-day course designed to equip individuals who administer and maintain SQL Server databases with the knowledge and skills necessary to manage a SQL server database infrastructure. The course is also beneficial for individuals who develop applications that deliver content from SQL Server databases.

The course is primarily intended for individuals who administer and maintain SQL Server databases, either as their main responsibility or in environments where databases are a crucial part of their primary job.

Additionally, the course is useful for individuals who develop applications that deliver content from SQL Server databases.

This course is the equivalent …

Fundamentals of MySQL

Fundamentals of MySQL (AMS-DB112)

2 days

Fundamentals of MySQL is the first step in mastering MySQL, the world's most popular open-source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools. This course is perfect for those interested using MySQL for backend data storage in their applications.

Hands-on activities are included designed to reinforce the content delivered in the course. A step-by-step document is provided to guide in creating a hands-on Windows 10 VM. A cloud-based VM is also available for the attendees to use, which can be purchased separately.

MySQL for Developers

MySQL for Developers (AMS-DB124)

4 days

MySQL for Developers will be useful for anyone who wants to truly master SQL using MySQL. The course covers relational database design, implementation of a database design, and the skills necessary to use a MySQL database as a backend to an application. Along with SQL query skills, the attendee will also learn about query optimization and importing and exporting data. 

Hands-on activities are included designed to reinforce the content delivered in the course. A step-by-step document is provided to guide in the creation of a  Windows 10 VM configured to support the hands-on activities. A cloud-based VM is also available …