Kursbeschreibung
SQL (Structured Query Language) is the world’s dominant database language. It is used in a wide variety of database systems for querying and processing data.
SQL is supported by leading database programs such as MySQL, Microsoft SQL Server and Oracle Database. For most companies, the biggest challenge is turning raw data into actionable insights. Much of the world’s Big Data — from electronic medical records to online shopping purchases and transaction logs in bank customer accounts — resides in organized collections of tables called relational databases.Companies all over the world are therefore looking for people who can understand such data and evaluate it with SQL.
With our SQL & Relational Databases course you will build up practice-oriented expert knowledge of SQL and relational databases. We teach you how to get the most out of relational databases with the latest best practices.
Quick Fact: 50 % aller Jobinserate für Tech-Jobs verlangen die neusten SQL-Skills im Stellenprofil.
In diesem Training lernst Du
- Write and execute basic and advanced SQL queries to quickly create data summaries
- Situationsgerecht die korrekte SQL-Abfragetechnik wählen und optimierte Queries erzeugen.
- Key functions to order, filter and group information in a relational database
- Selected practical projects and programming exercises in Jupyter Notebooks
- Advanced knowledge of views, CTEs, subqueries and window functions
Zielgruppe
The course is aimed at anyone who wants to learn and apply SQL quickly and practically, and thus improve their IT skills. The course is also suitable for people who want to pursue a career in the IT or tech industry or want to become Data Scientists or Business Intelligence Consultants.
Voraussetzungen für die Teilnahme
No programming knowledge is required for the course.
