SQL for beginners – Microsoft SQL Server

SQL for beginners - Microsoft SQL Server

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

 

SQL for beginners - Microsoft SQL ServerSQL for beginners - Microsoft SQL Server

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate