Give The Gift of Learning
25% off Winter Sale!

Days
Hours
Minutes

Use coupon code: 25learn

Microsoft MCSA: SQL Server Solutions Associate

$999.00

SKU mcsa-sql-certificationnew-365 Categories ,
 

Course overview

27  HOURS OF TRAINING
215 VIDEOS
43  SKILLS
199 PRACTICE QUESTIONS

Demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.

To see more Microsoft related training, click here.

Microsoft 70-461: Querying SQL Server 2012 Course Outline

Lesson 1: Getting Started with SQL Server 2012
  •    Course Introduction
Lesson 2: Working with T-SQL
  •    Creating Queries-Part 1
  •    Creating Queries-Part 2
  •    Creating Queries-Part 3
  •    Creating Queries-Part 4
  •    Creating Queries-Part 5
  •    Constraints-Part 1
  •    Constraints-Part 2
  •    Constraints-Part 3
  •    Constraints-Part 4
  •    Constraints-Part 5
Lesson 3: Writing SELECT Queries
  •    Select Statement-Part 1
  •    Select Statement-Part 2
  •    Select Statement-Part 3
  •    Select Statement-Part 4
Lesson 4: Working with SQL Data Types
  •    Data Types-Part 1
  •    Data Types-Part 2
  •    Data Types-Part 3
  •    Data Types-Part 4
  •    Data Types-Part 5
  •    Data Types-Part 6
  •    Data Types-Part 7
  •    Data Types-Part 8
  •    Data Types-Part 9
  •    Data Types-Part 10
Lesson 5: Sorting and Filtering Data
  •    Sorting Results-Part 1
  •    Sorting Results-Part 2
  •    Sorting Results-Part 3
  •    Sorting Results-Part 4
  •    Sorting Results-Part 5
  •    Sorting Results-Part 6
Lesson 6: Querying Data from Multiple Tables
  •    Tables Part 1
  •    Tables Part 2
  •    Tables Part 3
  •    Tables Part 4
  •    Tables Part 5
  •    Tables Part 6
Lesson 7: Modifying Data
  •    Inserting Data-Part 1
  •    Inserting Data-Part 2
  •    Inserting Data-Part 3
  •    Inserting Data-Part 4
  •    Inserting Data-Part 5
  •    Inserting Data-Part 6
Lesson 8: Working with SQL Server Built-in Functions
  •    Functions
  •    Parse
  •    Logical Functions
  •    Group By
Lesson 9: Programming in T-SQL
  •    Programming-Part 1
  •    Programming-Part 2
  •    Programming-Part 3
  •    Programming-Part 4
  •    Programming-Part 5
  •    Programming-Part 6
Lesson 10: Implementing Stored Procedures
  •    Storage Procedures-Part 1
  •    Storage Procedures-Part 2
  •    Dynamic SQL-Part 1
  •    Dynamic SQL-Part 2
Lesson 11: Working with Subqueries and Table Expressions
  •    Sub-Queries And Table Expressions-Part 1
  •    Sub-Queries And Table Expressions-Part 2
  •    Sub-Queries And Table Expressions-Part 3
  •    Sub-Queries And Table Expressions-Part 4
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
  •    Set Operators-Part 1
  •    Set Operators-Part 2
  •    Window Functions-Part 1
  •    Window Functions-Part 2
  •    User Defined Functions-Part 1
  •    User Defined Functions-Part 2
  •    Advanced Analytical Functions
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
  •    Pivot
  •    Grouping Sets
Lesson 14: Managing Error Handling and Transactions
  •    Error Handling-Part 1
  •    Error Handling-Part 2
  •    Manage Transactions-Part 1
  •    Manage Transactions-Part 2
  •    Manage Transactions-Part 3
Lesson 15: Querying SQL Server System
  •    System Databases-Part 1
  •    System Databases-Part 2
  •    System Databases-Part 3
  •    System Databases-Part 4
Lesson 16: Optimizing Query Performance
  •    Query Planning-Part 1
  •    Query Planning-Part 2
  •    Index-Part 1
  •    Index-Part 2
  •    Index-Part 3

Microsoft 70-462: Administering SQL Server 2012 Databases Course Outline

Lesson 1: Identifying the SQL Server Platform
  •    Overview
  •    DataStorage-Part 1
  •    DataStorage-Part 2
Lesson 2: Deploying SQL Server
  •    Install-Part 1
  •    Install-Part 2
Lesson 3: Configuring SQL Server
  •    Configuring-Part 1
  •    Configuring-Part 2
  •    Changing Memory-Part 1
  •    Changing Memory-Part 2
  •    Email-Part 1
  •    Email-Part 2
Lesson 4: Managing Databases in SQL Server 2012
  •    User Databases-Part 1
  •    User Databases-Part 2
  •    User Databases-Part 3
  •    User Databases-Part 4
  •    User Databases-Part 5
Lesson 5: Managing SQL Server Security
  •    Setting Security-Part 1
  •    Setting Security-Part 2
  •    Server Roles-Part 1
  •    Server Roles-Part 2
  •    Setting Permissions-Part 1
  •    Setting Permissions-Part 2
Lesson 6: Implementing Advanced Security Settings
  •    Querying Data From Multiple Tables-Part 1
  •    Querying Data From Multiple Tables-Part 2
  •    Querying Data From Multiple Tables-Part 3
  •    Querying Data From Multiple Tables-Part 4
  •    Querying Data From Multiple Tables-Part 5
Lesson 7: Applying Encryption and Compression
  •    Encrypting And Compressing-Part 1
  •    Encrypting And Compressing-Part 2
  •    Encrypting And Compressing-Part 3
