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.
SQL
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.
Database Administration Fundamentals (SF21SQL1001) – Day 5
We have reviewed all functions prior to creating objects.
Download the class notes for day 5.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 3
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.
Database Administration Fundamentals (SF21SQL1001) – Day 4
We continue manipulating data (without making changes in the database). We have covered functions that affect strings and numeric values — especially `CONVERT()` to change data types.
Download the class notes for day 4.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 2
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.
Database Administration Fundamentals (SF21SQL1001) – Day 3
We continue manipulating data (without making changes in the database). We have covered functions that affect strings and numeric values — including `FORMAT()` to change currency and date values.
FORMAT(numeric_value, format_needed, culture) FORMAT(numeric_value_money, 'c', 'en-us') FORMAT(numeric_value_date, 'd', 'en-us') FORMAT(numeric_value_date, 'D', 'en-us')
Download the class notes for day 3.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 1
We have started a new course and, so far, we have seen what SQL can do for us like getting the correct cookies from a store.
Download the class notes for day 1.
