Data Base Management System (DBMS)
We shall study and do exercises covering Data Base Management Concepts, Installation to Manage and work with Data Base Management System, Structured Query Language (SQL), Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language (DCL).
Introduction
Data Base Management System(DBMS)-MySQL is a fast, easy to use, and open-source relational database management system. It is commonly used in conjunction with server-side scripting language to create powerful and dynamic server-side applications -
Key Topics
Install, manage and work with MySQL, Understand and explain the roles of DBMS, Use of the Structured Query Language (SQL), Write DDL statement to Create, modify and delete database/ schema, tables, and indexes, MySQL datatypes, unique key, primary key, foreign key and table constraints, Write DML statement to create, modify and delete tables and Retrieve data from the tables through queries and sub-queries, Write DCL statement to undo work or permanently save work to database, Control Transactions, Write DML statement to create, modify and delete tables and Retrieve data from the tables through queries and sub-queries, Work with MySQL built-in functions.
Mode of Training
Class Room & Instructor led Online
Course Duration
2 weeks
Course Fees
INR 4000/-