Starting from ₹499
Buy now
Learn more
Has discount
Made in

Last updated at

Tue, 10-Jan-2023
Total lessons

Total duration

06:11:35 Hours
Number of reviews

Total enrolment

Avg rating
Short description
Become an Expert at Microsoft SQL! By writing SQL queries for Data Analytics and Data Science base concepts
  • No prior technical experience is required! All you need a computer!
  • No software is required in advance of the course (all software used in the course is free)
  • No pre-knowledge is required - you will learn from basic
  • Use SQL to query a database
  • Advanced SQL statements
  • Be comfortable putting SQL and Microsoft SQL on their resume
  • Replicate real-world situations and query reports
  • Complete basic SELECT statements querying against a single table
  • Sort data using the ORDER BY clause
  • Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
  • Import Flat, .CSV, Excel to SQL Database
  • Write SELECT on Query Calculations to get Discount and Non Discount Sales
  • Get a job as a junior Database developer
  • Use SQL to perform data analysis
  • Learn to perform GROUP BY statements
  • Complete literal SELECT statements.
  • Filter data using the WHERE clause
  • Using joins, return columns from multiple tables in the same query
  • Complete SQL statements that use aggregate functions
  • Perform Secure Backup and Restore Full SQL Database task