This course teaches the ability to demonstrate essential skills and break through insights in developing and maintaining the next wave of mission critical environments. Students learn the technical skills to write basic Transact-SQL queries for Microsoft SQL Server 2014.
This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course also focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Total Hours: 120 clock hours
Time required for completion: 3+ weeks (15 days)
Potential Certifications: MCSA SQL Server
Prerequisite: MCSA SQL Server 2012
Certification Exams: MCSA SQL Server
Summaries of Courses: