InstructorPriyanka Pandey
TypeOnline Course
Student Enrolled3
Price₹99
Buy NowBook Now

Prominent Features

Our online courses offer a quality learning experience, convenience, and flexibility and are delivered through our online course management system. Using this supportive, user-friendly course environment you can make learning fun.

Twitter Feed

Blog Updates

Top 50 Engineering Colleges of India – 2017
IC Fabrication Process
Indian Institute of Technology Bombay

MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming.

MySQL is the most popular database system used with PHP.

What is MySQL?

  • MySQL is a database system used on the web
  • MySQL is a database system that runs on a server
  • MySQL is ideal for both small and large applications
  • MySQL is very fast, reliable, and easy to use
  • MySQL uses standard SQL
  • MySQL compiles on a number of platforms
  • MySQL is free to download and use
  • MySQL is developed, distributed, and supported by Oracle Corporation
  • MySQL is named after co-founder Monty Widenius’s daughter: My

The data in a MySQL database are stored in tables. A table is a collection of related data, and it consists of columns and rows.

Databases are useful for storing information categorically. A company may have a database with the following tables:

  • Employees
  • Products
  • Customers
  • Orders

PHP + MySQL Database System

  • PHP combined with MySQL are cross-platform (you can develop in Windows and serve on a Unix platform)

Database Queries

A query is a question or a request.

We can query a database for specific information and have a recordset returned.

Look at the following query (using standard SQL):

SELECT LastName FROM Employees

The query above selects all the data in the “LastName” column from the “Employees” table.

Download MySQL Database

If you don’t have a PHP server with a MySQL Database, you can download it for free here: http://www.mysql.com

Facts About MySQL Database

MySQL is the de-facto standard database system for web sites with HUGE volumes of both data and end-users (like Facebook, Twitter, and Wikipedia).

Another great thing about MySQL is that it can be scaled down to support embedded database applications.

Section 1Download , Install MYSQL and first SQL query
Section 2CREATE NEW DATABASE SCHEMA and TABLE
Section 3MySQL INSERT Statement Query
Section 4MySQL SELECT Statement Query
Section 5MySQL WHERE Clause Statement Query
Section 6MySQL AND & OR Operators Statement Query
Section 7SQL ORDER BY Keyword Statement Query
Section 8SQL UPDATE Statement Statement Query
Section 9MySQL DELETE Query
Section 10MySQL COUNT,MAX,MIN,AVG & SUM Function
Section 11How To Install MySQL on Windows 10
Section 12How to uninstall MySQL from windows 7 / windows 8 / windows 8.1/ windows 10