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).
Just another CUNY Academic Commons site
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).
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.
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.
We continue creating, dropping and altering objects like databases, schemata, tables and views.
Download the class notes for day 7.
We have started creating objects like databases, schemata and tables.
Download the class notes for day 6.
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.
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.
We continue working with built-in functions — those that affect strings and those that affect numeric values.
Download the class notes for day 3.
So far, we have covered built-in functions that affect strings and how to retrieve data from one or multiple tables.
Download the class notes for day 2.
We have started a new course. You will learn the basics of SQL.
Download the class notes for day 1.