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.2 (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.
722 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 96
  • Length 7.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

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.

What are the 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)

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Software Installations
01:49

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

02:12

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

01:02

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

1 page

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

Section 2: SQL Basics
04:03

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

03:55

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

08:16

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

06:30

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

02:54

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

06:00

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

01:41

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

01:40

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

03: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.
04:54

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

02:08

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

06:32

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

02:00

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

01:33

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

04:42

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

02:37

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

02:54

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

02:28

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

02:08

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

24 pages

This is a resume about section 2 of this course.

Section 3: SQL Views
04:23

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

03:16

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

05:39

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

Section 4: SQL Procedures and Cursors
02:56

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

05:41

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

10:34

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

8 pages

SQL Cursors slides.

05:28

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

09:30

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

04:45

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

Section 5: Functions
01:55

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

04:10

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

03:18

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

05:28

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

10:10

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

Section 6: MySQL Project Exercises
03:57

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

03:02

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

04:25

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

2 pages

This file contains views and procedures exercises.

09:10

This lecture is about resolving exercise 1.

03:26

This lecture is about resolving exercise 2.

3 pages

This file contains solutions of all view exercises.

07:44

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

04:18

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

03:02

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

3 pages

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

Section 7: PHP - No programming skills required
02:41

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

04:51

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

04:01

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

10:45

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

06:22

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

05:31

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

01:09

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

01:23

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

08:26

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

10:13

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

07:31

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.

04:37

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

07:06

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

09:29

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

05:27

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

09:20

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

09:10

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

08:40

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

06:12

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

Section 8: JavaScript and jQuery
04:51

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

3 pages

PDF file.

02:34

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

11:27

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

03:08

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

03:07

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

01:47

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

02:57

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

03:07

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

04:35

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

05:52

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

04:14

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

02:48

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

02:25

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

02:19

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

02:51

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

02:44

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

06:05

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

01:20

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

01:02

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

01:58

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

07:28

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

07:06

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Eng Ali Mehdy, 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.

Ready to start learning?
Take This Course