SQL for beginners Microsoft SQL Server

SQL for beginners – Microsoft SQL Server, available at Free, has an average rating of 4.44, with 34 lectures, based on 235 reviews, and has 6826 subscribers.

Free Enroll Now

You will learn about Selecting data from mulitiple tables Filter data with different techniques Aggregate data and use the built-in functions Use set operations This course is ideal for individuals who are Developers who want to advance their SQL skill or IT Student who wants to have practical experience or People who are changing career to database development/administration It is particularly useful for Developers who want to advance their SQL skill or IT Student who wants to have practical experience or People who are changing career to database development/administration.

Enroll now: SQL for beginners – Microsoft SQL Server

Summary

Title: SQL for beginners – Microsoft SQL Server

Price: Free

Average Rating: 4.44

Number of Lectures: 34

Number of Published Lectures: 32

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 32

Original Price: Free

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Setup database

Lecture 3: Practice what you learned in this section

Chapter 2: Selecting data from multiple tables

Lecture 1: Section introduction

Lecture 2: INNER JOIN

Lecture 3: SQL Alias

Lecture 4: RIGHT OUTER JOIN

Lecture 5: LEFT OUTER JOIN

Lecture 6: FULL OUTER JOIN

Lecture 7: Sub-queries

Lecture 8: CASE

Lecture 9: Practice what you learned in this section

Chapter 3: Filtering data

Lecture 1: Section introduction

Lecture 2: TOP N

Lecture 3: DISTINCT

Lecture 4: IN and NOT IN

Lecture 5: NULL and NOT NULL

Lecture 6: LIKE

Lecture 7: BETWEEN and NOT BETWEEN

Lecture 8: Practice what you learned in this section

Chapter 4: Aggregating data

Lecture 1: Section introduction

Lecture 2: GROUP BY

Lecture 3: COUNT

Lecture 4: SUM

Lecture 5: MIN and MAX

Lecture 6: HAVING

Lecture 7: Practice what you learned in this section

Chapter 5: Set operations

Lecture 1: Section introduction

Lecture 2: UNION and UNION ALL

Lecture 3: INTERSECT

Lecture 4: Practice what you learned in this section

Chapter 6: Conclusion

Lecture 1: Wrap up

Instructors

Bereket Wolde
Solution Architect

Rating Distribution

1 stars: 1 votes

2 stars: 8 votes

3 stars: 19 votes

4 stars: 90 votes

5 stars: 117 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!