Basic Concepts of MySQL Database

person icon Frahaan Hussain

Basic Concepts of MySQL Database

Basic MySQL Database Operations

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Frahaan Hussain

architecture icon MySQL,IT & Software,Other IT & Software


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

This course is introduction level for MySQL. It covers examples with handouts and MySQL queries. There will be also free online MySQL access for practice.

Please Note that Last Chapter is very fast and it is more of installing MySQL database on Debian, Ubuntu, CENTOS. You must require root access if you want to perform those operations.

If I am missing something; you can refer handout, and SQL script. You can also reach me through email if you need any explanation on specific topics.

Chapter 1: Introduction on MySQL

Chapter 2: Data Types

Chapter 3: SELECT Statements

Chapter 4: Backticks

Chapter 5: NULL

Chapter 6: Limit and Offset

Chapter 7: Creating databases

Chapter 8: Using Variables

Chapter 9: Comment MySQL

Chapter 10: INSERT Statements

Chapter 11: DELETE Statements

Chapter 12: UPDATE Statements

Chapter 13: ORDER BY Clause

Chapter 14: Group By

Chapter 15: Errors in MySQL

Chapter 16: Joins

Chapter 17: Joins continued

Chapter 18: UNION

Chapter 19: Arithmetic

Chapter 20: String operations

Chapter 21: Date and Time Operations

Chapter 22: Handling Time Zones

Chapter 23: Regular Expressions

Chapter 24: VIEWS

Chapter 25: Table Creation

Chapter 26: ALTER TABLE

Chapter 27: Drop Table

Chapter 28: MySQL LOCK TABLE

Chapter 29: Error codes

Chapter 30: Stored routines (procedures and functions)

Chapter 31: Indexes and Keys

Chapter 32: Full-Text search

Chapter 33: PREPARE Statements

Chapter 34: JSON

Chapter 35: Extract values from JSON type

Chapter 36: MySQL Admin

Chapter 37: TRIGGERS

Chapter 38: Configuration and tuning

Chapter 39: Events

Chapter 40: ENUM

Chapter 41: Collations, Transactions, Log files, Replication, Backup

Who this course is for:

  • Beginner for MySQL Database


What will you learn in this course:

  • Basic syntax in MySQL Database
  • Basics of MySQL Database
  • Usage of syntax


What are the prerequisites for this course?

  • Novice
  • All Audience
  • Beginner
Basic Concepts of MySQL Database


Check out the detailed breakdown of what’s inside the course

Introduction on MySQL Database
42 Lectures
  • play icon Introduction on MySQL Database 59:39 59:39
  • play icon Course Resources
  • play icon Data Types 51:11 51:11
  • play icon Select Statements 59:19 59:19
  • play icon Backticks 14:35 14:35
  • play icon Usage of NULL 18:16 18:16
  • play icon Limit and OffSet 13:20 13:20
  • play icon Creating Databases 17:52 17:52
  • play icon Using Variables 24:44 24:44
  • play icon Commenting in MySQL 13:31 13:31
  • play icon Inserting Data in MySQL 28:45 28:45
  • play icon Deleting Data in MySQL 20:36 20:36
  • play icon Updating in MySQL 19:59 19:59
  • play icon Order by Clause in MySQL 07:54 07:54
  • play icon Group by Statements 17:42 17:42
  • play icon Errors in MySQL 10:18 10:18
  • play icon Joins 37:15 37:15
  • play icon Joins continued 10:39 10:39
  • play icon Union 18:22 18:22
  • play icon Arithmetic 19:38 19:38
  • play icon String Operations 32:53 32:53
  • play icon Date and Time Operations 07:48 07:48
  • play icon Handling Time Zones 07:02 07:02
  • play icon Regular Expressions 19:21 19:21
  • play icon Views 19:31 19:31
  • play icon Table Creation 22:50 22:50
  • play icon Altering a Table 22:41 22:41
  • play icon Dropping a Table 05:29 05:29
  • play icon MySQL Lock Table 09:38 09:38
  • play icon Error Codes 07:48 07:48
  • play icon Stored Routines 29:08 29:08
  • play icon Indexes and Keys 24:07 24:07
  • play icon Full Text Search 17:55 17:55
  • play icon Prepare Statements 09:09 09:09
  • play icon JSON Introduction 10:38 10:38
  • play icon Extract values from JSON types 05:15 05:15
  • play icon MySQL Admin 08:00 08:00
  • play icon Triggers 12:15 12:15
  • play icon Configuration and Tuning 07:19 07:19
  • play icon Events 08:12 08:12
  • play icon ENUM 09:12 09:12
  • play icon Collations, Transactions, Log files, Replication, Backup 40:42 40:42

Instructor Details

Frahaan Hussain

Frahaan Hussain

CEO and Lead Developer at Sonar Systems

I am CEO of Sonar Systems which is the world leader in educational material for the game engine Cocos2d-x, one of the best and most popular game engines in the world. With years of experience programming and running an online education platform (Sonar Learning) I can help and support new programming like you. I am also a University Lecturer teaching a variety of topics in Games Programming from Games Design to OpenGL Shader Programming. I am also a published author of games design and soon to be released Responsive Web Design. I have all the facets required to educate and inspire.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us