- SQL Server architecture, editions & versions
- Introducing Transact-SQL (T-SQL)
With data becoming the core part of our daily lives, there’s a need to learn to manage it using various storage & manipulation techniques. Microsoft’s SQL Server enables you to design, query and maintain data using MSSQL. And more importantly, working knowledge of SQL has become a crucial skill in any data job.
This course focuses on helping you to use Microsoft’s SQL Server products and tools to implement a database server. Also, you get to learn querying using T-SQL along with foundations of database administration, development and business intelligence. Furthermore, you shall be exposed to the BI & Data Warehousing fundamentals like dimensional modelling and principles behind the lifecycle of a Business Intelligence solution
MCSA - SQL Server 2016
You shall receive a certification of completion from MCIT towards the end of this course.
Furthermore, you can attempt these examinations:
70-761 - Querying Data with Transact-SQL.
70-762 - Developing SQL Databases.