We have finished all new material for this course.
Download the class notes for day 9.
Open Source
Database Administration Fundamentals (SF21SQL1001) – Day 9
We have finished covering all the material for this course.
Download the class notes for day 9.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 8
We have finished all new material for this course.
Download the class notes for day 8.
Database Administration Fundamentals (SF21SQL1001) – Day 8
We are two sessions away to finish the course and we have covered all the material for this course.
Download the class notes for day 8.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 7
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.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 6
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.
Database Administration Fundamentals (SF21SQL1001) – Day 7
We are almost done with the course. We have covered how to SELECT (retrieve data), various built-in functions including FORMAT() and how to CREATE, ALTER and DROP various data objects.
Download the class notes for day 7.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 5
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.
Database Administration Fundamentals (SF21SQL1001) – Day 6
We started creating data objects.
CREATE obj_type obj_name [some_code]
DROP obj_type obj_name
ALTER obj_type obj_name
ALTER obj_type obj_name data_type
Download the class notes for day 6.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 4
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.
