Data Courseware
Find your courseware here to deliver great Data 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 Microsoft Access (ACC101)
2 days
The Introduction to Access course provides a comprehensive foundation for students looking to learn about the Access database management system. This course covers the basics of Access, including its user interface, fundamentals, tables, queries, forms, and reports. Students will also gain insights into databases, Access terms, and relational databases. By the end of this course, students will have a solid understanding of Access and be prepared to use it effectively for managing and organizing data in various applications.
Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier versions …
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.
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.
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.
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.
SQL Server Integration Services (SSIS) (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 …
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, …
Introduction to GraphQL (GQL101)
2 days
This comprehensive course on GraphQL is designed to provide participants with a deep understanding of the GraphQL query language, its core concepts, and practical implementation techniques. Through a combination of theoretical explanations, hands-on labs, and real-world examples, participants will gain the knowledge and skills needed to effectively design, build, and consume GraphQL APIs.
Web Applications with Vue.js, Node.js, and MongoDB (MEVN100)
5 days
In this 5-day course, students will start with an optional review of advanced JavaScript, followed by the fundamental concepts and structures of Vue.js development. Students will use Vue.js to build a real-world frontend application through a series of hands-on labs.
In the 2nd part of the course, students will learn the fundamentals using Node and Express to build an API for the Vue frontend application using a MongoDB database.
Students will then connect the Vue frontend with the Node.js backend.
Professional Vue.js is a complete introduction to modern full-stack development. It covers the syntax, conventions, and best practices of modern …
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 (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.
SQL Server Reporting Services for Report Writers (SSRS101)
4 days
This Introduction to SQL Server 2016/2019 Reporting Services (SSRS) training class teaches students how to create, format, and manage SQL Server 2016/2019 Reporting Services reports. This course focuses primarily on the Report Designer tool in the SQL Server Data Tools (SSDT) for Visual Studio. Attendees will also work in and become familiar with Report Builder and Report Manager.
Creating Reports with Report Builder (REPBLD101)
3 days
In this Report Builder training class, students learn how to create, format, and customize SQL Server 2016 Reporting Services reports using the Report Builder tool. This class is geared toward business analysts and data consumers who need to be able to successfully create reports on a SQL Server Reporting Services server.
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 (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 (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 …
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 (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 …
Advanced Microsoft Access (ACC201)
2 days
The Advanced Access course builds upon the foundational skills acquired in the Introduction to Access course, diving deeper into topics such as relationships, queries, table functions, advanced forms, reports, macros, and completing a desktop application. This course equips students with the skills and knowledge to handle more complex Access tasks, further enhancing their data management capabilities and proficiency with the software.
Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier versions of Access. We draw attention to features that are not supported in earlier versions of Access, and …