Introduction to Database Systems the complete guide

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

 Database Systems. This specialized program is aimed at computer people who want to enter the field of information systems and learn their different types of requirements, architectures, performance, techniques, and tools so you can know when to use business intelligence, data mining, data science, databases, databases in memory or big data in order to have relilecture able, maintainable and scalable data-intensive systems.

Through 26 courses, you will cover [Introduction to and basic concepts of database, an overview of relational databases, Query optimization, Recovery and concurrency in the database, production to deductive and object-oriented databases]

 

ENROLLED NOW!

What Will You Learn?

  • The Entity-relationship and Relational Models
  • The SQL Query Language
  • Traditional and Modern Data Storage, File Organizations, and Indexing
  • Hashing and Sorting
  • Query Evaluation and Relational Operators
  • Query Optimization
  • Schema Refinement
  • Transaction Management (Concurrency Control and Recovery)

Course Content

Introduction to Database Systems

  • 01 – Course Introduction & Relational Model
    00:00
  • 02 – Advanced SQL
    00:00
  • 03 – Database Storage I
    00:00
  • 04 – Database Storage II
    00:00
  • 05 – Buffer Pools + Memory Management
    00:00
  • 06 – Hash Tables
    00:00
  • 07 – Tree Indexes
    00:00
  • 08 – Tree Indexes II
    00:00
  • 09 – Multi-Threaded Index Concurrency Control
    00:00
  • 10 – Sorting & Aggregations
    00:00
  • 11 – Join Algorithms
    00:00
  • 12 – Query Execution I
    00:00
  • 13 – Query Execution II
    00:00
  • 14 – Query Planning & Optimization I
    00:00
  • 15 – Query Planning & Optimization II
    00:00
  • 16 – Concurrency Control Theory
    00:00
  • 17 – Two-Phase Locking Concurrency Control
    00:00
  • 18 – Timestamp Ordering Concurrency Control
    00:00
  • 19 – Multi-Version Concurrency Control
    00:00
  • 20 – Database Logging Schemes
    00:00
  • 21 – ARIES Database Recovery
    00:00
  • 22 – Introduction to Distributed Databases
    00:00
  • 23 – Distributed OLTP Databases
    00:00
  • 24 – Distributed OLAP Databases
    00:00
  • 25 – Shasank Chavan
    00:00
  • 26 – Systems Potpourri
    00:00

Student Ratings & Reviews

No Review Yet
No Review Yet
ResearcherStore

Want to receive push notifications for all major on-site activities?