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
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)
Qual : 10th or 12th or Above
Course Code : M-S003
Course Code : DS002
Course Code : DS013
Course Code : DS025
Course Code : M-T-S005
Course Code : M-D-S004
Course Code : M-AH-S006
Course Code : S-DS032
Course Code : MD-S-006
Course Code : DS-S005