Welcome to ONLC Training Centers
Get training, exam prep software and exam vouchers at up to 35% savings.  Click for details!

MCSA Certification - Data Management & Analytics Track

(Solutions Associate)

 

There are multiple MCSA (Microsoft Certified Solutions Associate) options available in the Microsoft Data Management and Analytics Track and include focuses in SQL Server, Azure, BI and Machine Learning.

MCSA is a certification level intended for people who seek entry-level jobs in IT. A typical MCSA candidate should have at least six to 12 months of IT experience before pursuing this certification. (New to IT? Learn about MTA certification for new entrants.)

Earning one (1) of the below MCSA certifications demonstrates your essential skills as a database professional, for both on-premises and cloud-based databases, and is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE) Data Management & Analytics. To earn MCSA you must pass the assigned exams for one of the paths below.

 

Exam numbers appear in the chart. Click an exam number to view the corresponding class.

Microsoft has recently added new MCSA options to this track. As such, some courses and exams may not yet be available.

Microsoft course 20462 Microsoft course 20463 Microsoft course 20762 Microsoft course 20764 Microsoft course 20765 Microsoft course 20767 Microsoft course 20768

MCSA Options for Data Management and Analytics Track


In most cases you can earn MCSA certification by passing just two (2) exams. Options include:

  • MCSA: SQL 2016 Database Development
    This certification validates your skills in building and implementing databases across organizations, and will qualify you for a position as a database developer.

  • MCSA: SQL 2016 Database Administration
    This certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist.

  • MCSA: SQL 2016 Business Intelligence Development
    This certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.

  • MCSA: Machine Learning
    This certification demonstrates knowledge relevant to Machine Learning, Data Scientists and Data Analysts positions, particularly those who process and analyze large data sets using R and use Azure cloud services to build and deploy intelligent solutions.

  • MCSA: BI Reporting
    This certification is very specialized for professionals who are working with Power BI and SQL data models.

  • MCSA: Data Engineering with Azure
    This certification demonstrates your skills working with Big Data solutions.

  • MCSA: Azure Database Development
    This certification validates your skills using NoSQL solutions in the Cloud.

Or earn MCSA: SQL Server 2012 / 2014 certification by passing three (3) exams.

  • MCSA: SQL Server 2012 / 2014
    This certification validates your skills in designing, building, and maintaining database and information solutions and will qualify you for a position as a database developer or database analyst.

 



Microsoft Authorized Training Options for Certification Exam Preparation

Microsoft certification exams are performance-based requiring you to complete specific tasks during the exam to prove your knowledge and understanding of the technology rather than memorizing information.

The best way to prepare for a Microsoft certification exam is by having hands-on experience with the technology.

ONLC provides authorized Microsoft training classes

ONLC Training Centers is a Microsoft Gold Learning Partner. We provide authorized Microsoft training that will help you prepare for certification exams.

Authorized training is available in two delivery formats:

  • Instructor-led training (ILT) classes
    Our instructor-led training classes are live, hands-on instruction. Classes are led by a Microsoft Certified Trainer (MCT). The class includes Microsoft official curriculum in digital format, and you'll do hands-on labs and exercises with the technology throughout the class. You can ask questions, participate in class discussions, receive direct assistance from the trainer during class and more. Review FAQs.

    Students may attend an ILT class from any of ONLC's more than 300 locations or from your own home/office computer. ONLC typically limits ILT class enrollments to no more than 12 students nationwide to ensure for individual attention from the instructor.

  • MOC On-Demand (self-study)
    MOC On-Demand is Microsoft's official self-study option that you access using your own equipment. This format is most appropriate for experienced IT professionals and for those who can't spend days out of the office for instructor-led training (ILT). When you purchase a MOC On-Demand course you'll have 24/7 access to the on-line course for 90 days. A MOC On-Demand course includes self-paced video modules, hands-on labs, high-quality video presentations and knowledge checks. Course content is recorded and delivered by Microsoft experts.

    ONLC Training Centers is one of just a handful of approved providers from which MOC On-Demand courses can be purchased. We also offer a number of exclusive options with MOC On-Demand courses. Learn more about MOC On-Demand.

 

Immediately below are classes for the MCSA options in the Data Management & Analytics track. Classes are in sections for each MCSA credential. You only need to earn one (1) MCSA to move onto the MCSE certification requirement.

Where applicable, you'll see both the Instructor-led course and the equivalent MOC On-Demand (self-study) course listed. Choose the format that works best for you—both are Microsoft authorized training and available from ONLC!

 

MCSA SQL Server 2012/2014


Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
STEP 1: Prepare for Exam 461 with this course (either live instructor-led or self-study On-Demand training)
20461: Querying Microsoft SQL Server 5 $2795
MOC On-Demand: 20461-Querying Microsoft SQL Server 5 $995    
STEP 2: Prepare for Exam 462 with this course (either live instructor-led or self-study On-Demand training)
20462: Administering Microsoft SQL Server Databases 5 $2795
MOC On-Demand: 20462-Administering Microsoft SQL Server Databases 5 $995    
STEP 3: Prepare for Exam 463 with this course (either live instructor-led or self-study On-Demand training)
20463: Implementing a Data Warehouse with Microsoft SQL Server 5 $2795
MOC On-Demand: 20463-Implementing a Data Warehouse with Microsoft SQL Server 5 $995    

 

