On request
3 days
English
Online
Certificate of Participation
online
LECTURER
Dr. Dina Deifallah
1295 โฌ
Recognized as Bildungszeit
RELATIONAL DATABASES AND DATA QUERYING
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 be familiar with the basic concepts of relational databases (RDBs) and will have deepened their knowledge of proven methods for modeling them. With the goal of gaining valuable business insights, participants will learn to formulate different types of SQL queries. This will enable them to create, organize, update and retrieve databases.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
The Northwind Traders database is used as a case study for the development of the content. MySQL Server and MySQL Workbench will be used during the course.
Target group
Professionals and researchers who interact with relational databases and want to learn how to perform data analysis and prepare reports using SQL.The 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 B1 (according to the European Framework)
- Laptop (no specific operating system required) + headset with microphone
Dates
The dates will be announced on request.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.
