Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on RDBMS which gives you the opportunity to interact with a RDBMS instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


Introduction to Databases 

  • What is a database? 
  • Why Use A Database? 
  • Types Of database 

Relational Databases 

  • Terminology 
  • Connecting Tables 
  • Advantages of Relational Databases 
  • Relational Database Management Systems 
  • (RDBMS) 
  • Relational Database Applications 
  • Relational Database Design Process 
  • Business Needs Analysis 
  • Database Specification 
  • Identifying Database & Programming 
  • Functions 
  • Design Phases 

Relational Data Model 

  • The Conceptual Data Model 
  • The Entity-Relationship Data Model 

Entity-Relationship Diagrams 

  • The Role of E-R Diagrams 
  • Construction of E-R Diagrams 
  • Testing Your Data Model 

Microsoft SQL Server RDBMS 

  • Microsoft SQL Server Tools 
  • Enterprise Manager 
  • Query Analyzer 

Normalisation 

  • First Normal Form (1NF) 
  • Second Normal Form (2NF) 
  • Third Normal Form (3NF) 
  • Fourth Normal Form (4NF) 
  • Fifth Normal Form (5NF) 

Creating the Physical Database 

  • Data Definition SQL Statements 
  • Creating A Database 
  • Creating A Table 
  • Altering A Table 
  • Dropping A Table 
  • Creating An Index 
  • Dropping An Index 
  • Constraints 

Working with Data 

  • Loading Data Into A Database 
  • Inserting Data Into A Table 
  • Retrieving Records 

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234