dynamic web design with php and mysql training video kickass

Learn PHP MySQL and PDO and Build a Complete Project

This course includes:

8 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of completion

What you'll learn

You will be able to understand some backend key terms
You will be able to grasp most common PHP standards code in no time
You will be able to read and write PHP code
You will be able to dive deep into some PHP complex topics easily
Grasp the concept of SQL clauses, functions, data types
Learn CRUD operations and how to use them to make use out of your database
How to write simple to complex SQL queries
Learn PDO from the basics to the advanced concepts
Learn some advanced PDO concepts like transactions
Utilize what you have learned by building an app from the ground up

Requirements

Just PC and active internet connection

Description

Welcome to my full stack PHP, MySQL, and PDO course where you will learn everything you need to know about one of the most three hot technologies right now. This course is organized systematically from the programming language (PHP) to The most well-known database (MySQL) to the best PHP tool to connect to this database which is (PDO) to give the most interesting, fun, informative, and worthy opportunity for learning web development the right way. Throughout the course, you will be introduced to major parts of these tools that should get you your dream web development job by building your CV.

The course also is going to updated constantly in order to bring some more practical knowledge and projects. So what are waiting for? This is the best way to sharpen your skills and be a great developer. The course is also planned and sectioned out really well so if you have some experience with some technology you can move easily to your targeted tool. you can see in the curriculum that I flagged the tools with these—— tech name —— . if you are interested in this course, don't hesitate and just get going with it

I hope to see you inside 🙂

Who this course is for:

Anyone who is interested in learning PHP
Anyone who is interested in learning MySQL
Anyone who is interested in learning PDO

Course content

25 sections • 74 lectures • 7h 54m total length

Introduction1 lecture • 2min

IntroductionPreview01:32

Installation for The Course3 lectures • 13min

NOTE00:05
Installing Xampp09:46
Installing Sublime03:09

———————-PHP Basics————————1 lecture • 7min

Into to The CoursePreview07:20

PHP Basics: Basic Syntax and First Steps7 lectures • 46min

Basic SyntaxPreview12:07
Echo03:56
Print and Differences between Echo and Print08:24
Variables06:35
Constants06:25
Comments04:50
Single vs Double Quotes03:52

PHP Basics: Data Types5 lectures • 13min

Integers04:48
Floats01:21
Booleans01:40
Strings02:43
Nulls02:18

PHP Basics: Operations4 lectures • 20min

Arithmetical Operators04:30
Assignment Operators05:59
Comparison Operators05:46
Increment and Decrement Operators04:03

PHP Basics: Statements2 lectures • 15min

If Elseif Else08:44
Switch06:26

PHP Basics: Loops2 lectures • 15min

While09:09
For06:09

PHP Basics: Arrays3 lectures • 19min

Arrays and Indexed Arrays05:42
Associative Arrays05:50
Multidimensional Arrays07:43

PHP Basics: Functions2 lectures • 13min

Functions07:09
Functions with Arguments05:50

PHP Basics: Super Globals5 lectures • 47min

Intro to Super Globals04:13
Post11:07
Get14:25
Sessions pt. 109:00
Sessions pt. 208:11

PHP Basics: Date and Time2 lectures • 13min

Date03:51
Time09:03

———————-MySQL Basics————————1 lecture • 10min

Intro10:08

MySQL Basics: First Steps7 lectures • 36min

Creating and Dropping Databases07:05
Creating Tables08:29
Dropping Tables02:36
Inserting into Tables04:51
Updating and Deleting06:14
Data Types04:10
Operators02:16

MySQL Basics: Constraints3 lectures • 23min

Primary Keys07:07
Foreign Keys08:23
Functions07:03

MySQL Basics: Clauses3 lectures • 26min

Select and Where11:56
Order by04:28
Group by09:28

MySQL Basics: Alters1 lecture • 3min

Alters02:58

MySQL Basics: Joins3 lectures • 27min

Aliases02:59
Inner Joins11:33
Left and Right Joins12:07

———————-PDO Basics————————1 lecture • 5min

Intro to The Course04:48

PDO: Connecting to The Database2 lectures • 15min

Connecting to DB with PDOPreview07:27
Catching ErrorsPreview07:45

PDO: The Many Ways of Fetching Data with PDO5 lectures • 32min

Getting Data with Query and Fetch pt.106:23
Getting Data with Query and Foreach03:57
Getting Data with Query and Fetch pt.207:25
Getting Data with FetchColumn05:14
Getting Data with FetchAll09:12

PDO: Prepared Statements and Performing Crud Operations2 lectures • 19min

Prepared Statements10:06
Update and Delete09:01

PDO: More Crucial Parts of PHP PDO4 lectures • 26min

Getting RowCount06:20
Getting LastInsertId03:15
Transactions13:20
Closing the Connection02:50

———————-The First Project————————1 lecture • 1min

Intro00:05

First Project: Complete PHP PDO Todolist4 lectures • 30min

Setting Up07:19
Inserting into DB08:04
Pulling the Data08:00
Deleting the Data06:24

🎓 Keep Learning 🎓

How to Enroll ?