Database Systems - Cornell University Course (SQL, NoSQL, Large-Scale Data Analysis)

Learn about relational and non-relational database management systems in this course. This course was created by Professor Immanuel Trummer, PhD. He is an assistant professor for computer science at Cornell University. 🐦 Follow Professor Trummer on Twitter: https://twitter.com/ImmanuelTrummer 🎥 Watch part 2 of this course here (8 more hours): https://youtu.be/lxEdaElkQhQ You will learn how to query database systems via languages such as SQL (the structured query language). Then, you will see how database systems work internally, how they store and index data, how they process and optimize queries, and how they process transactions while providing guarantees such as isolation, atomicity, and durability (ACID guarantees). The course addresses questions of database design and discusses novel approaches to data management via NoSQL or NewSQL systems. Finally, the course will discuss about graph, stream, and spatial data, and about systems that are specialized for those data types. The lectures are from the Fall 2020 online lecture at Cornell by Prof. Trummer (www.itrummer.org). 🔗 Slides: http://cdn.freecodecamp.org/youtube/database-course-slides/database_course_slides.zip To download the slides, you may have to right-click the link and select "Save link as...". After clicking 'Save' you may have to look at the bottom of your browser window, click the up arrow, and then select 'Keep'. ❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba) ⭐️ Course Contents ⭐️ ⌨️ (0:00:00) The Structured Query Language (SQL) ⌨️ (3:04:52) Storing and Indexing Data ⌨️ (5:52:44) Relational Data Processing ⌨️ (10:40:23) Transaction Processing ⌨️ (https://youtu.be/lxEdaElkQhQ) Database Design ⌨️ (https://youtu.be/lxEdaElkQhQ) Beyond Relational Data ⭐️ Additional Reading ⭐️ About the first two thirds of the course are based on the textbook "Database Management Systems" by