Datat Analysis Session 05

Name: Datat Analysis Session 05
Start: 2024-12-25T12:00:00+02:00
End: 2024-12-25T14:30:00+02:00
Location: Benha University Obour Branch

Benha University Obour Branch, F, Al Obour City, 6360231

GDG on Campus Benha National University - Obour, Egypt

1. SQL Basics: ◦ SQL Commands: DDL, DML, DCL, TCL, and DQL. ◦ Data Types: Numeric, text, date/time, and boolean. 2. DQL ...

Dec 25, 2024, 10:00 AM – 12:30 PM (UTC)

0 RSVP'd

Key Themes

DataGoogle Analytics

About this event

SQL Basics: ◦ SQL Commands: DDL, DML, DCL, TCL, and DQL. ◦ Data Types: Numeric, text, date/time, and boolean. 
DQL (Data Query Language): ◦ SELECT Statement: Retrieves data from a database. ◦ WHERE Clause: Filters data based on conditions. ◦ JOINs: Combines data from multiple tables (INNER, LEFT, RIGHT, FULL OUTER). 
Aggregation Functions: SUM, AVG, COUNT, MIN/MAX. 
GROUP BY and HAVING: Group data and filter grouped data. 
Subqueries: Nested queries for complex data analysis.
DML (Data Manipulation Language): ◦ INSERT, UPDATE, DELETE: Commands for modifying data.
DDL (Data Definition Language): ◦ CREATE, DROP, ALTER: Commands for managing database structures. 
TCL (Transaction Control Language): ◦ BEGIN, COMMIT, ROLLBACK: Commands for managing transactions.  