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

4.45 (152 reviews)

Udemy

platform

English

language

Databases

What you will learn

Selecting data from mulitiple tables

Filter data with different techniques

Aggregate data and use the built-in functions

Use set operations

Why take this course?

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!

Reviews

Tammy

March 20, 2023

If you could show how to import data file on the second video, rather than 3rd, it would have been no confusion. I had to search youtube how to import bak file in to the server.

Anna

March 17, 2023

Thank you for your time and knowledge. The course is easy and understandable with nice short lessons. Appreciate it!

Sujeen

December 20, 2022

VERY INFORMATIVE and THE EXPLAINATIONS were in tune with the lecture. Keep up the good work. Very impressive layout with examples. WELL DONE. JAI HIND THANK YOU

Azeez

December 17, 2022

TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'SchoolDB' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: Microsoft.Data.SqlClient.SqlError: The database was backed up on a server running version 16.00.1000. That version is incompatible with this server, which is running version 15.00.2000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended) For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.200.48028.0&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Please I keep getting this error, how do I fix it?

Charts

Price

Rating

Enrollment distribution

SQL for beginners - Microsoft SQL Server - Distribution chart