Latest videos
Is your password for sale on the Dark Web? Find out now with Dashlane: https://www.dashlane.com/networkchuck50 (Use code networkchuck50 to get 50% off)
In this video, we’re learning one of the oldest, yet most dangerous Hacking Techniques out there, SQL Injection. Despite SQL Injections being over 20 years old, they still rank number 3 on the OWASP Top 10 List….why? Even fortune 500 companies are still vulnerable to these attacks!! So, in this video, NetworkChuck will show you how to run an SQL Injection attack. Running a basic SQL Injection attack is pretty easy but will often become more complex with trickier targets.
Stuff from the Video
---------------------------------------------------
TARGET SITE (Altoro Mutual): https://demo.testfire.net/index.jsp
MORE practice: https://play.picoctf.org/practice/challenge/304?page=1&search=sqli
How to protect against SQL Injection attacks: https://www.crowdstrike.com/cy....bersecurity-101/sql-
🔥🔥Join Hackwell Academy: https://ntck.co/NCAcademy
**Sponsored by Dashlane
SUPPORT NETWORKCHUCK
---------------------------------------------------
➡️NetworkChuck membership: https://ntck.co/Premium
☕☕ COFFEE and MERCH: https://ntck.co/coffee
Check out my new channel: https://ntck.co/ncclips
🆘🆘NEED HELP?? Join the Discord Server: https://discord.gg/networkchuck
STUDY WITH ME on Twitch: https://bit.ly/nc_twitch
READY TO LEARN??
---------------------------------------------------
-Learn Python: https://bit.ly/3rzZjzz
-Get your CCNA: https://bit.ly/nc-ccna
FOLLOW ME EVERYWHERE
---------------------------------------------------
Instagram: https://www.instagram.com/networkchuck/
Twitter: https://twitter.com/networkchuck
Facebook: https://www.facebook.com/NetworkChuck/
Join the Discord server: http://bit.ly/nc-discord
0:00 ⏩ Intro
0:39 ⏩ Sponsor - Dashlane
1:43 ⏩ How Websites work with Databases
2:08 ⏩ What is a SQL Injection??
2:51 ⏩ Strings in SQL Queries
3:25 ⏩ Is a website vulnerable to SQL Injection?
4:14 ⏩ SQL Query Logic
4:45 ⏩ the OR SQL Injection Payload
7:13 ⏩ the COMMENT SQL Injection Payload
8:42 ⏩ how to protect against SQL Injections
AFFILIATES & REFERRALS
---------------------------------------------------
(GEAR I USE...STUFF I RECOMMEND)
My network gear: https://geni.us/L6wyIUj
Amazon Affiliate Store: https://www.amazon.com/shop/networkchuck
Buy a Raspberry Pi: https://geni.us/aBeqAL
Do you want to know how I draw on the screen?? Go to https://ntck.co/EpicPen and use code NetworkChuck to get 20% off!!
#sqlinjection #owasptop10 #sqli
JOIN me for a full beginner’s tutorial on MySQL. Learn the basics of relational databases by recreating AirBnb’s database with raw SQL https://fireship.io/tags/sql/
Buy the MySQL Pillow https://fireshipio-swag.creato....r-spring.com/listing
References
Diagram https://drawsql.app/fireship/d....iagrams/airbnb-mysql
Installer https://dev.mysql.com/downloads/installer/
MySQL Docs https://dev.mysql.com/doc/
#mysql #database #tutorial
00:00 0. SQL is King
00:49 1. The Legend of Ted Codd
01:24 2. ORM Magic
02:00 3. What is a RDBMS?
02:37 4. Draw SQL Diagrams
02:56 5. Schemas, Datatypes, & Constraints
04:12 6. Be Normalized
05:00 7. Install MySQL on Windows/Mac
05:50 8. Create a New Database
06:13 9. SQLTools VS Code Extension
06:46 10. --comments
07:02 11. Basic SQL Syntax
08:04 12. Primary Key
08:31 13. Varchar vs Text
09:31 14. INSERT New Data
10:28 15. Read or SELECT Data
10:57 16. LIMIT & ORDER
11:23 17. Filtering with WHERE
11:50 18. LIKE pattern matching
12:19 19. INDEX for read speed
12:56 20. JOIN a relationship
15:41 21. Alias AS
16:08 22. JOIN through a middle man
16:58 23. DROP a video
Install the quiz app 🤓
iOS https://itunes.apple.com/us/ap....p/fireship/id1462592
Android https://play.google.com/store/....apps/details?id=io.f
Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
My VS Code Theme
- Atom One Dark
- vscode-icons
- Fira Code Font
🔥🔥🔥Intellipaat SQL training: https://intellipaat.com/micros....oft-sql-server-certi
🔥🔥🔥Intellipaat MySQL training: https://intellipaat.com/php-mysql-training/
🡆In this video on SQL vs MySQL you will understand about the difference between these two and which one should you use for better performance. So in this MySQL vs SQL comparison some important parameters have been taken into consideration to tell you the difference between SQL and MySQL & also which one is preferred over the other in certain aspects in detail.
#SQLvsMySQL #MySQLvsSQL #DifferencebetweenSQLandMySQL #Intellipaat
📌 Do subscribe to Intellipaat channel & get regular updates on videos: https://goo.gl/hhsGWb
📕Read complete SQL tutorial here: https://intellipaat.com/blog/t....utorial/sql-tutorial
📔 Get SQL Server cheat sheet here: http://bit.ly/2KljiiP
📰 Interested to learn SQL still more? Please check similar SQL blogs here:- https://goo.gl/d3a6H2
Are you looking for something more? Enroll in our MS SQL Server course and become a certified SQL professional (https://intellipaat.com/micros....oft-sql-server-certi). It is a 16 hrs training where you can learn SQL through instructor led training provided by Intellipaat which is completely aligned with industry standards and certification bodies.
If you’ve enjoyed this sql vs MySQL video, Like us and Subscribe to our channel for more similar informative video.
Got any questions about sql vs MySQL when to use? Ask us in the comment section below.
----------------------------
Intellipaat Edge
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. Job Assistance
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
⭐Why should you opt for a SQL career?
SQL optimization has always been a popular topic in database management. SQL Database optimization can be an extremely difficult task, in particular for large-scale data wherever a minute variation can result or impact drastically on the performance. So learning this skill will definitely help you grab the best jobs in top MNCs after finishing Intellipaat SQL online training. The entire Intellipaat SQL course is in line with the industry needs.There is a huge demand for SQL certified professional. The salaries for SQL professional are very good.
⭐Why should you opt for a MySQL career?
MySQL can do much of the workhorse kind of stuff you see in databases like Oracle or SQL Server, but sometimes it achieves those goals in very different ways. For instance there are many open-source projects that support and surround the database, such as mysqltuner an analysis script, innotop a unix top-like utility for monitoring on-going activity in the database, and maatkit a whole suite of tools that build on and expand the features already present in the MySQL database.
------------------------------
For more information:
Please write us to sales@intellipaat.com or call us at: +91-7847955955
Website: https://intellipaat.com/micros....oft-sql-server-certi
Website: https://intellipaat.com/mongodb-training/
Facebook: https://www.facebook.com/intellipaatonline
Telegram: https://t.me/s/Learn_with_Intellipaat
Instagram: https://www.instagram.com/intellipaat
LinkedIn: https://www.linkedin.com/in/intellipaat/
Twitter: https://twitter.com/Intellipaat
sql tutorial for beginners full from Basic to Advance level in 4 hours in PHP admin.
SQL is a standard query language for storing, manipulating and retrieving data in databases. Our tutorial will teach you how to use SQL in MySQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.
SQL tutorial Timestamps
0:00 Introduction to Databases
7:32 SQL Server
12:04 Creating a Database
21:40 SHOW and SELECT
28:19 Rules for SQL Statements
32:30 Getting Multiple Columns
37:41 Distinct and LIMIT
43:29 Sorting Results
50:25 Sort Direction
54:42 Data Filtering and WHERE
59:38 Advanced Filtering Using AND and OR
1:06:33 IN ,NOT IN
1:12:52 Search Engines Work
1:19:19 More on Wildcards
1:22:33 Regular Expressions
1:30:05 Custom Columns
1:38:49 Functions
1:45:02 Aggregate Functions
1:52:59 GROUP BY
2:00:19 Subqueries (watch this https://youtu.be/iq52vhD45A4 )
2:06:28 Another Subquery Example
2:13:37 Join Tables
2:22:05 Outer Joins
2:30:12 UNION
2:35:34 Text Searching
2:42:39 INSERT INTO
2:50:45 Insert Multiple Rows
2:59:26 UPDATE & DELETE
3:07:13 CREATE TABLE
3:14:19 NOT NULL & AUTO INCREMENT
3:21:25 ALTER / DROP / RENAME TABLE
3:27:30 Views
3:36:38 General Tips
SQL Beginners. SQL tutorial advanced
#SQL #SQLTutorial
This course is for absolute beginners and will give you a great kickstart to learning PHP.
We'll first talk about what PHP is and why we should learn it, then we will setup a working environment and start coding
This video covers all the basics:
- How to declare Variables
- How to work with strings, Arrays
- How to work with file System
- How to use cURL to fetch resources
- Object Oriented PHP
- Namespaces
- Composer
- Autoloading
and much more...
At the end of this course we will create a CRUD (CREATE, READ, UPDATE, DELETE) application 3 times. First, we will create it as beginner and see what PHP code looks like without best practices, then we will refactor our application and make it more optimal. We will learn how to use composer, autoloading and we'll create a mini MVC framework with custom routing and then build the final version of our CRUD application using the framework
Code:
Initial Source files: https://bit.ly/3jmfETf
Final Source files: https://bit.ly/3dS9BEx
The Codeholic YouTube Channel:
https://www.youtube.com/channe....l/UC_UMEcP_kF0z4E6Kb
Official Docs:
Numbers - https://bit.ly/2IMwiih
Strings - https://bit.ly/2T3Prht
Arrays - https://bit.ly/2H5NU8i
File System - https://bit.ly/3jcjHkE
Timestamps:
00:00:00 - Introduction
00:02:45 - Course Overview
00:06:19 - What is PHP and why you should learn it?
00:09:02 - Setup working environment
00:22:45 - PHP Syntax
00:25:50 - Comments
00:26:58 - Variables
00:35:45 - Numbers
00:47:53 - Strings
01:01:07 - Arrays
01:14:09 - Associative Arrays
01:21:44 - Conditionals (If-else, switch)
01:30:59 - Loops
01:38:22 - Functions
01:45:43 - Dates
01:50:36 - Including files
01:58:43 - Working with File System
02:08:01 - OOP
02:25:46 - cURL
02:33:53 - Start working on Products CRUD (bad version)
02:42:05 - Setup connection to database
02:45:36 - Select & display products from MySql
02:52:28 - Products CRUD: Creating Product functionality
02:56:50 - $_GET & $_POST
03:04:04 - Save data in MySql
03:13:45 - Form Validation
03:21:10 - Uploading Image
03:39:37 - Delete Product
03:46:01 - Update Product
03:58:22 - Product Search
04:02:24 - Improve Products CRUD: Code refactoring
04:38:30 - Namespaces & Autoloading with composer
04:49:10 - Install packages using composer
04:53:10 - MVC Framework with Custom Routing
04:56:15 - MVC Controllers
05:13:10 - MVC Views
05:31:25 - MVC Models
06:02:13 - Setup Apache Virtual Hosts
06:11:07 - Sessions
06:20:55 - Cookies
Learn the PHP programming language in this full course / tutorial. The course is designed for new programmers, and will introduce common programming topics using the PHP language.
⭐️Course Contents ⭐️
⌨️ 1. (0:00) Introduction
⌨️ 2. (1:56) Windows Installation
⌨️ 3. (7:32) Choosing a Text Editor
⌨️ 4. (11:06) Hello World & Setup
⌨️ 5. (20:29) Writing HTML
⌨️ 6. (27:30) Variables
⌨️ 7. (38:09) Data Types
⌨️ 8. (44:27) Working With Strings
⌨️ 9. (54:50) Working With Numbers
⌨️ 10. (1:05:14) Getting User Input
⌨️ 11. (1:15:37) Building a Basic Calculator
⌨️ 12. (1:22:13) Building a Mad Libs Game
⌨️ 13. (1:28:59) URL Parameters
⌨️ 14. (1:35:52) POST vs GET
⌨️ 15. (1:41:44) Arrays
⌨️ 16. (1:50:26) Using Checkboxes
⌨️ 17. (1:57:22) Associative Arrays
⌨️ 18. (2:04:55) Functions
⌨️ 19. (2:12:10) Return Statements
⌨️ 20. (2:19:10) If Statements
⌨️ 21. (2:37:16) If Statements (con't)
⌨️ 22. (2:47:13) Building a Better Calculator
⌨️ 23. (2:56:53) Switch Statements
⌨️ 24. (3:05:09) While Loops
⌨️ 25. (3:15:18) For Loops
⌨️ 26. (3:26:24) Comments
⌨️ 27. (3:31:08) Including HTML
⌨️ 28. (3:36:51) Include: PHP
⌨️ 29. (3:45:57) Classes & Objects
⌨️ 30. (3:56:23) Constructors
⌨️ 31. (4:06:18) Object Functions - PHP - Tutorial 31
⌨️ 32. (4:13:52) Getters & Setters
⌨️ 33. (4:29:17) Inheritance
Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channe....l/UCvmINlrza7JHB1zkI
🐦Follow Mike on Twitter: https://twitter.com/GiraffeAcademy
🔗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
Login System Using PHP & SQL Database
In this tutorial we learn about php and mysql database login system. in this tutorial i have use latest sql and php.
i am using MYSQL SERVER 2014 And PHP 7. This video is for beginners so in this tutorial i do not use any exception handling in that so if you are beginner then this is best video for you.
so if you have any question regarding to my video so please comment me on my video and like this video if you find it is helpful to you.
css File :
https://ufile.io/l8690
In this channel we are learning about some programming tutorial and some problem solving video and mach more...!
so if you have any question or any opinion please comment on my video and share this video to you friends.
Also subscribe to the channel ...!
Suggested video :
How to Install Photoshop Color Efex Pro 4 Crack in Hindi
https://youtu.be/up74-kMPmOQ
Promote another Youtube Channel Video and Increase Views 100% Guarantee
https://youtu.be/VMmHKvbTUn4
How to Make Bootable Pd for Windows
https://youtu.be/_gfsXFrMkRU
How to Calculate Adsense Earning...!
https://youtu.be/aubc5XgMY98
Asp.net Login Page Design using Bootstrap
https://youtu.be/-P90tOJYf9o
ApkPure Alternative of Play store
https://youtu.be/NLThn2yWdq4
Grabpoint earn free money 100%
https://youtu.be/fZAaKwWeyxg
Asp.net Project With C#
https://youtu.be/1xVs3QkE9UU
Redgear gamepad review
https://youtu.be/Rln1YZ7xM14
Sleeping Parrott
https://youtu.be/XB7Hr7nr7gI
Run Project Visual Studio Asp.net
https://youtu.be/lvfXqqpl_Hw
Add Existing Files into .NET
https://youtu.be/wKxDwE_2_ZU
Add Refference In Visual Studio
https://youtu.be/Cwn6nrGujjI
Working Java Class In Asp.net 100%
https://youtu.be/eNG-Md1mle8
Learn the fundamentals of Structured Query Language SQL! Even though it's over 40 years old, the world's most popular databases still run on SQL.
Foreign key basics https://docs.microsoft.com/en-....us/sql/relational-da
#dev #database #100SecondsOfCode
Draw SQL Diagrams https://drawsql.app/
Install the quiz app 🤓
iOS https://itunes.apple.com/us/ap....p/fireship/id1462592
Android https://play.google.com/store/....apps/details?id=io.f
Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
My VS Code Theme
- Atom One Dark
- vscode-icons
- Fira Code Font
( PHP & MySQL with MVC Frameworks Certification Training
- https://www.edureka.co/php-mysql-self-paced )
Watch Sample Class recording: http://www.edureka.co/php-mysql?utm_source=youtube&utm_medium=referral&utm_campaign=data-manipulation-php
A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for selecting, inserting, deleting and updating
data in a database. Performing read-only queries of data is sometimes also considered a component of DML.Let's see some data manipulation in MySQL.
This video helps you to learn following topics :
1.Insert query with Example
2.Inserting Dat afrom commnad prompt
3.Inserting Data using Script
4.Creating a form
5.Inserting data in MySQL table
6.Select Query
7.Syntax for select query
8.Fetching data using PHP script
9.Releasing Memeory
10.WHERE Clause
11.WHERE Clause operators
12.Update Query
13.Delete Query
Related Posts :
http://www.edureka.co/blog/php-tutorial-web-concepts-in-php?utm_source=youtube&utm_medium=referral&utm_campaign=data-manipulation-php
http://www.edureka.co/blog/php-tutorial-data-types-declaration?utm_source=youtube&utm_medium=referral&utm_campaign=data-manipulation-php
http://www.edureka.co/blog/php-tutorial-differentiating-php-code-in-html-script?utm_source=youtube&utm_medium=referral&utm_campaign=data-manipulation-php
Edureka is a New Age e-learning platform that provides Instructor-Led Live, Online classes for learners who would
prefer a hassle free and self paced learning environment, accessible from any part of the world.
The topics related to Data Manipulation have extensively been covered in our course 'PHP & MySQL’.
For more information, please write back to us at sales@edureka.co
Call us at US: 1800 275 9730 (toll free) or India: +91-8880862004
PHP Hypertext Preprocessor is a scripting language for building dynamic websites on the server. It remains one of the most popular programming languages in the world, powering tools like Wordpress, Laravel, and Symfony. https://fireship.io
#programming #webdev #100SecondsOfCode
🔗 Resources
PHP Docs https://www.php.net/docs.php
PHP usage stats https://w3techs.com/technologies/details/pl-php
📚 Chapters
🔥 Get More Content - Upgrade to PRO
Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
🎨 My Editor Settings
- Atom One Dark
- vscode-icons
- Fira Code Font
🔖 Topics Covered
- History of PHP
- PHP syntax and features
- Basic Overview of PHP
- What does PHP stand for?
- Does Facebook use PHP?
- Websites that use PHP
Hey gang, in this first PHP tutorial (with MySQL) I'll explain exactly why I'm creating this series as well as what you'll be making / learning as we progress. PHP is a server-side scripting language which can be used to create dynamic websites and is used all over the web today.
----------------------------------------
🐱💻 🐱💻 Course Links:
+ Course files - https://github.com/iamshaunjp/php-mysql-tutorial
+ VS Code editor - https://code.visualstudio.com/
+ Materialize Playlist - https://www.youtube.com/watch?v=gCZ3y6mQpW0&list=PL4cUxeGkcC9gGrbtvASEZSlFEYBnPkmff
🤑🤑 Donate
+ https://www.paypal.me/thenetninja
🎓🎓 Find me on Udemy
+ https://www.udemy.com/user/47f....d83f6-5e4a-4e87-a0f0
Your first step in learning PHP. We will go over all of the fundamentals and create a small PHP/MySQL project.
⭐ Sponsor:
https://linode.com/traversy
💻 Github Repo:
https://github.com/bradtraversy/php-crash
💻 Download Xampp:
https://apachefriends.com
👇 PHP OOP MVC Udemy Course:
https://www.udemy.com/course/o....bject-oriented-php-m
💖 Show Support
Patreon: https://www.patreon.com/traversymedia
PayPal: https://paypal.me/traversymedia
👇 Follow Me On Social Media:
Twitter: https://twitter.com/traversymedia
Instagram: https://www.instagram.com/traversymedia
Linkedin: https://www.linkedin.com/in/bradtraversy
Timestamps:
0:00 - Intro
0:59 - Linode Sponsor
1:40 - Slides
9:47 - Getting Setup With XAMPP
14:30 - Opening a PHP File
15:38 - VS Code Setup & Auto Reload
18:20 - Output Constructs & Functions
26:35 - Data Types & Variables
34:32 - Arrays
42:05 - Conditionals
52:57 - Loops
1:02:00 - Functions
1:09:47 - Array Functions
1:24:15 - String Functions
1:30:28 - Superglobals
1:34:05 - $_GET & $_POST
1:40:56 - Sanitizing Inputs
1:45:24 - Cookies
1:49:10 - Sessions
1:58:45 - File Handling
2:03:48 - File Uploading
2:17:20 - Erros & Exceptions
2:22:05 - OOP & Classes
2:35:14 - Feedback App Project
2:38:15 - Including PHP Pages
2:42:23 - Database & Feedback Table Setup
2:48:45 - Connecting To MySQL
2:53:54 - If & Foreach Shorthands
2:58:11 - Fetch From Database
3:01:05 - Inserting Data From a Form
This beginner's course is a complete introduction to web application development. Learn how to build dynamic database-backed web sites. Dr. Chuck will teach you how to use HTML, CSS, JavaScript, PHP, MySQL, jQuery, and Handlebars to build web and database applications.
🔗 Couse website: https://www.wa4e.com/
✏️ Dr. Charles Severance created this course. He is a professor at the University of Michigan and is one of the most popular Python instructors in the world.
⭐️ Course Contents ⭐️
⌨️ (00:00:00) Web Applications and the Request/Response Cycle
⌨️ (00:16:56) Understanding Browser Developer Mode
⌨️ (00:25:42) HTML - HyperText Markup Language (Part 1)
⌨️ (00:31:37) HTML - HyperText Markup Language (Part 2)
⌨️ (00:45:32) Code Walkthrough: HTML
⌨️ (00:59:32) CSS - Cascading Style Sheets (Part 1)
⌨️ (01:12:35) CSS - Cascading Style Sheets (Part 2)
⌨️ (01:27:40) CSS - Cascading Style Sheets (Part 3)
⌨️ (01:41:21) Code Walkthrough: CSS - Part 1
⌨️ (01:54:49) Code Walkthrough: CSS Part 2
⌨️ (02:20:40) Installing MAMP on Macintosh for PHP/MySql
⌨️ (02:27:42) Installing MAMP on Windows-10 for PHP/MySql
⌨️ (02:42:15) Installing XAMPP on Windows for PHP/MySql
⌨️ (02:51:21) PHP Language - Overview (Part 1)
⌨️ (03:00:02) PHP Language - Expressions (Part 3)
⌨️ (03:08:51) PHP Language - Variables and Constants (Part 2)
⌨️ (03:27:46) PHP Language - Control Structures (Part 4)
⌨️ (03:41:09) PHP Arrays (Part 1)
⌨️ (03:51:32) PHP Arrays (Part 2)
⌨️ (04:02:45) PHP Functions (Part 1)
⌨️ (04:12:49) PHP Functions (Part 2)
⌨️ (04:26:06) PHP Forms (Part 1)
⌨️ (04:31:04) PHP Forms - GET and POST (Part 2)
⌨️ (04:36:19) PHP Forms - Input Types (Part 3)
⌨️ (04:50:09) PHP Forms - HTML Injection and Validation (Part 4)
⌨️ (05:01:01) PHP Forms - MVC (Part 5)
⌨️ (05:11:40) Code Walkthrough: Forms Part 1
⌨️ (05:25:00) Code Walkthrough: Forms Part 2
⌨️ (05:32:28) Code Walkthrough: Forms Part 3
⌨️ (05:39:28) Single Table SQL - Part 1
⌨️ (06:01:59) Single Table SQL - Part 2
⌨️ (06:23:26) Data Modeling - Building a Data Model (Part 1)
⌨️ (06:32:12) Data Modeling - Representing Relationships (Part 2)
⌨️ (06:42:52) Data Modeling - Relationships in SQL (Part 3)
⌨️ (06:57:09) Data Modeling - Using Join (Part 4)
⌨️ (07:07:16) Data Modeling - Many-to-Many (Part 5)
⌨️ (07:20:51) PHP Objects (Part 1)
⌨️ (07:31:23) PHP Objects - Building Objects (Part 2)
⌨️ (07:43:20) PHP Objects - Life Cycle (Part 3)
⌨️ (07:48:54) PHP Objects - Inheritance (Part 4)
⌨️ (07:59:57) PHP, MySQL, and PDO - Part 1
⌨️ (08:18:16) PHP, MySQL, and PDO - Part 2
⌨️ (08:32:05) PHP, MySQL, and PDO - Part 3
⌨️ (08:44:30) PHP, MySQL, and PDO - Part 4
⌨️ (08:53:30) Code Walkthrough: PHP, MySQL, and PDO - Part 1
⌨️ (09:02:15) Code Walkthrough: PHP, MySQL, and PDO - Part 2
⌨️ (09:11:51) Code Walkthrough: PHP, MySQL, and PDO - Part 3
⌨️ (09:19:53) PHP - Cookies (Part 1)
⌨️ (09:29:53) PHP - Sessions (Part 2)
⌨️ (09:43:59) PHP - Sessions without Cookies - Part 3
⌨️ (09:51:42) Code Walkthrough: Cookies and Sessions
⌨️ (10:02:08) PHP - HTTP Redirects - Part 1
⌨️ (10:09:07) PHP - Post / Redirect - Part 2
⌨️ (10:20:03) PHP - Flash Messages / Authentication - Part 3
⌨️ (10:32:15) Code Walkthrough: Routing and Redirect - Part 1
⌨️ (10:37:33) Code Walkthrough: Routing and Redirect - Part 2
⌨️ (10:44:31) Code Walkthrough: Routing and Redirect - Part 3
⌨️ (10:51:02) Building a CRUD Application in PHP
⌨️ (11:05:35) Code Walkthrough: Forms and CRUD
⌨️ (11:20:08) JavaScript - Part 1
⌨️ (11:35:18) JavaScript - Part 2
⌨️ (11:47:40) JavaScript - Document Object Model - Part 3
⌨️ (11:58:20) Code Walkthrough: JavaScript and Profiles
⌨️ (12:08:37) JavaScript - Object Orientation
⌨️ (12:19:18) JQuery - Part 1
⌨️ (12:32:22) JQuery - Part 2
⌨️ (12:46:53) Code Walkthrough: Profiles, Positions, and JQuery
⌨️ (13:12:10) JSON - JavaScript Object Notation - Part 1
⌨️ (13:26:50) JSON - JavaScript Object Notation - Part 2
⌨️ (13:38:26) JSON - CRUD - Part 3
⌨️ (13:48:00) Code Walkthrough: Profiles, Positions, Education and JSON
⌨️ (14:22:16) MOOC Graduation Video with Curt Bonk as Commencement Speaker
🎉 Thanks to our Champion and Sponsor supporters:
👾 Wong Voon jinq
👾 hexploitation
👾 Katia Moran
👾 BlckPhantom
👾 Nick Raker
👾 Otis Morgan
👾 DeezMaster
👾 AppWrite
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
►Source Code + Text Tutorials - http://codewithharry.com/video....s/php-tutorials-in-h
►This video is a part of this PHP tutorials in Hindi playlist - https://www.youtube.com/playli....st?list=PLu0W_9lII9a
►For Doubt Solving, Brain Storming Sessions & guaranteed replies, join the channel membership here: https://www.youtube.com/channe....l/UCeVMnSShP_Iviwkkn
►Click here to subscribe - https://www.youtube.com/channe....l/UCeVMnSShP_Iviwkkn
►Checkout my English channel here: https://www.youtube.com/ProgrammingWithHarry
Best Hindi Videos For Learning Programming:
►Learn Python In One Video - https://www.youtube.com/watch?v=ihk_Xglr164
►Python Complete Course In Hindi - https://www.youtube.com/playli....st?list=PLu0W_9lII9a
►C Language Complete Course In Hindi -
https://www.youtube.com/playlist?list=PLu0W_9lII9aiXlHcLx-mDH1Qul38wD3aR&disable_polymer=true
►JavaScript Complete Course In Hindi -
https://www.youtube.com/playli....st?list=PLu0W_9lII9a
►Learn JavaScript in One Video - https://www.youtube.com/watch?v=onbBV0uFVpo
►Learn PHP In One Video - https://www.youtube.com/watch?v=xW7ro3lwaCI
►Django Complete Course In Hindi -
https://www.youtube.com/playli....st?list=PLu0W_9lII9a
►Machine Learning Using Python - https://www.youtube.com/playli....st?list=PLu0W_9lII9a
►Creating & Hosting A Website (Tech Blog) Using Python - https://www.youtube.com/playli....st?list=PLu0W_9lII9a
►Advanced Python Tutorials - https://www.youtube.com/playli....st?list=PLu0W_9lII9a
►Object Oriented Programming In Python - https://www.youtube.com/playli....st?list=PLu0W_9lII9a
►Python Data Science and Big Data Tutorials - https://www.youtube.com/playli....st?list=PLu0W_9lII9a
Follow Me On Social Media
►Website (created using Flask) - http://www.codewithharry.com
►Facebook - https://www.facebook.com/CodeWithHarry
►Instagram - https://www.instagram.com/codewithharry/
►Personal Facebook A/c - https://www.facebook.com/geekyharis
Twitter - https://twitter.com/Haris_Is_Here
How to download and install Microsoft SQL Server 2019
https://www.youtube.com/watch?v=A9daWBSyMak
How to Connect PHP to Microsoft SQL Server 2019
https://www.youtube.com/watch?v=VQBPzyp2NE4
Insert Form Data Into Microsoft SQL Server 2019 Database Using PHP
https://www.youtube.com/watch?v=DW-tayBmiis
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.
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/creat
⭐️ 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/channe....l/UCvmINlrza7JHB1zkI
🐦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