MySQL tutorial for beginners - Learn MySQL, the world's most popular open source database.
🔥 Want to master MySQL? Get the full MySQL course: http://bit.ly/2uAoPM3
👍 Subscribe for more SQL tutorials like this: https://goo.gl/6PYaGF

⭐️Want to learn more from me? Check out these links: 

Courses: https://codewithmosh.com
Twitter: https://twitter.com/moshhamedani
Facebook: https://www.facebook.com/programmingwithmosh/
Blog: https://programmingwithmosh.com 

📕Get my FREE SQL cheat sheet: 
http://bit.ly/2JCO73l

📔Scripts to create the databases in this course:
https://bit.ly/3rvtqdO

TABLE OF CONTENT

0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course 
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators 
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables 
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row 
2:35:40 Inserting Multiple Rows 
2:38:58 Inserting Hierarchical Rows 
2:44:51 Creating a Copy of a Table 
2:53:38 Updating a Single Row 
2:57:33 Updating Multiple Rows 
3:00:47 Using Subqueries in Updates 
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases

If you're looking for a complete SQL tutorial for beginners with examples, this tutorial is a great way to learn SQL basics. Just follow through and you'll be able to write SQL queries in no time. 

SQL, short for Structured Query Language, is a language used by software developers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information. 

There are various database management systems (DBMS) that support SQL but each product has its own implementation of SQL. In this course, we'll be using MySQL to learn SQL. MySQL is the most popular free and open-source database management system in the world. If you use a different DBMS (eg SQL Server), you can still benefit from this course as 90% of the skills you'll learn in this course can be transferred to other database management systems.

MySQL Tutorial for Beginners [Full Course]

Learn about software system design and microservices. This course is a hands-on approach to learning about microservice architectures and distributed systems using Python, Kubernetes, RabbitMQ, MongoDB, mySQL.

✏️ Course from Kantan Coding. Check out his channel: https://www.youtube.com/channel/UC5UgemAz061hkjTFHOfxNpg

💻 Code: https://github.com/selikapro/microservices-python

Kubernetes API Reference: https://kubernetes.io/docs/reference/kubernetes-api/

⭐️ Contents ⭐️
(0:00:00) Intro
(0:01:02) Overview 
(0:02:47) Installation & Setup?
(0:10:16) Auth Service Code
(0:32:25) Auth Flow Overview & JWTs
(0:53:04) Auth Service Deployment
(0:56:08) Auth Dockerfile
(1:20:05) Kubernetes
(1:37:26) Gateway Service Code
(1:42:34) MongoDB & GridFs
(1:47:04) Architecture Overview (RabbitMQ)
(1:49:50) Synchronous Interservice Communication
(1:50:49) Asynchronous Interservice Communication
(1:53:19) Strong Consistency
(1:54:07) Eventual Consistency
(2:19:16) RabbitMQ
(2:21:16) Gateway Service Deployment
(2:35:34) Kubernetes Ingress
(2:46:28) Kubernetes StatefulSet
(2:51:18) RabbitMQ Deployment
(3:09:35) Converter Service Code
(3:33:43) Converter Service Deployment
(4:21:09) Checkpoint
(4:22:11) Update Gateway Service
(4:31:46) Notification Service Code
(4:43:24) Notification Service Deployment
(4:51:55) Sanity Check
(5:05:54) End

⭐️ References ⭐️
https://www.mongodb.com/docs/
https://www.rabbitmq.com/documentation.html
https://docs.microsoft.com/en-us/azure/architecture/patterns/competing-consumers
https://docs.microsoft.com/en-us/azure/architecture/microservices/design/interservice-communication
https://cloud.google.com/datastore/docs/articles/balancing-strong-and-eventual-consistency-with-google-cloud-datastore

🎉 Thanks to our Champion and Sponsor supporters:
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Erdeniz Unvan
👾 Justin Hual
👾 Agustín Kussrow
👾 Otis Morgan

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

Microservice Architecture and System Design with Python & Kubernetes – Full Course

SQL or NoSQL? MySQL vs MongoDB? Which database is better? Which one should you use?

Get our complete SQL (MySQL & PostgreSQL) course: https://acad.link/sql
Learn all about MongoDB: https://acad.link/mongodb
Exclusive discount also available for our MEAN (Mongo, Express, Angular, Node) course: https://acad.link/mean
Join our Academind Community on Discord for free: https://discord.gg/gxvEWGU

Don't miss the article on this video: https://academind.com/learn/web-dev/sql-vs-nosql/

Want to learn something totally different? Check out our other courses: https://academind.com/learn/our-courses

----------

More on SQL Horizontal Scaling: https://stackoverflow.com/questions/27157227/can-relational-database-scale-horizontally

----------

• You can follow Max on Twitter (@maxedapps).
• And you should of course also follow @academind_real.
• You can also find us on Facebook.(https://www.facebook.com/academindchannel/) 
• Or visit our Website (https://www.academind.com) and subscribe to our newsletter!

See you in the videos!

----------

Academind is your source for online education in the areas of web development, frontend web development, backend web development, programming, coding and data science! No matter if you are looking for a tutorial, a course, a crash course, an introduction, an online tutorial or any related video, we try our best to offer you the content you are looking for. Our topics include Angular, React, Vue, Html, CSS, JavaScript, TypeScript, Redux, Nuxt.js, RxJs, Bootstrap, Laravel, Node.js, Progressive Web Apps (PWA), Ionic, React Native, Regular Expressions (RegEx), Stencil, Power BI, Amazon Web Services (AWS), Firebase or other topics, make sure to have a look at this channel or at academind.com to find the learning resource of your choice!

SQL vs NoSQL or MySQL vs MongoDB

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. 
Want more from Mike? He's starting a coding RPG/Bootcamp - https://simulator.dev/

The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.

You can get PopSQL to follow along here: http://popsql.com/freecodecamp

🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/

⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables & Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints 
⌨️ (1:48:11) Update & Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating Company Database
⌨️ (2:30:27 ) More Basic Queries
⌨️ (2:26:24) Functions
⌨️ (2:45:13) Wildcards
⌨️ (2:53:53) Union
⌨️ (3:01:36) Joins
⌨️ (3:11:49) Nested Queries
⌨️ (3:21:52) On Delete
⌨️ (3:30:05) Triggers
⌨️ (3:42:12) ER Diagrams Intro
⌨️ (3:55:53) Designing an ER Diagram
⌨️ (4:08:34) Converting ER Diagrams to Schemas

Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw

🐦Follow Mike on Twitter: http://twitter.com/mike_dane

🔗The Giraffe Academy website: http://www.giraffeacademy.com/

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org