Microsoft MCSA: SQL Server Solutions Associate - ITU Online

Microsoft MCSA: SQL Server Solutions Associate

Showcase your indispensable abilities and ingenious insights in creating and managing the upcoming generation of mission-critical environments with our Microsoft MCSA: SQL Server Solutions Associate online course.

Included In This Course

Microsoft MCSA: SQL Server Solutions Associate
27 Hrs 42 Min
Videos
215 On-demand Videos
Closed Captions

Closed Captions

Course Topics
43  Topics
Question & Answers
199 Prep Questions
Certificate of Completion

Certificate of Completion

Note: Although the associated examination for this Microsoft MCSA: SQL Server Solutions Associate course has been retired, it is a good resource for training.

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

Skills measured

  • Ensure that data access and auditing are optimized for maximum security.
  • Ensure the secure and efficient backup and restoration of databases.
  • Supervise and observe SQL Server instances for optimal performance.
  • Ensure maximum uptime and seamless recovery from disruptions with a high availability strategy.
  • Deploy SQL in Azure
  • Take control of databases and instances to maximize your organization’s potential.
  • Storage Management

To see more Microsoft related training, Visit the Microsoft Website.

Frequently Asked Questions About Microsoft MCSA: SQL Server Solutions Associate

What exactly is the Microsoft MCSA: SQL Server Solutions Associate online course?

The Microsoft MCSA: SQL Server Solutions Associate online course is designed to demonstrate your indispensable abilities and breakthrough insights in developing and maintaining the next wave of mission-critical environments. Although the associated examination has been retired, the course remains a valuable resource for training.

What kind of skills will I learn from this IT training course?

You’ll learn a variety of skills such as optimizing data access and auditing for maximum security, efficiently backing up and restoring databases, supervising SQL Server instances for optimal performance, and deploying SQL in Azure. You’ll also learn to take control of databases and instances to maximize your organization’s potential.

How long is this online course, and what kind of content does it offer?

The course offers 27 hours of content, with 215 videos across 43 topics. There are also 199 questions included for self-assessment.

Who will be instructing this online course?

The course is instructed by Chrys Thorsen, an education and technology expert specializing in enterprise-level IT infrastructure consulting and certified training-of-trainers. She has garnered 35 IT Certifications and authored 40 published certification textbooks

Can I access other IT training courses as well?

Absolutely! With the All Access Monthly Subscription, you can access the complete training library with over 2,500 hours of on-demand content. This library includes IT training for the most popular leading development and technology companies including CompTIA, Cybersecurity, Project Management, Cisco, Microsoft, Adobe, Microsoft SQL, Azure, Amazon Web Services, and more. Plus, the content is regularly updated to stay in line with emerging trends.

How flexible is the learning process with this online course?

Our exclusive learning management system allows you to learn with flexibility. You can learn anywhere at any time on desktop, tablet or mobile. All you need is an internet connection to start learning today.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Microsoft 70-461: Querying SQL Server 2012 Course Content

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 Content

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 Content

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
Add a review
Currently, we are not accepting new reviews
4.8
Based on 81 reviews
1-5 of 14 reviews
  1. A
  2. MF
  3. AT

    I’ve enjoyed the training so far. Wish it was more focused on Linux like other training, but still good.

  4. F

    The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.

  5. JT

    This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.

Your Training Instructors

Chrys Thorsen

Chrys Thorsen

Education and Technology Expert

Chrys Thorsen is an education and technology expert who specializes in enterprise-level IT infrastructure consulting and certified training-of-trainers. In her career, she has garnered over 50 IT Certifications including CISSP, CISA, CEHv12, PenTest+, CompTIA CNVP, Cisco CCSI/CCNP, Microsoft Cloud and on-premises technologies, VMware vSphere, and many more. She has also authored 40 published certification textbooks, and over 35 full-length IT certification video courses.

When not working in the United States, Chrys spends her time abroad capacity-building IT literacy in developing nations in Sub-Saharan Africa. Her client list has included: the US Federal Government, the Republic of Zambia Ministry of Health, Cavendish University Zambia, Accenture, JP Morgan Chase, the US Centers for Disease Control and Prevention, the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF), Hughes Aircraft, Microsoft, and many more.

Chrys lives by, and is fond of repeating, her professional creed:

“The only true measure of success for any project or training is results on the ground. Everything else is just noise.” “I teach what I deploy; I deploy what I teach.”

Rafiq Wayani

Rafiq Wayani

Project Management Instructor

Rafiq has extensive experience including more than 20 years in IT as a Systems Architect, Software Engineer, DBA, and Project Manager. He has instructed in a variety of technical areas and has designed and implemented network and information systems. Bringing nearly 30 years of advanced IT experience to each course and adding his unique perspective and “real world” tips, Rafiq has a knack for making complex topics easy to understand.

Microsoft MCSA: SQL Server Solutions Associate

Subscribe To All-Access
Lock In $16.99 / Month Forever

Gain access to this training and all our other courses with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.99 $16.99 Monthly

OR

$49.00