Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X
TOTAL PHP TRAINING COURSE DESCRIPTION PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions. WHAT WILL YOU LEARN * Create dynamic web sites using PHP. * Write PHP programs. * Debug PHP programs. * Examine existing code and determine its function. TOTAL PHP TRAINING COURSE DETAILS * Who will benefit: Anyone creating dynamic web sites. * Prerequisites: Software development fundamentals * Duration 3 days TOTAL PHP TRAINING COURSE CONTENTS * What is PHP? PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues. * A first PHP web page A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML. * PHP forms HTML forms, taking values from forms. * PHP and HTML Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript. * Variables operators and expressions Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables. * Operators Arithmetic, logical, relational, Boolean, others. * Control statements Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit. * Functions Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name. * Arrays Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions. * String handling What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs. * PHP and databases Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling. * File I/O Opening, reading, writing files. Permissions, ownership, locking, directories. * PHP, cookies and sessions State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs. * PHP and email Emailing from servers, attachments. * Objects OOP, PHP classes, constructors, instances.
APACHE TRAINING COURSE DESCRIPTION A hands on training course covering installation, configuration and management of the Apache web server. WHAT WILL YOU LEARN * Install Apache. * Configure Apache. * Manage Apache. * Build static and dynamic web sites with Apache. * Secure Apache. APACHE TRAINING COURSE DETAILS * Who will benefit: Technical staff working with Apache. * Prerequisites: TCP/IP foundation for engineers. UNIX fundamentals * Duration 3 days APACHE TRAINING COURSE CONTENTS * Installing Apache What is Apache? Apache versions, history, downloading Apache, source distribution, compilation, binary distribution, installation, platform considerations. Hands on Downloading and installing Apache. * Controlling the Apache server Running Apache, automatic Apache start, starting, stopping, restarting Apache. Checking Apache status. Hands on Server control. * Configuration Serving webpages, setting the document root, applying configuration changes, Configuration files, httpd.conf, syntax, directives, modules, utilities, turning features on/off. Hands on basic Apache configuration. * More configuration MIME, URL mapping, content negotiation, indexing, performance tuning. * Logging log file content, configuration, log file locations, error logging, browser errors, error page configuration, forbidden index pages. Hands on Log files. * Security File permissions, .htaccess, protecting files with passwords, password files, authentication, restricting access by IP address. * Secure HTTP HTTPS, installing mod_ssl, certificates, configuring mod_ssl, http and https coexistence * Virtual hosts Multiple sites on one server, separate configuration files, IP based, name based, port based, virtual host names, enabling, defining, configuring, aliases, testing, https virtual hosts. Hands on Virtual hosts. * Dynamic sites Dynamic sites, CGI, PHP, PERL, CGI programs, example CGI scripts, Apache and CGI, CGI parameters, CGI issues, PHP, mod_php, Perl and Apache, mod_perl, installing mod_perl. Hands on CGI, PHP and Perl with Apache. * Modules What are modules, standard modules, loading modules, mod_speling, mod_rewrite, other special purpose modules, URL rewriting, redirection, URL transformation, browser dependent pages. Hands on Working with modules.
SOCKETS PROGRAMMING TRAINING COURSE DESCRIPTION A hands on course for programmers using Sockets. It is important to recognise that the course assumes that delegates are already familiar with TCP/IP and Python. Practical exercises follow all the major theory sessions. WHAT WILL YOU LEARN * Read Python programs which use Sockets. * Write Python programs which use Sockets. * Debug Python programs which use Sockets. SOCKETS PROGRAMMING TRAINING COURSE DETAILS * Who will benefit: Programmers working with network applications. * Prerequisites: TCP/IP foundation for engineers Python for network engineers * Duration 2 days SOCKETS PROGRAMMING TRAINING COURSE CONTENTS * What is a socket? Review of IP, ICMP, UDP vs TCP, IP addresses, protocol numbers, ports. API's, UNIX I/O, sockets. SOCK_STREAM, SOCK_DGRAM. Hands on Compile and run code. * The systems calls Clients and servers, structs, socket(), bind(), connect(), listen(), accept(), send(), recv(), sendto (), recvfrom(), close(), shutdown(), getpeername(), gethostname(). Hands on Walk through of example client and server code. * First code TCP connections, passive opens, active opens. Hands on Write a simple 'hello world' server and client. * Application protocols User character stream, ASCII turn taking, binary protocols. Hands on Raw SMTP, Writing a mail client. * Clients Concurrency, polling, threads, event driven programming. Hands on Conferencing application. * Servers Concurrency, stateful, stateless. Forks and execs. inetd. Hands on Running servers with and without inetd, chroot jails, conferencing server modifications. * Advanced techniques Blocking, select(), partial send(s). Raw sockets, example sockets using Java, Perl and PHP. Hands on A broadcast application.
MYSQL FOR DEVELOPERS TRAINING COURSE DESCRIPTION This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. WHAT WILL YOU LEARN * Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. * Use advanced features of the MySQL Client. * Use advanced data types. * Manage the structure of databases and tables. * Manage and using indexes. * Write complex SQL query statements. * Use advanced SQL expressions. * Use advanced SQL functions. * Perform advanced Insert, Update, Delete, Replace and Truncate Operations. * Use user variable syntax and properties. * Import and export data from within MySQL. * Import and export data from the command line. * Perform complex joins to access multiple tables. * Perform complex subqueries. * Create, manage and us views. * Use prepared statements. * Create and use stored routines. * Create and use triggers. * Obtain database metadata. * Optimize queries. * Work with the main storage engines. * Debug MySQL applications. MYSQL FOR DEVELOPERS TRAINING COURSE DETAILS * Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. * Prerequisites: MySQL foundation * Duration 5 days MYSQL FOR DEVELOPERS TRAINING COURSE CONTENTS * Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. * Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server * The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program * Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types * Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers * Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases * Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes * Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data * SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions * Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data * Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. * Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata * Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging * Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins * Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries * Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views * Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting * User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements * Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines * Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic * Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic * Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters * Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions * Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers * Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations * More about indexes Indexes and joins Hands on Investigating indexes and joins
Online Options
Show all 237PHP Crash Course: Learn PHP in 90 Minutes
By Packt
Learn PHP in less than 90 minutes with this fast-paced PHP guide
Object Oriented PHP and MVC
By Packt
Learn to build a custom object-oriented PHP MVC framework and application
Create a PHP Login and Registration System from Scratch 2020
By Packt
Learn how to build a login and registration system using PHP, MySQL, and Ajax
Modern PHP Web Development with MySQL, GitHub and Heroku
By Packt
This course covers all the essential topics of PHP web development, such as syntaxes, loops, conditional statements, Bootstrap, GitHub, Heroku, XAMPP, and MySQL that every PHP developer needs to know. You will learn all these concepts by building and deploying a data-driven web application into the production.
[vc_row][vc_column][vc_column_text]Description: Do you want to learn basic programming? Or do you want to learn PHP scripting language specifically? Well, you're in the right place! This Diploma in PHP Programming course will be useful to anyone who wants to train themselves to program and become an expert in PHP language. This PHP programming course is designed to teach you how to plan and create dynamic, database-driven site pages utilising PHP adaptation. PHP is a dialect composed on the web, which is fast to learn, simple to convey and is an instrumental programming language required for web development. This course explores the PHP structure and covers the most vital strategies used to assemble dynamic sites. On course completion, you will be able to utilise any ODBC-supported database, including hands-on experience with MySQL database to make database-driven HTML structures and reports. This course covers all aspects of web development fundamentals, including client verification; information approval, dynamic information updates, and shopping basket usage. You will additionally be trained on how to design PHP and the Apache Web Server. This course contains hands-on activities expertly curated to strengthen learning and fast-track career progression. WHO IS THE COURSE FOR? * Beginner to advanced level users can benefit from the lessons we provide * People who have an interest in learning about programming and PHP ENTRY REQUIREMENT: * This course is available to all learners, of all academic backgrounds. However, someone who has an education and experience in programming and PHP will be an advantage. * Learners should be aged 16 or over to undertake the qualification. * Good understanding of English language, numeracy and ICT are required to attend this course. ASSESSMENT: * At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. * Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. CERTIFICATION: * After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. * PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. WHY CHOOSE US? * Affordable, engaging & high-quality e-learning study materials; * Tutorial videos/materials from the industry leading experts; * Study in a user-friendly, advanced online learning platform; * Efficient exam systems for the assessment and instant result; * The UK & internationally recognized accredited qualification; * Access to course content on mobile, tablet or desktop from anywhere anytime; * The benefit of career advancement opportunities; * 24/7 student support via email. CAREER PATH: The Diploma in Programming in PHP is a very useful qualification to possess, and will be very helpful to have especially for these careers: * IT Department Manager * IT Specialists * Computer Engineer * Computer Specialist * Programmers * Web developers * And Other Computer Operation-related jobs! [/vc_column_text][/vc_column][/vc_row] Diploma in PHP Programming Welcome to the world of programming! 00:30:00 Getting Started 01:00:00 Let's Start Coding! 01:00:00 PHP Strings 01:00:00 PHP Variables 01:00:00 Useful Variables 00:30:00 PHP Includes & Problem Solving 01:00:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:30:00 Multiple Conditions 01:00:00 PHP Arrays 01:00:00 PHP Loops 01:00:00 Note on PHP Math Functions: 00:30:00 Functions 01:00:00 PHP Sessions 00:30:00 Cookies 01:00:00 Introduction to MySQL 01:00:00 Making The Connection 01:00:00 Inserting Data 01:00:00 Deleting / Removing Data 00:15:00 Reference Books PHP - A BEGINNERS GUIDE 00:00:00 Programming with PHP 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in PHP Programming 00:20:00 Final Exam Final Exam- Diploma in PHP Programming 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
COURSE OVERVIEW Whether you are already a professional in the IT industry or aspire to be one, the more programming languages you will learn, the faster you will climb the career ladder. The PHP Tutorial for Absolute Beginners - PHP Course 2021 course is here to help you build your expertise in one more programming language and enrich your CV. In this PHP Tutorial for Absolute Beginners - PHP Course 2021 course, you will receive the essential knowledge and skills required for PHP coding. First, the course will introduce you to the core elements of PHP. Here, you will get the opportunity to introduce yourself to different operators. The highly informative modules will enhance your understanding of loops, arrays and functions. The course will equip you with the key skills to read and write PHP code. Join this PHP Tutorial for Absolute Beginners - PHP Course 2021 course today and prepare yourself to build a promising career in the relevant industry. LEARNING OUTCOMES * Understand the course principles of PHP programming language * Familiarize with the steps of installing PHP * Learn about the basic syntax, variables, and constants * Enrich your understanding of Arithmetic Operators, Assignment Operators and more * Explore different functions of PHP code WHO IS THIS COURSE FOR? This PHP Tutorial for Absolute Beginners - PHP Course 2021 course is for those interested in learning the PHP programming language for the very first step. ENTRY REQUIREMENT * This course is available to all learners, of all academic backgrounds. * Learners should be aged 16 or over to undertake the qualification. * Good understanding of English language, numeracy and ICT are required to attend this course. CERTIFICATION * After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. * PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. WHY CHOOSE US? * Affordable, engaging & high-quality e-learning study materials; * Tutorial videos/materials from the industry-leading experts; * Study in a user-friendly, advanced online learning platform; * Efficient exam systems for the assessment and instant result; * The UK & internationally recognized accredited qualification; * Access to course content on mobile, tablet or desktop from anywhere anytime; * The benefit of career advancement opportunities; * 24/7 student support via email. CAREER PATH The PHP Tutorial for Absolute Beginners - PHP Course 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: * Programmer Unit 01: Introduction Introduction 00:07:00 Unit 02: Installation Installing Xampp 00:10:00 Installing Sublime 00:03:00 Unit 03: Basic Syntax and First Steps Basic Syntax 00:12:00 Echo 00:04:00 Print and Differences between Echo and Print 00:08:00 Variables 00:07:00 Constants 00:06:00 Comments 00:05:00 Single vs Double Quotes 00:04:00 Unit 04: Data Types Integers 00:05:00 Floats 00:01:00 Booleans 00:02:00 Strings 00:03:00 Nulls 00:02:00 Unit 05: Operators Arithmetical Operators 00:05:00 Assignment Operators 00:06:00 Comparison Operators 00:06:00 Increment and Decrement Operators 00:04:00 Unit 06: Statements If Elseif Else 00:09:00 Switch 00:06:00 Unit 07: Loops While 00:09:00 For 00:06:00 Unit 08: Arrays Arrays and Indexed Arrays 00:06:00 Associative Arrays 00:06:00 Multidimensional Arrays 00:08:00 Unit 09: Functions Functions 00:07:00 Functions with Arguments 00:06:00 Unit 10: Super Globals Intro to Super Globals 00:04:00 Post 00:11:00 Get 00:14:00 Sessions pt. 1 00:09:00 Sessions pt. 2 00:08:00 Unit 11: Date and Time Date 00:04:00 Time 00:09:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Introduction to PHP Training
By Nexus Human
Duration 4 Days 24 CPD hours This course is intended for This course is Intended for students with HTML Experience. Overview At the completion of the course, you will be able to: How PHP works. The basic syntax of PHP. Create dynamic interactive pages with PHP. Manipulate files with PHP. Work with arrays in PHP. Validate forms with PHP. Write functions in PHP. Manipulate and manage database data with PHP. Authenticate users with PHP. Manage sessions with PHP. Work with the MDB2 package. Learn advanced form validation with regular expressions. Send email with PHP. In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. PHP BASICS * How PHP Works The php.ini File Basic PHP Syntax Variables First PHP Script PHP Operators Creating Dynamic Pages Passing Variables via the Query String FLOW CONTROL * Conditional Processing Working with Conditions Loops Working with Loops ARRAYS * Enumerated Arrays Working with Enumerated Arrays Associative Arrays Working with Associative Arrays Two-dimensional Arrays Array Manipulation Functions PHP AND HTML FORMS * HTML Forms Processing Form Input STRING MANIPULATION * Formatting Strings Working with String Manipulation Functions Magic Quotes REUSING CODE AND WRITING FUNCTIONS * Including Files Adding a Header and Footer User Functions Form Processing Form Validation and Presentation Functions MANAGING DATA * Querying a Database Inserting Records AUTHENTICATION WITH PHP AND SQL * A Database-less Login Form Authenticating Users REGULAR EXPRESSIONS * Perl-compatible Regular Expression Functions Regular Expression Syntax Form Validation Functions with Regular Expressions SESSION CONTROL AND COOKIES * Sessions Cookies Authentication with Session Control SENDING EMAIL WITH PHP * mail() PHPMailer Sending a Password by Email FILE SYSTEM MANAGEMENT * Opening a File Reading from a File Writing to a File Writing to a File File Locking Uploading Files via an HTML Form Getting File Information More File Functions Directory Functions Creating a Resume Management Page
Embark on a digital crafting odyssey, diving into the intricate world of web creation with our 'PHP Web Development with MySQL; GitHub & Heroku' course. Visualise your first step into this digital tapestry with the 'Introduction' unit, an inviting prelude that demystifies the realm of server-side scripting. As learners unfurl the sails of their developmental journey, they'll configure their coding environment, laying the robust groundwork for a future in web architecture. Advancing into the heart of PHP, our syllabus navigates through the crucial syntax and fundamentals that form the bedrock of dynamic website construction. Engage with the creation of interactive forms, delve into database manipulation using MySQL, and master user authentication processes. This course promises a transformative learning expedition, from first principles to deploying live web applications, all while ensuring each participant garners the confidence to stitch together the seams of secure, responsive online experiences. Learning Outcomes * Comprehend PHP fundamentals and create robust web applications. * Configure environments for PHP development with precision. * Integrate MySQL databases for dynamic content management. * Construct and handle secure PHP forms for data collection. * Implement user authentication to safeguard web applications. WHY CHOOSE THIS PHP WEB DEVELOPMENT WITH MYSQL; GITHUB & HEROKU COURSE? 1. Unlimited access to the course for a lifetime. 2. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. 3. Structured lesson planning in line with industry standards. 4. Immerse yourself in innovative and captivating course materials and activities. 5. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. 6. Flexibility to complete the Course at your own pace, on your own schedule. 7. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. 8. Unlock career resources for CV improvement, interview readiness, and job success. WHO IS THIS PHP WEB DEVELOPMENT WITH MYSQL; GITHUB & HEROKU COURSE FOR? * Novices embarking on web development careers. * Technologists eager to learn server-side scripting. * Data managers focusing on MySQL database integration. * Coders looking to understand PHP in web applications. * Developers aiming to utilise GitHub and Heroku for deployment. CAREER PATH * Web Developer: £25,000 - £50,000 * PHP Developer: £24,000 - £45,000 * MySQL Database Administrator: £30,000 - £60,000 * User Authentication Specialist: £35,000 - £55,000 * Back-End Developer: £28,000 - £53,000 * DevOps Engineer: £40,000 - £70,000 PREREQUISITES This PHP Web Development with MySQL; GitHub & Heroku does not require you to have any prior qualifications or experience. You can just enrol and start learning.This PHP Web Development with MySQL; GitHub & Heroku was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CERTIFICATION After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. COURSE CURRICULUM Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstrap 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - PHP Web Development w/ MySQL GitHub & Heroku 00:00:00 Assignment Assignment - PHP Web Development with MySQL; GitHub & Heroku 00:00:00
