0(0)

Fundamentals of database systems

  • Course level: Beginner

Description

Fundamentals of database systems. Become a Microsoft Technology Associate and get recognized for demonstrating introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server.

In this self-paced course,  I’ll be taking you from the basic understanding of database concepts to writing your own queries, selecting data, modifying data, and creating database structures. Along the way, I’ll explain the key concepts, demonstrate the syntax.

This course consists of presentations to cover the theoretical objectives of the exam and demonstrations to cover the practical skills required to pass the exam.

**This is a dedicated preparation course for the Microsoft Technology Associate: 98-364 Database Fundamentals Exam**

Who this Fundamentals of database systems course is for:

-Beginners seeking to pass the MTA 98-364 Database Fundamentals Exam
-Database developers seeking to pass the MTA 98-364 Database Fundamentals Exam
-Individuals seeking to learn the fundamentals of relational databases, database management -systems, database components, and querying databases

What Will I Learn?

  • Fundamentals of Relational Databases
  • Core Database Concepts
  • Query Relational Databases
  • Fundamentals of Creating Database Objects
  • Database Administration Fundamentals

Topics for this course

48 Lessons

Fundamentals of database systems

Introduction to Databases12:05
Relational Data Model24:51
Relational Algebra Basic Operators00:00:00
Relational Algebra Composition of Operators00:00:00
Relational Algebra Additional Operators00:00:00
Relational Algebra Extended Relational Algebra00:00:00
Relational Algebra: Database Modifications00:00:00
SQL: Introduction and Data Definition00:00:00
SQL: Basic Queries00:00:00
SQL: Advanced Queries00:00:00
SQL: Updates, Joins, Views and Triggers00:00:00
Normalization Theory: Motivation00:00:00
Normalization Theory: 1 NF and 2NF00:00:00
Normalization Theory: 3NF00:00:00
Normalization Theory: BCNF00:00:00
Normalization Theory: MVD00:00:00
Physical Design00:00:00
Database Indexing: Hashing00:00:00
Database Indexing: Tree-based Indexing00:00:00
Query Processing: Selection00:00:00
Query Processing: Sorting00:00:00
Query Processing: Nested-Loop joins and Merge join00:00:00
Query Processing: Hash join and other Operations00:00:00
Query Optimization: Equivalent Expressions and Simple Equivalance Rules00:00:00
Query Optimization: Complex Equivalence Rules00:00:00
Query Optimization: Join Order00:00:00
Query Optimization: Heuristics and Sizes00:00:00
Database Transactions: Properties and Failures00:00:00
Database Transactions: States and Systems00:00:00
Recovery Systems: Deferred Database Modification00:00:00
Recovery Systems: Immediate Database Modification.00:00:00
Recovery Systems: Checkpointing and Shadow Paging00:00:00
Schedules: Introduction00:00:00
Schedules: Conflict Serializability00:00:00
Schedules: View Serializability00:00:00
Schedules: Result Equivalence and Testing for Serializability00:00:00
Schedules: Recoverability00:00:00
Concurrency Control: Locks00:00:00
Concurrency Control: Two-phase Locking Protocol00:00:00
Concurrency Control: Timestamp Ordering Protocol00:00:00
Concurrency Control: Validation-based Protocol00:00:00
Concurrency Control: Multiple Granularity for Locks00:00:00
Concurrency Control: Deadlock Prevention and Deadlock Detection00:00:00
Concurrency Control: Deadlock Recovery and Update Operations00:00:00
NoSQL: Introduction and Properties00:00:00
NoSQL: Columnar Families00:00:00
NoSQL: Different NoSQL Systems00:00:00
Big Data00:00:00
Fundamentals of database systems
80 £

Enrolment validity: Lifetime

Requirements

  • SQL Server
  • SQL Server Management Studio