Course description
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% of all job advertisements for tech jobs require the latest SQL skills in the job profile.
In this course you will learn
- Write and execute basic and advanced SQL queries to quickly create data summaries
- Choose the correct SQL query technique according to the situation and create optimized queries
- 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
Target Audience
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.
Prerequisites for participation
No programming knowledge is required for the course.
