Admissions Open : DCA Plus, AHDCA, AHCCA, A/c Plus, Digital Marketing, Office Automation, Computerized Accounting, Taxation, O Level, CCC, C Prog, C++ Prog, Python, Java, My SQL & DISTANCE EDUCATION Prog : MBA (Dual Specilization), M Com, B Com, MA, BA etc.

CERTIFICATE IN RDBMS ( DS021 )

CERTIFICATE IN RDBMS ( DS021 )

BASIC INFORMATION

Admission Now

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.

Qual : 10th or 12th or Above