to
and
a
In
in
5
with
6
of
4
• Archive: $99 $26 - Getting Started with PHP and MySQL Development - Tech Learning Network PHP is an object oriented general purpose language suitable for a wide variety of tasks.
• In this course, we'll learn how to use PHP as a server-side scripting language for use in web development.MySQL is a general purpose relational database management system (RDBMS) used mainly to provide a back-end database for web applications.
• In this course, we'll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular.Unlike traditional courses that concentrate mainly on theory, we'll take a practical “how-to” approach to working with data.
• Here's what you'll learn:The course cover following topics:PHPbasic syntax, variables,loops and decision constructs.Object oriented featuresString functions.ArraysREQUEST, GET, and POSTIntegrate MySQL databases with PHP.Creating databases and tablesAdding data to a table with INSERTReading a table with SELECTHow to use WHERE to filter dataUsing ORDER BY to sort dataJOINs and how to use them to read from multiple tablesChanging data in a table with UPDATEThe DELETE query: removing one or more rows of data from a tableUsing a text file to load a database schemaMySQLI hope you enjoy the course, and I look forward to working with you!Course CurriculumIntroduction to PHPIntroduction to PHP, Requirements (7:13)Getting XAMPP and Brackets, Starting Server (2:36)First PHP Script (5:55)Variable in PHP (5:02)If, if else, if else if..., Switch (10:04)While, Do While, For, Foreach (9:15)Object Oriented FeaturesFunctions in PHP (5:44)Require, Include and some String Functions (9:15)Classes Overview (7:11)Scoping Rules and the Global Keyword (3:36)Static Properties (9:28)Arrays and VariablesArrays in PHP (10:37)$_SERVER Variables in PHP (5:57)$_GET in PHP (4:10)$_POST in PHP (2:50)$_REQUEST in PHP (3:57)MySQL Database InsightUsing PHPMyAdmin (5:03)Sample Database (1:59)Connecting to MySQL (5:13)Inserting to MySQL, and Wrapup (6:49)Introduction and Installation of MySQLInstalling MySQL (5:35)Database Creation (2:47)Table Creation with SELECT and INSERT (6:28)MySQL Data Types (12:49)Creating an Auto Incrementing Primary Key (8:08)MySQL Basic StatmentsDescribe Table (3:59)Loading sql Files into MySQL (6:57)Introduction to SELECT Query (6:36)SELECT Query Demo (5:18)MySQL Advanced StatementsMySQL Update Query (3:16)Mathematical Operations (6:08)DISTINCT, COUNT and GROUP by Clauses (4:04)Table Relationships (7:49)Introduction to Joins (5:57)MySQL Advanced Statements Part 2The Delete Query (4:38)Types of Joins (6:06)Joins Demo (4:38)Creating and Using Views (2:44)Setting Up a Many to Many Relationship (4:38)Demo of Many to Many Relationship (6:34) $99 $26 - Getting Started with PHP and MySQL Development - Tech Learning Network