Writing Advanced SQL Queries on Microsoft SQL Server

Writing Advanced SQL Queries on Microsoft SQL Server, available at $49.99, has an average rating of 3.8, with 31 lectures, based on 79 reviews, and has 2271 subscribers.

You will learn about Download SQL Server Download and Attach Sample Database Extract data from multiple tables Aggregate data using aggregate functions Write queries to analyse data using various analytic functions Write queries using various SET Operators This course is ideal for individuals who are Beginner Database Administrator It is particularly useful for Beginner Database Administrator.

Enroll now: Writing Advanced SQL Queries on Microsoft SQL Server

Summary

Title: Writing Advanced SQL Queries on Microsoft SQL Server

Price: $49.99

Average Rating: 3.8

Number of Lectures: 31

Number of Published Lectures: 30

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 30

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Download SQL Server
Download and Attach Sample Database
Extract data from multiple tables
Aggregate data using aggregate functions
Write queries to analyse data using various analytic functions
Write queries using various SET Operators

Who Should Attend

Beginner Database Administrator

Target Audiences

Beginner Database Administrator

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.

Course Curriculum

Chapter 1: SQL Server Installation

Lecture 1: Introduction

Lecture 2: SQL Server Express Installation

Lecture 3: Download Adventureworks Database

Lecture 4: Attach Adventureworks Database

Chapter 2: Executing Queries to extract data from multiple tables

Lecture 1: Introduction to Table Joins

Lecture 2: Extracting data with INNER Join

Lecture 3: Extracting data with LEFT OUTER Join

Lecture 4: Extracting data with RIGHT OUTER Join

Chapter 3: Returning a single result with Aggregate Functions

Lecture 1: Introduction to aggregate functions

Lecture 2: Returning data with COUNT function

Lecture 3: Returning data with SUM function

Lecture 4: Returning data with AVG function

Lecture 5: Returning data with MIN function

Lecture 6: Returning data with MAX function

Lecture 7: Returning data with VAR function

Lecture 8: Returning data with VARP function

Chapter 4: Analytic Queries

Lecture 1: What are Analytic Functions

Lecture 2: The Syntax

Lecture 3: Using LEAD Function

Lecture 4: LAG Function

Lecture 5: LAST_VALUE Function

Lecture 6: FIRST_VALUE Function

Lecture 7: PERCENT_RANK Function

Lecture 8: CUME_DIST Function

Lecture 9: PERCENTILE_DISC FUNCTION

Chapter 5: Querying Data with SET Operators

Lecture 1: What are SET Operators

Lecture 2: Querying with EXCEPT

Lecture 3: Querying with INTERSECT

Lecture 4: Querying with UNION

Lecture 5: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 7 votes
2 stars: 7 votes
3 stars: 15 votes
4 stars: 23 votes
5 stars: 27 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu