Contents
1. introduction to relational databases
- Introduction to the topic of databases
- Structure of relational databases
- Writing SQL queries and reading relational databases
- Extract company-relevant information
- Filter data with Boolean logic
2. deepening in SQL
- Grouping and sorting data
- Connecting 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
- You have two options for the fourth chapter. Select 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 will be activated 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 available 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 special topics of data analysis.
Career coaching: What professional goals are you pursuing with your further training and how can you achieve them? A team of mentors is available 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.