Introduction to back end web development


Dates:
Start: 13 Apr 2019      End: 20 Apr 2019
Duration:
2 weekends (Saturdays or Sundays) of intensive onsite lectures and tutorials on. Offline work and teacher assessments take place in between classes.
Locations:
Lagos: King's College, Lagos. 3 Catholic Mission Street, Lagos, Nigeria
Kano: TBA
Entry Requirements:
There are no Academic requirements for this course
Course Materials:
Students are encouraged to attend the class with their own laptops as additional costs would apply for use of in-house computers. Furthermore, students are required to do off-site tutorials which would require the use of a computer.
Fee: ₦20000.00
Detailed information:
Basic Training: For people who would like to have a good grounding in Internet technologies, web building and/or software development. This course does not involve any examinations or issue any certification.

It is ideal for: Enthusiasts who would like to know more about building and software development; Company bosses and managers who would want a better understanding of IT and how it can be applied to their business. Students who would like to use this as a stepping stone for a certification or a degree course etc etc.



*** Week 1 ****
(1) What the course covers
(2) What materials are required and what you get from the course
* All students will be given a 1 year online web access to enable them to develop upload and test their applications
(3) Brief discourse on CGI types and history: ASP, JSP, PERL, PHP
(4) PHP: Introduction to PHP. What is PHP? Why PHP?
(5) PHP in dynamic HTML pages
(6) Basic "Hello World" page
(7) PHP core functions (eg echo, printf etc)
(8) Variables in php
(9) If statements
(10) for loops (with brief mention of other loops)
(11) Forms with php
(12) Your free web hosting site
(13) How to upload files to your server
(14) How to see files that you have uploaded, on the www
(15) Question and answer session
(16) Homework 1: Give students a list of PHP functions to study, test and understand
(17) Homework 2: Give students a pdf of a basic HTML page with dynamic parts to create via php. They must replicate and upload theor work for assessment before the next class


*** Week 2 ****
(1) Tutorial: resolve any problems with the building of the dynamic PHP/HTML pages.
(2) Question and answer session
(3) Error messages in PHP
(4) More php functions (concentrate on the core/most used)
(5) More forms with php (Uploads will be in advanced class)
(6) Databases: what are databases? Why use them?
(7) A short discourse on various types. Differentiate localDBs like Microsoft ??? from DB server.
(8) create a MySQL database with phpMyAdmin
(9) Explain data types, unique fields, primary fields etc
(10) Question and answer session
(11) Homework 1: Students must create a MySQL database with certain fields
(12) Homework 2: give students a pdf of a basic HTML page with dynamic parts to create via php. They must replicate and upload theor work for assessment before the next class


*** Week 3 ****
(1) Tutorial: resolve any problems with the building of the MySQL database.
(2) Question and answer session
(3) SQL and php queries with SQL
(4) Basic SQL Queries: Select
(5) Basic SQL Queries: Insert
(6) Basic SQL Queries: Update
(7) Basic SQL Queries: Delete
(test all queries with a basic script)
(8) Common SQL errors
(9) Question and answer session
(10) Homework 1: Students must create a MySQL and populate it with php scripts. This database will be used in the last lesson
(11) Homework 2: TBA


*** Week 4 ****
(1) Tutorial: resolve any problems with the last homework.
(2) Question and answer session
(3) Bringing it all together: HTML, PHP, MySQL
(4) Including back end form validation with php
(5) All students to build dynamic HTML form that allows than to insert, update, view and delete from the server
What to expect from the course: