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'.
⭐️ 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
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Видео Database Systems - Cornell University Course (SQL, NoSQL, Large-Scale Data Analysis) канала freeCodeCamp.org
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
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Видео Database Systems - Cornell University Course (SQL, NoSQL, Large-Scale Data Analysis) канала freeCodeCamp.org
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Python Backend Web Development Course (with Django)Computer Networking Course - Network Engineering [CompTIA Network+ Exam Prep]SQL Tutorial - Full Database Course for BeginnersAlgorithms and Data Structures Tutorial - Full Course for Beginners7 Database ParadigmsData Visualization with D3, JavaScript, React - Full Course [2021]C++ Programming Course - Beginner to AdvancedCreate a C# Application from Start to Finish - Complete CourseDatabase Design Course - Learn how to design and plan a database for beginnersComplete MySQL Beginner to ExpertDatabase Tutorial for BeginnersIntroduction to Database Management Systems (DBMS)Web Applications for Everybody Course - Dr. Chuck Teaches HTML, PHP, SQL, CSS, JavaScript, and more!Python for Everybody - Full University Python CourseDBMS Complete RoadMap🔴 || What to study in DBMS for Placement Interviews ?? || SolvedCISSP Certification Course – PASS the Certified Information Security Professional Exam!NoSQL Database Tutorial – Full Course for BeginnersData Visualization with D3.js - Full Tutorial CourseData Analysis with Python Course - Numpy, Pandas, Data Visualization