SQL for beginners – Microsoft SQL Server

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

Language: english

Note: 0/5 (0 notes) 1,018 students New course

Instructor(s): Bereket Wolde

Last update: 2022-12-09

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

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

Course content

Introduction
- Introduction
- Setup database
- Practice what you learned in this section
Selecting data from multiple tables
- Section introduction
- INNER JOIN
- SQL Alias
- RIGHT OUTER JOIN
- LEFT OUTER JOIN
- FULL OUTER JOIN
- Sub-queries
- CASE
- Asking for your feedback
- Practice what you learned in this section
Filtering data
- Section introduction
- TOP N
- DISTINCT
- IN and NOT IN
- NULL and NOT NULL
- LIKE
- BETWEEN and NOT BETWEEN
- Asking for your feedback
- Practice what you learned in this section
Aggregating data
- Section introduction
- GROUP BY
- COUNT
- SUM
- MIN and MAX
- HAVING
- Practice what you learned in this section
Set operations
- Section introduction
- UNION and UNION ALL
- INTERSECT
- Asking for your feedback
- Practice what you learned in this section
Conclusion
- Wrap up