Get our Bestselling Ethical Hacker Course V13 for Only $12.99

Get Offer

For a limited time, check out some of our most popular courses for free on Udemy.  View Free Courses.

Microsoft Sql Server Training Series – 16 Courses – Deal

Course Level: Beginner
Duration: 190 Hrs 15 Min
Total Videos: 1,011 On-demand Videos

Master essential SQL Server management, data modeling, and reporting skills to advance your career as a database professional or BI analyst in real-world scenarios

Buy An all access pass to over 3,000 hours of training

Course Description

Handling data effectively requires more than just basic knowledge of databases. Whether you’re managing large data warehouses, designing efficient database schemas, or creating reports that influence strategic decisions, you need a comprehensive skill set. After completing this series, you’ll be equipped to manage, optimize, and leverage Microsoft SQL Server across multiple versions, from 2012 to 2019, in real-world scenarios.

This series covers core aspects of SQL Server, including database administration, data modeling, query optimization, and reporting. You’ll learn to deploy and maintain SQL Server environments, design scalable data solutions, and create insightful reports using Power BI, SSAS, and SSRS. If you aim to work in roles that demand hands-on database expertise, this training will prepare you to handle the most critical tasks confidently.

What sets this program apart is its emphasis on practical application. Instead of just theory, you’ll work through labs and exercises that mirror real workplace challenges. This approach ensures you’re not only familiar with concepts but also capable of applying them immediately in your job.

What You Will Learn

This course series provides practical skills designed to make you proficient in managing and utilizing SQL Server databases effectively. You will develop the ability to handle complex data environments and produce actionable insights for your organization.

  • Learn how to install, configure, and maintain SQL Server instances across different versions, ensuring reliable database operations.
  • Gain the skills to design normalized and scalable database schemas that support business growth and data integrity.
  • Master writing efficient SQL queries, including complex joins, subqueries, and window functions, to retrieve data accurately and quickly.
  • Implement security best practices, including role-based access control and encryption, to protect sensitive data.
  • Optimize database performance by analyzing query plans, creating effective indexes, and tuning server settings.
  • Design and develop data warehouses, applying ETL processes to integrate data from multiple sources for analysis.
  • Create compelling reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI to communicate insights clearly.
  • Build and deploy analytical models using SQL Server Analysis Services (SSAS) to support advanced business intelligence solutions.
  • Apply data governance principles to ensure data quality, consistency, and compliance within your SQL Server environment.

Who This Course Is For

This training is ideal for IT professionals, data analysts, database developers, and BI specialists who want to deepen their knowledge of Microsoft SQL Server. If you already have some experience with databases but need to advance your skills in administration, data modeling, or reporting, this series will be a perfect fit. It’s also suitable for those preparing for roles that require managing SQL Server environments across versions 2012 through 2019.

Prerequisites include basic familiarity with databases and SQL. Prior experience with database management or programming concepts will help you get the most out of this series, but beginners with a technical background can also succeed with dedicated effort.

Why These Skills Matter

Mastering SQL Server and associated BI tools opens doors to more senior roles in data management, analysis, and architecture. Organizations rely heavily on SQL Server for critical applications, making these skills highly sought-after in the job market. With this knowledge, you can streamline database operations, improve data quality, and deliver reports that inform strategic decisions.

By developing expertise in SQL Server administration, data warehousing, and reporting, you position yourself as a vital player in any data-driven organization. These capabilities support career growth into roles such as database administrator, data analyst, BI developer, or data architect. Whether you’re looking to enhance your current role or transition into a data-centric position, this series provides the practical skills to elevate your professional profile.

Who Benefits From This Course

Frequently Asked Questions

What are the key topics covered in the Microsoft SQL Server Training Series?

The Microsoft SQL Server Training Series offers comprehensive coverage of essential SQL Server skills, including database administration, data modeling, query optimization, and reporting. Participants will learn to install, configure, and maintain SQL Server environments across versions from 2012 to 2019, ensuring reliable database operations.

The series also delves into designing scalable and normalized database schemas, writing efficient T-SQL queries with complex joins, subqueries, and window functions. Additionally, it covers security best practices like role-based access control and encryption, as well as performance tuning through index creation and query plan analysis. Advanced topics include data warehousing with ETL processes, report development with SSRS and Power BI, and building analytical models with SSAS. Practical labs and exercises reinforce these concepts, preparing learners for real-world scenarios.

How does this SQL Server course series prepare me for real-world data management roles?

This course series emphasizes practical application through hands-on labs and exercises designed to mirror workplace challenges. You’ll work with real datasets, simulate database deployment, performance tuning, and report creation, which helps solidify your understanding of theoretical concepts.

By engaging in scenarios such as designing data warehouses, optimizing queries, implementing security measures, and developing BI reports, you'll gain the confidence to handle complex data environments. The practical focus ensures you can immediately apply your skills to tasks like managing SQL Server instances, creating scalable data solutions, and delivering insightful reports, making you well-prepared for roles like database administrator or BI analyst.

What are the career benefits of completing this Microsoft SQL Server training series?

Completing this series enhances your ability to manage and optimize SQL Server environments, which are critical assets for organizations relying on data-driven decision-making. The skills gained open doors to senior roles such as SQL Server Database Administrator, Business Intelligence Developer, Data Analyst, or Data Architect.

Moreover, proficiency in SQL Server and BI tools like Power BI, SSRS, and SSAS improves your marketability and earning potential. As organizations continue to prioritize data management and analytics, your expertise positions you as a valuable asset capable of improving database performance, ensuring data quality, and delivering strategic insights—key drivers of organizational success.

What is the best way to prepare for the Microsoft SQL Server certification exams like 70-461 or 70-463?

Preparation for Microsoft SQL Server certification exams such as 70-461 (Querying Microsoft SQL Server) or 70-463 (Implementing a Data Warehouse with Microsoft SQL Server) should begin with a solid understanding of the core topics covered in this training series. Focus on mastering T-SQL query writing, data modeling, security practices, and performance tuning.

Practice extensively with real-world labs, review exam objectives provided by Microsoft, and utilize official practice tests to identify weak areas. Engaging with community forums, study groups, and supplementary resources like Microsoft’s official documentation can further reinforce your knowledge. Consistent hands-on experience and targeted review of exam topics will maximize your chances of success.

Are there prerequisites or prior knowledge required to enroll in this SQL Server training series?

This training series is designed for IT professionals, data analysts, and developers with basic familiarity with databases and SQL. Prior experience with relational database concepts and basic SQL queries will help you grasp the material more quickly.

While prior experience is beneficial, beginners with a strong technical background and willingness to learn can succeed by dedicating extra effort to understanding foundational concepts. The series builds progressively, starting from introductory topics and advancing to complex queries, performance optimization, and BI deployment, making it suitable for learners at different levels of expertise.

Included In This Course

Module 1 - Query Tools

  •    1.1 Course Introduction
  •    1.2 Intro to Management Studio
  •    1.3 Intro to command-line query tools

Module 2 - Introduction to T-SQL Querying

  •    2.1 Introducing T-SQL
  •    2.2 Understanding Sets
  •    2.3 Understanding the Logical Order of Operations in SELECT statements

Module 3 - Basic SELECT Queries

  •    3.1 Writing Simple SELECT Statements
  •    3.2 Eliminate Duplicates with DISTINCT
  •    3.3 Using Column and Table Aliases
  •    3.4 Write Simple CASE Expressions

Module 4 - Querying Multiple Tables

  •    4.1 Understanding Joins
  •    4.2 Querying with Inner Joins
  •    4.3 Querying with Outer Joins
  •    4.4 Querying with Cross Joins and Self Joins

Module 5 - Sorting and Filtering Data

  •    5.1 Sorting Data
  •    5.2 Filtering Data with Predicates
  •    5.3 Filtering with the TOP and OFFSET-FETCH
  •    5.4 Working with Unknown Values

Module 6 - Introduction to Business Intelligence and Data Modeling

  •    6.1 Introduction to Business Intelligence
  •    6.2 The Microsoft Business Intelligence Platform
  •    6.3 Exploring a Data Warehouse
  •    6.4 Exploring a Data Model

Module 7 - Prepare Data

  •    7.1 Introduction to Power BI
  •    7.2 Get data from various data sources
  •    7.3 Preview source data

Module 8 - Clean, Transform, and Load Data

  •    8.1 Data Transformation Intro
  •    8.2 Transformation Example 1
  •    8.3 Transformation Example 2
  •    8.4 Transformation Example 3
  •    8.5 Transformation Example 4
  •    8.6 Transformation Example 5
  •    8.7 Transformation Example 6

Module 9 - Design a Data Model

  •    9.1 Introduction to Data Modeling
  •    9.2 Model Relationships
  •    9.3 Table Configuration
  •    9.4 Model interface
  •    9.5 Quick Measures
  •    9.6 Many-to-many relationships
  •    9.7 Row-level security

Module 10 - Create Model Calculations using DAX

  •    10.1 DAX context
  •    10.2 Calculated Tables
  •    10.3 Calculated Columns
  •    10.4 Managing Date Tables
  •    10.5 Measures
  •    10.6 Filter Manipulation
  •    10.7 Time Intelligence

Module 11 - Create Reports

  •    11.1 Basic Report Creation
  •    11.2 Example Page 1
  •    11.3 Example Page 2
  •    11.4 Example Page 3
  •    11.5 Report Publishing
  •    11.6 Enhancing Reports
  •    11.7 Drill-Through Pages
  •    11.8 Conditional Formatting
  •    11.9 Buttons and Bookmarks

Module 12 - Create Dashboards

  •    12.1 Dashboard Basics
  •    12.2 Real Time Dashboards
  •    12.3 Enhanced Dashboards

Module 13 - Create Paginated Reports

  •    13.1 Introduction to Power BI Report Builder
  •    13.2 Report Layouts
  •    13.3 Report Data
  •    13.4 Report Tables

Module 14 - Perform Advanced Analytics

  •    14.1 Introduction to Advanced Analytics
  •    14.2 Scatter Chart
  •    14.3 Forecast
  •    14.4 Decomposition Tree
  •    14.5 Key Influencers

Module 15 - Create and Manage Workspaces

  •    15.1 Introduction to Workspaces
  •    15.2 Working with Workspaces and the Portal

Module 16 - Create Power App Visuals

  •    16.1 Introduction to Power Apps Visual
  •    16.2 Creating the App
  •    16.3 Basic Power Apps Concepts
  •    16.4 Refreshing the Report

Module 17 - Analysis Services and Power BI

  •    17.1 Introduction to Analysis Services
  •    17.2 Connecting with Multidimensional Models
  •    17.3 Premium Workspaces and Analysis Services
  •    17.4 Course Wrap Up

Module 1 - Query Tools

  •    1.1 Course Introduction
  •    1.2 Module 1 Introduction
  •    1.3 Intro to Management Studio
  •    1.4 Intro to command-line query tools

Module 2 - Introduction to T-SQL Querying

  •    2.1 Module 2 Introduction
  •    2.2 Introducing T-SQL
  •    2.3 Understanding Sets
  •    2.4 Understanding the Logical Order of Operations in SELECT statements

Module 3 - Basic SELECT Queries

  •    3.1 Module 3 Introduction
  •    3.2 Writing Simple SELECT Statements
  •    3.3 Eliminate Duplicates with DISTINCT
  •    3.4 Using Column and Table Aliases
  •    3.5 Write Simple CASE Expressions

Module 4 - Querying Multiple Tables

  •    4.1 Module 4 Introduction
  •    4.2 Understanding Joins
  •    4.3 Querying with Inner Joins
  •    4.4 Querying with Outer Joins
  •    4.5 Querying with Cross Joins and Self Joins

Module 5 - Sorting and Filtering Data

  •    5.1 Module 5 Introduction
  •    5.2 Sorting Data
  •    5.3 Filtering Data with Predicates
  •    5.4 Filtering with the TOP and OFFSET-FETCH
  •    5.5 Working with Unknown Values

Module 6 - Working with SQL Server Data Types

  •    6.1 Module 6 Introduction
  •    6.2 Writing Queries that return Date and Time Data
  •    6.3 Writing Queries that use Date and Time Functions
  •    6.4 Writing Queries that return Character Data
  •    6.5 Writing Queries that use Character Functions

Module 7 - Using DML to Modify Data

  •    7.1 Module 7 Introduction
  •    7.2 Inserting Records with DML
  •    7.3 Updating Records Using DML
  •    7.4 Deleting Records Using DML

Module 8 - Using Built-In Functions

  •    8.1 Module 8 Introduction
  •    8.2 Writing Queries with Built-In Functions
  •    8.3 Using Conversion Functions
  •    8.4 Using Logical Functions
  •    8.5 Using Functions to Work with NULL

