Thank you for taking class SF21JOB#2.
Download the class notes for day 10.
Just another CUNY Academic Commons site
Thank you for taking class SF21JOB#2.
Download the class notes for day 10.
We have finished all new material for this course.
Download the class notes for day 9.
We have finished all new material for this course.
Download the class notes for day 8.
We are almost done with this course. We have covered how to SELECT data from tables throughout several sessions. We have also just started to CREATE and DROP objects.
Download the class notes for day 7.
We are almost ready to start working with database objects. In the meantime, we reviewed all the material so far.
Download the class notes for day 6.
We continue covering built-in functions and slightly covered the CASE clause.
CASE WHEN some_condition_1 THEN some_action_1 -- if this condition fails, -- need to go to the next one WHEN some_condition_2 THEN some_action_2 -- if this condition fails, -- need to go to the next one WHEN some_condition_3 THEN some_action_3 -- if this condition fails, -- need to go to the next one ... ELSE escape_action -- if all prior conditions fail, -- need to perform this action END
Download the class notes for day 5.
We have continue retrieving data from one or more tables and using built-in functions — this time, aggregate functions. Just remember to use GROUP BY.
Download the class notes for day 4.
We have reviewed all functions prior to creating objects.
Download the class notes for day 5.
We have started retrieving data from one or more tables and using built-in functions. It is time for fun!
Download the class notes for day 3.
We are finally looking at code and now you can retrieve data.
SELECT field1, field2... FROM table1 INNER|LEFT|RIGHT JOIN table2 ON table1.shared_value = table2.shared_value;
Download the class notes for day 2.