Learn SQL, PHP-PDO, JavaScript and Bootstrap for web apps
4.3 (32 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
724 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL, PHP-PDO, JavaScript and Bootstrap for web apps to your Wishlist.

Add to Wishlist

Learn SQL, PHP-PDO, JavaScript and Bootstrap for web apps

Course to master SQL, JavaScript, twitter bootstrap and PHP to create powerful web applications. Better than on youtube
4.3 (32 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
724 students enrolled
Created by Eng Ali Mehdy
Last updated 1/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 24 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
Have a coupon?
What Will I Learn?
Design advanced and complicated databases
Create advanced SQL queries and Views
Create advanced SQL Procedures and Functions
Create and design powerful and secure Web applications using PHP and SQL
Create PHP Data Object (PDO) codes to make web apps more secure
Master SQL Language
View Curriculum
Requirements
  • You will need to download MySQL server and MySQL workbench (links available in course)
  • You will need to download wamp server (Link available in course)
Description


This course can be taken by students who are interested in learning advanced SQL scripting, and learn basics of PHP to create a secure, anti-injections and powerful web applications.

At the end of this course, you will be able to create strong databases with foreign keys implemented, then writing SQL queries, Views, Procedures and Functions to facilitate your work, managing and contacting your main database server.

By subscribing to this course, you will be able to create advanced PHP web applications using PHP data object (PDO), to create a secure, non-vulnerable codes, and powerful PHP based web applications, where SQL Injections are 99% eliminated.

Who is the target audience?
  • No programming skills required
  • This course is meant for newbies in SQL
  • This course is for beginners who wants to create powerful web applications
  • This course is for newbies in PHP programming
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 96 Lectures Collapse All 96 Lectures 07:38:09
+
Software Installations
4 Lectures 05:03

In this lecture, we will talk about what we are going to learn with this course.

Preview 01:49

In this lecture, we will download and install MySQL Server and MySQL workbench, and take a simple and fast introduction about them.

Installing MySQL server And Workbench
02:12

In this lecture, we will download and install local servers (wampserver for windows and mamp server for mac).

Installing local server
01:02

In this file, we have links for all our software to download and install.

Links
1 page
+
SQL Basics
20 Lectures 01:10:35

In this lecture, we will learn the definition of databases, with examples.

What are databases?
04:03

In this lecture we will take the definition of tables and relationships between them, with examples.

Tables and Relationships
03:55

In this lecture we will learn how to add databases and tables using SQL queries and scripts.

Creating databases and tables by queries
08:16

In this lecture we are going to create databases, tables, primary keys and foreign keys using graphical interface of MySQL workbench.

Preview 06:30

In this lecture, we will add data to tables using the Insert query.

Insert query
02:54

In this lecture, we are going to use select query to select all, some columns or rows from a table.

Select query
06:00

In this lecture, we are going to learn about Update query syntax.

Update query
01:41

In this lecture, we are going to learn about delete query.

Delete query
01:40

In this lecture we are going to learn how to:

  1. Add a column;
  2. Modify a column name or datatype;
  3. Drop a column.
Alter Table
03:40

In this lecture we are going to learn about join types with their specific queries

Joins - Part 1
04:54

In this lecture, we are going to learn about LEFT Join query.

Joins - Part 2
02:08

In this lecture, we are going to learn how to write a multiple join query.

Multiple Joins
06:32

In this lecture, we are going to learn about cross joins.

Cross Joins
02:00

In this lecture, we will see why we use sometimes, cross joins.

Why we use cross joins
01:33

in this lecture, we are going to learn about some SQL pre-made functions.

Averages, Sums, and Counting
04:42

In this lecture, we are going to learn the SQL union all query.

SQL Union All
02:37

In this lecture, we are going to learn about SQL subqueries.

SQL Subqueries
02:54

In this lecture, we are going to learn how to search inside character values inside database.

SQL Like
02:28

In this lecture, we are going to learn the SQL between query.

SQL Between
02:08

This is a resume about section 2 of this course.

Resume
24 pages
+
SQL Views
3 Lectures 13:18

In this lecture, we are going to take small introduction about views.

What are views
04:23

In this lecture, we are going to make our first view.

Views Syntax
03:16

In this lecture, we are going to learn how to create views, with sub queries.

Views with subquery
05:39
+
SQL Procedures and Cursors
7 Lectures 38:54

In this lecture, we are going to take an introduction about SQL Procedures.

Procedures
02:56

In this lecture, we are going to make an example about procedures but without parameters.

Procedure with no parameters
05:41

In this lecture, we are going to make an example about procedures with parameters.

Procedure with parameters
10:34

SQL Cursors slides.

SQL Cursors slides
8 pages

In this lecture, we are going to learn about SQL Cursors.

SQL Cursors
05:28

In this lecture, we are going to write an SQL script with cursors.

Cursor example
09:30

In this lecture, we are going to change the script, so instead of cursors, we will uses Case statements.

Cases
04:45
+
Functions
5 Lectures 25:01

In this lecture, we will take an introduction about functions.

Functions
01:55

In this lecture, we will write a function with no parameters.

Functions with no parameters
04:10

In this lecture, we will write a function with parameters.

Functions with parameters
03:18

In this lecture, we are going to learn some of the pre-made date and time functions in MySQL.

Date and Time functions
05:28

In this lecture, we are going to learn how to write trigger codes.

Triggers
10:10
+
MySQL Project Exercises
11 Lectures 39:04

In this lecture, you are going to learn how to grant some privileges, to your users.

Users and Privileges
03:57

In this lecture, you are going to learn, how to export and import SQL in MySQL.

Export and Import Databases
03:02

In this lecture, we will be introduced to our database where we are going to create views and procedures.

Introduction to our exercise database
04:25

This file contains views and procedures exercises.

Exercises
2 pages

This lecture is about resolving exercise 1.

Preview 09:10

This lecture is about resolving exercise 2.

Exercise 2 - Fields
03:26

This file contains solutions of all view exercises.

Solutions of View questions
3 pages

In this lecture, we are going to make a procedure that counts number of goals in each half.

Exercise 8 - Goals in each half
07:44

In this lecture, we are going to make a procedure that calculates the number of goals at a specific time.

Exercise 9 - Goals at a given time
04:18

In this lecture, we are going to make a function exercise.

Exercise about functions
03:02

In this file, you will find the solution of all procedures and functions.

Solution of Procedures and Functions
3 pages
+
PHP - No programming skills required
19 Lectures 02:02:54

In this lecture, we will be introduced to some PHP editors to work with, during our web developing.

PHP Editors
02:41

In this lecture, we are going to create our web application working folder.

Web applications working folder
04:51

In this lecture, we will see how to work with variables, and echo them in our web application.

Variables and Echo
04:01

In this lecture, we will see how to create web forms.

Web Forms
10:45

In this lecture, we will see how to POST variables from web forms into our code.

POST
06:22

In this lecture, we are going to learn about PHP operators like AND, OR and the empty function.

AND, OR and empty
05:31

In this lecture, we are going to learn what are sessions.

Sessions
01:09

In this lecture, we are going to learn about SQL injections with a fast and easy example.

SQL Injections Example
01:23

In this lecture, we are going to connect php file into our database.

Connection
08:26

In this lecture, we are going to take username and password, and see if they're true, to redirect to a new page.

Login
10:13

In this lecture, we are going to see how to make a connection file and call it in all our pages, instead of writing it every time.

Require once function
07:31

In this lecture, we are going to learn how to make a logout page with PHP codes.

Logout
04:37

Before we continue, we should learn about HTML tables, so we can use them in displaying some data in our web pages.

HTML Tables
07:06

In this lecture, we are going to learn how to display MySQL data into our web page.

Select data from database into html tables
09:29

In this lecture, we are going to learn how to request variables from URL.

Request Variables from URL
05:27

Instead of sending variables throughout URL, and request them, we can send those variable through a hidden input.

Hidden input and Form managing
09:20

In this lecture, we are going to add data to database through our html table.

Insert using web page table
09:10

In this lecture, we are going to update some rows, using html table.

Update a row of a table
08:40

In this lecture, we are going to add a delete button, so we can delete data from our table.

Delete a row of a table
06:12
+
JavaScript and jQuery
26 Lectures 01:38:20

In this lecture we are going to take an introduction about JavaScript and why we use it in web developing.

What is JavaScript ?
04:51

PDF file.

What is JavaScript ?
3 pages

In this lecture we are going to learn how start typing JavaScript and see the different types of variable.

Script and Variables
02:34

Instead of using PHP to see if a text box is empty or not, we can do that on client-side using JS.

Input Validation
11:27

In this lecture, we are going to change colors of input, and set a character condition.

Colors And Characters
03:08

In this section, we are going to type our first OnMouseOver and OnMouseOut functions.

OnMouseOver and OnMouseOut
03:07

In this lecture, we are going to learn how to increment and decrement a variable.

Increment and decrement
01:47

In this lecture, we are going to learn how to acces a div using innerHTML.

Accesing a div element using innerHTML
02:57

In this lecture, we are going to learn about arrays and how to work with in JS.

Arrays
03:07

in JS, we have many type of loops. Do While, While, and For loops.

Loops
04:35

In this lecture, we are going to work with OnClick, and how we can go to another page using JS.

OnClick and changing location
05:52

In this lecture, we are going to learn some date and time methods.

date and Time methods
04:14

In this lecture, we are going to learn some string methods using JS.

String Method
02:48

In this lecture, we are going to learn basic math and numbers methods.

Math and Numbers
02:25

In this lecture, we are going to learn how to include JS files in our pages.

Include JavaScript files
02:19

In this lecture, we are going to learn how to append elements.

Append ELements
02:51

From now on, we are going to learn some jQuery codes. And this lecture, is an introduction about it.

jQuery - Introduction
02:44

In this lecture, we are going to learn about jQuery events.

jQuery - Events
06:05

In this lecture, we are going to learn some new events to use.

jQuery - Other events
01:20

In this lecture, we are going to learn how to show an element.

jQuery - show()
01:02

In this lecture, we are going to learn how to animate an element using fadeIn().

jQuery - fadeIn()
01:58

In this lecture, we are going to learn how to set and get contents from html elements.

jQuery set and get contents
07:28

In this lecture, we are going to learn how to add elements using jQuery.

jQuery Add (append, prepend, after, before)
07:06

In this lecture, we are going to learn how to remove elements, or make them empty.

jQuery remove and empty
03:41

In this lecture, we are going to learn some jQuery animation coding.

jQuery Animation
02:58

In this lecture, we are going to learn how to make a print button using JavaScript and jQuery.

jQuery exercise - Print an element
05:56
+
Bonus: Introduction to Bootstrap
1 Lecture 00:00
More lectures to come in couple of days
1 page
About the Instructor
Eng Ali Mehdy
4.0 Average rating
117 Reviews
2,592 Students
5 Courses
Electrical and Telecommunications Engineer

I am an Electrical, Telecommunications and IT engineer graduate with a Master degree since 2013, with experience in designing software and web apps for telecommunication purposes, designing household electrical schematics and designing electrical panels. I have an advanced experience programming industrial microprocessors PLC. And now I am an Udemy Premium Instructor.