Fundamentals of database systems

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

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

Show More

What Will You Learn?

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

Course Content

Fundamentals of database systems

  • Introduction to Databases
    12:05
  • Relational Data Model
    24:51
  • Relational Algebra Basic Operators
    00:00
  • Relational Algebra Composition of Operators
    00:00
  • Relational Algebra Additional Operators
    00:00
  • Relational Algebra Extended Relational Algebra
    00:00
  • Relational Algebra: Database Modifications
    00:00
  • SQL: Introduction and Data Definition
    00:00
  • SQL: Basic Queries
    00:00
  • SQL: Advanced Queries
    00:00
  • SQL: Updates, Joins, Views and Triggers
    00:00
  • Normalization Theory: Motivation
    00:00
  • Normalization Theory: 1 NF and 2NF
    00:00
  • Normalization Theory: 3NF
    00:00
  • Normalization Theory: BCNF
    00:00
  • Normalization Theory: MVD
    00:00
  • Physical Design
    00:00
  • Database Indexing: Hashing
    00:00
  • Database Indexing: Tree-based Indexing
    00:00
  • Query Processing: Selection
    00:00
  • Query Processing: Sorting
    00:00
  • Query Processing: Nested-Loop joins and Merge join
    00:00
  • Query Processing: Hash join and other Operations
    00:00
  • Query Optimization: Equivalent Expressions and Simple Equivalance Rules
    00:00
  • Query Optimization: Complex Equivalence Rules
    00:00
  • Query Optimization: Join Order
    00:00
  • Query Optimization: Heuristics and Sizes
    00:00
  • Database Transactions: Properties and Failures
    00:00
  • Database Transactions: States and Systems
    00:00
  • Recovery Systems: Deferred Database Modification
    00:00
  • Recovery Systems: Immediate Database Modification.
    00:00
  • Recovery Systems: Checkpointing and Shadow Paging
    00:00
  • Schedules: Introduction
    00:00
  • Schedules: Conflict Serializability
    00:00
  • Schedules: View Serializability
    00:00
  • Schedules: Result Equivalence and Testing for Serializability
    00:00
  • Schedules: Recoverability
    00:00
  • Concurrency Control: Locks
    00:00
  • Concurrency Control: Two-phase Locking Protocol
    00:00
  • Concurrency Control: Timestamp Ordering Protocol
    00:00
  • Concurrency Control: Validation-based Protocol
    00:00
  • Concurrency Control: Multiple Granularity for Locks
    00:00
  • Concurrency Control: Deadlock Prevention and Deadlock Detection
    00:00
  • Concurrency Control: Deadlock Recovery and Update Operations
    00:00
  • NoSQL: Introduction and Properties
    00:00
  • NoSQL: Columnar Families
    00:00
  • NoSQL: Different NoSQL Systems
    00:00
  • Big Data
    00:00

Student Ratings & Reviews

No Review Yet
No Review Yet
ResearcherStore

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