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.

 

IMPORTANT NOTE: Microsoft retired MCSA: Machine Learning and MCSA: Data Engineering with Azure certifications as of June 30, 2019.
Microsoft has introduced role-based certifications for Azure in their place. See Azure Role-based Certifications.

 

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

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
    Microsoft retired this certification as of June 30, 2019.
    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
    Microsoft retired this certification as of June 30, 2019.
    This certification demonstrates your skills working with Big Data solutions.

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.

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.

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.

 

 

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
20761: Querying Data with Transact-SQL 5 $2795
STEP 2: Prepare for Exam 762 with this course
20762: Developing SQL Databases 5 $2795    

 

 

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
20764: Administering a SQL Database Infrastructure 5 $2795    
STEP 2: Prepare for Exam 765 with this course
20765: Provisioning SQL Databases 5 $2795

 

 

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
20767: Implementing a SQL Data Warehouse 5 $2795    
STEP 2: Prepare for Exam 768 with this course
20768: Developing SQL Data Models 3 $1795    

 

 

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
20779: Analyzing Data with Excel 3 $1595    

 

 

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 accepts Microsoft Software Assurance Training Vouchers (SATV) on Microsoft-approved courses. Note, Microsoft is retiring the SATV benefit effective January 01, 2022. SA Vouchers must be used prior to that date. 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.

 

 

 

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