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 full Chapter 1 reading with its 132 key terms, databases versus lists, tables, relationships, primary, composite, and foreign keys, metadata, and the characteristics of relational databases, plus the professor's lectures on database systems and on where relational databases sit in data science)Cliff Notes Module 2 Part 2/(the four components of a database system: users, database applications, the DBMS, and the database itself. What applications do, the nine functions of a DBMS, the metadata that makes a database self-describing, personal Microsoft Access versus enterprise-class systems, and the big three products with the operating systems they run on)Cliff Notes Module 2 Part 3/(how databases come to exist and where they came from: the three database design paths, from existing data, for new systems development, and redesign, the two roles you are training for, and the history of database processing from file systems through the relational model, the PC era, object-oriented databases, OLTP and BI, the Web, open source, XML, and big data with NoSQL)Cliff Notes Module 3 Part 1/(introduction to SQL: what SQL is and its four statement types from the professor's lecture, the Cape Codd business intelligence extract with its six tables, keys, and data types, the SELECT/FROM/WHERE framework, how to submit a statement to Access, SQL Server, Oracle, and MySQL, and the professor's Workbench demos on SELECT, on filtering and sorting, and on basic troubleshooting)Cliff Notes Module 3 Part 2/(SQL enhancements for querying a single table: DISTINCT, TOP, the WHERE clause with its quoting rules and the full comparison operator table, ORDER BY with multi column sorts, and compound conditions with AND, OR, and NOT)
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.