Call for details
9308464309 / 9308474587
Address :- 2nd Floor,
Singh Palace,
Radium Road, Ranchi.
Click here to Enquire

Institute of Information Technology & Enabled Services

MySql - Open Source Database

The MySQL database has become the world’s most popular open source database because of its high performance, high reliability and ease of use. It is also the database of choice for a new generation of applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python.). MySQL is a database management system that is written in Structured Query Language (SQL). It is both multi-threaded (can execute multiple commands at the same time) and multi-user (more than one user at a time can run commands). .

MySql Training Ranchi

Topics Covered in - MySql - Open Source Database

  • Database Basics
    Basics of Relational Databases, SQL Language and MySQL
  • Database Design
    Database Modeling, Keys, Normalization
  • Table Data Types
    Data Types, Numeric Data Types, Temporal Data Types, Character String Data Types, The Meaning of Null
  • Database and Table Creation
    Database Structure Creation, Database Creation, Table Creation
  • Basic Queries
    The SELECT Statement, MySQL Workbench for SQL Development, Troubleshooting
  • Database and Table Maintenance
    Deleting an Entire Database, Maintaining Tables, Maintaining Columns, Indexes and Constraints
  • Table Data Manipulation
    Delete/Modify Table Row Data, The INSERT Statement, The REPLACE Statement, The UPDATE Statement, The DELETE Statement
  • Functions
    Simple Functions, Grouping with Functions
  • Joining Tables
    Combining Multiple Tables, Inner Joins, Outer Joins
  • Table Queries
    What is a Subquery, Categories of Subqueries, Subquery Types, Placing Subqueries, Other Subquery Uses, Converting Subqueries to Joins
  • Exporting and Importing Data