Lecture - 14 Query Processing and Optimization

Course Lectures

• Lecture -1 Introduction to Database Management System

  Play
• Lecture -1a Conceptual Designs

  Play
• Lecture -2 Conceptual Designs

  Play
• Lecture - 3 Relational Model

  Play
• Lecture - 4 Relational Model

  Play
• Lecture - 5 Structured Query Language

  Play
• Lecture - 6 Structured Query Language II

  Play
• Lecture - 7 ER Model to Relational Mapping

  Play
• Lecture - 8 Functional Dependencies and Normal Form

  Play
• Lecture - 9 ER Model to Relational Model Maping

  Play
• Lecture - 10 Storage Structures

  Play
• Lecture - 11 Indexing Techniques Single Level

  Play
• Lecture - 12 Indexing Techniques Multi-Level

  Play
• Lecture - 13 Constraints and Triggers

  Play
• Lecture - 14 Query Processing and Optimization

  Playing
• Lecture -15 Query Processing and Optimization II

  Play
• Lecture - 16 Query Processing and Optimization - III

  Play
• Lecture - 17 Transaction Processing Concepts

  Play
• Lecture - 18 Transaction Processing and Database Manager

  Play
• Lecture - 19 Foundation for Concurrency Control

  Play
• Lecture - 20 Concurrency Control Part - I

  Play
• Lecture - 21 Concurrency Control Part - 2

  Play
• Lecture - 22 Concurrency Control Part - 3

  Play
• Lecture - 23 Concurrency Control Part - 4

  Play
• Lecture -24 Distributed Transaction Models

  Play
• Lecture - 25 Basic 2-Phase and 3-phase commit protocol

  Play
• Lecture - 26 Concurrency Control for Distributed Transaction

  Play
• Lecture - 27 Introduction to Transaction Recovery

  Play
• Lecture - 28 Recovery Mechanisms II

  Play
• Lecture - 29 Recovery Mechanisms III

  Play
• Lecture - 30 Introduction to Data Warehousing and OLAP

  Play
• Lecture - 31 Introduction to Data Warehousing nad OLAP

  Play
• Lecture - 32 Case Study : MYSQL

  Play
• Lecture - 33 Case Study ORACLE and Microsoft Access

  Play
• Lecture - 34 Data Mining and Knowledge Discovery

  Play
• Lecture - 35 Data Mining and Knowledge Discovery Part II

  Play
• Lecture - 36 Object Oriented Databases

  Play
• Lecture -37 Object Oriented Databases II

  Play
• Lecture -38 XML - Introductory Concepts

  Play
• Lecture -39 XML Advanced Concepts

  Play
• Lecture -40 XML Databases

  Play
• Lecture -41 Case Study - Part One Database Design

  Play
• Lecture -42 Case Study - Part 2 Database Design

  Play