Top videos | CashInVids – Watch Videos & Earn Money Online

Home
Articles

Top videos

All Time

Today

This week

This month

This year

MySQL Tutorial for Beginners [Full Course] cashinvids 36 Views • 4 years ago

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.

User Registration System Using PHP And MySQL Database | PHP MySQL Tutorial | Edureka cashinvids 36 Views • 4 years ago

🔥 PHP & MySQL Certification Training (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎"): https://www.edureka.co/search
This Edureka video on "PHP MySQL Tutorial" will teach you how to create a user registration and login system using PHP and a MySQL database. This video covers the following topics:

3:40 Creating the database
5:30 Creating the registration page
11:23 Creating the login page
13:50 Creating backend logic for registration
28:05 Creating the home page
33:10 Creating the error page
36:30 Creating server logic for login

Check out our complete Youtube playlist here: https://goo.gl/gMFLx3

Do subscribe to our channel and hit the bell icon to never miss an update from us in the future: https://goo.gl/6ohpTV

Instagram: https://www.instagram.com/edureka_learning
Facebook: https://www.facebook.com/edurekaIN/
Twitter: https://twitter.com/edurekain
LinkedIn: https://www.linkedin.com/company/edureka

#php #phptutorial #phpmysql #LearnPHP #phponlinetraining

-------------------------------------

How it Works?

1. This is a 7 Week Instructor-led Online Course, 45 hours of assignment and 20 hours of project work

2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.

3. At the end of the training, you will be working on a real-time project for which we will provide you a Grade and a Verifiable Certificate!

-------------------------------------

About the Course

Edureka's PHP & MySQL with MVC framework will introduce attendees to PHP, MySQL, and CakePHP MVC framework. The course will cover aspects of how to use PHP, MySQL along with CakePHP MVC framework to create powerful and easy to maintain database driven websites. The course will also cover Installation & Configuration of PHP, MySQL, and CakePHP. Attendees will also get to implement one project towards the end of the course.

Why learn PHP & MySQL with MVC Frameworks?

PHP scripting and MySQL database are one of the worlds most popular open source techniques used to develop websites. Add an advantage of an MVC framework to it and you can develop powerful, dynamic and easy to maintain database driven websites. PHP, MySQL, and CakePHP are also platform independent i.e. You can easily port a website developed on a windows machine to a Linux based Apache web server with minimal to no changes. The CakePHP MVC architect also adds some additional security against threats like SQL injections, hacking etc.

-------------------------------------

Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.
For more information, please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free).