We continue retrieving data from different tables, using functions and now CASE clauses.
Download the class notes for day 5.
SQL
Introduction to Structured Query Language for Data Analytics (WS23SQL1001) — Day 4
We have started working with functions — currently playing with aggregate functions and the need to use GROUP BY when calling fields that are not subject to any aggregate function.
Download the class notes for day 4.
Introduction to Structured Query Language for Data Analytics (WS23SQL1001) — Day 3
We have started working with functions — currently playing with strings and making numbers (dates and currency) into strings.
Download the class notes for day 3.
Introduction to Structured Query Language for Data Analytics (WS23SQL1001) — Day 2
We are finally writing code to query data from tables.
SELECT field1, field2... FROM table1 AS t1 INNER|LEFT|RIGHT JOIN table2 AS t2 ON t1.common_data = t2.common_data;
Download the class notes for day 2.
Introduction to Structured Query Language for Data Analytics (WS23SQL1001) — Day 1
We have started a new course. We will cover the basics of SQL from querying to creating and altering data objects. It will be a fun ride.
Download the class notes for day 1.
Intermediate Structured Query Language for Data Analytics (WS231) — Day 10
We have finished another course. Remember that programming is a fun experience as we can tell a machine and tell it what to do. I hope you had fun in this course and continue learning SQL and related technologies like Python.
Download the class notes for day 10.
Intermediate Structured Query Language for Data Analytics (WS231) — Day 9 (π)
We are one more session away from finishing this course. I hope you have had fun.
Download the class notes for day 9.
Intermediate Structured Query Language for Data Analytics (WS231) — Day 8
We have finished all new material for this class and have started the review for the final next week.
Download the class notes for day 8.
Intermediate Structured Query Language for Data Analytics (WS231) — Day 7
We continued taking a look at LOGINs, USERs, ROLEs, AUTHENTICATION and other data objects. We also looked at how to BACKUP and RESTORE databases.
Download the class notes for day 7.
Intermediate Structured Query Language for Data Analytics (WS231) — Day 6
We have covered how to CREATE, DROP and ALTER several objects including user-defined functions, stored procedures, triggers and sequences. We have also covered normalization as well as learning how to CREATE, DROP and ALTER logins and users.
Download the class notes for day 6.
