Module 2: Learning SQL Overview

Previous Tutorial - Next Tutorial

Welcome to this course SQL server for beginners module 2 where first we will understand the fundamentals of Transact-SQL (T-SQL). In this part, we will understand some core language elements such as what is called clauses, which is called a statement or what is a predicate, etc.

Then we will see the introduction of the SELECT statement. In this part, we will explore the general structure or syntax of the Select statement. We will also understand the role of other clauses associated with it and then we will see logical query processing. In this part, we will understand each phase involved in logical query processing.

It means how the query logically interpreted by the database engine. So this part provides a brief description of what happens in each phase according to the logical query processing. Then we will see how to filter data using the WHERE clause.

In this part, we will understand the WHERE clause in detail. We will also learn the different types of operators associated with the WHERE clause and then we will see how to sort data using ORDER by clause. In this part, we will understand the ORDER by clause and see how it sort the results based on the specified columns.

Then we will see how to grouping data using the GROUP BY Clause. So in this part, we will understand the GROUP BY Clause. It defines a group for each distinct combination of values. Then we will see how to limit the result data using the TOP (n) clause. In this part, we will see how it helped us to return only a limited number of rows using the TOP clause. The last we will play one small quiz in which we will ask you some questions and you need to answer. We will ask you some questions by writing some queries. So let’s get started.

Web API for developers Free Trial Offline SDK

SQL video tutorial:

Other useful tutorials:

• General SQL Introduction
• Module 1: Getting Started with SQL Server
• Module 1: SQL Server Management
• Module 1: Essential SQL Commands
• Module 1: SQL Introduction Essentials
• Module 2: Learning SQL Overview
• Module 2: Logical Query Processing Order
• Module 2: Select Statement Fundamentals
• Module 2: Filtering Data with WHERE Clause Overview
• Module 2: Filter Data with WHERE Clause - Part 1
• Module 2: How to Filter Data with WHERE Clause - Part 2
• Module 2: Filter PDF Data Using WHERE clause - Part 3
• Module 2: Sorting Data Using ORDER BY Clause
• Module 2: Grouping Data with GROUP BY Clause Part 1
• Module 2: Grouping Data with GROUP BY Clause Part 2
• Module 2: Grouping Data with GROUP BY Clause Part 3
• Module 2: Limiting Data With TOP Clause
• Module 2: Summary and Quiz
• Module 3: SQL Joins and SET Operators
• Module 3: Understanding Inner Join
• Module 3: Understanding Outer Join
• Module 3: Cross Join Explained
• Module 3: Self Join Explained
• Module 3: UNION and UNION ALL
• Module 3: INTERSECT and EXCEPT
• Module 3: Understanding Sub-Queries
• SQL Analytic Functions