Developing & Administering SQL Server Integration Services (SSIS)

The Developing and Administering SQL Server Integration Services (SSIS) class teaches attendees how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages. SSIS is used to extract, transform, and load data to and from SQL Server. We also offer a 4-day class, Introduction to SQL Server Integration Services (SSIS) that…

Introduction to SQL Server Integration Services (SSIS)

The Introduction to SQL Server Integration Services (SSIS) training teaches attendees how to use SSIS to build high-performance ETL (Extract, Transform, and Load) and workflow packages and projects. We also offer Developing and Administering SQL Server Integration Services (SSIS), a 5-day class that adds coverage of administrative topics, such as project deployment, managing packages in an SSIS…

Introduction to SQL for Report Writers and Analysts

This 3-day SQL Server course, Introduction to SQL for Report Writers and Analysts, teaches attendees the basics of Transact-SQL, including writing simple and complex queries, working with data types, building functions, and more. Students will also learn how to combine data from multiple tables and result sets using JOIN operations and subqueries. Note: This class…

DP-300: Administering Microsoft Azure SQL Solutions

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

Delivering High Quality Databases using Visual Studio

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

Mastering Entity Framework

With Entity Framework (EF), Microsoft provides an object-relational mapper (ORM) for managing relational data, allowing developers to leverage the power of object-oriented programming (OOP) in their data-driven applications. Mastering Entity Framework provides you with the essential knowledge and skills needed to leverage the power and flexibility of the Entity Framework, while avoiding common mistakes and pitfalls.