Lesson 8: Working with Indexes and Log Files
  •    Functions-Part 1
  •    Functions-Part 2
  •    Functions-Part 3
  •    Functions-Part 4
  •    Functions-Part 5
  •    Functions-Part 6
Lesson 9: Working with Backup and Restore
  •    Managing Backups-Part 1
  •    Managing Backups-Part 2
  •    Managing Backups-Part 3
  •    Managing Backups-Part 4
  •    Managing Backups-Part 5
  •    Managing Backups-Part 6
  •    Managing Backups-Part 7
Lesson 10: Implementing High Availability
  •    Stored Procedures-Part 1
  •    Stored Procedures-Part 2
  •    Stored Procedures-Part 3
  •    Stored Procedures-Part 4
Lesson 11: Optimizing Server Performance
  •    Managing SQL Performance-Part 1
  •    Managing SQL Performance-Part 2
  •    Managing SQL Performance-Part 3
  •    Managing SQL Performance-Part 4
  •    Managing SQL Performance-Part 5
  •    Managing SQL Performance-Part 6
  •    Managing SQL Performance-Part 7
Lesson 12: Troubleshooting Issues and Recovering Databases
  •    Set Operators-Part 1
  •    Set Operators-Part 2
  •    Set Operators-Part 3
  •    Set Operators-Part 4
  •    Set Operators-Part 5
Lesson 13: Performing Advanced Database Management Tasks
  •    Managing Database Infrastructures-Part 1
  •    Managing Database Infrastructures-Part 2
  •    Managing Database Infrastructures-Part 3

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Course Outline

Lesson 1: Introduction to Data Warehouse
  •    Introduction
  •    Introduction To Data Warehouse-Part1
  •    Introduction To Data Warehouse-Part2
  •    Introduction To Data Warehouse-Part3
  •    Introduction To Data Warehouse-Part4
  •    Introduction To Data Warehouse-Part5
  •    Introduction To Data Warehouse-Part6
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
  •    Creating Dimensions And Changing Granularity Of Dimensions-Part1
  •    Creating Dimensions And Changing Granularity Of Dimensions-Part2
  •    Creating Dimensions And Changing Granularity Of Dimensions-Part3
  •    Creating Dimensions And Changing Granularity Of Dimensions-Part4
  •    Creating Dimensions And Changing Granularity Of Dimensions-Part5
  •    Creating Dimensions And Changing Granularity Of Dimensions-Part6
Lesson 3: Creating Fact Tables and ColumnStore Indexes
  •    Creating Fact Tables And Column Store Indexes-Part1
  •    Creating Fact Tables And Column Store Indexes-Part2
  •    Creating Fact Tables And Column Store Indexes-Part3
  •    Creating Fact Tables And Column Store Indexes-Part4
  •    Creating Fact Tables And Column Store Indexes-Part5
Lesson 4: Implementing Data Warehouse in SQL Server 2012
  •    Implementing Data Warehouse-Part1
  •    Implementing Data Warehouse-Part2
  •    Implementing Data Warehouse-Part3
  •    Implementing Data Warehouse-Part4
Lesson 5: Working with Integration Services
  •    Working With Integration Services-Part1
  •    Working With Integration Services-Part2
  •    Working With Integration Services-Part3
  •    Working With Integration Services-Part4
  •    Working With Integration Services-Part5
  •    Working With Integration Services-Part6
Lesson 6: Managing Control Flow
  •    Managing Control Flow-Part1
  •    Managing Control Flow-Part2
  •    Managing Control Flow-Part3
  •    Managing Control Flow-Part4
  •    Managing Control Flow-Part5
Lesson 7: Working with Dynamic Variables
  •    Working With Dynamic Variables-Part1
  •    Working With Dynamic Variables-Part2
  •    Working With Dynamic Variables-Part3
  •    Working With Dynamic Variables-Part4
  •    Working With Dynamic Variables-Part5
  •    Working With Dynamic Variables-Part6
  •    Working With Dynamic Variables-Part7
  •    Working With Dynamic Variables-Part8
Lesson 8: Implementing Data Flow
  •    Implementing DataFlow-Part1
  •    Implementing DataFlow-Part2
  •    Implementing DataFlow-Part3
  •    Implementing DataFlow-Part4
  •    Implementing DataFlow-Part5
  •    Implementing DataFlow-Part6
  •    Implementing DataFlow-Part7
  •    Implementing DataFlow-Part8
Lesson 9: Managing Data Flow
  •    Managing DataFlow-Part1
  •    Managing DataFlow-Part2
  •    Managing DataFlow-Part3
  •    Managing DataFlow-Part4
Lesson 10: Managing SSIS Package Execution
  •    Managing SSIS Package Execution-Part1
  •    Managing SSIS Package Execution-Part2
  •    Managing SSIS Package Execution-Part3
  •    Managing SSIS Package Execution-Part4
  •    Managing SSIS Package Execution-Part5
  •    Managing SSIS Package Execution-Part6
Lesson 11: Debugging and Troubleshooting
  •    Debugging And Troubleshooting-Part1
  •    Debugging And Troubleshooting-Part2
  •    Debugging And Troubleshooting-Part3
  •    Debugging And Troubleshooting-Part4
Lesson 12: Deploying Packages
  •    Deploying Packages-Part1
  •    Deploying Packages-Part2
  •    Deploying Packages-Part3
Lesson 13: Securing Packages and Databases
  •    Securing Packages And Databases-Part1
  •    Securing Packages And Databases-Part2
Lesson 14: Working with MDS and Windows
  •    Working With MDS And Windows Azure
ITU Learning Management System Image