Module 9 - Grouping and Aggregating Data

  •    9.1 Module 9 Introduction
  •    9.2 Using Aggregate Functions
  •    9.3 Using the GROUP BY Clause
  •    9.4 Filtering Groups with HAVING

Module 10 - Using Subqueries

  •    10.1 Module 10 Introduction
  •    10.2 Writing Self-Contained Subqueries
  •    10.3 Writing Correlated Subqueries
  •    10.4 Using the EXISTS Predicate with Subqueries

Module 11 - Using Table Expressions

  •    11.1 Module 11 Introduction
  •    11.2 Using Views
  •    11.3 Using Inline Table-Valued Functions
  •    11.4 Using Derived Tables
  •    11.5 Using Common Table Expressions

Module 12 - Using Set Operators

  •    12.1 Module 12 Introduction
  •    12.2 Writing Queries with the UNION operator
  •    12.3 Using EXCEPT and INTERSECT
  •    12.4 Using APPLY

Module 13 - Using Window Ranking, Offset, and Aggregate Functions

  •    13.1 Module 13 Introduction
  •    13.2 Creating Windows with OVER
  •    13.3 Exploring Window Functions

Module 14 - Pivoting and Grouping Sets

  •    14.1 Module 14 Introduction
  •    14.2 Writing Queries with PIVOT and UNPIVOT
  •    14.3 Working with Grouping Sets

Module 15 - Implementing Error Handling

  •    15.1 Module Introduction
  •    15.2 Implementing T-SQL error handling
  •    15.3 Implementing structured exception handling

Module 16 - Managing Transactions

  •    16.1 Module 16 Introduction
  •    16.2 Transactions and the Database Engine
  •    16.3 Controlling Transactions
  •    16.4 Course Wrap Up

Module 1 - Designing and Building Tables

  •    1.1 Course Introduction
  •    1.2 Module 1 Introduction
  •    1.3 Introduction to Database Design
  •    1.4 Creating Tables
  •    1.5 Data Types
  •    1.6 Schemas
  •    1.7 Altering Tables

Module 2 - Enforcing Data Integrity

  •    2.1 Module 2 Introduction
  •    2.2 Introduction to Data Integrity
  •    2.3 Data Domain Integrity
  •    2.4 Implementing Data Domain Integrity
  •    2.5 Implementing Entity and Referential Integrity

Module 3 - Indexing

  •    3.1 Module 3 Introduction
  •    3.2 Core Indexing Concepts
  •    3.3 Heaps, Clustered, and Nonclustered Indexes
  •    3.4 Data Types and Indexes
  •    3.5 Single Column and Composite Indexes

Module 4 - Stored Procedures, Functions, and Triggers

  •    4.1 Module 4 Introduction
  •    4.2 Introduction to Database Programming
  •    4.3 Creating Stored Procedures
  •    4.4 Creating User-Defined Functions
  •    4.5 Creating Triggers

Module 5 - Blob and Filestream Data

  •    5.1 Module 5 Introduction
  •    5.2 Introduction to Binary Data
  •    5.3 Considerations for BLOB data
  •    5.4 FILESTREAM Example
  •    5.5 File Table Example

Module 6 - Full-Text Search

  •    6.1 Module 6 Introduction
  •    6.2 Introduction to Full-Text Search
  •    6.3 Full-Text Catalogs
  •    6.4 Full-Text Indexes
  •    6.5 Full-Text Queries

Module 7 - Azure vs On-Prem

  •    7.1 Module 7 Introduction
  •    7.2 SQL Server on Azure VM
  •    7.3 Azure Managed SQL Instance
  •    7.4 Azure SQL Database
  •    7.5 Course Wrap Up

Module 1 - Introduction to Business Intelligence and Data Modeling

  •    1.1 Course Introduction
  •    1.2 Module 1 Introduction
  •    1.3 Introduction to Business Intelligence
  •    1.4 The Microsoft Business Intelligence Platform
  •    1.5 Exploring a Data Warehouse
  •    1.6 Exploring a Data Model

Module 2 - Multidimensional Databases

  •    2.1 Module 2 Introduction
  •    2.2 Introduction to Multidimensional Analysis
  •    2.3 Overview of Cube Security
  •    2.4 Creating and Configuring a Cube
  •    2.5 Data Sources
  •    2.6 Data Source Views
  •    2.7 Adding a Dimension to a Cube

