Course curriculum

  • 1

    What We Will Learn?

    • What we will learn?
  • 2

    Introduction

    • What is database?

    • RDBMS (Relational Database Management System)

    • What is SQL/Query?
  • 3

    Database Normalization

    • Normalization

    • Normal Forms (NF)
  • 4

    Installation

    • Install MS SQL Server Express Edition 2017
  • 5

    Starting to SSMS

    • Starting To SSMS (SQL Server Management Studio)

    • Create, Alter and Drop Database

    • Create, Rename and Drop Table

    • Data Types and Constraints

    • Foreign Key Constraint

    • Unique & Check Constraint
  • 6

    Manipulating Data

    • Insert Data To Table

    • Update Data In A Table

    • Delete Data and AdventureWorks
  • 7

    Basic Select Statement

    • Select Statement and Alias

    • Where Clause and Operators
  • 8

    Sorting and Grouping Data

    • Sorting and Grouping Data
  • 9

    Wildcard Operations

    • Like Clause
  • 10

    IF-THEN Statement

    • Case Function
  • 11

    Conversion Functions

    • Convert and Cast Function
  • 12

    Retrieve Data From Multiple Tables

    • Inner Join

    • Left and Right Join

    • Full and Self Join
  • 13

    Set Operations

    • Union Operators

    • Intersect and Except Operators
  • 14

    Subqueries

    • Subqueries With Select Statement
  • 15

    DateTime Functions

    • DateTime Function

    • Converting DateTime
  • 16

    String Functions

    • String Functions
  • 17

    Math Functions

    • Math Functions
  • 18

    SQL Transactions

    • SQL Transactions

    • SQL Transactions Commands
  • 19

    Schema Objects and Managing Schema

    • Create Schema and View

    • Create Sequence
  • 20

    User Management

    • Create Logins

    • Users & User Permissions

    • Permissions & Roles
  • 21

    What We Have Learned?

    • What we have learned?