Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server For Beginners - Part 3
Rating: 4.5 out of 5(87 ratings)
8,665 students

SQL Server For Beginners - Part 3

Sql Server querying essentials and concepts
Created byBytescout Academy
Last updated 3/2020
English

What you'll learn

  • Basic of querying in T-SQL with SQL Server

Course content

1 section • 8 lectures • 1h 10m total length

  • Overview5:40

    In this video, You will see the brief overview about what we will be going to cover in this module such as the various types of SQL Joins and SET operators available in SQL Server.

  • Understanding Inner Join10:58

    In this video, we will be going to learn the basic structure or syntax of the Inner join and how with an inner join we can match up rows in one table with corresponding rows in another table where the associated columns contain the same value. In addition to this we will also learn an older style syntax of join using the where clause.

  • Understanding Outer Join9:44

    In this video, we will be going to learn the three types of outer join available in Sql server; which are Left join, Right join and Full join. We will learn each one with example.

  • Understand Cross Join4:27

    In this video, we will be going to learn the cross join available in Sql server. We will learn how it performs Cartesian product of the two input tables.

  • Understand Cross Join8:56

    In this video, we will be going to learn the self join in detail. In addition to this we'll also learn multi join query with example.

  • UNION and UNION ALL8:17

    In this video, we will be going to learn about types of set operators UNION and UNION ALL.

  • INTERSECT and EXCEPT7:18

    In this video, we will be going to learn about last two types of set operators which are INTERSECT and EXCEPT operator.

  • Understanding Sub-Queries15:27

    SQL server is flexible enough to provides different way of doing same thing. In this video, we will be going to learn about types of Sub-queries available in SQL Server which are Self-contained sub-query and Correlated sub-query.

Requirements

  • Basic knowledge on computing

Description

In this course we'll cover basics of SQL querying and concepts with SQL Server. We'll start with basics and essentials of SQL Server, followed by SQL syntax and lastly we'll delve into SQL joins and set operators.

Following is the manifest we'll be covering. Each course video is designed to be short and concept wise complete.

  1. SQL Joins and SET Operators

    • Overview

    • Understanding Inner Join

    • Understanding Outer Join

    • Understanding Cross Join

    • Understanding Self Join

    • UNION and UNION ALL

    • INTERSECT and EXCEPT

    • Understanding Sub-Queries

Who this course is for:

  • Beginners in T-SQL

Report abuse