Certificate of Completion
360 Clock Hours
The objective for the MCSA/MCSE SQL Data Management and Analysis Professional is to teach individuals how to design, implement and administer a SQL 2016 Database Infrastructure. The student will also learn how to write Transact SQL code to access data from a SQL database, learn concepts for building enterprise-scale data solutions, and leveraging business intelligence data both on-premises and in cloud environments. Upon successful program completion, graduates will possess the education and skills necessary to obtain an entry-level database administrator position in a medium to large sized organization.
The core training for this program is defined by the competencies emphasized in attaining the (MCSA) Microsoft Certified Solutions Associate certification credential in the SQL Server 2016 Platform and the (MCSE) Microsoft Certified Solutions Expert certification credential in the SQL Server 2016 Platform. This certification ensures that the holder possesses competencies in developing, maintaining, and managing .SQL Databases. Students in the MCSA/MCSE SQL Data Management and Analysis Professional program will be provided with hands-on learning in order to ensure that they receive ample experience in both structured learning and “real world” environments with the goal of becoming a SQL Database Administrator.
In order to achieve the MCSA / MCSE SQL certifications covered within the program, all students must sit for and pass the following exams:
- 70-764 Administering a SQL Database Infrastructure
- 70-765 Provisioning SQL Databases
- 70-473 Designing and Implementing Cloud Data Platform Solutions
- 70-761 Querying Data with Transact-SQL
- 70-668 Developing SQL Databases
- 70-767 Implementing a SQL Data Warehouse
- 70-768 Developing SQL Data Models