Tutorialspoint
Subscription Includes
$ 130   9.99

Basic Concepts of MySQL Database

Created by Frahaan Hussain, Last Updated 08-Jun-2020, Language:English

Basic Concepts of MySQL Database

Basic MySQL Database Operations

Created by Frahaan Hussain, Last Updated 08-Jun-2020, Language:English

What Will I Get ?

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

Requirements

  • Novice
  • All Audience
  • Beginner

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

Course Content

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.