Course description
SQL (Structured Query Language) is the world’s dominant database language. It IS used in one of database systems for creating queries (queries) 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 training, you will build up practice-oriented expert knowledge of SQL and relational databases. We clean up with renowned SQL practices and teach you how to get the most out of relational databases with the latest best practices.
With our SQL & Relational Databases training, you will build up practice-oriented expert knowledge of SQL and relational databases. We clean up with renowned SQL practices and 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
- Create data summaries quickly and hands-on with SQL to write and execute basic and advanced SQL queries
- Choose the correct SQL query technique according to the situation and create optimized queries
- Key functions to order, filter and categorize information in a relational database
- Selected practical projects and programming exercises in the Jupyter Notebook
- Advanced knowledge of views, cte’s, subqueries and window functions
Target Audience
The training 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 aspire to a career in the IT or tech industry or want to become a data scientist or business intelligence consultant.
Prerequisites for participation
No programming knowledge is required for the training.
