The Complete MySQL Developer Course

Learn SQL from scratch using MySQL Databases. A well-structured and easy to learn course for beginners to transform into a SQL developer.

365 days course access

Live instructor-led online classes

Industry-based projects

Master the basics of Querying Databases with MySQL.

E-box Job Assistant

Get noticed by the top hiring companies

Guide from “Amphi”

The Super teacher

Includes:

  • 4 hours of lecture Videos
  • 206 hands-on practice exercises
  • 40 Assessment exercises
  • 68 code analysis exercises
  • 487 knowledge based questions
  • 10 Live connect sessions
             (Master classes)
  • Lifetime access
Contact Us
+91 95669 33778

The Complete MySQL Developer Course

ABOUT THE COURSE

This course gives you the required skill set which a software developer needs. You can start with designing the ER Modelling, Database design and complex query processing.

COURSE OBJECTIVES

MySQL is one of the widely used Databases for all web developers who like to build an application using JAVA, PHP, PEARL or Python etc. This course helps you to develop any application which contains the Database. In this course you will explore the relationship of a Database and how to convert it to ER Diagram of an application. With the help of ER modelling you will be creating and maintaining the Database tables by exploring simple queries to complex functions using MYSQL.

Course Content

ER Diagram

In this module you will be exposed to ERD Modelling. An ERD also known as an entity relationship model, is a graphical representation of an information system that depicts the relationships among people, objects, places, concepts or events within that system.

  • 4 Videos
  • 6 Hours
  • 46 Problems

DDL & DML Statements

In this module you will be exposed to DDL and DML concepts. DDL (Data Definition Language) which deals with Database schemas and descriptions, of how the data should reside in the Database. DML (Data Manipulation Language) which deals with data manipulation, and includes most common SQL statements such as INSERT, UPDATE, DELETE, etc. and it is used to store, modify, retrieve, delete and update data in the Database.

  • 2 Videos
  • 6 Hours
  • 92 Problems

Basic SELECT Queries

In this module you will be exposed to Basic SELECT statements. The SELECT statement retrieves data from a Database. The data is returned in a table-like structure called a result-set. SELECT is the most frequently used actions on a Database.

  • 2 Videos
  • 5 Hours
  • 91 Problems

Aggregate Functions

In this module you will be exposed to aggregate Functions in Mysql. An aggregate function is a function where the values of multiple rows are grouped together to form a single value. These functions are useful while performing mathematical calculations.

  • 2 Videos
  • 6 Hours
  • 86 Problems

Date, Time, String Functions

In this module you will be exposed to Date, Time and String functions. Date, Time, String functions is to perform string and date related operations on data. These functions are useful while performing string concatenations, sub-strings, date between, datediff functions etc.

  • 2 Videos
  • 8 Hours
  • 79 Problems

Nested Queries

In this module you will be exposed to Nested/Subqueries. A Nested/subquery is a statement that has another SQL query embedded in the WHERE or the HAVING clause. A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.

  • 2 Videos
  • 8 Hours
  • 81 Problems

Joins

In this module you will be exposed to Join queries. A Join statement is used to combine data or rows from two or more tables based on a common field between them. The most common type of join is Inner, Left, Right and Full Joins.

  • 1 Video
  • 10 Hours
  • 73 Problems

Views

In this module you will be exposed to view. A view is a virtual table based on the result-set of an SQL statement. We can create a view by selecting fields from one or more tables present in the Database.

  • 1 Video
  • 5 Hours
  • 47 Problems

Procedures & Functions

In this module you will be exposed to Procedures & Functions. Procedures and Functions are the subprograms which can be created and saved in the Database as Database objects. A function MUST return a value. A procedure cannot return a value. Procedures and functions can both return data in OUT and IN OUT parameters.

  • 3 Videos
  • 4 Hours
  • 65 Problems

Triggers

In this module you will be exposed to triggers. A trigger is a special type of stored procedure. DML triggers execute when a user tries to modify data through DML events like INSERT, UPDATE, or DELETE statements on a table.

  • 1 Video
  • 4 Hours
  • 39 Problems

Exceptions

In this module you will be exposed to Exceptions. Exceptions are error handling in Stored Procedures. It is a standard SQLSTATE value. Or it can be an SQLWARNING, NOTFOUND or SQLEXCEPTION condition, which is shorthand for the class of SQLSTATE values.

  • 1 Video
  • 5 Hours
  • 27 Problems

Set Operators

In this module you will be exposed to Set Operators. Set operators combine the results of two component queries into a single result. Queries containing set operators are called compound queries. SET operations to be performed on table data like Union, Union all, Intersect and Minus.

  • 1 Video
  • 3 Hours
  • 36 Problems

Recommended Courses

You can opt for the following courses once you complete your ongoing course

About E-Box

E-Box is a Technology Enabled Active Learning and
Assessment platform for technology and engineering
domains apart from the basic LMS components like
quizzes, assignments, lesson components.

Connect with us

E-Box Google Playstore