Introduction to MySQL

Learn MySQL from zero

Welcome everyone to the ultimate MySQL course. In this course you’ll get to know about Structured Query Language and Query handling in MySQL.

What you’ll learn

  • Create and Interact with Databases on your system.
  • Create and manage tables in databases.
  • Differentiate between SQL and MySQL.
  • Learn several commands to handle queries for extracting data from the table.

Course Content

  • Introduction –> 2 lectures • 4min.
  • Introduction and some basic commands in MySQL –> 3 lectures • 15min.
  • Commands for Creating, Modifying, and Inserting values into tables –> 6 lectures • 58min.
  • Extracting data from the table –> 5 lectures • 41min.
  • Date and Time Functions –> 2 lectures • 11min.
  • String Functions –> 1 lecture • 9min.
  • Indexing and Foreign Key Constraint –> 2 lectures • 21min.
  • Merging Data of two tables –> 2 lectures • 14min.
  • Thank you Note –> 1 lecture • 1min.

Introduction to MySQL

Requirements

  • A laptop/ pc is required.
  • No additional experience/ technical knowledge is needed for this course.

Welcome everyone to the ultimate MySQL course. In this course you’ll get to know about Structured Query Language and Query handling in MySQL.

 

Almost anyone with a laptop or a PC can master MySQL with this course. This course provides you with the lecture slides, several resources to help you handle complex queries, crack interview questions asked in Structured Query Language, and source code to MySQL commands cheatsheet.

 

It is a full package that will help you to: –

– Differentiate between SQL and NoSQL

– Get familiar with MySQL Workbench and Command Line Client

– Learn to install MySQL command line client and MySQL Workbench

– Understand SQL concepts in simple manner.

– Create tables and Databases in MySQL.

– Update and delete records as well as columns in MySQL.

– Update,  Undo, and commit queries in MySQL command line client.

– Handle different constraints in a table including primary key constraint.

– Link two tables with a foreign key constraint and handle queries related to it.

– Display desirable results using various Clauses and Conditions.

– Filter data with various clauses, conditions, like clause, and Regular Expression.

– Know about several date, time, and string functions.

– Merge records of two tables as well as join two tables.

– Crack SQL Job interviews.

– Add a feather to your resume.

Get Tutorial