Microsoft SQL from scratch – Beginner to Expert

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
Tutorial Bar
Logo