Learn MySQL from scratch! 📚 This beginner-friendly tutorial covers SQL essentials for working with databases.

🚀 Want a complete MySQL deep dive?
- Check out my full course: http://bit.ly/2uAoPM3
- Subscribe for more awesome content: https://goo.gl/6PYaGF

✋ Want more? Follow me on:
- Twitter: https://twitter.com/moshhamedani
- Facebook: https://www.facebook.com/programmingwithmosh/
- Instagram: https://www.instagram.com/codewithmosh.official/
- LinkedIn: https://www.linkedin.com/school/codewithmosh/

📕 Get the FREE goodies:
- SQL cheat sheet: http://bit.ly/2JCO73l
- Scripts to create databases: 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

💡 Why Learn SQL?
- It's the standard language for working with databases.
- In-demand skill for developers, data scientists, and more.
- MySQL is popular, open-source, and easy to learn.

👉 This tutorial is perfect for you if:
- You're completely new to SQL.
- You want a practical, hands-on approach.
- You work (or want to work) with data.

#programming #coding

Start your web development career with HTML! 🌐 This beginner-friendly tutorial covers the essentials.

🚀 Want to master HTML/CSS?
- Check out my complete course: https://bit.ly/4cRdVCb
- Subscribe for more awesome content: https://goo.gl/6PYaGF

✋ Stay connected:
- Twitter: https://twitter.com/moshhamedani
- Facebook: https://www.facebook.com/programmingwithmosh/
- Instagram: https://www.instagram.com/codewithmosh.official/
- LinkedIn: https://www.linkedin.com/school/codewithmosh/

💡 Why HTML?
- It's the foundation for every website.
- Essential skill for front-end web developers.
- Easy to learn, even for absolute beginners.

👉 This tutorial is perfect for you if:
- You dream of a career in web development.
- You want to build your own website.
- You're curious about how the internet works.

📖 TABLE OF CONTENT
0:00:00 Introduction
0:01:09 What You Need
0:03:42 Languages and Tools of Web Development
0:09:36 How the Web Works
0:14:27 Inspecting HTTP Requests and Responses
0:18:30 HTML Basics
0:25:41 CSS Basics
0:30:35 Formatting Code
0:32:51 Inspecting Pages Using DevTools
0:35:04 Validating Web Pages
0:39:45 The Head Section
0:43:33 Text
0:50:13 Entities
0:53:42 Hyperlinks
1:03:12 Images

#html #webdevelopment #coding

Master React 18 with TypeScript! ⚛️ Build amazing front-end apps with this beginner-friendly tutorial.

🚀 Want the ultimate React deep dive?
- Check out my complete course: http://bit.ly/3l0vWYR
- Subscribe for more awesome content: https://goo.gl/6PYaGF

✋ Stay connected:
- Twitter: https://twitter.com/moshhamedani
- Facebook: https://www.facebook.com/programmingwithmosh/
- Instagram: https://www.instagram.com/codewithmosh.official/
- LinkedIn: https://www.linkedin.com/school/codewithmosh/

📖 TABLE OF CONTENT
00:00:00 Course Intro
00:01:55 Prerequisites
00:02:43 What is React?
00:04:57 Setting Up the Development Environment
00:06:24 Creating a React App
00:09:17 Project Structure
00:11:20 Creating a React Component
00:16:41 How React Works
00:19:00 React Ecosystem
00:21:04 Building Components
00:21:40 Creating a ListGroup Component
00:27:15 Fragments
00:29:42 Rendering Lists
00:33:11 Conditional Rendering
00:38:36 Handling Events
00:44:43 Managing State
00:50:44 Passing Data Via Props
00:54:42 Passing Functions Via Props
00:58:27 State Vs Props
01:00:00 Passing Children
01:05:04 Inspecting Components with React Dev Tools
01:07:14 Exercise: Building a Button Component
01:14:15 Exercise: Showing an Alert

#react #reactjs #javascript #coding

Learn JavaScript basics in 1 hour! ⚡ This beginner-friendly tutorial covers everything you need to start coding.

🚀 Ready to dive deeper?
- Check out my complete JavaScript course: https://bit.ly/3Uod3vF
- Subscribe for more coding tutorials: https://goo.gl/6PYaGF

✋ Stay connected:
- Twitter: https://twitter.com/moshhamedani
- Facebook: https://www.facebook.com/programmingwithmosh/
- Instagram: https://www.instagram.com/codewithmosh.official/
- LinkedIn: https://www.linkedin.com/school/codewithmosh/

💡 Why JavaScript?
- It's the essential language for web development.
- Build front-end AND back-end applications (with Node.js).
- Super in-demand for developers

👉 This tutorial is perfect for you if:
- You're a complete beginner.
- You want a fast and practical intro to JavaScript.
- You're aiming for a career in web development.

📖 TABLE OF CONTENT
00:00 What is JavaScript
04:41 Setting Up the Development Environment
07:52 JavaScript in Browsers
11:41 Separation of Concerns
13:47 JavaScript in Node
16:11 Variables
21:49 Constants
23:35 Primitive Types
26:47 Dynamic Typing
30:06 Objects
35:22 Arrays
39:41 Functions
44:22 Types of Functions

⭐️ Related Tutorials
- Node tutorial for beginners: https://youtu.be/TlB_eWDSMt4
- Express.js tutorial for beginners: https://youtu.be/pKd0Rpw7O48
- React tutorial for beginners: https://youtu.be/Ke90Tje7VS0
- Angular tutorial for beginners: https://youtu.be/k5E2AVpwsko

#coding #javascript #webdevelopment