Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Database Systems - Spring 2020

UofU Data Science via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore comprehensive database systems concepts through this university-level course covering fundamental and advanced topics in database design, implementation, and optimization. Master relational database principles, SQL querying, and database normalization while diving deep into practical applications using .NET frameworks and LINQ. Learn essential security practices including authentication, user management, and testing methodologies for database applications. Understand transaction management, synchronization, and isolation levels to ensure data consistency in concurrent environments. Discover indexing strategies, B-trees, hash indexes, and spatial data handling to optimize database performance. Examine memory hierarchy, disk storage systems, and query optimization techniques including join analysis and execution plan generation. Study functional dependencies and normal forms for proper database design. Gain hands-on experience with database testing, mocking frameworks, and unit testing for MVC applications. The course progresses from foundational concepts to advanced topics like query plan analysis and performance optimization, providing both theoretical understanding and practical skills for working with modern database systems.

Syllabus

Database Systems - Lecture 01
Database Systems Lecture 1 part 2
Database Systems (Spring 2020) Lecture 2
Database Systems (Spring 2020) - Lecture 3
Database Systems (Spring 2020) - Lecture 4
Database Systems (Spring 2020) - Lecture 5
Database Systems (Spring 2020) - Lecture 6
Database Systems (Spring 2020) - Lecture 7
Database Systems (Spring 2020) - Lecture 8
Database Systems (Spring 2020) - Lecture 9
Database Systems (Spring 2020) - Lecture 10
Database Systems (Spring 2020) - Lecture 11
Database Systems (Spring 2020) - Lecture 12
Database Systems (Spring 2020) - Lecture 13
Database Systems (Spring 2020) - Lecture 14
Database Systems (Spring 2020) - Lecture 15 Part 1 - Announcements
Database Systems (Spring 2020) - Lecture 15 Part 2 - LINQ Recap
Database Systems (Spring 2020) - Lecture 15 Part 3 - JSON
Database Systems (Spring 2020) - Lecture 15 Part 4 - LINQ Wrapup
Database Systems (Spring 2020) - Lecture 15 Part 5 - Authentication
Database Systems (Spring 2020) - Lecture 15 Part 6 - Improving Security
Database Systems (Spring 2020) - Lecture 16 Part 1 - Announcements
Database Systems (Spring 2020) - Lecture 16 Part 2 - Security Misc.
Database Systems (Spring 2020) - Lecture 16 Part 3 - .NET User Management
Database Systems (Spring 2020) - Lecture 16 Part 4 - DB Testing
Database Systems (Spring 2020) - Lecture 16 Part 5 - Unit Testing MVC
Database Systems (Spring 2020) - Lecture 16 Part 6 - Setup Mocking
Database Systems (Spring 2020) - Lecture 16 Part 7 - Mocking
Database Systems (Spring 2020) - Lecture 17 Part 1 - Intro to Transactions
Database Systems (Spring 2020) - Lecture 17 Part 2 - Synchronization
Database Systems (Spring 2020) - Lecture 17 Part 3 - Isolation Levels
Database Systems (Spring 2020) - Lecture 17 Part 4 - Low Isolation Levels
Database Systems (Spring 2020) - Lecture 17 Part 5 - High Isolation Levels
Database Systems (Spring 2020) - Lecture 17 Part 6 - Serializable LINQ
Database Systems (Spring 2020) - Lecture 18 Part 1 - Locks
Database Systems (Spring 2020) - Lecture 18 Part 2 - Intro to Indexes
Database Systems (Spring 2020) - Lecture 18 Part 3 - Picking Indexes
Database Systems (Spring 2020) - Lecture 18 Part 4 - Memory Hierarchy
Database Systems (Spring 2020) - Lecture 18 Part 5 - Disk Drives
Database Systems (Spring 2020) - Lecture 19 Part 1 - Index Structure Considerations
Database Systems (Spring 2020) - Lecture 19 Part 2 - Wide Search Trees
Database Systems (Spring 2020) - Lecture 19 Part 3 - B trees
Database Systems (Spring 2020) - Lecture 19 Part 4 - B tree Indexes
Database Systems (Spring 2020) - Lecture 19 Part 5 - Exercises
Database Systems (Spring 2020) - Lecture 20 Part 1 - B tree Operations
Database Systems (Spring 2020) - Lecture 20 Part 2 - Hash Indexes
Database Systems (Spring 2020) - Lecture 20 Part 3 - Index Performance Demo
Database Systems (Spring 2020) - Lecture 20 Part 4 - Spatial Data
Database Systems (Spring 2020) - Lecture 21 Part 1 - Plan Generator
Database Systems (Spring 2020) - Lecture 21 Part 2 - Join Analysis
Database Systems (Spring 2020) - Lecture 21 Part 3 - Index Joins
Database Systems (Spring 2020) - Lecture 21 Part 4 - Plan Analyzer
Database Systems (Spring 2020) - Lecture 22 Part 1 - Functional Dependencies
Database Systems (Spring 2020) - Lecture 22 Part 2 - Normal Forms
Database Systems (Spring 2020) - Final Review Part 1 - Announcements
Database Systems (Spring 2020) - Final Review Part 2 - Exercises
Extra: Lecture 24
Extra: Lecture 25

Taught by

UofU Data Science

Reviews

Start your review of Database Systems - Spring 2020

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.