SQL – Datacrunch Academy

Know more about this course

This course is designed to teach you the fundamentals of SQL (Structured Query Language) and database management. It is ideal for beginners and professionals looking to enhance their data management skills.

Course Content

What is SQL?

Definition and uses

00:00
Brief history of SQL

00:00
Overview of relational databases

00:00

Setting Up the Environment

Basic SQL Syntax

SELECT Statement Basics

Filtering Data

Sorting Data

Working with NULL Values

Aggregate Functions

Joins

Subqueries

Inserting Data

Updating Data

Deleting Data

Data Types

Creating and Modifying Tables

Indexes and Views

Transactions and Concurrency

Stored Procedures and Functions

Triggers

Performance Optimization

Window Functions

Common Table Expressions (CTEs)

Advanced Subqueries and Joins

Capstone Project

Assessment and Review

Student Ratings & Reviews

No Review Yet

Know more about this course

What will you learn in this course?

Course Content

What is SQL?

Definition and uses

Brief history of SQL

Overview of relational databases

Setting Up the Environment

Installing a database (e.g., MySQL, PostgreSQL, SQL Server, SQLite)

Introduction to SQL clients (e.g., MySQL Workbench, pgAdmin, SQL Server Management Studio)

Basic SQL Syntax

SQL statements (SELECT, INSERT, UPDATE, DELETE)

Understanding SQL structure (keywords, clauses, expressions)

SELECT Statement Basics

Selecting columns and rows

Using aliases

Filtering Data

WHERE clause

Logical operators (AND, OR, NOT)

Comparison operators (=, , >, =, <=)

Sorting Data

ORDER BY clause

Sorting by multiple columns

Working with NULL Values

IS NULL and IS NOT NULL

Aggregate Functions

COUNT, SUM, AVG, MIN, MAX

GROUP BY clause

HAVING clause

Joins

Inner Join

Left Join

Right Join

Full Outer Join

Self Join

Subqueries

Subqueries in SELECT, WHERE, and FROM clauses

Correlated subqueries

Inserting Data

INSERT INTO statement

Inserting multiple rows

Updating Data

UPDATE statement

Using subqueries in updates

Deleting Data

DELETE FROM statement

Using subqueries in deletes

Data Types

Numeric, string, date/time, and other data types

Creating and Modifying Tables

CREATE TABLE statement

ALTER TABLE statement

Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, DEFAULT)

Indexes and Views

Creating and using indexes

Creating and using views

Transactions and Concurrency

Transaction control (COMMIT, ROLLBACK, SAVEPOINT)

Isolation levels and concurrency control

Stored Procedures and Functions

Creating and using stored procedures

Creating and using user-defined functions

Triggers

Creating and using triggers

Practical use cases

Performance Optimization

Query optimization techniques

Analyzing and using execution plans

Index optimization

Window Functions

OVER() clause

Ranking functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE)

Aggregate functions as window functions

Common Table Expressions (CTEs)

Using CTEs for complex queries

Advanced Subqueries and Joins

Recursive CTEs

Advanced join techniques

Capstone Project

Design and implement a small database