SQL | SQLITE - Aggregate Functions, Group By, Distinct

Показать описание

Database Management Systems (DBMS) course is divided into two sub-courses: Level 1 and Level 2. In Level 1, you will learn how to QUERING a DBMS to get the data distributed over multiple relations (tables). This level is sufficient for jobs like Data Analysts, Data Scientists, Researchers, and Developers. In Level 2, you will learn all aspects related to designing the database which is useful for jobs like Data Engineers.

This is Level 1 and here is the syllabus
---------------------------------------------------------
1- Introduction to Relational Databases
2- Relational Algebra (Implementation tool: Relax)
|------ Unary Operators (Select - Project - Rename)
|------ Binary Operators
|------ Set Operators (Intersect - Union - Minus)
|------ Join Operators
|------ Inner Join (Theta - Equi - Natural)
|------ Outer Join (Left - Right - Full)
|------ Divide By Operator
|------ Aggregate Functions and Grouping
3- Tuple Relational Calculas
|------ One variable
|------ Two or more variables
|------ Quantifiers
4- DBMSs introduction
5- SQL (Implementation tool: SQLite)
|------ DDL (Create - Drop - Alter)
|------ DML (Insert - Delete - Update - Replace)
|------ DQL (Select)
|------ Select - From - Where
|------ Join
|------ Aggregate Functions and Grouping
|------ Sorting rows
|------ Set Operators (Intersect - Union - Minus)
|------ SubQueries
|------ Quantifiers
|------ Divide By Implementation
|------ Case
|------ Exercises
6- SQLite as an embedded system
|------ with Java
|------ with Python
8- SQL Dialect
9- Postgres as Client-Server model
|------ with Java
|------ with Python