Module 3 - Cubes and Dimensions

  •    3.1 Module 3 Introduction
  •    3.2 Dimensions
  •    3.3 Attribute Hierarchies and Relationships
  •    3.4 Sorting and Grouping Attributes
  •    3.5 Slowly Changing Dimensions

Module 4 - Measures and Measure Groups

  •    4.1 Module 4 Introduction
  •    4.2 Measures
  •    4.3 Measure Groups and Relationships
  •    4.4 Measure Group Storage

Module 5 - Introduction to MDX

  •    5.1 Module 5 Introduction
  •    5.2 MDX Fundamentals
  •    5.3 Adding Calculations to a Cube
  •    5.4 Querying a cube using MDX

Module 6 - Customizing Cube Functionality

  •    6.1 Module 6 Introduction
  •    6.2 Key Performance Indicators
  •    6.3 Actions
  •    6.4 Perspectives
  •    6.5 Translations

Module 7 - Tabular Data Models

  •    7.1 Module 7 Introduction
  •    7.2 Introduction to Tabular Data Models
  •    7.3 Creating a Tabular Data Model
  •    7.4 Configure Relationships and Attributes
  •    7.5 Configuring Data Model for an Enterprise BI Solution

Module 8 - Data Analysis Expressions (DAX)

  •    8.1 Module 8 Introduction
  •    8.2 DAX Fundamentals
  •    8.3 Calculated Columns
  •    8.4 Relationships
  •    8.5 Measures
  •    8.6 Time Intelligence
  •    8.7 KPI
  •    8.8 Parent - Child Hierarchies

Module 9 - Data Mining

  •    9.1 Module 9 Introduction
  •    9.2 Overview of Data Mining
  •    9.3 Custom Data Mining Solutions
  •    9.4 Validating a Data Mining Model
  •    9.5 Consuming a Data Mining Model
  •    9.6 Course Wrap Up

Module 1 - Prepare Data

Module 2 - Clean, Transform, and Load Data

Module 3 - Design a Data Model

Module 4 - Create Model Calculations using DAX

Module 5 - Create Reports

Module 6 - Create Dashboards

Module 7 - Create Paginated Reports

Module 8 - Perform Advanced Analytics

Module 9 - Create and Manage Workspaces

Module 10 - Create Power App Visuals

Module 11 - Analysis Services and Power BI

Module 1: What are Big Data Clusters?

Module 2: Big Data Cluster Architecture

Module 3: Deployment of Big Data Clusters

Module 4: Loading and Querying Data in Big Data Clusters

Module 5: Working with Spark in Big Data Clusters

Module 6: Machine Learning on Big Data Clusters

Module 7: Create and Consume Big Data Cluster Apps

Module 8: Maintenance of Big Data Clusters

Module 1: Installation

Module 2: Data Storage

Module 3: Data Recover

Module 4: Monitoring

Module 5: Security

Module 6: Maintenance

Module 1: Deploy a Microsoft Azure SQL Database

Module 2: Plan for SQL Server Installation

Module 3: Deploy SQL Server Instances

Module 4: Deploy SQL Server Databases to Azure Virtual Machines

Module 5: Configure Secure Access to Microsoft Azure SQL Databases

Module 6: Configure SQL Server performance settings

Module 7: Manage SQL Server instances

Module 8: Manage SQL Storage

Module 9: Perform Database Maintenance

Module 1: Configure Encryption

Module 2: Configure Data Access and Permissions

Module 3: Configure Auditing

Module 4: Develop a Backup Strategy

Module 5: Restore Databases

Module 6: Manage Database Integrity

Module 7: Monitor Database Activity

Module 8: Monitor Queries

Module 9: Manage Indexes

Module 10: Monitor SQL Server Instances

Module 11: Implement Log Shipping

Module 12: Implement Failover Cluster Instances

Module 13: Implement Always On Availability Groups

Module 1: Intro To Business Intelligence

Module 2: Database Essentials

Module 3: Business Intelligence Development

Module 4: Business Intelligence Results

Module 5: Advanced Reporting And Development

Module 6: SQL Server Integration Services (SSIS)

Module 7: SQL Server 2014 New Features

Module 8: Course Review And Exam Prep

