Microsoft SQL Server

2014★★★★★(4.8)• 31 students enrolled• 15k views

Instructor

Professor Mohammed Safder Ali

Course language

English

COURSE DETAILS

Dive deep into Microsoft SQL Server Database — one of the world's most powerful enterprise-grade RDBMS. Covers installation, PL/SQL, performance tuning, security, and real-world DBA skills.

WHAT YOU'LL LEARN

✓Microsoft SQL Server Database Architecture and core concepts.

✓PL/SQL programming fundamentals.

✓DDL and DML operations in Microsoft SQL Server.

✓Advanced querying with Microsoft SQL Server-specific functions.

✓Database security, users, and privileges.

REQUIREMENTS

Skills in understanding elementary-level English.

COURSE CONTENT

∨Chapter 1 - Course Introduction

1 lecture

Live SQL Training

∨Chapter 2 - Introduction to Software Applications

9 lectures

Application Software Software Development Life Cycle Database Components Database Platforms GUI tools for SQL Development Tansy Cloud Business Application Assignment: Analyzing LinkedIn Business Application Assignment: Analyzing Netflix Social Application Assignment: Analyzing Gmail Mobile Application

∨Chapter 3 - Database Tables, Columns and Rows

5 lectures

Database Table ROWs and COLUMNs SQL Assignment - List Tables and Columns - Store Management System Assignment - List Tables and Columns - Food Delivery Application

∨Chapter 4 - Setup Sample Database

2 lectures

Online SQL Editor Database Hosting

∨Chapter 5 - DDL (Data Definition Language)

12 lectures

CREATE TABLE ALTER TABLE DROP TABLE Data Types JSON Data Type NUll vs NOT NULL CHECK Constraint DEFAULT Constraint UNIQUE Constraint AUTO INCREMENT DDL ASSIGNMENT1 - Store Management System DDL ASSIGNMENT2 - Food Delivery System

∨Chapter 6 - DML (Data Manipulation Language)

8 lectures

INSERT SELECT INTO UPDATE UPSERT DELETE TRUNCATE DML ASSIGNMENT1 - Store Management System DML ASSIGNMENT2 - Food Delivery System

∨Chapter 7 - DQL (Data Query Language)

44 lectures

SELECT * WHERE Clause TOP FETCH OFFSET DISTINCT ORDER BY BETWEEN Operator CONCAT IN Operator NOT IN Operator IS NULL Operator IS NOT NULL Operator AND and OR Operators '>' and '<' Operator (greater than, less than) '< >' or '!=' Operator (not equal) '=' (equal to) Operator LIKE Operator NOT LIKE Operator EXISTS, ANY and ALL Clause SQL Aliases GROUP BY HAVING Clause COUNT, SUM, AVG, MIN, MAX Functions CASE statement INNER JOIN LEFT JOIN RIGHT JOIN UNION and UNION ALL PIVOT Sub Queries GROUP RANK JSON SELECT Arithmetic Operators Comparison Operators Logical Operators STRING functions DATE functions NUMERIC functions SQL Execution Order CAST COALESCE DQL ASSIGNMENT1 - Store Management System DQL ASSIGNMENT2 - Food Delivery System DQL ASSIGNMENT3 - MS SQL Logic for Dashboard Reporting in a Store Management System DQL Assignment 4 - MS SQL Logic for Dashboard Reporting in a Food Delivery System

∨Chapter 8 - RDBMS Concepts

15 lectures

What is RDBMS Primary Key Foreign Key Cardinality Normalization Second Normal Form Third Normal Form Business key, Natural key and Candidate Key Surrogate Key Database Index Index Types Structured VS Unstructured ERD (Data Model) SQL Data Model Assignment - Store Management System SQL ERD Data Model Assignment - Food Delivery System

∨Chapter 9 - Advanced Topics

6 lectures

Database View Stored Procedure DB Function DB Trigger Common Table Extensions (CTE) SQL Window Functions

∨Chapter 10 - Projects

2 lectures

Final Capstone Project 1: Store Management System in MS SQL Server Final Capstone Project 2: Food Delivery System in MS SQL Server

∨Chapter 11 - Microsoft SQL Server Certifications

1 lecture

SQL certifications

STUDENT REVIEWS

No Review Found