- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft MCSA: SQL Server Solutions Associate
Take an extra 30% off this course! No coupon needed; auto applies in cart.
$29.00
Sale Ends Soon
- 00Days
- 00Hours
- 00Minutes
- 00Seconds
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.
27 Training Hours
215 Videos
43 Topics
199 Practice Questions
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, click here.
Your Training Instructors
Chrys 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 35 IT Certifications including Cisco CCSI/CCNP, CISSP, CISA, MCSE/MCITP, and many more. She has also authored 40 published certification textbooks and is currently working on the new CompTIA PenTest+ courseware.
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.
Course Outline
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
Microsoft MCSA: SQL Server Solutions Associate
$29.00
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.
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
$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
$20.00
In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
$20.00
In this Microsoft 70-462: Administering SQL Server Databases course you will learn how to perform installation, maintenance, and configuration tasks. This course will also teach you other responsibilities including setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. This course will provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
$39.00
In this Microsoft 70-461: Querying SQL Server course you will learn the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 which is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
$49.00
If you’re ready to dive into Java Programming, this JavaScript Fundamentals online training course is for you! You’ll start with the basics and work your way up to advanced levels. Not only will you get a comprehensive introduction to object-oriented programming, but also learn many other core Java features in detail. Don’t miss out on this opportunity – sign up now and make strides in mastering Java today!