Contents
1. introduction to relational databases
- Introduction to the topic of databases.
- Structure of relational databases.
- Write SQL queries and read relational databases.
- Extract company-relevant information.
- Filter data with Boolean logic.
2. deepening in SQL
- Group and sort data.
- Connect queries with different joins.
- Use subqueries and extended filter options.
3. specialization in database design
- Structures of relational databases.
- Database design and normalization rules.
- Create or change tables and data.
- Practical project: Designing and implementing a database.
4. advanced use
- There are two options for the fourth chapter. Choose the topic that best suits your area of work.
- SQL with a focus on analytics: You analyze a database independently - from the first exploration to the last query.
- SQL with a focus on the backend: You will work with a completely new database and apply all the content you have learned independently. You will also learn where SQL is used in everyday work.
Learning environment
This online course offers you a particularly practice-oriented learning concept with comprehensive self-study units and a team of mentors who are available to you at all times. A new chapter is unlocked for you every week. With a time budget of around 8 hours per week, you are sure to reach your goal in 4 weeks. This is how you learn in the course:
Data Lab: In the learning environment of the course, you can expect videos, interactive graphics, text and, above all, many practical exercises with comprehensive datasets. You can run these directly in the browser or import them into Power BI.
Mentor team: Your learning coaches are on hand to answer any questions you may have. They are experienced data analysts who will be happy to help you - via chat, audio or video call.
Webinars: Once a week, you have the opportunity to take part in webinars and immerse yourself in selected specialist data analysis topics.
Career coaching: What professional goals are you pursuing with your further education and how can you achieve them? A team of mentors is ready to help you achieve your career goals.
Certificate: After the final project, you will receive your official certificate of participation in this training course.
This online training is provided by our partner StackFuel GmbH. StackFuel specializes in training courses on data literacy, data science and AI.
Your benefit
In this practice-oriented training course, you will learn how to set up and configure databases and structure data independently.
You will learn how to create data overviews quickly and practically with SQL in order to write and execute basic and advanced SQL queries.
You will learn all about key functions for organizing, filtering and categorizing information in a relational database.
You will learn to understand and implement good database design - including normalization rules and the most common schemas.
You will gain advanced specialist knowledge of views, CTEs, subqueries and window functions.
You will learn how databases interact with web applications and what role SQL plays in web development.
You not only learn theory, but also apply the methods and techniques in many practical exercises and consolidate your knowledge quickly and sustainably.
The technical barriers to entry are minimized through the use of Jupyter notebooks, with which you can carry out the exercises directly in the browser.
Recommended for
This course is aimed at anyone who wants to learn SQL quickly and practically, apply their specialist knowledge and thus improve their IT skills. The course also provides important basic knowledge for a career in the IT or tech industry or for a career as a data scientist or business intelligence consultant.
This course is suitable for career changers and offers the ideal introduction to database technologies. No prior knowledge or programming skills are required.