These are my personal auto-generated cliff notes, produced in part with my CMPIF2110 Intelligent Transcriber. I'm sharing them with the rest of the cohort. I'll do my best to keep this repo updated as they are mostly for my own use.
There are no Module 1 notes. Module 1 was purely administrative, so there was nothing to take notes on. The notes start at Module 2.
The notes are organized by module part:
Cliff Jumper Notes/(each module's notes woven into one connected lesson)Cliff Notes Module 2 Part 1/(what a database is and why it matters: the Chapter 1 reading and its key terms, databases versus lists, tables, relationships and keys, metadata, the characteristics of relational databases, and where they sit in data science)Cliff Notes Module 2 Part 2/(the four components of a database system: users, applications, the DBMS and the database itself, the nine DBMS functions, metadata, personal Access versus enterprise class systems, and the big three products)Cliff Notes Module 2 Part 3/(how databases come to exist and where they came from: the three design paths, the two roles you are training for, and the history from file systems through the relational model to the Web, XML, and big data with NoSQL)Cliff Notes Module 3 Part 1/(introduction to SQL: the four statement types, the Cape Codd extract with its six tables and keys, the SELECT/FROM/WHERE framework, submitting statements to Access, SQL Server, Oracle and MySQL, and the Workbench demos)Cliff Notes Module 3 Part 2/(SQL enhancements for querying a single table: DISTINCT, TOP, the WHERE clause and its comparison operators, ORDER BY with multi column sorts, and compound conditions with AND, OR and NOT)Cliff Notes Module 4 Part 1/(calculations in SQL queries: the five built in aggregate functions, COUNT and DISTINCT, the two things aggregates cannot do, expressions and string concatenation with RTRIM, GROUP BY, HAVING, and the professor's aggregation demo)
Standalone walkthroughs and setup guides:
Guides/AltConnectInstructions.md(Pitt's VPN without the GlobalProtect client: OpenConnect inside WSL2, working from VS Code on the tunnel, a relay so Microsoft Access can reach the course server, and the fixes for when it goes sideways)Guides/CMPIF2110_SQL_Statements_Field_Guide.pdf(a four-page field guide to basic, intermediate, and advanced SQL statements, plus common operators and functions with examples)
- DatJavaClass (Victor S), author and director. Conceived these notes, established their format and structure, directed their creation, and fact-checked, edited, and quality-controlled every one, with assistance by Claude. Some material may have been derived from assigned material, but has not been copied verbatim. For source materials please contact CMPINF-2110 Faculty and Assistants.
As Always! You're awesome, Stay awesome! and I wish everyone the best of grades!
Can you find the passive aggressive parentheses?
(c) 2026 Victor S (DatJavaClass). Everything in this repo is released under the MIT License. Use it, share it, fork it, remix it. Keep the copyright notice, and keep the credit: these notes were created by Victor S (DatJavaClass) for CMPINF-2110 at the University of Pittsburgh.