Top videos | Cash In Vids Make Money From Vids And Vloging CashInVids CashInVids.com

Home
Articles

Top videos

All Time

Today

This week

This month

This year

MySQL Tutorial for Beginners [Full Course] cashinvids 2 Views • 2 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.

PHP For Absolute Beginners | 6.5 Hour Course cashinvids 2 Views • 2 years ago

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

User Registration System Using PHP And MySQL Database | PHP MySQL Tutorial | Edureka cashinvids 2 Views • 2 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).