Become 100% job ready with our DBMS/SQL course!!
Let us guide you!
RDBMS Curriculum
3 Months
Practical training
Major Projects!
Introduction to DBMS
- Data.
- Database .
- Database Management Systems.
- Three-level Architecture of Database System.
- Physical Level.
- Logical Level.
- View Level.
- Data Abstraction.
- Different Levels of Data Abstraction.
- Instance and Schema.
- Data Independence.
- Logical and Physical Independence.
- Overall Structure of DBMS.
- Data Modelling.
- Record-based Logical Model- Relational.
- Network Model.
- Hierarchical Model.
Relational Database Management System
- Fundamentals of RDBMS
- Record.
- Fields.
- Data types.
- Tables.
- Database.
- E.F. Codd’s Rules.
- Keys.
- Primary Key.
- Super Key.
- Candidate Key.
- Alternate Keys.
- Composite Keys.
- Foreign Key.
- Normalization.
- 1NF.
- 2NF.
- 3NF.
- Anomalies.
- Insert Anomaly.
- Update Anomaly.
- Delete Anomaly.
Entity Relationship Modelling
- Introduction to Entity-Relationship (ER) Model
- Entity types
- Weak entity
- Strong entity
sets - Entity sets,
- Attributes
- Types of Attributes
- Keys
- Relationship constraints
- Cardinality
- Participation
- Mapping ER to Relational Model
Structured Query Language (SQL)
- Introduction to SQL
- Characteristics of SQL
- Advantages of SQL
- Datatypes in SQL
- CHAR
- VARCHAR
- TINYINT
- SMALLINT
- INT
- DECIMAL
- FLOAT
- DATE
- TIME
- Components of SQL
- Data Definition Language (DDL)
- Data Manipulation Language(DML)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
- Data Query Language (DQL)
Data Definition Language (DDL)
● Introduction.
● CREATE.
● ALTER.
● DROP.
● TRUNCATE.
● DESC.
● RENAME.
Data Integrity Constraint
- Introduction.
- Types of Data Integrity Constraints.
- IO Constraint.
- Primary Key Constraint.
- Foreign Key Constraint.
- Unique Key Constraint.
- On delete Cascade.
- Business Rule Constraint.
- Null constraint.
- Not Null constraint.
- Check constraint.
Data Manipulation Language (DML)
- Introduction
- INSERT
- UPDATE
- DELETE
Data Control Language (DCL) and DQL
- Introduction.
- COMMIT.
- SAVEPOINT.
- ROLLBACK.
- GRANT.
- REVOKE.
- SELECT.
Clauses
- WHERE.
- DISTINCT.
- FROM.
- ORDER BY.
- GROUP BY.
- HAVING.
Conditions
- AND.
- OR.
- AND OR.
- Boolean.
- LIKE.
- IN.
- Exists.
- NOT.
- Not Equal.
- IS NULL.
- IS NOT NULL.
- BETWEEN.
SQL Operators
- Arithmetic Operators.
- Comparison Operators.
- Logical Operators.
- Set Operators.
- Range Searching Operators.
- Pattern Matching Operators.
In-built Functions
- String functions
- Arithmetic functions
- Date and Time functions
- Aggregate Functions
Views
- Concept of View.
- The create view command.
- Updating views.
- Views and joins.
- Views and subqueries.
- Dropping views.
Sequences
- Creating Sequences.
- Altering Sequences.
- Dropping Sequences.
Indexes
- Introduction.
- Creating an Index.
- Simple Index.
- Unique Index.
- Composite Index.
- Implicit Index.
- Dropping Indexes.
Synonyms
- Introduction.
- Creating Synonyms.
- Dropping Synonyms.
Triggers
- Introduction to Trigger.
- How to apply Triggers.
- Creating Triggers.
- Create Trigger.
- Show Trigger.
- DROP Trigger.
- Before Insert Trigger.
- After Insert Trigger.
- BEFORE UPDATE Trigger.
- AFTER UPDATE Trigger.
- BEFORE DELETE Trigger.
- AFTER DELETE Trigger.
- Deleting Triggers.
Stored Procedures
- Why Stored Procedures?
- How to Create Procedure?
- Call a procedure.
- Compound-Statement.
- BEGIN … END Compound-Statement Syntax.
- Label Statement.
- Declare Statement.
- Variables in Stored Programs.
- Procedure Parameters.
- Procedure: Parameter IN .
- Procedure: Parameter OUT.
- Procedure: Parameter INOUT.
Functions
- Introduction.
- Creating functions.
- Executing functions.
- Deleting a function.
Cursors
- Introduction to cursors.
- Implicit and Explicit Cursors.
- Declaring cursors.
- Opening and closing cursors.
- Fetching a record from cursor.
- Parameterized cursors.
Transactions in SQL
- Introduction to Transactions
- Transaction states
- ACID properties
- Transaction
Control Commands - Concurrent Executions
- Serializability-Conflict and
View - Concurrency Control
- Lock-based
- Timestamp-based protocols
- Recovery System
- Log based recovery
- Deadlock handling
Major Project
Our students have a few things to say...
Get placed in your dream company!
Become 100% Job ready to work with our alumni in the top MNCs!
Let’s pursue your dream together!
Let us guide you!
Testimonials
4.8 / 5
4.5 / 5
4.7 / 5
Trusted by Thousands of Students
Akshaya Mulay
Accenture
Got to know about mikado from a friend and it was one of the best decisions i ever made during the starting phase of my career.
Sanjay sir’s way of teaching is just top notch and also he has a very interactive way of teaching which results into detailed learning.
Superb learing experience and great atmosphere ! 🙂
Bharat Patel
Bank of America
It is around a year since I have started my journey of learning Core Java, Advance, Hibernate and Spring.If any non-programmer want to learn Java then this place is the right option. There are many Java training institutes in city, however the thing which makes Mikado Solutions and Sanjay Sir exceptional is Quality of Teaching and connection with the students. It is sheer hardwork and excellence of Sanjay Sir to help each student to excel in career.
Saurabh Dubey
Morgan Stanley
It had been around 2.7 year in industry as a java developer now i can say that taking admission here for java training was the best decision taken ever … Sanjay sir’s java knowledge is vast and the way of explaining things is exceptionally great. I have completed core and advanced java in mikado and before the completion of my course i got placed.