Module 1: Introduction To Business Intelligence And Data Modeling

Module 2: Implementing Reports The SQL Server Reporting Services

Module 3: Supporting Self Service Reporting

Module 4: Managing Report Execution And Delivery

Module 5: Creating Multidimensional Databases

Module 6: Working With Cubes And Dimensions

Module 7: Working With Measures And Measure Groups

Module 8: Introduction To MDX

Module 9: Customizing Cube Functionality

Module 10: Implementing A Tabular Data Model

Module 11: Introduction To DAX

Module 12: Implementing An Analysis Services Tabular Data Model

Module 13: SQL Analysis Services

Module 14: Creating Data Visualizations With Power View

Module 15: Supporting Self Service Reporting

Module 16: Performing Predictive Analysis With Data Mining

Module 17: Predictive Analytics

Module 1: Designing A Database Server Infrastructure

Module 2: Designing A Logical Database Scheme

Module 3: Designing A Physical Database Implementation

Module 4: Incorporating Data Files Into the Database

Module 5: Tuning Database Performance

Module 6: Designing Database Security

Module 7: Policy Based Management

Module 8: Monitoring Server Health

Module 9: Designing Database Backup Solution

Module 10: Automating Multi Server Maintenance

Module 11: Managing SQL Server With Windows Powershell

Module 12: Replicating Data

Module 13: Planning High Availability

Module 14: Review of SQL Statements

Module 15: Eleven Rules of Database Design

Module 1: SQL 2012 And The 464 Test

Module 2: Working With Data Types

Module 3: Tables

Module 4: Data Constraints

Module 5: Planning In Indexing

Module 6: Table Structures

Module 7: Improving Performance with Non-Clustered Indexes

Module 8: Using Indexes And Execution Plans

Module 9: Working with Views

Module 10: Designing and Implementing Stored Procedures

Module 11: Merging Data and Passing Tables

Module 12: Designing and Implementing User Functions

Module 13: Creating Highly Concurrent SQL Server Applications

Module 14: Handling Errors in T-SQL

Module 15: Triggers

Module 16: Implementing Managed Code

Module 17: Storing XML in SQL

Module 18: Querying XML

Module 19: Working with the Spatial Data

Module 20: Working With Full-Text Indexes and Queries

Lesson 1: Getting Started with SQL Server 2012

Lesson 2: Working with T-SQL

Lesson 3: Writing SELECT Queries

Lesson 4: Working with SQL Data Types

Lesson 5: Sorting and Filtering Data

Lesson 6: Querying Data from Multiple Tables

Lesson 7: Modifying Data

Lesson 8: Working with SQL Server Built-in Functions

Lesson 9: Programming in T-SQL

Lesson 10: Implementing Stored Procedures

Lesson 11: Working with Subqueries and Table Expressions

Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions

Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets

Lesson 14: Managing Error Handling and Transactions

Lesson 15: Querying SQL Server System

Lesson 16: Optimizing Query Performance

Lesson 1: Identifying the SQL Server Platform

Lesson 2: Deploying SQL Server

Lesson 3: Configuring SQL Server

Lesson 4: Managing Databases in SQL Server 2012

Lesson 5: Managing SQL Server Security

Lesson 6: Implementing Advanced Security Settings

Lesson 7: Applying Encryption and Compression

Lesson 8: Working with Indexes and Log Files

Lesson 9: Working with Backup and Restore

Lesson 10: Implementing High Availability

Lesson 11: Optimizing Server Performance

Lesson 12: Troubleshooting Issues and Recovering Databases

Lesson 13: Performing Advanced Database Management Tasks

Lesson 1: Introduction to Data Warehouse

Lesson 2: Creating Dimensions and Changing Granularity of Dimensions

Lesson 3: Creating Fact Tables and ColumnStore Indexes

Lesson 4: Implementing Data Warehouse in SQL Server 2012

Lesson 5: Working with Integration Services

Lesson 6: Managing Control Flow

Lesson 7: Working with Dynamic Variables

Lesson 8: Implementing Data Flow

Lesson 9: Managing Data Flow

Lesson 10: Managing SSIS Package Execution

Lesson 11: Debugging and Troubleshooting

Lesson 12: Deploying Packages

Lesson 13: Securing Packages and Databases

Lesson 14: Working with MDS and Windows