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.
This 2-day course examines the services and features of Microsoft SQL 2022, including scenarios and lab exercises. 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.
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 …
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 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.
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.
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.
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.
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.
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.
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 …
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 …
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 …
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.