0(0)

Introduction to Database Systems the complete guide

  • Course level: All Levels

Description

 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 I 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)

Topics for this course

26 Lessons

Introduction to Database Systems

01 – Course Introduction & Relational Model00:00:00
02 – Advanced SQL00:00:00
03 – Database Storage I00:00:00
04 – Database Storage II00:00:00
05 – Buffer Pools + Memory Management00:00:00
06 – Hash Tables00:00:00
07 – Tree Indexes00:00:00
08 – Tree Indexes II00:00:00
09 – Multi-Threaded Index Concurrency Control00:00:00
10 – Sorting & Aggregations00:00:00
11 – Join Algorithms00:00:00
12 – Query Execution I00:00:00
13 – Query Execution II00:00:00
14 – Query Planning & Optimization I00:00:00
15 – Query Planning & Optimization II00:00:00
16 – Concurrency Control Theory00:00:00
17 – Two-Phase Locking Concurrency Control00:00:00
18 – Timestamp Ordering Concurrency Control00:00:00
19 – Multi-Version Concurrency Control00:00:00
20 – Database Logging Schemes00:00:00
21 – ARIES Database Recovery00:00:00
22 – Introduction to Distributed Databases00:00:00
23 – Distributed OLTP Databases00:00:00
24 – Distributed OLAP Databases00:00:00
25 – Shasank Chavan00:00:00
26 – Systems Potpourri00:00:00
Introduction to Database Systems
40 £

Enrolment validity: Lifetime

Requirements

  • Basic Computer knowledge