Installation SQL SERVER and Azure Data Studio
Introduction
Database Structure and Design
Real time Domain introduction and data modelling of one specific domain project
Server logging
Create Database in on-premises
Data Types
Course Syllabus
Tables creation in Database
Table Name
Columns and its datatypes
Created Table modifications
Table Creation
Drop Table
Alter Table
Alter Column
Integrity Key Constraints
Indexing
Insert the Data into Tables
Read data from Table
Insert using query
Insert the Data into Table using select query
Query on single table
Select, as, TOP, Distinct, where (is null, is not null, IN, =, NOT IN between, (! = or <>), AND, OR, Like, order by etc
TEMP TABLES, select into, insert into from select query, UNION, UNION ALL, INTERSECT, EXCEPT
Table joins, ON
Inner join
left join
right join
cross join
full join
Self join
Subquery and Correlated subquery
Functions
String Functions
Aggregate Functions
Date Functions
Math Functions --ABS, ROUND, RAND, NEWID, FLOOR, CEILING, SQRT, POWER
Conversion Functions --- cast
Window Functions or Ranking Functions
Views, CTE's, updates
Delete & Truncate
T-SQL
Declare
Variables
Variable select
Table Variable
Stored Procedures. (Alter Column)
Stored Procedures
Stored Procedures with parameters
Azure Account
Introduction on Azure Services
Azure Cloud Introduction
Difference between on-premises SQL Database and Azure SQL Database
Azure Sql
Azure SQL Database ---sql
Introduction of Database Services in Azure
Elastic Pools
Azure SQL managed Instance
Azure Postgre SQL
Azure COSMOS DB
Introduction Supported Azure Services of Data Engineering
Azure Key vault
Azure Active Directory
App Registrations
Azure Log Analytics
Storage Account
Azure Data Lake Gen2
Azure Blob Storage
Azure Data Lake Gen1
Azure Databricks
Azure Data Factory
COST Management
Muhammad
Azure Data Engineer Specialist
Muhammad is a certified professional with over 5 years of experience in their field, and He is Azure domain working professional, and have many live projects that they will use during training sessions.
Azure Data Engineer Associate DP-203 Training in Pune Key Skills
- SQL SERVER
- Azure Data Studio
- Tables Creation
- SQL Database
- Azure SQL Database
- Azure Log Analytics
- Azure Active Directory
- Azure Key Vault
Advantages in TutorsBot
- Placement Team for Job Assurance to Course Enroller
- Professional Trainer from IT Industry
- Deidicated Support Team for Training and Development
- Practical Training Program includes Hand On Project Session
- More than 150 Subject Matter Expert Community
- Five Years of Training Services Provider
- Placed More than 850 Students
