SQL using MySQL Tutorial for beginners, learn sql queries , sql course for beginners, MySQL course

One of the best course to learn sql queries. This is free sql course for beginners.
SQL using MySQL tutorial for beginners – Learn MySQL.

MySQL is an open source relational database management system based on SQL. MySQL is the world’s most popular database server (RDBMS).

✅ How to install MySQL Server on Windows
https://youtu.be/-LJiF2u6uqc

✅ Script to create MySQL sample database for this course
https://drive.google.com/file/d/1au2R5EZtE1xg29iL0yz4K6Fvu_buEPRD/view?usp=sharing

✅ Setup Development Environment Playlist:
https://www.youtube.com/playlist?list=PLj4CUKmgqTSOjUSSMvGR4rbTViBwuUQjm

✅ How to install and run node js in windows 11
https://youtu.be/XPZmr3oA_G4

TABLE OF CONTENTS

00:00 Introduction
00:13 What is database?
01:44 What is DBMS?
03:21 What is SQL?
03:57 Basic philosophy of database
05:52 Overview of MySQL
06:37 Installing MySQL on windows
07:43 Overview of MySQL Workbench
11:46 How to drop and create database for this course
16:31 The SELECT statement
24:52 The WHERE Clause
26:44 The AND, OR and NOT Operatores
30:00 The ORDER BY Operator
31:49 The LIMIT Operator
32:34 The LIKE Operator
36:27 The IN Operator
40:06 The BETWEEN Operator
40:58 Using Alias with AS keyword
44:02 What are SQL Joins?
46:11 The INNER Joins
53:04 LEFT Outer Join
54:34 RIGHT Outer Join
55:35 Joining Multiple Table – A Complex Example

#mysql #mysqldatabase #mysqlworkbench

HTech IT Education

#softwareengineer
#softwareengineering