- 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
Mornings | Evenings | Weekends
The median annual salary for a database administrator is $64,446, with a usual range between 40 and 90K.
A 10% job increase by 2022 is currently being anticipated.
To further develop their career, students can obtain certifications in Microsoft’s PowerBI tool and analyze data.
Anyone who would like to foray into the world of analytics
Seasoned professionals who would like to upskill themselves to work with the latest tools
Aspiring BI professionals and Software Developers
Writing SELECT statements with filtering and sorting
Writing DML statements & various data types in SQL
Writing queries using built-in functions and aggregating data
Writing subqueries, implementing views and table-valued functions
Writing queries using window ranking, offset, and aggregate functions
Creating and implementing stored procedures
Adding programming constructs such as variables, conditions, and loops to T-SQL code
Understanding advanced table designs and ensuring data integrity through constraints
Designing and implementing user-defined functions in-memory tables
Handling exceptions in SQL
Writing queries using Transactions
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.