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

Title:

Description:

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'.

⭐️ 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 Raghu Ramakrishnan and Johannes Gehrke. The last third of the course discusses recently proposed systems, more details about them can be found in the corresponding research papers.

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

YouTube url:	https://www.youtube.com/watch?v=4cWkVbC2bNE&t=33s
Created:	3. 3. 2023 03:19:10

CaptionsMaker.com

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