- 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