Basic Concepts of MySQL Database
Basic MySQL Database Operations
Updated on Sep, 2023
Language - English
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
Goals
What will you learn in this course:
- Basic syntax in MySQL Database
- Basics of MySQL Database
- Usage of syntax
Prerequisites
What are the prerequisites for this course?
- Novice
- All Audience
- Beginner
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction on MySQL Database
42 Lectures
-
Introduction on MySQL Database
59:39
59:39
-
Course Resources
-
Data Types
51:11
51:11
-
Select Statements
59:19
59:19
-
Backticks
14:35
14:35
-
Usage of NULL
18:16
18:16
-
Limit and OffSet
13:20
13:20
-
Creating Databases
17:52
17:52
-
Using Variables
24:44
24:44
-
Commenting in MySQL
13:31
13:31
-
Inserting Data in MySQL
28:45
28:45
-
Deleting Data in MySQL
20:36
20:36
-
Updating in MySQL
19:59
19:59
-
Order by Clause in MySQL
07:54
07:54
-
Group by Statements
17:42
17:42
-
Errors in MySQL
10:18
10:18
-
Joins
37:15
37:15
-
Joins continued
10:39
10:39
-
Union
18:22
18:22
-
Arithmetic
19:38
19:38
-
String Operations
32:53
32:53
-
Date and Time Operations
07:48
07:48
-
Handling Time Zones
07:02
07:02
-
Regular Expressions
19:21
19:21
-
Views
19:31
19:31
-
Table Creation
22:50
22:50
-
Altering a Table
22:41
22:41
-
Dropping a Table
05:29
05:29
-
MySQL Lock Table
09:38
09:38
-
Error Codes
07:48
07:48
-
Stored Routines
29:08
29:08
-
Indexes and Keys
24:07
24:07
-
Full Text Search
17:55
17:55
-
Prepare Statements
09:09
09:09
-
JSON Introduction
10:38
10:38
-
Extract values from JSON types
05:15
05:15
-
MySQL Admin
08:00
08:00
-
Triggers
12:15
12:15
-
Configuration and Tuning
07:19
07:19
-
Events
08:12
08:12
-
ENUM
09:12
09:12
-
Collations, Transactions, Log files, Replication, Backup
40:42
40:42
Instructor Details
Frahaan Hussain
CEO and Lead Developer at Sonar SystemsI 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.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now