Database Engineering

All-In-One Package 🐘

Querying and Filtering

Joins and Aggregates

Set Operators and Subqueries

Modifying Data and Managing Table

Data Types and Constraints

Conditions and Transactions

Leetcode SQL Easy Problems (50)

Leetcode SQL Medium Problems (30)

Leetcode SQL Hard Problems (20)

Database Design & ER Modeling

Advanced Database Concepts

Database System Architecture

“4PMs — More than a concept” by Xurshidbek

Querying and Filtering

1- Sample database

2- SELECT

3- ORDER BY

4- SELECT DISTINCT

5- WHERE

6- LIMIT

7- FETCH

8- IN

9- BETWEEN

10- LIKE

11- IS NULL

Joins and Aggregates

1- JOIN

2- INNER JOIN

3- LEFT OUTER JOIN

4- LEFT ONLY

5- RIGHT OUTER JOIN

6- RIGHT ONLY

7- SELF JOIN

8- FULL JOIN

9- FULL OUTER JOIN

10- ONLY OUTER

11- CROSS JOIN

12- NATURAL JOIN

13- GROUP BY

14- HAVING

15- GROUPING SETS

16- ROLL UP

17- CUBE

18- ANALYTIC FUNTIONS

19- AVG FUNCTION

20- ROW_NUMBER, RANK, DENSE_RANK

21- FIRST_VALUE, LAST_VALUE

Set Operators and Subqueries

1- UNION

2- UNION ALL*

3- INTERSECT

4- EXCEPT

5- SUBQUERY

6- ANY

7- ALL

8- EXISTS*

Data Types and Constraints

1- INSERT

2- UPDATE

3- UPDATE JOIN

4- DELETE

5- UPSERT

6- DATA TYPE

7- CREATE TABLE

8- CTAS*

9- VIEW

10- Change Table Structure

11- Change Table Name

12- Add Column

13- Remove Column

14- Change Column Datatype

15- Change Column Name

16- Remove Table

17- Temporary Table

18- TRUNCATE

Data Types & Constrains

1- BOOLEAN

2- CHAR, VARCHAR, TEXT

3- NUMERIC

4- SERIAL

5- DATE, TIME, TIMESTAMP

6- PRIMARY KEY

7- FOREIGN KEY

8- CHECK CONSTRAINT

9- UNIQUE CONSTRAINT

10- NOT NULL CONSTRAINT

Conditions and Transactions

1- CASE

2- COALESCE

3- NULLIF

4- CAST

5- WITH

6- RECURSIVE QUERY

7- BEGIN, COMMIT

8- ROLLBACK

9- SCHEMAS

Leetcode SQL Easy Problems

1- Leetcode problem

2- Leetcode problem

3- Leetcode problem

…- Leetcode problem

48- Leetcode problem

49- Leetcode problem

50- Leetcode problem

Leetcode SQL Medium Problems

1- Leetcode problem

2- Leetcode problem

3- Leetcode problem

…- Leetcode problem

28- Leetcode problem

29- Leetcode problem

30- Leetcode problem

Leetcode SQL Hard Problems

1- Leetcode problem

2- Leetcode problem

3- Leetcode problem

…- Leetcode problem

18- Leetcode problem

19- Leetcode problem

20- Leetcode problem

Database Design & ER Modeling

1- Logical Model

2- Physical Model

3- Entities

4- Attributes

5- Cardinality

6- Relationships

7- One to One

8- One to Many

9- Many to One

10- Many to Many

11- Normalization

12- ERD Modeling

Advanced Database Concepts

1- SQL Triggers

2- Concurrency Control

3- Isolation Level

4- Database MVCC

5- Functional Dependency

6- Normalization(1st, 2nd, 3rd, 4th)

7- Database Indexing (B Tree)

8- Partition, Sharding, Replication

9- Database Connection Pool

Database System Architecture

1- DBMS — MySQL Architecture

2- System Administration

3- Backup and Recovery

4- DBMS — PostgreSQL Architecture

5- System Administration

6- Backup and Recovery

7- DBMS — SQLServer Architecture

8- System Administration

9- Backup and Recovery

10- DBMS — Oracle Architecture

11- System Administration

12- Backup and Recovery

13- NoSQL — Document Database