Welcome to Datasoft Institute

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 )

BASIC INFORMATION

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