SQL | SQLITE - Aggregate Functions, Group By, Distinct

Published: 27 September 2021
on channel: TechPulse Academy

703

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.

Playlist:    • Database Course Introduction {قواعد بيانات...
Facebook page:   / olearningo
Facebook Group:   / 1296343220550686

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

On this page of the site you can watch the video online SQL | SQLITE - Aggregate Functions, Group By, Distinct with a duration of hours minute second in good quality, which was uploaded by the user TechPulse Academy 27 September 2021, share the link with friends and acquaintances, this video has already been watched 703 times on youtube and it was liked by 18 viewers. Enjoy your viewing!

3,097

113