image

About the MySQL

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.

Course Syllabus

Introduction to MYSQL
  • Introduction to RDBMS
  • Introduction to MYSQL
  • Installing MYSQL, Using MYSQL Admin
Creating Tables
  • Designing & Creating a Databases
  • Creating Tables
  • Data types for Field
Manipulating table [DML Operations]
  • Manipulating table [DML Operations]
  • Adding data
  • Modifying data
  • Removing data
  • Searching data
Restricting Data [Types of Constraints]
  • Restricting Data [Types of Constraints]
  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • CHECK
  • DEFAULT
MySQL Functions
  • MySQL Functions
  • Working with built-In Functions
  • String Functions
  • Math Functions
  • Date and Time Functions
  • Introduction to UDF Functions
  • Create, Alter And Drop UDF Functions
Displaying Data from Multiple Table (Joining)
  • Displaying Data from Multiple Table (Joining)
  • Introduction to Joins
  • Types of Joins
  • Examples
List of Aggregate Functions
  • Aggregate Functions and Aggregation Using GROUP BY Clause (Grouping)
  • List of Aggregate Functions
  • Examples
Introduction to Subqueries
  • Introduction to Subqueries
  • Types of Subqueries
  • The Subquery as Scalar Operand
  • Comparisons using Subqueries
  • Subqueries with ALL, ANY, IN, or SOME
  • Row Subqueries
  • Subqueries with EXISTS or NOT EXISTS
  • Correlated Subqueries
  • Subqueries in the FROM Clause
Introduction to Views & Union
  • Introduction to Views & Union
  • Why Views?
  • Restrictions on View definition
  • Create, Alter and Drop Views
  • Union vs. Union ALL
Introduction to Stored Procedure
  • Introduction to Stored Procedure
  • Why Stored Procedures?
  • Create, Alter and Drop Stored Procedure.
  • Procedure Parameters
  • IN, OUT and INOUT Parameters
Exporting and importing data
  • Exporting and importing data
  • MySQL Backup and Restore
Introduction to SQL Injection
  • Introduction to SQL Injection
  • SQL Injection preventive measures
Project Internship - 14 Hours