Guide to effective SQL queries for relational databases
With the SQL & Relational Databases training you build up practical expert knowledge for SQL and relational databases. We'll break down common SQL practices and teach you how to get the most out of relational databases with the latest best practices.
The advanced training is designed for anyone who wants to learn SQL quickly and practically, apply the expertise 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 become Data Scientist or Business Intelligence Consultants.
In the first chapter you get into the topic Databases one. You learn what databases are and where they are used for what reason. You understand how relational databases are built and know their Advantages and disadvantages. You dive deeper into ER diagrams (Entity Relationship Model) and learn to read them. You build your knowledge around the most important SQL terms and locate SQL as the language to communicate with relational databases. You get an overview of how these Interaction works and what SQL can do.
In the second chapter you will learn independently SQL queries and to read relational databases in order to extract company-relevant information. Thereby you distinguish Data formats from each other, learn the Boolean logic and filter tables with Boolean operators. In the first Practice project apply previous learning and build a toolkit to filter, group, sort, and connect data (Join).
In the third chapter you will concentrate on advanced SQL concepts and techniques and how to use them to overcome limitations of basic SQL queries. This includes four concepts for reusing query results: Subqueries, Views, Common Table Expressions (CTEs) as well as the Table creation. In several use cases you will learn advanced filtering and joining methods using nested SQL queries. You'll also learn how to speed up your queries (Indexes) and apply in the second Practice project all the learning content taught so far.
OPTION 1: FOCUS ON ANALYTICS
In the last chapter the Final project in focus. You will analyze a completely new database independently - from the first exploration to the last query. For this purpose, we teach you two other important concepts that often come up in everyday work with SQL: You learn how to work with Common Table Expressions (CTEs) maintain an overview even with complex queries. You will also build up in-depth knowledge of analytical functions in order to Rankings create or running sums over longer periods of time. In addition, you will get an overview of how you can use SQL in practice after the training and which tools are available to you for this purpose.
OPTION 2: FOCUS ON BACKEND
You will work with a completely new database and independently apply all the content you have learned. In addition, the chapter teaches you where SQL appears in everyday work: You will learn how to use databases with Web applications interact and what role SQL plays in the Web development plays. You also build in-depth knowledge about the Performance optimization of SQL queries. In addition, you will get an overview of how you can use SQL in practice after the training and which tools are available to you for this purpose.