06.12.2024-07.12.2024 + 13.12.2024-14.12.2024
3 days
English
Online
Certificate of Participation
Online
LECTURER
Dr. Dina Deifallah
1400 €
Recognized as Bildungszeit
RELATIONAL DATABASES AND DATA QUERYING
06.12.2024-07.12.2024+13.12.2024-14.12.2024
Data fuels the contemporary world, serving as a cornerstone for virtually every business, be it an emerging startup or an established multinational corporation. The organization and utilization of this data in relational databases hinges on a particular programming language known as Structured Query Language or SQL. Mastering the ability to manipulate and retrieve data from databases using SQL is a crucial skill in data-centric roles and beyond.
Learning goals
Upon completion of the course, participants will have explored the basic concepts of Relational Databases (RDBs) and have delved into best practices for modeling them. They will learn how to formulate various types of SQL queries to create, organize, update and query data tables in an RDB, as well as extracting valuable business insights.Content
Introduction to Relational Databases:- Definition of an RDB and applications
- MySQL Server and Workbench installation
- Difference between a RDB Server and RDB Management System
- Entity Relationship Model (ERM) and Cardinality
- Primary and Foreign Keys
- RDB Normalization
- Create, update and delete databases and tables
- Basic structure of an SQL query
- Limiting and Sorting
- Filtering
- Joining tables
- Aggregation functions
- Saving results in flat files
- CASE statements
- Correlated Subqueries
- Nested Subqueries
- Common Table Expressions
- Window functions
- Saving results in Views
Throughout the course, participants will use the Northwind Traders database as a case study. The primary software tools used in this course will be MySQL Server and MySQL Workbench.
Target group
Professionals and researchers interacting with Relational Databases and interested in learning how to perform data analyses and prepare reports using SQL.This course is suitable for beginners in SQL and Data Analysis.
This course is recognized as Bildungszeit according to paragraph § 10 (5) of the Berliner Bildungszeitgesetz (BiZeitG).
Prerequisites
- English level of at least B1 (according to the European Framework)
- Laptop (no specific operating system required) + headset with microphone
Dates
December 06 – 07, 2024 and December 13 – 14, 2024 (virtual classroom sessions).Expected hours on Fridays from 15:00 - 19:00 (CET) and on Saturdays from 10:00 - 18:00 (CET).
LECTURER
Dr. Dina Deifallah is a Data Science and Analytics lecturer in the International University of Applied Sciences (IUBH). She is a guest lecturer in the Summer and Winter School of the Technische Universität Berlin as well as the University of Europe. She also worked as a Data Scientist and Data Science coach in multiple startups in Europe since 2018. She has a Ph.D. in Communication Engineering with a focus on AI optimization algorithms and 15+ years of experience in academic teaching.
