SQL Server

This course provides a comprehensive introduction to Microsoft SQL Server and the principles of relational database management. It is designed for beginners and aspiring data and software professionals who want to learn how to store, manage, and retrieve data efficiently using SQL.

  • Students will begin with an introduction to databases, learning how data is structured, how tables relate to each other, and how database systems are used in real-world applications. They will then explore Data Definition Language (DDL) to create, modify, and manage database structures such as tables, relationships, and constraints.

  • The course continues with Data Manipulation Language (DML), where students will learn how to insert, update, and delete data. This is followed by Data Query Language (DQL), focusing on retrieving data using powerful SELECT statements. Students will also learn how to combine data from multiple tables using SQL joins and set operations, enabling them to answer complex business questions.

  • Learners will develop skills in using aggregate functions to analyze data and SQL functions and triggers to automate and enhance database behavior. The course also covers stored procedures, allowing students to write reusable, efficient database logic for real-world applications. Finally, students will study Data Control Language (DCL) to manage users, roles, and database security.

  • This course follows a project-based learning approach, with regular exercises and assignments designed to reinforce key concepts. Students will apply their knowledge in a final group project, where they will design and build a complete database solution for a real-world scenario.

  • By the end of the course, students will be able to confidently design databases, write complex SQL queries, and manage data in SQL Server for professional applications.

Pricing options

Payment is once only and you have unlimited access to the material.

  • £300 Now £240.00

    Zoom Class and Videos

    Buy now

  • £150 Now £120

    ቪድዮ ንበይኑ One time payment

    Buy now

Course curriculum

    1. About this course

    2. Introduction to Database

    3. What is a relational database

    4. Structured Query Language - SQL

    5. Windows - Getting started with SQL Server

    6. MacOS - Getting started with SQL Server using Docker and VS Code

    1. Introduction

    2. Create/Drop Database

    3. Data Types Part 1

    4. Data Types Part 2

    5. Create/Drop Table

    6. Primary Key

    7. Unique Constraint

    8. Check Constraint

    9. NOT NULL and DEFAULT

    10. Foriegn Key

    11. Alter Statement

    12. Truncate Statement

    13. DDL Assignment

    1. Introduction

    2. INSERT Statement

    3. INSERT INTO Statement

    4. UPDATE Statement

    5. DELETE Statement

    6. DML Exercise

    1. Introduction

    2. SELECT

    3. Where Clause

    4. AND & OR

    5. LIKE

    6. IS & NOT

    7. DISTINCT

    8. ORDER

    1. Introduction

    2. Left Join

    3. Left Outer Join

    4. Right Join

    5. Right Outer Join

    6. Full Outer Join

    7. Inner Join

    8. Union

    9. Cross Join

    10. SQL Joins Assignment

    1. Introduction

    2. Count

    3. Min

    4. Max

    5. Avg

    6. Sum

    7. Group By

    8. Having

    9. Common Table Expression - CTE

    10. AVERAGE - AVG

    11. Sum - SUM

About this course

  • £240.00
  • 82 lessons
  • 15 hours of video content

Introduction

Discover your potential, starting today

Enroll today