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

  • Home
  • T-SQL and SQL Server Basics: A Practical Course for Beginners
Shape Image One

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.

What Will You Learn?

  • 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

Joins – JOINs

Subqueries

DDL – managing database and tables

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
No Review Yet