CERTIFICATES
Data Management with SQL
Overview
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
Instructor led
COURSE OUTLINE
MCSA - SQL Server 2016
- SQL Server architecture, editions & versions
- Introducing Transact-SQL (T-SQL)
- Understanding & writing SELECT queries in SQL
- Eliminating duplicates with DISTINCT
- Using column, table aliases & CASE expressions
- Understanding Joins
- Querying with Inner, Outer, Cross Self Joins
- Sorting data
- Filtering data with Predicates, TOP & OFFSET-FETCH
- Introducing SQL Server Data Types
- Working with date & time data
- Using DML to modify data
- Using Built-in functions in SQL
- Using Aggregate functions
- Using Group By clause
- Filtering groups with HAVING
- Writing self-contained subqueries
- Writing correlated subqueries
- Using Views
- Using Inline Table Valued Functions (TVFs)
- Using Common Table Expressions (CTEs)
- Writing queries with UNION operator
- Using EXCEPT, INTERSECT & APPLY
- Using Window ranking, offset & aggregate functions
- Writing queries with PIVOT & UNPIVOT
- Working with Grouping Sets
- Understanding Stored Procedures & executing them
- Programming with T-SQL
- Implementing T-SQL Error Handling
- Implementing Structured Exception Handling
- Transactions & the database engine
SKILLS ACQUIRED
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.
INSTRUCTOR SPOTLIGHT
Gregory Shinder
Greg is keen on working with SQL Server, solving performance issues. troubleshoot poor-performing queries, design and implement high availability and disaster recovery solutions. Greg also like to interact with new tech talent and mentor them through his experience. currently assigned at Gentec as a senior Business Intelligence tech lead. Also loves teaching.
