Microsoft SQL from scratch – Beginner to Expert
Practical Hands-on Real World SQL Skills
What you’ll learn
-
Extract and Read Data Using SELECT statements
-
Insert new data into database
-
Update existing data in a database
-
Delete data from a database
-
Understand Normalization
-
Extract Data from multiple tables using table joins
-
Filter data returned from a query
-
Sort data returned by a query
-
Group data returned by a query
-
Summarize data using aggregate functions
-
Build real world queries for business intelligence
-
Remove Duplicate Records
Requirements
-
Windows based computer required to install SQL Server
-
Internet Access Required
-
Knowledge of basic database concepts useful but not mandatory
Who this course is for:
- Beginners to Microsoft SQL ( T -SQL )
- Beginner DBA ( Database Administrator)
- Beginner Data Analyst
- Beginner Data Scientist