© Institute Of Information Technology & Enabled Services (IITES).
Website Developed & Maintained by - IITES
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). .

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