SQL Server For Beginners - Part 3

Sql Server querying essentials and concepts
New
Rating: 4.5 out of 5 (13 ratings)
5,104 students
SQL Server For Beginners - Part 3
New
Rating: 4.5 out of 5 (13 ratings)
5,102 students
Basic of querying in T-SQL with SQL Server

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
Course content
1 section • 8 lectures • 1h 10m total length
  • Overview
    05:40
  • Understanding Inner Join
    10:58
  • Understanding Outer Join
    09:44
  • Understand Cross Join
    04:27
  • Understand Cross Join
    08:56
  • UNION and UNION ALL
    08:17
  • INTERSECT and EXCEPT
    07:18
  • Understanding Sub-Queries
    15:27

Instructor
Bytescout Learning Academy
Bytescout Academy
  • 4.1 Instructor Rating
  • 76 Reviews
  • 7,084 Students
  • 5 Courses

Founded in 2006, ByteScout, Inc. is the recognized vendor of solutions, tools and APIs for unstructured data extraction. Thousands of companies are using our technologies to replace manual data entry, decrease costs and risks in their business processes. Our products and solutions are recognized by respectful online and offline magazines such as Wall Street Journal, PC Advisor, CNET and many others. We also support academic and non-profit organizations involved into cancer research and cancer eliminating activities.