MCSA SQL Server 2016 Database Development


Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
STEP 1: Prepare for Exam 761 with this course (either live instructor-led or self-study On-Demand training)
20761: Querying Data with Transact-SQL 5 $2795
MOC On-Demand: 20761-Querying Data with Transact-SQL 3 $995    
STEP 2: Prepare for Exam 762 with this course (either live instructor-led or self-study On-Demand training)
20762: Developing SQL Databases 5 $2795
MOC On-Demand: 20762-Developing SQL Databases 4 $995    

 

MCSA SQL Server 2016 Database Administration


Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
STEP 1: Prepare for Exam 764 with this course (either live instructor-led or self-study On-Demand training)
20764: Administering a SQL Database Infrastructure 5 $2795
MOC On-Demand: 20764-Administering a SQL Database Infrastructure 5 $995    
STEP 2: Prepare for Exam 765 with this course
20765: Provisioning SQL Databases 5 $2795
MOC On-Demand: 20765-Provisioning SQL Databases 5 $995    

 

MCSA SQL Server 2016 Business Intelligence Development


Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
STEP 1: Prepare for Exam 767 with this course (either live instructor-led or self-study On-Demand training)
20767: Implementing a SQL Data Warehouse 5 $2795
MOC On-Demand: 20767-Implementing a SQL Data Warehouse 5 $995    
STEP 2: Prepare for Exam 768 with this course
20768: Developing SQL Data Models 3 $1795    

 

MCSA Machine Learning


Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
STEP 1: Prepare for Exam 773 with this course (either live instructor-led or self-study On-Demand training)
20773: Analyzing Big Data with Microsoft R 3 $1595    
MOC On-Demand: 20773-Analyzing Big Data with Microsoft R 3 $995    
STEP 2: Prepare for Exam 774 with this course (either live instructor-led or self-study On-Demand training)
20774: Perform Cloud Data Science with Azure Machine Learning 5 $2795    
MOC On-Demand: 20774-Perform Cloud Data Science with Azure Machine Learning 5 $995    

 

MCSA BI Reporting


Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
STEP 1: Prepare for Exam 778 with this course
20778: Analyzing Data with Power BI 3 $1595
STEP 2: Prepare for Exam 779 with this course (either live instructor-led or self-study On-Demand training)
20779: Analyzing Data with Excel 3 $1795
MOC On-Demand: 20779-Analyzing Data with Excel 3 $995    

 

MCSA Data Engineering with Azure


Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
STEP 1: Prepare for Exam 775 with this course
20775: Perform Data Engineering on Microsoft HDInsight 5 $2795    
STEP 2: Prepare for Exam 776 with this course
20776: Engineering Data with Microsoft Cloud Services 5 $2795    

 

MCSA Azure Database Development


Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
STEP 1: Prepare for Exam 777 with this course
20777: Implementing NoSQL Solutions with DocumentDB and Azure Search 3 $1595    
STEP 2: Prepare for Exam 473 with this course
40441: Designing and Implementing Cloud Data Platform Solutions 3 $1795    

 

 

Top of page Top of page

 


 

Microsoft Digital Badges

Sample of Microsoft Digital Badge

Once you've passed a Microsoft technical exam or earned a new Microsoft certification, Microsoft will provide you with a digital badge. Badges are web-enabled representations of your Microsoft certifications. Your digital badge is made of an image and metadata uniquely linked to you. This ensures that only you can take credit for your achievement.

You can share the details of your skills in a trusted and verifiable way. You can share your digital badge to popular online destinations, such as LinkedIn, Facebook, and Twitter. It can also be embedded in a résumé, your personal website, or an email signature.

Anyone who views your badge can select it to learn about your skills and verify authenticity.

 

Next Step: MCSE Data Management and Analytics


MCSA SQL Server certification is a prerequisite for MCSE (Microsoft Certified Solutions Expert) Data Management and Analytics certification.

Once you have earned one of the above MCSA SQL Server certifications, you just have to pass one (1) more exam from a list of approved electives to earn MCSE Data Management and Analytics.

 

 

News & Offers

 

 

Save on technical training with our 15-Day Saver plan.

Save on Technical Training
For just $6,995 an individual can take up to fifteen (15) technical days of live, instructor-led hands-on training at ONLC! The 15-day Pass can be used for many public technical classes. Find out more

 

Save on technical training for your entire company with our CEA Tech Saver

Save on Company-wide Technical Training
Our Corporate Education Account (CEA) Tech Saver can give an entire company a set discount on technical classes for a full year. The greater your purchase the higher your discount. Find out more

 

Microsoft Software Assurance vouchers accepted hereMicrosoft Software Assurance Vouchers Accepted Here
ONLC gladly accepts Microsoft Software Assurance (SA) Vouchers on approved classes. These vouchers can be redeemed for any official Microsoft instructor-led training course that was created for the IT professional or developer audience. Learn more and view approved classes.

 

Online Proctored Exam


Online Proctored Exams

Technical-level Microsoft (MCP) and Microsoft Technology Associate (MTA) exams are available as Online Proctored (OP) so you can take an exam in the comfort of your home or office. The OP exam delivery system has very specific technical, system, environment, and testing protocol requirements. Learn more at Online Proctored Exams.

 

 

MOC On-Demand: Microsoft's Official Self-study option

MOC On-Demand
Many Microsoft technical level courses are offered as MOC On-Demand—Microsoft's self-study format. MOC On-Demand is most appropriate for seasoned IT professionals. For details about MOC On-Demand and ONLC's optional value-adds see MOC On-Demand.

 

 

Top of page Top of page

 


Questions?

To learn more about ONLC's classes or in the event of questions contact our Education Advisors at:

1.800.288.8221

ONLC TRAINING CENTERS
800-288-8221
www.onlc.com