Our Courses

MySQL Programming

MySQL is a very popular open-source Relational Database Management System (RDBMS). It is ideal for both small and large applications. MySQL is very fast, reliable, scalable and easy to use. MySQL is cross-platform language. It is compliant with the ANSI SQL Standard. It was first released in 1995 and developed, distributed and supported by Oracle Corporation


Select query is use to fetch the data from the MySQL database. Database store data for later retrieval. The purpose of MySQL select is to return from the database tables, one or more rows that match a given criteria.


We can use a conditional clause called the WHERE clause to filter out the results. Using this where clause, we can specify a selection criteria to select the required records from a table. The where clause works like an if condition in any programming language. This clause is use to compare the given value with the field value available in MySQL table. If the given value from outside is equal to the given value in MySQL table, then it return that row.


The WHERE condition is MySQL when used together with the AND logical operator, is only executed if ALL filter criteria specified are meet.

The WHERE clause when used together with the OR operator, is only executed if any or the entire specified filter criteria is met.


MySQL Order By is use in conjunction with the Select query to sort data in an orderly manner. The MySQL Order By clause use to sort the query result sets in either ascending or descending order. The Order By keyword sorts the records in ascending order by default. To sort record in descending order, use the DESC keyword.


INSERT INTO is use to store data in tables. The Insert command creates a new row in the table to store data. Application programs that run on top of the database usually supply the data.


Update MySQL command is use to modify rows in a table. The update command can be used to update a single field or multiple fields at the same time. It can also be used to update a MySQL table with values from another table.


MySQL Delete command is use to delete rows that are no longer required from the database table. It deletes the whole row from the table and returns count of deleted rows. Delete command comes in handy to delete temporary or obsolete data from database. The delete query in MySQL can delete more than one row from a table in a single query. This proves to be advantages when removing large numbers of rows from database table.


The MIN() function returns the smallest value of the selected column. The MAX() function returns the largest value of the selected column.


The COUNT() function returns the number of rows that matches a specific criterion. The AVG() function returns the average value of a numeric column. The SUM() function returns the total sum of a numeric column.


Joins help retrieving data from two or more database tables. The tables are mutually related using primary and foreign keys. Types of Joins:

  • • Cross Join
  • • Inner
  • • Outer Join
  • • Left Join
  • • Right Join

A database is used to store the collection of records in an organized form. It allows us to hold the data into tables, rows, columns, and indexes to find the relevant information frequently. We can access and manage the records through the database very easily. MySQL implements a database as a directory that stores all files in the form of a table. It allows us to create a database mainly in two ways, first is MySQL Command Line Client and second is MySQL Workbench.


The MySQL Drop user statement allows us to remove one or more user accounts and their privileges from the database server. If the account does not existing the database server, it gives an error. If you want to use Drop User Statement, it is required to have global privileges of Create User statement or delete privileges for the MySQL system schema.


A table is use to organize data in the form of rows and columns and used for both storing and displaying records in the structure format. It is similar to worksheets in the spreadsheet application. A table creation command requires three things, first Name of the Table. Second, Names of Fields. Third, Definition for each Field. MySQL uses a Drop Table statement to delete the existing table. This statement removes the complete data of a table along with the whole structure or definition permanently from the database.


MySQL Alter statement is use when you want to change the name of your table or any table field. It is also use to add or delete an existing column in a table. The Alter statement always used with “ADD”, “DROP” and “MODIFY” commands.


The constraints in MySQL is use to specify the rule that allows or restricts what values/data will be sorted in the table. They provide suitable method to ensure data accuracy and integrity inside the table. It also helps to limit the type of data that will be inserted inside the table.


A Unique Key in MySQL is a single field or combination of fields that ensure all values going to store into the column will be unique. It means a column cannot store duplicate values. MySQL allows us to use more than one column with Unique Constraint in a table. It can accept null value, but MySQL allowed only one null value per column.


MySQL Primary key is a single or combination of the field, which is used to identify each record in a table uniquely. If the column contains primary key constraint, then it cannot be null or empty. The foreign key is use to link one or more than one table together. It is also known as the referencing key. A foreign key matches the primary key field of another table


Auto-increment is define as a field that is mainly use to generate a unique number for each record being added to a table at any instance. In general terms, it is use for a primary key column because a primary key in SQL is supposed to be unique and not null. Thus, auto-increment makes it easy for the developers to automatically generate a unique number for all the records.


The date function allows us to handle date effectively. While working with the database, the format of date should be matches while inserting data into table. We have a variety of data types in SQL server that can be use as the date in our table. The most popular format of date is ‘YYYY-MM-DD’ and ‘DD-MM-YYYY’.


Duration : 30 Hours
Pre-requisite :

• An RDBMS database program (like MySQL)
• To use SQL to get the data you want


Module 1 : Select


Module 2 : Where


Module 3 : AND, OR


Module 4 : Order By


Module 5 : Insert


Module 6 : Update


Module 7 : Delete


Module 8 : Min and Max


Module 9 : Count, Avg, Sum


Module 10 : Joins


Module 11 : Create DB


Module 12 : Drop DB


Module 13 : Create, Drop Table


Module 14 : Alter Table


Module 15 : Constraints


Module 16 : Unique


Module 17 : Primary Key, Foreign Key


Module 18 : Auto Increment


Module 19 : Dates


Send Your Message