Having founded a company in Zurich and having hired over 40 Software Engineers, Thorben has a good i ...
Introduction to SQL
If data is the new oil, SQL is what allows you to manage this precious resource: it is the standard language for relational database management systems. If you work (or want to work) with data, learning SQL will definitely boost your career. This course takes you from novice to comfortably leveraging SQL within four weeks, through both theory and lots of hands-on practice.
We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. To this day, an overwhelming majority of businesses store their data in relational databases, which makes familiarity with SQL an essential skill for everyone.
Introduction to SQL
If data is the new oil, SQL is what allows you to manage this precious resource: it is the standard language for relational database management systems. If you work (or want to work) with data, learning SQL will definitely boost your career. This course takes you from novice to comfortably leveraging SQL within four weeks, through both theory and lots of hands-on practice.
We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. To this day, an overwhelming majority of businesses store their data in relational databases, which makes familiarity with SQL an essential skill for everyone.
What you'll learn
This course starts by introducing you to DBeaver, a Software you will use to interact with databases. Then, you will learn how to define, manipulate and query data using SQL , starting from basic commands like how to create and modify tables, create, retrieve, update and delete records. Once you have enough practice with the basics, we will explore intermediate concepts such as joining tables, conditional expressions, indexing and views. Finally, we will cover advanced topics by looking at window functions, common table expression and database design.
Schedule:
Schedule:
- This remote course runs for 4 weeks on Monday and Wednesday from 16:00 to 19:00.
- On Mondays you will be introduced to new SQL concepts during the lecture. On Wednesdays you will have an intensive exercise session supervised by a Teaching Assistant.
1
Basic SQL
2
Intermediate SQL
3
Advanced SQL
4
Advanced SQL II
Tools we teach
SQL
Postgres
Application Process & Prerequisites
Simply apply to the program here. The only prerequisite is that you own a computer, are new to SQL and are not intimidated by technology.
FAQs
Who should attend this course?
Is there an interview selection for this course?
Your Instructors
About Us
Our motto is { CodeHard: PlayHard }
We aspire to boost Switzerland’s and Germany’s startup scene and tech industry by educating the next generation of Data Scientists, Full-Stack Developers, and Big Data Engineers.
We believe that the latest technologies should be accessible to everyone. We create learning environments that are inspiring and overcome doubts of the impossible. Everyone has the ability to learn tech skills, which is why we want to guide motivated and talented people towards the future of their dreams.
