Types of keys

Candidate Key

Primary Key

Alternate Key

Super Key

Foreign Key

Introduction

Entity: Strong and Weak Entity

Attribute: Key Attribute, Simple and Composite Attributes

Attribute: Single and Multi-valued Attributes & Stored and Derived Attributes

Relationship: Introduction, Weak Relationship

Relationship: Degree - Unary, Binary, Ternary and n-ary Relationships

Relationship: Cardinality - One

(1:1), One

), Many

(M:1), Many

)

Relationship: Partial and Total Participation & Cardinality Ratio

Functional Dependency: Introduction, Examples

Types of Functional Dependencies: Trivial and Non-Trivial FD's

FD: Example

Inference Rules

Attribute Closure:

Applications of Attribute Closure

Application 1: Finding Additional FD's

Application 2: Finding Keys in a Relation

Find Candidate Keys

Application 3: Equivalence of Functional Dependencies

Application 4: Irreducible Set and Algorithm

Application 4: Irreducible Set

Partial Functional Dependency and Full Functional Dependency

Anomalies: Update, Deletion, and Insertion Anomaly

Normalization: Introduction and Types

First Normal Form (1NF)

Second Normal Form (2NF)

2NF: Examples

Third Normal Form (3NF)

3NF: Examples

Boyce-Codd Normal Form (BCNF)

SELECT Statement Structure and Evaluation Order

SELECT Clause Syntax and Examples

DISTINCT Keyword in SELECT Clause

WHERE Clause: Introduction

WHERE Clause: Operators

WHERE Clause: Logical Operators - AND, OR, NOT

WHERE Clause: AND, OR, NOT - Together

ORDER BY Clause: ASC, DESC

LIKE and Wildcard Operators

NULL Values and IS NULL & IS NOT NULL

Aggregate Functions: SUM(), AVG(), MIN(), MAX()

Aggregate Functions: COUNT()

GROUP BY Clause

GROUP BY Clause: Multiple Columns

HAVING Clause and Rules

Set Manipulation Operators: Rules

Set Manipulation Operators: UNION, INTERSECTION, MINUS

Joins: Introduction, Cross Join

Joins: Theta Join / Conditional Join

Joins: Equi Join

Joins: Natural Join

Joins: Self Join

Outer Join: Introduction

Joins: Left Outer Join

Joins: Right Outer Join

Joins: Full Outer Join

Relational Algebra: Introduction

RA: Selection and Projection Operators

RA: Set Manipulation Operators (Union, Intersection, Difference)

RA: Set Manipulation Operators - UNION

RA: Set Manipulation Operators - INTERSECTION

RA: Set Manipulation Operators - SET DIFFERENCE

RA: Cartesian Product

RA: Rename Operator

RA: Join Introduction and Types

RA: Conditional Join / Theta Join

RA: Equijoin

RA: Natural Join

RA: Outer Join

RA: Left Outer Join

RA: Right Outer Join

RA: Full Outer Join

RA: Division Operator

Transaction: Introduction

Schedule: Serial and Concurrent Schedules - Definitions

Problem: Number of Serial and Concurrent Schedules

Last Update Problem: Problems Due to Concurrency Control

Dirty Read Problem: Problems Due to Concurrency Control

Unrepeatable Read Problem: Problems Due to Concurrency Control

Problem

Non-recoverable Schedules

Recoverable Schedules

Cascading Schedules

Cascadeless Schedules

Strict Schedules

Relation Among Strict, Cascadeless, and Recoverable Schedules

Problem: 1, 2

Problem: 3

Problem: 4

Problem: 5, 6

Problem: 7, 8

Classification

Serializability: Introduction

Serializability: Number of Serial and Non-Serial Schedules

Serializability: Types

Conflict Serializable Schedules: Introduction

Conflict Serializable Schedule: Example 2, 3

Introduction

Storage Strategies: Spanned and Unspanned Strategies

Records Organization in a File

Sparse Index and Dense Index

Indexing: Introduction

Indexing: Primary Indexing

Indexing: Primary Indexing - Numerical Problem

Indexing: Cluster Index

Indexing: Secondary Indexing

Database Management Training Program

Check Your Course Fee

KEY POINTS

90+

18+

1500+

5+

ZebLearn Certification Partners – Globally Recognized Credentials!

Course content

Why Should You Learn Database Management Training?

Request more information

What you will get at Zeblearnindia Learning?

() 60 Minutes WEBINAR with CERTIFICATE

Explore Our Courses Across India - Flexible batches

DSP & Microcontrollers

Computer Hardware

Cisco

Cisco & Networking Certifications

Database Management Training Program

Check Your Course Fee

KEY POINTS

90+

18+

1500+

5+

ZebLearn Certification Partners – Globally Recognized Credentials!

Course content

# Keys : Candidate key, Primary key, Super key, Foreign Key.

# Entity - Relationship Model ( ER Model).

# Functional Dependency (FD).

# Normalization

# Structured Query Language ( SQL ).

# Relational Algebra (RA) and Relational Calculus (RC).

# Transactions and Concurrency Control.

# File Organization

Why Should You Learn Database Management Training?

Request more information

What you will get at Zeblearnindia Learning?

() 60 Minutes WEBINAR with CERTIFICATE

Explore Our Courses Across India - Flexible batches