We have reviewed all functions prior to creating objects.
Download the class notes for day 5.
Open Source
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.
Installing SQL Server Express in macOS #3
There is no native installation for macOS, but there are instructions how to install the Linux port using a Docker container.
More information:
Database Administration Fundamentals (SF21SQL1001) – Day 2
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 2.
Database Administration Fundamentals (SF21SQL1001) – Day 1
We have started a new class. We covered what SQL can do like getting the correct cookies when going to The Corner Shop for a boss who does not give up complete details of what you need to buy.
Download the class notes for day 1.
Get Started with a List of Reference Sites: Where to Get Help When Needed or What to Read When Bored
Get yourself a list of websites and other resources to read and for reference. The following are some recommendations.
- https://arstechnica.com/
- https://apachefriends.org/
- https://cloudsavvyit.com/
- https://cnet.com/
- https://dev.to/
- https://freecodecamp.org/
- https://mariadb.org/
- https://mongodb.com/
https://mongodb.com/blog - https://mysql.com/
- https://news.ycombinator.com/
- https://oracle.com/
- https://phpmyadmin.net/
- https://postgresql.org/
- https://slashdot.org/
- https://sqlite.org/
- https://techonthenet.com/
https://techonthenet.com/sql_server/ - https://techrepublic.com/
- https://wired.com/
