Best Seller Icon Bestseller
0 students

CERTIFICATE IN RDBMS

  • Last updated Nov, 2025
  • Certified Course
₹4,500 ₹5,000
  • Duration2 Months
  • Enrolled0
  • Lectures50
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

RDBMS (Relational Database Management System) is a specialized course designed to teach the fundamentals of database design, management, and SQL programming. The course covers data models, tables, relationships, keys, normalization, SQL commands (SELECT, INSERT, UPDATE, DELETE), joins, and database security concepts.

Students learn to store, organize, and manage data efficiently using tools like MySQL, Oracle, or MS Access.

After completing RDBMS, students can work as Database Assistants, SQL Developers, or Data Entry Operators in business and IT organizations.

Show More

Course Syllabus

Module 1: Introduction to Databases: What is a Database?, DBMS vs RDBMS, Types of Databases (Relational, NoSQL), Overview of MS Access, MySQL, and SQL Server, Database Design Concepts (Entities, Attributes, Relationships), Introduction to ER Diagrams.

Part I: MS Access

 Module 2: MS Access Basics: Introduction to MS Access Interface, Creating a New Database, Tables: Creating and Modifying, Field Types, Primary Keys, Data Entry and Validation, Creating Forms for Data Input, Queries: Select, Update, Delete, Creating Reports, Relationships Between Tables, Macros and Basic Automation.

Part II: MySQL

Module 3: MySQL Basics: Installing MySQL and Workbench, Creating Databases and Tables using SQL, Data Types in MySQL, Inserting, Updating, and Deleting Records, Basic SQL Queries (SELECT, WHERE, ORDER BY, GROUP BY), Using Joins (INNER, LEFT, RIGHT, FULL), Constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY), Aggregate Functions (SUM, AVG, COUNT, etc.), Subqueries and Views, User Management and Access Control.

Part III: SQL Server (Optional or Parallel with MySQL)

Module 4: SQL Server Basics: Overview of SQL Server & SSMS (SQL Server Management Studio), Creating Databases and Tables, Using T-SQL for Queries, Stored Procedures and Functions, Triggers and Transactions, Backup and Restore, Import/Export Data­­, Indexing and Performance Tuning (Intro level).

Module 5: Database Design & Normalization: Functional Dependency, Normal Forms (1NF to 3NF), Designing ER Diagrams and Converting to Tables, Case Studies: Student Database, Inventory System.


Course Fees

Course Fees
:
₹5000/-
Discounted Fees
:
₹ 4500/-
Course Duration
:
2 Months

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%