Write queries to analyse data using various analytic functions
Write queries using various SET Operators
5 sections • 30 lectures • 2h 23m total length
Attach Adventureworks Database
Introduction to Table Joins
Extracting data with INNER Join
Extracting data with LEFT OUTER Join
Extracting data with RIGHT OUTER Join
Introduction to aggregate functions
Returning data with COUNT function
Returning data with SUM function
Returning data with AVG function
Returning data with MIN function
Returning data with MAX function
Returning data with VAR function
Returning data with VARP function
What are Analytic Functions
Using LEAD Function
What are SET Operators
Querying with EXCEPT
Querying with INTERSECT
Querying with UNION
Basic knowledge of relational database concepts
Microsoft SQL Server is robust relational database management system used by so many
organizations of various sizes including top fortune 100 companies.
SQL -Structural Query language is the language used to interrogate and manipulate Microsoft SQL Server Databases.
This course is a beginners to slightly advanced course that will walk you through how to develop queries to execute on and SQL Server Database.
We will developing queries to extract data from multiple tables using: Inner joins Left outer joins Right Outer joins
We will also be Summarising data with aggregate functions such as: COUNT SUM AVG MIN MAX VAR VARP
We will also be writing queries using various analytic functions like: LEAD LAG LAST_VAUE FIRST_VALUE PERCENT_RANK CUME_DIST
SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases. You will gain the practical skills to choose the best query method to ensure accuracy and avoid common errors or pitfalls.