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 (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 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.
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 …
Introduction to GraphQL (GQL101)
3 days
This comprehensive 3-day 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 (ZZ-NA45)
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 …
MEAN JavaScript Technology Stack Training (WA2497)
5 days
What is Mean Stack? Our Mean Stack course goes in depth to answer this question. MEAN [MongoDB, Express, Angular, and Node.JS] represents a new breed of software platforms that creatively leverage a stack of production-ready technologies centered on JavaScript. This intensive training course introduces the students to the essential concepts, design principles, idioms, and techniques behind the efficient use of the MEAN JavaScript Technology Stack. Upon completion of this training course, students will have a solid understanding of MEANS’ value proposition; they will also gain practical experience working with all the components of the MEAN stack. This high-octane training course …
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.
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 …