Web Development Basics: Learn PHP+SQL

Course details

                                     PHP+MYSQL
 
COURSE OVERVIEW

PHP

Hypertext Preprocessor” is a widely-used Open Source general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. Its syntax draws upon C, Java, and Perl, and is easy to learn. The main goal of the language is to allow web developers to write dynamically generated web pages quickly, but you can do much more with PHP.

MYSQL

MySQL is a RDBMS (Relational database management system). We use such a system in order to store, retrieve and manage data related to our applications. Apache is an Open Source web server in wide usage. A web-server is required to host a web-application (webpage) on a remote server and is responsible for processing the request from the client, who wants to access the application (or webpage).
 
What you'll learn:

·         Create Dynamic Websites using php
·         Interact with the database using PHP
·         Handle files with PHP
·         Create Database using phpMyAdmin
·         Implement Sessions and Cookies
·         Build CMS using php and MySql
 
COURSE DESCRIPTION

PHP and MySQL are incredibly powerful open source technologies that allow people to create functional websites and apps that go way beyond basic HTML. While it can seem intimidating to someone with no background in coding, working with PHP is much easier than many realize. With the right guidance and a desire to learn, most people can learn how to put together a functional web app in a few days!
Anyone who wants to build a website that goes beyond the requirements of basic HTML and CSS.
Anyone who wants to learn how to build an app that can handle data and interface with end users at the same time.
Anyone who wants to learn how MySQL can function as a database solution.
Anyone who wants to learn basic programming and development skills without days of digging through technical books.
 
COURSE OUTLINE
 
·         Connecting To a MySQL Database
·         Database Structure
·         Inserting Data in MySQL
·         Intro To Variables And Operator
·         Outputting Tabular Data
·         Repetition - for Loops
·         MySQL Select
·         Using Variables With GET
·         Redirection In PHP
·         Multi Part Forms
·         Normalization
·         MySQL Join Diagrams
·         Styling Our Lists
·         PHP Error Types
·         Protecting Pages
·         Custom Functions
·         Server Variables
·         Browser Detection
 
  Updated on 10 April, 2023