MySQL Complete Course Basic to Advanced


What you will learn

  • Understanding what are database and why they are used.
  • Establish a solid foundation for databases and MySQL.
  • Learn how to create and deal with databases.
  • How to write simple to complex SQL queries.
  • Grasp the concept of SQL clauses, functions and datatypes.
  • Perform different types of join Operations.
  • Learn SQL Operators to write complex SQL Queries.
  • Learn about different SQL functions and constrains.
  • And much more.


Course Outline

OVERVIEW:

After completing the MySQL Database 2018 (Basic to Advance) Online Video Training Course in Urdu and Hindi, you will be able to navigate, personalize, working on different Database Platform/workplace also manage and control the user interface of PHP Admin Panel. Make the basic to advance Database in MYSQL and You Also Manage Your Own website databases. This course will teach you the nuances of proper database design. It will teach you all the hidden tips and tricks and will ensure that you learn all the major concepts of a proper database design. This course will also teach you SQL and you will be a SQL power user by the end of this course.

INTRODUCTION:

A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds. MySQL is a leading open-source database management system. It is a multi-user, multithreaded, Free, Fast, reliable, and easy to use database management system. SQL (Structured Query Language) is use in MySQL Database System. MySQL is especially popular on the web. It is one of the parts of the very popular LAMP platform. Linux, Apache, MySQL and PHP. MySQL database is available on most important OS platforms. MySQL (pronounced My S-Q-L) is an open-source relational database. It's free, and most web hosting providers include it in their most basic packages. It is freely available and released under GPL (GNU General Public License).

MySQL is a Relational Database Management System (RDBMS). Database Management system is a computer software application, designed to allow the definition, creation, querying, update, and administration of databases.

Example:

Some examples of DBMS are.

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server
  • Oracle
  • Sybase

PREREQUISITES:

Before starting this course, you should have a working knowledge of Following:

  • Basic computer
  • Basic Internet

This training is compatible with windows XP, Window 7, Windows 8, Windows 8.1, Windows 10. MAC operating system.

CERTIFICATION:

You are hereby advised to visit www.virtualacademy.pk and get yourself certified in MySQL, furthermore you'll have to meet the following criteria for earning this particular Registered Certification.

  • You will have to complete all 35 lessons through Virtual Academy Online Learning Management System at www.virtualacademy.pk.
  • Every lesson has 3 to 5 quizzes, which you must have to pass with 70% marks.
  • You need to submit your project/assignments on time.
  • After completion of Virtual Academy offered MySQL lessons via www.virtualacademy.pk Online Learning Management System there will be final exam which comprises of 50 to 100 questions.

After having assessment of your account with www.virtualacademy.pk whether you meet all the above terms and conditions, then we will dispatch your Certificate/Diploma at your given address.

 

Course Contents

 

Getting Started with MySQL

  • Introduction to MySQL
  • Introduction to Database
  • Introduction to MySQL Server
  • Xampp (PHP my admin ) installation and Configuration
  • Download and Installation of MySQL Server
  • Introduction to Data and Datatypes
  • Questions and Answers

Database Creation and Select Statement,

  • Create a new database
  • Creating tables
  • Inserting data into tables
  • Using the SELECT Clause
  • Using the SELECT DISTINCT Clause
  • Using the WHERE Clause
  • True Condition
  • False Condition
  • Questions and Answers

SQL Operators

  • SQL AND Operator
  • SQL OR Operator
  • SQL LIKE Operator
  • SQL Between Operator
  • SQL CONCAT Operator
  • SQL Numeric Operator
  • SQL Comparison Operator
  • SQL Mathematical Operators
  • Questions and Answers

Insert Update and Delete

  • Inserting Data Using the Insert
  • Insert into Select Statement
  • Updating data using Update
  • Deleting Data
  • Questions and Answers

SQL Joins

  • Introduction to Joins
  • Inner Join
  • Left Inner Join
  • Right Inner Join
  • Full Outer Join
  • Cross Join
  • Questions and Answers

MySQL Functions

  • SQL AVG() Function
  • SQL Count() Function
  • SQL Min() Function
  • SQL Max() Function
  • SQL Sum() Function
  • SQL Ucase() Function
  • SQL Lcase() Function
  • SQL Mid() Function
  • SQL LEN() Function
  • ROUND() Function
  • NOW() Function
  • FORMAT() Function
  • Questions and Answers

Constraints in MySQL

  • Constraints in SQL
  • Not Null Constraints in SQL
  • Unique Constraints
  • Primary key Constraints
  • Foreign key Constraints
  • Default Constraints
  • Auto Increment Constraints
  • Questions and Answers

Clauses In MySQL

  • Order by Clause
  • Top Clause
  • Where Clause
  • Group By Clause
  • Having Clause
  • Questions and Answers

Sub Queries

  • Sub Query Concept and Demonstration
  • Corelated Subquery
  • Questions and Answers

SQL Wildcard and Fully Qualified Name

  • Wildcard in Detail
  • Fully Qualified name
  • Questions and Answers

SQL Other Concepts

  • Add Multiple Queries in MYSQL
  • Order by
  • Triggers
  • Store Procedure
  • Alter
  • Limits
  • Sorting
  • Regular Expression
  • On Delete Cascade
  • Nth Highest Record
  • Find Duplicate Values
  • Copy, Column, rows, Tables, Structures in SQL
  • How to Import & Export MySQL Data
  • MySQL View
  • Questions and Answers

Final Exam and Certification



Comments

  • Zahid
    16 April 2024

    R programming and other high level languages...


  • Muhammad shafiq
    23 June 2024

    Explained very well, I just learned My SQL in 1 week without prior SQL knowledge . Thank you very much...


Leave a Comment