We have covered so far how to query data from one or multiple tables as well as how to manipulate data using built-in functions and adding logic using `CASE`.
Download the class notes for day 3.
SQL
Database Administration Fundamentals (WS19SQL10004) – Day 2
We have started working with built-in functions to manipulate strings and numbers.
Download the class notes for day 2.
Database Administration Fundamentals (WS19SQL10004) – Day 1
We have started a new course. You will learn the basics of SQL, which will prepare you for the Intermediate SQL course. It is time to have fun.
Download the class notes for day 1.
Database Administration Fundamentals (SF18SQL10002) – Day 10
Congratulate yourself. You finished the Introduction to SQL course. You now have the foundation to work with SQL.
Download the class notes for day 10 (the final).
Database Administration Fundamentals (SF18SQL10002) – Day 9
We have finished all material for this course. We will meet one more time to take care of the final.
Download the class notes for day 9.
Database Administration Fundamentals (SF18SQL10002) – Day 8
We have covered most of the material for the course. We have one more class day and then the final.
Download the class notes for day 8.
Database Administration Fundamentals (SF18SQL10002) – Day 7
We continue creating, dropping and altering objects like databases, schemata, tables and views.
Download the class notes for day 7.
Database Administration Fundamentals (SF18SQL10002) – Day 6
We have started creating objects like databases, schemata and tables.
Download the class notes for day 6.
Database Administration Fundamentals (SF18SQL10002) – Day 5
We are half-way finished with the course. We are almost ready to CREATE, DROP and ALTER objects like databases, schemata, tables and views.
Download the class notes for day 5.
Database Administration Fundamentals (SF18SQL10002) – Day 4
We have covered INNER JOIN (finding shared data between data sets), built-in functions and data types. We are now ready to create objects.
Download the class notes for day 4.
