MySQL Tutorial for Beginners | Learn MySQL

Name: MySQL Tutorial for Beginners | Learn MySQL
Rating: 4.0 (38 reviews)

Master The Basics Of MySQL | Learn MySQL Step by Step | Learn MySQL Fundamentals

Created byProgramming Knowledge

Last updated 7/2020

English

What you'll learn

Create MySQL Queries that are efficient and clear
Master SQL
To Learn to use MySQL
To Learn Database development using MySQL

Course content

5 sections • 37 lectures • 4h 29m total length

Introduction to MySQL4:43

How to Insert Data into a MySQL table7:29
Learn how to insert data into a MySQL table using insert into, specifying columns and values, including multiple records and single-column inserts, then verify with a select.
Using SELECT Statement to Query Data In MySQL8:20
MySQL SELECT DISTINCT Statement7:29
MySQL WHERE Clause with Examples10:00
Explore how to use the MySQL where clause to filter records, display specific columns, and apply operators such as greater than, less than, equals, not, and in, including null handling.
MySQL AND condition By Examples12:00
MySQL OR condition By Examples11:54
MySQL ORDER BY Clause8:46
Explore the MySQL order by clause to sort query results by one or more columns in ascending or descending order, with examples on name and number sorting.
MySQL LIMIT Clause4:52
MySQL UPDATE Statement9:26
MySQL DELETE Query6:58
MySQL TRUNCATE TABLE with Examples4:39
MySQL DROP TABLE Statement5:40
MySQL DESCRIBE Statement6:55
MySQL ALTER TABLE Statement11:40
Learn how to alter table structures in MySQL by adding, modifying, and dropping columns, changing data types and constraints, and renaming tables or columns.
MySQL BETWEEN Operator5:14
MySQL ALIASES6:38
MySQL IN Clause4:57
MySQL LIKE Operator7:40
Learn how to use the MySQL like operator to filter records by pattern, using wildcards % and _ to match starts with, ends with, and contains patterns.
MySQL INSERT INTO SELECT Statement7:27
MySQL CREATE TABLE LIKE A1 as A25:58
Create a new table that mirrors an existing one by using create table new_table like existing_table, copying the schema without data. Describe the table to verify the copied structure.
MySQL UNION Operator6:16
MySQL Primary Key8:10
MySQL UNIQUE Constraint5:34
MySQL FOREIGN KEY Constraint9:49
MySQL NOT NULL5:38
MySQL AUTO INCREMENT6:02
MySQL DEFAULT Constraint4:42

MySQL JOIN4:31
Discover how MySQL joins combine data from multiple tables using a common column, including left, right, inner, and full outer joins to retrieve matched and unmatched rows.
MySQL INNER JOIN7:26
MySQL LEFT JOIN5:08
MySQL RIGHT JOIN5:31
Learn how to use a MySQL right join to fetch matching employee and department records, returning all department rows and their related employees where available.

Requirements

A Windows, Mac or Linux computer
breadboard

Description

Welcome to this course on MySQL Tutorial for Beginners, designed to help you understand databases from the ground up in a simple, practical, and beginner-friendly way. Whether you are a student, aspiring developer, or someone looking to strengthen your technical skills, this course will give you a solid foundation in MySQL and database management concepts.

MySQL Database is the world’s most popular open-source database because of its consistent fast performance, high reliability, scalability, and ease of use. It is widely trusted by individuals, startups, and large enterprises alike. MySQL is released under an Open Source License, specifically the GNU General Public License (GPL). This means it is free to use, modify, and distribute, provided that any modifications are also made available in source code format. This open nature has contributed to its strong community support and continuous improvement.

MySQL is most commonly used to power websites, web applications, and small to medium-sized applications. Popular platforms such as content management systems, e-commerce websites, and social applications rely heavily on MySQL. In addition, it supports advanced features such as replication, clustering, and backup solutions, making it suitable for high-availability and scalable environments.

A Database Management System (DBMS) is used to efficiently manage the storage, organization, and retrieval of data while hiding the underlying complexity from users. SQL (Structured Query Language) is the standard language used to interact with databases. Using SQL, clients can make queries to retrieve, insert, update, and delete data in a structured and secure manner.

In this course, you will learn MySQL step by step, starting with basic concepts and gradually moving toward practical usage. If you are excited about mastering the basics of MySQL and building a strong foundation in databases, join this course and begin your journey with MySQL Step-by-Step Getting Started today.

Who this course is for:

Web Developers
Database designers
Students
beginners

MySQL Tutorial for Beginners | Learn MySQL

What you'll learn

Explore related topics

Course content

Create a Database & Tables1 lecture • 5min

Install MySQL3 lectures • 24min

Introduction2 lectures • 18min

MySQL queries27 lectures • 3hr 20min

MySQL JOINs4 lectures • 23min

Requirements

Description

Who this course is for: