In this course you’ll learn how to read and write complex queries to a database using one of the most in demand databases, PostgreSQL. The commands you will learn are applicable to all major SQL databases, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle.
- Introduction to Databases
- SQL basics: syntax, statement fundamentals,
- More advanced SQL queries: GROUPBY and aggregations statements
- JOINS statements
You will have dedicated use of an SQL Server for the database exercises to apply what you learn.
You will obtain a solid understanding what a database system and what the relational model of data is.
You will know how to retrieve data by creating complex queries
Active Learning, in combination with theoretical teaching and hands-on practice with guidance from the teacher and assistant. The teaching unit is in the form of a workshop with about 30 minutes of lecture and then with practice in hands-on exercises and problems.