COMPLETE BACKEND WEB DEVELOPMENT COURSE

What Will You Learn?

• 1. PHP – Web Scripting Language
• You will be introduced to common concepts of computer science and how they are
• implemented in PHP. No prior programming experience beyond the use of simple mark-up languages is necessary. That is, you must be familiar with HTML.
• THE LESSONS
• LESSON 1
• is an introduction to PHP—how it began and what it looks like. It may be
• sufficient for experienced programmers, since it moves quickly through PHP's key
• features. If you are less experienced, I encourage you to treat this chapter as a first look.
• LESSON 2.
• introduces the concepts of variables,
• operators
• expressions.
• These are the
• building blocks of a PHP script. Essentially, a computer stores and manipulates data.
• Variables let you name values; operators and expressions let you manipulate them.
• LESSON 3
• examines the ways PHP allows you to control program execution. This
• includes conditional branches and loops.
• LESSON 4
• deals with functions, how they are called, and how to define them. Functions
• are packages of code that you can call upon repeatedly.
• LESSON 5
• is about arrays—collections of values that are identified by either numbers or
• names. Arrays are a very powerful way to store information and retrieve it efficiently.
• LESSON 6.
• deals with how PHP sends and receives data. Files, network connections, and
• other means of communication are covered
• AREAS NOT COVERED
• is about classes, presenting an object-oriented approach to grouping functions
• and data. Although not strictly an object-oriented language, PHP supports many features found in OO languages like Java.
•  
• MYSQL AND SQL – DATABASE QUERY LANGUAGE
• INTRODUCTION
• 1. Information systems, data and information
• 2. What is a Database? And a DBMS?
• 3. Do you always need a database?
• 4. Relational Databases
• LESSONS
• 1 SQL Tutorial
• 2 Introduction to SQL
• 3 SQL Syntax
• 4 SQL SELECT Statement
• 5 SQL SELECT DISTINCT Statement
• 6 SQL WHERE Clause
• 7 SQL AND & OR Operators
• 8 SQL ORDER BY Keyword
• 9 SQL INSERT INTO Statement
• 10 SQL UPDATE Statement
• 11 SQL DELETE Statement
• 12 SQL TOP Clause
• 13 SQL LIKE Operator
• 14 SQL Wildcards
• 15 SQL IN Operator
• 16 SQL BETWEEN Operator
• 17 SQL Alias
• 18 SQL Joins
• 19 SQL INNER JOIN Keyword.
• 20 SQL LEFT JOIN Keyword
• 21 SQL RIGHT JOIN Keyword
• 22 SQL FULL JOIN Keyword
• 23 SQL UNION Operator
• 24 SQL SELECT INTO Statement
• 25 SQL CREATE DATABASE Statement
• 26 SQL CREATE TABLE Statement
• 27 SQL Constraints
• 28 SQL NOT NULL Constraint
• 29 SQL UNIQUE Constraint
• 30 SQL PRIMARY KEY Constraint
• 31 SQL FOREIGN KEY Constraint
• 32 SQL CHECK Constraint
• 33 SQL DEFAULT Constraint
• 34 SQL CREATE INDEX Statement
• 35 SQL DROP INDEX, DROP TABLE, and DROP DATABASE
• 36 SQL ALTER TABLE Statement
• 37 SQL AUTO INCREMENT Field
• 38 SQL Views
• 39 SQL Date Functions
• 40 SQL NULL Values
• 41 SQL NULL Functions
• 42 SQL Data Types
• 43 SQL Functions
• 44 SQL AVG() Function
• 45 SQL COUNT() Function
• 46 SQL FIRST() Function
• 47 SQL LAST() Function
• 48 SQL MAX() Function
• 49 SQL MIN() Function
• 50 SQL SUM() Function
• 51 SQL GROUP BY Statement
• 52 SQL HAVING Clause
• 53 SQL UCASE() Function
• 54 SQL LCASE() Function
• 55 SQL MID() Function
• 56 SQL LEN() Function
• 57 SQL ROUND() Function
• 58 SQL NOW() Function
• 59 SQL FORMAT() Function.
• 60 SQL Quick Reference From W3Schools
• 61 SQL Hosting
• 62 You Have Learned SQL, Now What?