TU BERLIN ACADEMY FOR PROFESSIONAL EDUCATION
a
a
a
M
COURSE DATES

07.06.2024-08.06.2024 + 14.06.2024-15.06.2024
COURSE DURATION

3 days
LANGUAGE

English
LOCATION

Online
CERTIFICATE

Certificate of Participation
FORMAT

Online

LECTURER


Dr. Dina Deifallah
PRICE

1400 €

Recognized as Bildungszeit
Category: Tag:

RELATIONAL DATABASES AND DATA QUERYING
07.06.2024-08.06.2024+14.06.2024-15.06.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
Fundamental SQL Queries
  • 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
Advanced SQL Queries
  • 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

June 07 – 08, 2024 and June 14 – 15, 2024 (virtual classroom sessions).

Expected hours on Fridays from 15:00 - 19:00 (CET) and on Saturdays from 10:00 - 18:00 (CET).

This course will also be offered in December 2024.

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.

PDF Download
Interested in signing up for this course?

Out of stock

Or do you have other questions?
Preloader