About the Course
Each and every concept from basics will be explained.Tips and tricks to solve difficult problems of Mechanics will be discussed thoroughly.Teaching Content is based on more than 8 books.Batch size limited to 10 to 15 students.Individual attention available for new and old students.
Topics CoveredUNIT-1:Introductory Concepts of DBMS:Introduction and application of DBMS,Data Independence,Database System Architecture-levels,Mapping,Database users and DBA,Entity-Relationship model,constraints,keys,Design issues,E-R Diagram,Extended E-R features-Generalization,Specialization,Aggregation,Translating E-R model into Relational model..
UNIT-2:Relational Model:The relational model,The catalog,Types,Keys,Relational Algebra,Fundamental operations,Additional operations-,SQL fundamentals,DDL,DML,DCL,PL/SQL Concepts,Cursors,Stored Procedures,Stored Funtions,Database Integrity-Triggers...
UNIT-3:Functional Dependencies,Non-loss Decomposition,First,Second,Third Forms,Dependency Preservation,Boyce/Conn Normal Form,Multi valued Dependencies and Fourth Normal Form,Join Dependencies and Fifth Normal Form..
UNIT-4:Transaction Management:ACID Properties and database recovery management..
Who should attendStudents of B.tech,BSc,Diploma
Pre-requisitesBasic knowledge of Laws of Physics
What you need to bringNotebook,Calculator & pen
Key TakeawaysNotes,Assignments,Test series,Tricks for solving tricky numericals,Grasping power i.e he will be able to solve difficult complicated problems.