Introduction

• What is SQL
• Who should Learn SQL

Installation of SQL SERVER 2019

• How to install SQL Server 2019
• Installation of SQL Server management System

An overview on SQL

• What is DBMS and RDBMS?
• Difference between Database Engine, Database Server and Database Software
• What is a database? How to create and use a database?
• What is a database table? How to create and use a database table?
• How to add the data rows to a database table?
• Understand Keywords, Identifiers, Constants and Clauses
• Learn about SQL Statements
• Data Definition Language (DDL) and Data Manipulation Language (DML)?

SQL Queries Topics

• Lesson 1: Introduction to SQL
• Lesson 2: Retrieving Data
• Lesson 3: Updating Data
• Lesson 4: Inserting Data
• Lesson 5: Deleting Data
• Lesson 6: Sorting and Filtering Data
• Lesson 7: Advanced Filtering
• Lesson 8: Summarizing Data
• Lesson 9: Grouping Data
• Lesson 10: Using Sub queries
• Lesson 11: Joining Tables
• Lesson 12: Managing Tables
• Lesson 13: Using Views
• Lesson 14: Stored Procedures
• Lesson 15: Using Cursors
• Lesson 16: Using Transactions