SQL for beginners - Microsoft SQL Server

Name: SQL for beginners - Microsoft SQL Server
Rating: 4.5 (364 reviews)

We will see multiple SQL features to select data, filtering data, aggregating data, and set operations using SQL Server

Created byBereket Wolde

Last updated 12/2022

English

What you'll learn

Selecting data from mulitiple tables
Filter data with different techniques
Aggregate data and use the built-in functions
Use set operations

Course content

6 sections • 32 lectures • 1h 46m total length

Introduction3:51
Setup database3:37
Practice what you learned in this section0:25

Section introduction0:30
INNER JOIN4:25
SQL Alias4:00
RIGHT OUTER JOIN4:39
LEFT OUTER JOIN3:09
Learn how left outer joins in SQL Server return all records from the left table while displaying matching course records and showing nulls for students without a course.
FULL OUTER JOIN3:27
Explore how a full outer join returns all matching and non-matching records from both tables, contrasting left and right joins, with a student and course example.
Sub-queries7:05
CASE4:37
Practice what you learned in this section0:16

Section introduction1:01
GROUP BY3:55
Learn how to use the group by clause in SQL Server to group data by gender ID and count students, enabling simple aggregation and summaries.
COUNT2:21
SUM6:56
Use the sum function, an SQL aggregate, with inner joins across student, student_course, and course tables to group by student and total their credit hours while showing full names.
MIN and MAX6:28
HAVING6:39
Demonstrate using the having clause to filter after a group by. Apply inner joins on student, student_course, and course to sum credits greater than five.
Practice what you learned in this section0:19

Requirements

Basic computer skill
Basic understanding of database concepts

Description

This course will teach you many SQL options to select, filter, and aggregate data. We also see some set operation features.

This course is designed for people who have basic database knowledge and some experience working with some kind of relational database tool. It can be on SQL Server, MySQL, PostgreSQL or Oracle. I strongly believe in short and simple courses that can get you ready in few hours as opposed to days and that's why I made sure this course to be less or equal to 2hrs.

We will not cover basic database operations like insert, update, delete and select data.

This course requires:

Basic computer skill
Basic understanding of database concepts

Who this course is for:

Developers who want to advance their SQL skill
IT Student who wants to have practical experience
People who are changing career to database development/administration

Who is teaching this course:

My name is Bereket Wolde and I started working database development for more than 15 years. I am also a certified SQL Server developer.

However, if you ever get stuck or need something that I don't cover in this course then feel free to reach out to me or add a comment on the course we will reach out to you at the earliest.

Join me today and I'll see you inside!

Who this course is for:

Developers who want to advance their SQL skill
IT Student who wants to have practical experience
People who are changing career to database development/administration

SQL for beginners - Microsoft SQL Server

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 8min

Selecting data from multiple tables9 lectures • 32min

Filtering data8 lectures • 26min

Aggregating data7 lectures • 28min

Set operations4 lectures • 12min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: