Querying Microsoft SQL Server 2012/2014 (70-461)
Learn how SQL server works, technical skills that are required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2014. Also, this course is a prerequisite course for other SQL disciplines like DB administration, DB development, and business intelligence. Learn T-SQL & SELECT Queries, Querying multiple tables, and many other valuable concepts.
Administering Microsoft SQL Server 2012/2014 Databases (70-462)
Provides students with working knowledge to maintain Microsoft SQL Database. Also, focusing on newly developed tools related to maintenance and managing the database. It also covers important aspects like Installing and configuring SQL Server 2014, Automating SQL Server 2014 Management, working with database and storage, and Data transfer and Mentoring of SQL servers.
Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 (70-463)
The course is designed for ETL and Data warehouse developers who are aiming towards creating a career in business intelligence (BI) Solutions. The learning includes Data Warehousing and Consideration, Designing and Implementing a Data Warehouse, ETL Solution with SSIS, and Data flow SSIS packages. Learners will also come to know about Implementing Data Extraction Solutions, Data Quality, and warehousing.