RDBMS Course Content

This is just 2 days course content, if you need training content for Faculty Development Program or for 5/7/10/15/30/45/180 Days training, Click Here.

Day 1

Introduction to DBMS: 

  • Approach to Data Management
  • Introduction to prerequisites
  • File and File system
  • Disadvantages of file
  • Review of Database Management Terminology
  • Database Models
  • Hierarchal Model
  • Network Model
  • Relational Model

 

Day 2 

Introduction to RDBMS

  • Feature of RDBMS
  • Advantages of RDBMS over FMS ad DBMS
  • The 12 rules (E.F Codd’s Rules –RDBMS)
  • Need for Database Design
  • Support of Normalization Process for Data Management
  • Client server Technology
  • Oracle Corporation Products
  • Oracle Versions
  • About SQL&SQL*PLUS

 

Day 3

Sub Language Commands: 

  • Data Definition Language  (DDL)
  • Data Retrieval Language (DRL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Database Security and Privileges (DCL) 

Introduction to SQL Database Object

  • Oracle Pre Defined Data types
  • DDL Commands
  • Create, Alter (add, modify, rename, drop)Columns, Rename, truncate, drop
  • DML-Insert, update, delete
  • DQL-SELECT Statements using WHEREclause
  • Comparison and Conditional Operators
  • Arithmetic and Logical Operators
  • Set Operators (UNION, UNION ALL, INTERSECT, MINUS)
  • Special Operators – IN (NOT IN), BETWEEN (NOT BETWEEN), LIKE (NOTLIKE), IS NULL (IS NOT NULL)
  • Working with DML, DRL Commands
  • Operators Support 

 

Day 4

Built in Functions

  • Arithmetic Functions, Character Functions, Date Functions, Conversion Functions
  • Aggregate Functions, OLAP Functions & General Functions 

Grouping the Result of a Query

  • Using Group by and Having Clause of DRL Statement
  • Using Order by clause 

Working with Integrity Constraints

  • Importance of Data Integrity
  • Support of Integrity Constraints for Relating Table in RDBMS
  • NOT NULL constraint
  • UNIQUE constraint
  • PRIMARY KEY constraint
  • FOREIGN KEY constraint
  • CHECK constraint
  • Working with different types of integrity Constraints 

 

Day 5

REF constraint 

  • Understanding ON DELETE clause in referential integrity constraint
  • Working with composite constraint
  • Applying DEFAULT option to columns
  • Working with multiple constraints upon a column
  • Adding constraints to a table
  • Dropping of constraints
  • Enabling / Disable constraints
  • Querying for constraints information 

Querying Multiple Tables (Joins)

  • Equi Join/Inner Join/Simple Join
  • Cartesian Join
  • Non-Equi Join
  • Outer Joins
  • Self Join

Working with Sub Queries

  • Understanding the practical approach to Sub Queries/Nested Select/Sub Select/Inner Select/Outer Select
  • What is the purpose of a Sub Query?
  • Sub Query Principle and Usage
  • Type of Sub Queries
  • Single Row
  • Multiple Row
  • Multiple Column
  • Applying Group Functions in Sub Queries
  • The impact of Having Clause in Sub Queries
  • IN, ANY/SOME, ALL Operators in Sub Queries
  • PAIR WISE and NON PAIR WISE Comparison in Sub Queries
  • Be … Aware of NULL’s
  • Correlated Sub Queries
  • Handling Data Retrieval with EXISTS and NOT EXISTS Operators 

 

Day 6

Working with DCL, TCL Commands

  • Grant, Revoke
  • Commit, Rollback, Savepoint
  • SQL Editor Commands
  • SQL Environment settings 

Maintaining Database Objects
VIEWS in Oracle

  • Understanding the Standards of VIEWS in Oracle
  • Types of VIEWS
  • Relational Views
  • Object Views
  • Prerequisites to work with views
  • Practical approach of SIMPLE VIEWS and COMPLEX VIEWS
  • Column definitions in VIEWS
  • Using VIEWS for DML Operations
  • In-Line View
  • Forced Views
  • Putting CHECK Constraint upon VIEWS
  • Creation of READ ONLY VIEWS
  • Understanding the IN LINE VIEWS
  • About Materialized Views
  • View Triggers

 

Day 7

Working with Sequences 
Working with Synonyms 
Working with Index and Clusters 
Creating Cluster Tables, Implementing Locks, working with roles 
Pseudo Columns in Oracle

  • Understanding Pseudo Columns in Oracle
  • Types of Pseudo Columns in Oracle
  • CURRVAL and NEXTVAL
  • LEVEL
  • ROWID
  • ROWNUM 

 

Day 8

Data Partitions & Parallel Process

  • Types of Partitions
  • Range Partitions
  • Hash Partitions
  • List Partition
  • Composite Partition
  • Parallel Query Process

Locks

  • Row level Locks
  • Table Level Locks
  • Shared Lock
  • Exclusive Lock
  • Dead Lock

SQL * Loader

  • SQL * Loader Architecture
  • Data file (Input Datafiles)
  • Control file
  • Bad file
  • Discard file
  • Log file
  • .txt to base table
  • .csv to base table
  • From more than one file to single table 

 

Day 9

PL-SQL (Procedure Language – SQL) 

  • Introduction to Programming Languages
  • Introduction to PL/SQL
  • The Advantages of PL/SQL
  • PL/SQL Architecture
  • PL/SQL Data types
  • Variable and Constants
  • Using Built_in Functions
  • Conditional and Unconditional Statements
  • Simple if, if… else, nested if..else, if..else Ladder
  • Selection Case, Simple Case, GOTO Label   and EXIT
  • Iterations in PL/SQL
  • Simple LOOP,WHILE LOOP,FOR LOOP   and NESTED LOOPS
  • SQL within PL/SQL
  • Composite Data types (Complete)
  • Cursor Management in PL/SQL
  • Implicit Cursors
  • Explicit Cursors
  • Cursor Attributes
  • Cursor with Parameters
  • Cursors with LOOPs Nested Cursors
  • Cursors with Sub Queries
  • Ref. Cursors
  • Record and PL/SQL Table Types 

 

Day 10

Advanced PL/SQL

  • Procedures in PL/SQL
  • STORED PROCEDURES
  • PROCEDURE with Parameters (IN,OUT  and IN OUT)
  • POSITIONAL Notation and NAMED Notation
  • Procedure with Cursors
  • Dropping a Procedure
  • Functions in PL/SQL
  • Difference between Procedures and Functions
  • User Defined Functions
  • Nested Functions
  • Using stored function in SQL statements
  • Packages in PL/SQL
  • Creating PACKAGE Specification and  PACKAGE Body
  • Private and Public Objects in PACKAGE

EXCEPTIONS in PL/SQL 

  • Types of exceptions 
  • User Defined Exceptions
  • Pre Defined Exceptions
  • RAISE_APPLICATION_ERROR
  • PRAGMA_AUTONOMOUS_TRANSACTION
  • SQL Error Code Values

Database Triggers in PL/SQL

  • Types of Triggers
  • Row Level Triggers
  • Statement Level Triggers
  • DDL Triggers
  • Trigger Auditing

The Workshop content consists of an approximately equal mixture of lecture and hands-on lab. 

Recommendation: It is strongly recommended to bring your own LAPTOP during the training on which you can install and run programs if you would like to do the optional, hands-on experiments/exercises after the trainings/ workshops.

Certificates will be provided by ISO 9001:2008 certified I-Medita Learning Solutions Pvt. Ltd. Company which is registered with Ministry of Corporate Affairs for providing IT Trainings all over India and IBNC India which is a trademark championship that has already been executed in 106 Engineering colleges till March 2015.

  • Participation Certificate: Given to each candidate who participate in the workshop
  • Appreciation Certificate: Given to the College/ Institution who help in conducting the workshop.
  • Excellence Certificate: Given to the winner of the Zonal Center Championship.
  • Coordination Certificate: Given to those active & strong students and faculty coordinators who help in making the workshop and training successful.

IBNC Team gives you freedom to ask your relationship manager at IBNC India for certificate samples in advance so that you could be aware of the certificate you will be receiving before hand the trainings/workshops.

IBNC DVD to each participant to help them learn more about the workshop containing e books, presentations, videos and softwares after the training.

  • One on one interaction in the class with the Trainer.
  • Study material designed by panel of experts from industry.
  • Lead trainer will also have supporting trainers with him/her so that they can help you fall in love with the technology.
  • We believe in learning with fun!
  • The skills we develop are those that employers within the industry are looking for.
  • Covering theoretical and practical concepts in such a way that it is fun to learn the technology and easy to make unique projects.
  • Your skills and certifications are recognized anywhere in the world your career takes you.
  • Successfully trained over 15000 students till now in India.
  • Watch video testimonials given by students: www.youtube.com/ibncindia
  • Check out our facebook page to see live comments from our prestigious students.
  • IBNC makes sure that you should get the full worth of the money you have paid during the trainings anywhere in India.

Please contact IBNC India Team to know more about careers in this technology.