HLCM25 – RDBMS | SFR College
  • Home
  • My Profile
  • My Achievements
  • Forums
  • Blog
  • Log In

HLCM25 - RDBMS

  1. Home
  2. courses

HLCM25 – RDBMS

Please Login to view this page

Course Content

Expand All | Collapse All
Lessons Status
1

UNIT I – INTRODUCTION TO RDBMS
  • Introduction
  • RDBMS Terminology
  • Relational Data Structure
  • Codd’s Rule
  • Relational Data Integrity and Database Constraints

2

UNIT II – ENTITY RELATIONAL MODELING
  • Introduction
  • ER-Model
  • Components of an ER model
  • ER-Modeling Symbols
  • Relational Algebra and Relational Algebraic operations
  • Relational Calculus

3

UNIT III – INTRODUCTION TO SQL
  • Introduction
  • SQL Datatypes and Literals
  • Types of SQL Commands
  • SQL operators
  • Advantages of SQL

4

UNIT IV – QUERIES AND AGGREGATE FUNCTIONS
  • Tables
  • Views
  • Indexes
  • Queries and SubQueries
  • Aggregate Functions
  • Insert Update Delete Operations

5

UNIT V – DATA NORMALIZATION
  • Introduction
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce Codd Normal Form (BCNF)
  • Fourth Normal Form (4NF)
  • Fifth Normal Form (5NF)
  • Domain Key Normal Form
  • Denormalization

QuizzesStatus
1

HLCM25 -RDBMS QUIZ

By Govindammal M | February 12, 2019 | PG Commerce-CA | Tags: pgcom

Govindammal M

Previous

HLCM1E3- Aptitude for Banking Career

Course Navigation

UNIT I - INTRODUCTION TO RDBMS
  • Introduction
  • RDBMS Terminology
  • Relational Data Structure
  • Codd’s Rule
  • Relational Data Integrity and Database Constraints
UNIT II - ENTITY RELATIONAL MODELING
  • Introduction
  • ER-Model
  • Components of an ER model
  • ER-Modeling Symbols
  • Relational Algebra and Relational Algebraic operations
  • Relational Calculus
UNIT III - INTRODUCTION TO SQL
  • Introduction
  • SQL Datatypes and Literals
  • Types of SQL Commands
  • SQL operators
  • Advantages of SQL
UNIT IV - QUERIES AND AGGREGATE FUNCTIONS
  • Tables
  • Views
  • Indexes
  • Queries and SubQueries
  • Aggregate Functions
  • Insert Update Delete Operations
UNIT V - DATA NORMALIZATION
  • Introduction
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce Codd Normal Form (BCNF)
  • Fourth Normal Form (4NF)
  • Fifth Normal Form (5NF)
  • Domain Key Normal Form
  • Denormalization
TOP
© Copyright 2015 | sfrmlearning.org
  • Home
  • My Profile
  • My Achievements
  • Forums
  • Blog
  • Log In
error: