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

Course Curriculum

Chapter 1: Software Installations

Lecture 1: Introductory Lecture

Lecture 2: Installing MySQL server And Workbench

Lecture 3: Installing local server

Lecture 4: Links

Chapter 2: SQL Basics

Lecture 1: What are databases?

Lecture 2: Tables and Relationships

Lecture 3: Creating databases and tables by queries

Lecture 4: Create databases and tables graphically

Lecture 5: Insert query

Lecture 6: Select query

Lecture 7: Update query

Lecture 8: Delete query

Lecture 9: Alter Table

Lecture 10: Joins – Part 1

Lecture 11: Joins – Part 2

Lecture 12: Multiple Joins

Lecture 13: Cross Joins

Lecture 14: Why we use cross joins

Lecture 15: Averages, Sums, and Counting

Lecture 16: SQL Union All

Lecture 17: SQL Subqueries

Lecture 18: SQL Like

Lecture 19: SQL Between

Lecture 20: Resume

Chapter 3: SQL Views

Lecture 1: What are views

Lecture 2: Views Syntax

Lecture 3: Views with subquery

Chapter 4: SQL Procedures and Cursors

Lecture 1: Procedures

Lecture 2: Procedure with no parameters

Lecture 3: Procedure with parameters

Lecture 4: SQL Cursors slides

Lecture 5: SQL Cursors

Lecture 6: Cursor example

Lecture 7: Cases

Chapter 5: Functions

Lecture 1: Functions

Lecture 2: Functions with no parameters

Lecture 3: Functions with parameters

Lecture 4: Date and Time functions

Lecture 5: Triggers

Chapter 6: MySQL Project Exercises

Lecture 1: Users and Privileges

Lecture 2: Export and Import Databases

Lecture 3: Introduction to our exercise database

Lecture 4: Exercises

Lecture 5: Exrercise 1 – Additional Time Goals

Lecture 6: Exercise 2 – Fields

Lecture 7: Solutions of View questions

Lecture 8: Exercise 8 – Goals in each half

Lecture 9: Exercise 9 – Goals at a given time

Lecture 10: Exercise about functions

Lecture 11: Solution of Procedures and Functions

Chapter 7: PHP – No programming skills required

Lecture 1: PHP Editors

Lecture 2: Web applications working folder

Lecture 3: Variables and Echo

Lecture 4: Web Forms

Lecture 5: POST

Lecture 6: AND, OR and empty

Lecture 7: Sessions

Lecture 8: SQL Injections Example

Lecture 9: Connection

Lecture 10: Login

Lecture 11: Require once function

Lecture 12: Logout

Lecture 13: HTML Tables

Lecture 14: Select data from database into html tables

Lecture 15: Request Variables from URL

Lecture 16: Hidden input and Form managing

Lecture 17: Insert using web page table

Lecture 18: Update a row of a table

Lecture 19: Delete a row of a table

Chapter 8: JavaScript and jQuery

Lecture 1: What is JavaScript ?

Lecture 2: What is JavaScript ?

Lecture 3: Script and Variables

Lecture 4: Input Validation

Lecture 5: Colors And Characters

Lecture 6: OnMouseOver and OnMouseOut

Lecture 7: Increment and decrement

Lecture 8: Accesing a div element using innerHTML

Lecture 9: Arrays

Lecture 10: Loops

Lecture 11: OnClick and changing location

Lecture 12: date and Time methods

Lecture 13: String Method

Lecture 14: Math and Numbers

Lecture 15: Include JavaScript files

Lecture 16: Append ELements

Lecture 17: jQuery – Introduction

Lecture 18: jQuery – Events

Lecture 19: jQuery – Other events

Lecture 20: jQuery – show()

Lecture 21: jQuery – fadeIn()

Lecture 22: jQuery set and get contents

Lecture 23: jQuery Add (append, prepend, after, before)