T-SQL and SQL Server Basics: A Practical Course for Beginners

About Course

You will learn to read and write complex database queries using one of the most popular programming languages – SQL and the super popular DBMS (database management system) – SQL Server. All the knowledge that you will gain in the course is easily applicable to other DBMSs, such as MySQL, PostgreSQL, Oracle. Learning SQL is one of the fastest ways to climb the career ladder and start earning even more. During the course, you will study and receive assignments to test yourself and improve your understanding of the material.

Relational model and SQL
Data Types in SQL Server
Creating a database and tables
Relationships 1 to 1, 1 to many, many to many
Selections - SELECT
Data filtering - WHERE
Sorting and grouping data
Operators UNION, INTERSECT, EXCEPT over sets
Table joins
Subqueries

Course Content

Introduction to SQL

Basic Concepts
Relational model
Briefly about SQL Server
Installing SQL Server 2019
Data types
Creating a database
One to one relationship”
Many-to-many relationship”
Creating Northwind

Simple queries with SELECT

Full sample
Sampling and basic arithmetic operations
DISTINCT
COUNT
DZ “simple samples”
DZ “simple samples” – Solution
WHERE
AND, OR
BETWEEN
IN, NOT IN
LIKE
TOP
Checking for NULL
GROUP BY
HAVING
UNION, INTERSECT, EXCEPT
DZ “grouping, matching, sorting”
DZ “grouping, matching, sorting” – Solution

Joins – JOINs

Subqueries

DDL – managing database and tables

Managing tables
DZ 1 according to DDL
DZ 1 by DDL – Solution
Primary key
External key
Check
Default
INSERT INTO
DELETE
DZ 2 according to DDL
DZ 2 by DDL – Solution

Database design

Representation

Logic with CASE, COALESCE and NULLIF

Procedures and functions

Transactions

Errors and their handling

Indexes

Common Table Expressions – CTE

Window functions

Student Ratings & Reviews

No Review Yet