Course module

Database Management and Warehousing — GATE 2027 Data Science and Artificial Intelligence (DA) Complete Course

Explore the module outline and lessons below. Enroll free to begin studying here.

Return to /learn/GATE-2027-DATA-SCIENCE-AND-ARTIFICIAL-INTELLIGENCE-DA-COMPLETE-COURSE/database-management-and-warehousing after enrolling
Lessons
45
Duration
—
PYQs
18
Practice
977

4% of this course's PYQ weight is covered in this module.

Syllabus index

Lessons in this module

SQL

Introduction, Components & Structure

  1. Introduction, Components & StructurePdf

Select, Where, Distinct

  1. Select, Where, DistinctPdf

Datatypes, Operators & Null

  1. Datatypes, Operators & NullPdf

DDL, DML, DCL, TCL & Desc

  1. DDL, DML, DCL, TCL & DescPdf

Order By & Rename Operation (Alias)

  1. Order By & Rename Operation (Alias)Pdf

Library Functions (Math, Aggregate, String, Date)

  1. Library Functions (Math, Aggregate, String, Date)Pdf

Set Operations & Cartesian Product

  1. Set Operations & Cartesian ProductPdf

Join Operations (Inner & Outer)

  1. Join Operations (Inner & Outer)Pdf

Group By Clause

  1. Group By ClausePdf

Nested & Correlated Subqueries

  1. Nested & Correlated SubqueriesPdf

Views & PLSQL Basics

  1. Views & PLSQL BasicsPdf

Relational Algebra

Introduction to Query Languages

  1. Introduction to Query LanguagesPdf

Unary Operators (Selection & Projection)

  1. Unary Operators (Selection & Projection)Pdf

Set Operations & Cartesian Product

  1. Set Operations & Cartesian ProductPdf

Join Operations (Inner & Outer)

  1. Join Operations (Inner & Outer)Pdf

Rename Operation

  1. Rename OperationPdf

Division Operator

  1. Division OperatorPdf

Keys & Integrity Constraints

Super Key, Candidate Key & Primary Key

  1. Super Key, Candidate Key & Primary KeyPdf

Foreign Key & Referential Integrity

  1. Foreign Key & Referential IntegrityPdf

Composite & Alternate Keys

  1. Composite & Alternate KeysPdf

Data Warehousing & Mining

Introduction to Data Mining and Data Warehouse

  1. Introduction to Data Mining and Data WarehousePdf

Data Warehousing

  1. Data WarehousingPdf

Data Mining Functionalities

  1. Data Mining FunctionalitiesPdf

Data Modelling in Warehouses

  1. Data Modelling in WarehousesPdf

Data Mining Techniques

  1. Data Mining TechniquesPdf

File Organization & Indexing

B-Trees & B+ Trees (Structure & Insertion)

  1. B-Trees & B+ Trees (Structure & Insertion)Pdf

Deletion in B-Trees & B+ Trees

  1. Deletion in B-Trees & B+ TreesPdf

Relational Model & Functional Dependencies

Basics of Relational Model & Anomalies

  1. Basics of Relational Model & AnomaliesPdf

Attribute Closure & Equivalence of Sets

  1. Attribute Closure & Equivalence of SetsPdf

Minimal Cover (Canonical Cover)

  1. Minimal Cover (Canonical Cover)Pdf

Relational Calculus

Tuple Relational Calculus (TRC)

  1. Tuple Relational Calculus (TRC)Pdf

Domain Relational Calculus (DRC)

  1. Domain Relational Calculus (DRC)Pdf

Safety of Expressions & Power

  1. Safety of Expressions and PowerPdf

ER Diagram

ER Modeling Fundamentals

  1. ER Modeling FundamentalsPdf

Cardinalities, Participation & Entity Strength

  1. Cardinalities, Participation & Entity StrengthPdf

Conversion of ER Diagram into Relational Model

  1. Conversion of ER Diagram into Relational ModelPdf
  2. TrapesPdf

Decomposition Properties & 4NF

Multivalued Dependency (MVD) & 4NF

  1. Multivalued Dependency (MVD) & 4NFPdf

Fifth Normal Form (5NF)

  1. 5th Normal FormPdf

Lossless Join Decomposition

  1. Lossless Join DecompositionPdf

Dependency Preserving Decomposition

  1. Dependency Preserving DecompositionPdf

Previous-year questions

PYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions18 questions

Explore the course

Previous moduleLinear AlgebraNext moduleArtificial Intelligence
View course details
Loading lesson…