Data Analysis Session 05

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

Workshop / hands-on session

About this event

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

2. 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).

3. Aggregation Functions: SUM, AVG, COUNT, MIN/MAX.

4. GROUP BY and HAVING: Group data and filter grouped data.

5. Subqueries: Nested queries for complex data analysis.

6. DML (Data Manipulation Language): ◦ INSERT, UPDATE, DELETE: Commands for modifying data.

7. DDL (Data Definition Language): ◦ CREATE, DROP, ALTER: Commands for managing database structures.

8. TCL (Transaction Control Language): ◦ BEGIN, COMMIT, ROLLBACK: Commands for managing transactions.  

When

When

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

Organizers

  • Mazen El Daly

    Leader Of The Community

  • Mariam Adel

    AI & Multi cloud Engineer

  • Marwan Megahed

    Machine Learning |Head

  • Ismail Elyan

    Machine Learning | Co Head

  • Abdallah Hamdy

    Flutter | Head

  • Youssef sa3d Ramadan

    HR Team

  • Rofaida Samy

    HR Team

  • Fareda Mohamed

    HR Team

  • Aya Ayman2

    HR Team