We have finished another class. I hope you enjoyed it. Thank you for joining us.
Download the class notes for day 10.
2025/11/17 SF25SQL6172025
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 9
We have finished the material and now we are getting ready for the final.
Download the class notes for day 9.
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 8
After running into errors with the original database server for this class last Wednesday and building a new server on a virtual machine running a 90-day Windows 11 Enterprise 25H2 image provided by Microsoft with SQL Server Express 2025 and SSMS 22. It was a slow installation (~3 hours), but we were back last night.
We covered how to CREATE, DROP and ALTER data objects.
Download the class notes for day 8.
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 7
We have started creating and dropping data objects.
CREATE data_object object_name [code] DROP data_object object_name ALTER data_object object_name ADD|ALTER|DROP data_object object_name
Download the class notes for day 7.
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 6
Before starting new material, we had a quick review of all the material so far — how to retrieve data from tables.
Download the class notes for <a href="https://s3.amazonaws.com/files.commons.gc.cuny.edu/wp-content/blogs.dir/2501/files/2025/12/SF25SQL6172025_20251203.pdf"day 6.
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 5
We are half way done with the course. We are almost ready to create our own data objects.
Download the class notes for day 5.
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 4
We continue working with functions. We first covered functions that affect strings and now we have moved to aggregate functions to affect numbers.
Download the class notes for day 4.
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 3
We have started working with functions. Now we can change what the output looks like.
Download the class notes for day 3.
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 2
We are getting data from a table.
SELECT field1, field2, field3 FROM table1;
We are getting data from tables.
SELECT table1.common_field1, -- field/data on both tables table1.field2, table2.field3, table2.field4 FROM table1 -- left table (main if `LEFT JOIN`) INNER|LEFT|RIGHT JOIN table2 -- right table (main if `RIGHT JOIN`) ON table1.common_field1 = table2.common_field1; -- relation between tables
Download the class notes for day 2.
Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) — Day 1
We have started a new course. It’s time to have fun, but let’s start with cookies first.
Download the class notes for day 1.
