MySQL (Open Source Database)

by IITES Claim Listing

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).

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

IITES Logo

img Duration

Please Enquire

Course Details

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). 

 

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
  • Ranchi Branch

    2nd Floor, Singh Palace, Above ICICI ATM, Radium Road, Ranchi

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy