Understanding the Concept of SQL and Relational Database Management Systems (RDBMS)

Installation Methods for SQL Server and MySQL

Working with Command Line Client vs. Workbench

Introduction to String Functions

CONCATENATE, SUBSTRING, REPLACE, and REVERSE Functions

Using UPPER and LOWER Functions for Case Conversion

Understanding the DISTINCT Keyword

Sorting Results with ORDER BY

Limiting Results with LIMIT

Using the LIKE Operator for Pattern Matching

Adding Columns with ALTER TABLE

Dropping Columns from Tables

Renaming Columns with ALTER TABLE

Creating Databases in SQL Server and MySQL

Creating Tables with Various Data Types

Understanding Primary Keys and Foreign Keys

Overview of CRUD (Create, Read, Update, Delete) Commands

INSERT and MULTI-INSERT Statements for Adding Data to Tables

Performing CRUD Operations on Tables

Common Issues and Troubleshooting with CRUD Functions

Introduction to Aggregate Functions

GROUP BY Clause for Grouping Data

Using MIN, MAX, SUM, and AVG Functions

Understanding Logical Operators (NOT EQUAL, NOT LIKE, GREATER THAN, AND, OR)

Combining Multiple Conditions with AND and OR

Using Logical Operators in WHERE Clauses

Understanding One-to-Many Relationships

Establishing Many-to-Many Relationships with Junction Tables

Implementing Relationships in SQL Tables

Introduction to Window Functions

Using the OVER Clause

Ranking Data with RANK, NTILE, LEAD, and LAG Functions

SQL-Q1