Advances of Database Design and Implementation in SQL Server
Description
This is a data engineering course in advance level to learn how to design and implement a database in Microsoft SQL Server.
COURSE OBJECTIVES
•To maximize the potential of SQL to build powerful, complex
and robust SQL queries
•To learn how to create and connect SQL server cloud database using Amazon AWS and Microsoft Azure
•To query multiple tables with joins
•To construct recursive common table expressions
•To summarize data using aggregation and grouping
•To build simple and correlated subqueries
•To select the most efficient solution to complex SQL
problems
•To know how to use T-SQL
•To know migration strategy
COURSE SYLLABUS
•Introduction to Microsoft SQL Server
•Cloud DataBases
•Advance Table Concepts
•Advanced Joining Tables
•Writing Advanced Queries
•Advanced CTE Queries
•Alternate CTE Syntax
•Using Multiple CTEs
•GROUPING SETS
•CUBE and ROLLUP
•Pivoted Queries
•T-SQL Guide
•SQL Injection and Advantages of Stored Procedure
•SQL Server Log shipping
•SQL Server Replication
•Planning High Availability and Disaster Recovery
•SQL Server Performance Monitoring
•Introduction to no-SQL
Registration fee :
€ 690
Target audience
- Data Engineers
- Database Administrators
- IT staff
- Computer Science and IT Students
Requirements
- Basic understanding of SQL commands and RDBMS concepts Basic knowledge on programming