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

Included In This Course

Total Hours
27 Training Hours
Microsoft MCSA: SQL Server Solutions Associate
215 On-demand Videos
Closed Caption

Closed Captions

Course Topics
43  Topics
Prep Questions
199 Prep Questions
Microsoft MCSA: SQL Server Solutions Associate

Certificate of Completion

Course Description

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

Course Outline

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 80 reviews
1-5 of 80 reviews
  1. AA
  2. K
  3. BO
  4. A

    Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

  5. A

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
 

$49.00

OR

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

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft MCSA: SQL Server Solutions Associate

Microsoft MCSA: SQL Server Solutions Associate
Microsoft MCSA: SQL Server Solutions Associate
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Learn how to handle Big Data with Microsoft SQL 2019. Master the art of data analysis & management with our online training course. Enroll now!

Dive into the depths of SQL Server with this Microsoft SQL – SQL Big Data course and discover one of its most invaluable tools, SQL Big Data Clusters. Here, you will fully explore data virtualization and lakes in order to build a complete artificial intelligence (AI) and machine learning (ML) platform directly within the SQL Server database engine.

Add To Cart

$49.00

Master the skills to effectively manage SQL Server with our Microsoft 70-764 training course. Get started today!

The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks.

Add To Cart

$49.00

Learn how to develop cutting-edge web applications with Microsoft .NET 4.5 Programming and HTML5. Enroll now and get certified!

In this online IT learning course you will learn the .NET open source developer platform. This platform provides a comprehensive and consistent programming model for building web applications that have visually stunning user experiences and seamless and secure communication. HTML 5, Javascript and CSS3 can integrate with this platform.

Add To Cart