CMPS 180: Database Systems I. Textbook: “A First Course in Database Systems”, Jeffrey Ullman and Jennifer Widom, Prentice-Hall, 3rd edition. Science and Engineering Library has textbook on Reserve. 2cd edition is also available, but this course uses 3rd e
CMPS 180: Database Systems I. Textbook: “A First Course in Database Systems”, Jeffrey Ullman and Jennifer Widom, Prentice-Hall, 3rd edition. Science and Engineering Library has textbook on Reserve . 2cd edition is also available, but this course uses 3rd edition Course Description/Syllabus CMPS 180 covers concepts, approaches, tools, and methodology of database design and querying. Topics include: • Relational Data Model and its History • SQL language: Data Definition, Queries and Updates, Indexes, Views, Constraints, Rules • Relational Algebra, Query Execution • Transaction Processing • Database Application Development • Design Theory: Schemas and Normal Forms • On-Line Analytical Processing (OLAP) • Semi-Structured Data Models: XML, JSON, etc. • Cloud Databases (time permitting) • Big Data and NOSQL (time permitting) Lots of practical material and logic … and lots of concepts and theory, particularly in the second half of the term
Connected book
Written for
- Institution
- CMPS 180: Database Systems I
- Course
- CMPS 180: Database Systems I
Document information
- Uploaded on
- March 23, 2023
- Number of pages
- 50
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
- prentice hall
-
cmps 180 database systems i
-
cmps 180 database systems i textbook “a first course in database systems”
-
jeffrey ullman and jennifer widom
-
3rd edition science and engineering librar
