Web Development Masterclass - Online Certification Course | Free Udemy Course

This lecture discusses the objectives of the course and provides an overview of how the material will be presented.

Students will learn key terms that are instrumental in web development, including:

• Data Packet Transmission
• Data Packet header, payload and trailer
• Internet bandwidth, bit-rate and latency
• Protocols, IP & TCP

Students learn how web page data is delivered using HTTP (Hyper Text Transfer Protocol) and GET Requests. DNS (Domain Name Servers) are also introduced.

Students are introduced to HTTPS (Hyper Text Transfer Protocol Secure). We explore several components of this protocol including:

• SSL (Secure Socket Layer)
• TLS (Transport Layer Security)
• SSL Handshake
• EV (Extended Validation Certificate)

Students learn the flow of email exchange using SMTP (Simple Mail Transfer Protocol). 

We also explore POP3 & IMAP for Local Mail Delivery.

This lecture expands on our discussion on email exchange, with a focus on outbound mail delivery. 

Students are introduced to the basics of an internet and local network. We discuss both Local and Wide Area Networks (LAN, WAN). 

Students are introduced to key terms relevant to data packet exchange over local and wide area networks, including:

• Routers
• Network Ports
• Hardware and Software Firewalls
• Data Pipelines
• Internet Service Provider (ISP)

This lecture provides an overview of the web development process. Students will follow this process in the development of several website projects. 

This lecture discusses the importance of planning the layout and flow of a web application of website prior to development. 

This Quiz covers materials from section 1-4 inclusive.

This lecture provides an introduction on the different types of web hosting solutions that the course will explore, including:

• Shared Hosting
• Virtual Private Servers (VPS)
• Dedicated Servers
• Virtual Cloud Servers

This lecture focuses on shared hosting solutions and offers a comparison of several packages available through popular hosting providers. 

Several Key terms are explored including:

• Bandwidth
• Cloaking
• Disk Space
• Linux vs. Windows Operating Systems
• Scripting language compatibility

This lecture discusses dedicated hosting solutions and provides a detailed comparison of different packages.

This lecture discusses Virtual Private Servers (VPS) and provides a detailed comparison of different packages.

This lecture provides a detailed overview of Cloud hosting and defines the "computing cloud".

We present a case study comparing cloud hosting to traditional hosting solutions in creating basic and "big data" style websites and applications.

Students will learn the concepts of flexibility, scalability, cost efficiency and reliability as applicable to virtual cloud servers.

We also explore various cloud hosting packages offered by popular providers such as Linode.

Students learn key terminology as applicable to domain names and registration, including:

• Registries
• Registrars
• Top Level Domains
• ICANN (Internet Corporation for Assigned Names and Numbers)
• ccTLD (Country Code Top Level Domain).
• IP to Domain Name Resolution. 

This lecture discusses the importance of selecting the right domain registrar for registration. 

We explore essential terms such as: Domain Brand Protection, Domain Monitoring, Enforcement, Security and Trademarking.

In this lecture we register a sample domain using registrar GoDaddy.com.

This lecture is a continuation of domain name registration. We demonstrate how to enable domain privacy to protect against the publication of personal information on public WHOIS records.

This lecture demonstrates how to log in to the GoDaddy domain management console. 

Students will learn to administer the Domain DNS settings and configure Auto Renewal.

This lecture further explores the GoDaddy domain management system, including the domain lock and domain transfer authorization.

Students learn the difference between permanent and temporary domain redirection. We also explore domain and sub-domain forwarding.

In this lecture we define the role of Name-servers (NS Records).

Students are also introduced to A-Records and MX-Records.

Students learn to amend Domain Registrant, Administrative, Technical and Billing information on their GoDaddy account. 

This Quiz includes materials from Section 5-6 Inclusive.

This lecture provides an introduction into testing servers to host web applications on a local system.

Students learn the difference between client and server-side scripting languages. 

We also introduce WAMP and MAMP (Apache, MySQL, PHP) for Windows and MAC respectively. 

Students learn to download and configure WAMP Server for Windows.

Students learn to download and configure MAMP Server for MAC.

This lesson explores the WAMP menu including:

• Starting and Stopping the WAMP Service
• Storing files into the Web Root (www) Folder.
• Exploring important configuration files for PHP, MySQL and APACHE.

Students learn to test their WAMP configuration to make sure all services are working properly. 

Students learn to administer a DNS Zone file for domain and email management using the Linode Dashboard.

The following concepts are explored:

• "A" and "AAAA" Records
• MX Records
• Domain Zone
• SOA (Start of Authority)
• TTL (Time to Live)
• CNAME Record
• TXT Record
• SRV Record

Students learn to mange DNS Settings using the GoDaddy domain control panel.

We provide a demonstration on downloading and installing FileZilla FTP Client used to transfer files from the local testing server to the live production web server.

We explore the FileZilla interface and administration of the site manager. 

Students also learn to establish SSH connections with their remote server for secure data file transfer.

Students learn to upload and download files from their remote virtual server using FileZilla FTP.

This lecture continues exploring the FileZilla FTP agent.

Students learn to check file transfer status and disconnect from the remote server.

This Quiz includes materials from sections 7-9 inclusive.

This lecture provides an introduction into HTML and it's primary role in web development.

We explore various examples to demonstrate the application of HTML and its usage.

This lecture explores the basic structure of an HTML document, including:

• <!DOCTYPE html> Tag
• Document Title Placement
• Document Script Placement
• Document Body Content

Students learn the difference between HTML 5, and previous versions. 

We also define XHTML and it's application in development.

Students learn the importance and application of the HTML <head></head> tags.

Here we introduce:

• Meta tags and meta data
• <title></title> Tags
• Character sets
• View-port Considerations
• Cascading Style Sheets (CSS)
• JavaScript Functions

Students learn the application of the HTML <body></body> tags.

Students learn the application of the HTML <p></p> tags.

Students learn the application of the HTML <br></br> tags.

Students learn to create a non-breaking space using HTML.

Students learn to create headings to emphasize important text content.

Students learn to format text content with different formatting attributes.

Students learn how to apply element formatting attributes within HTML tags, known as inline-text formatting.

Students learn to create unordered lists and list items using the <ul></ul> and <li></li> tags.

Students learn to create ordered lists and list items using the <ol></ol> and <li></li> tags.

Students learn to insert images into html documents and apply various image attributes.

Students learn to insert responsive videos using the HTML 5 <video></video> tags.

We also explore video controls and format options.

Students learn the difference between absolute (long-form) file references and relative file references (short-form).

We explore different examples using image file paths in a web document.

Students learn to create links and apply various link attributes to text and image content.

Students learn to create links to specific content areas of a single page using anchor tags.

Students learn to work with tables and custom table formatting. 

We explore: 

• Cell Spacing
• Cell Padding
• Table borders
• Fixed table width vs. Percentage

Students learn to nest tables into one another using nested and parent table structures.

Students learn to merge multiple table cells into one using the "collspan" attribute.

This lecture explores the HTML "no wrap" attribute when working with content in table cells.

Students learn to apply background images to tables using the "background" attribute.

Students learn to work with the align attribute to align content in a table cell. 

Students are introduced to HTML forms for the collection of user input data. 

We explain key concepts such as data validation and other important elements that are essential in processing form data while maintaining data integrity.

This lecture explores the <form></form> tags and various form attributes such as name, action and send method.

Students learn the difference between form data transmission using the POST and GET methods. 

This lecture introduces students to input fields and field attributes for maintaining data integrity. 

Students learn to work with HTML select menus and various attributes associated with the <select></select> tags.

We teach how to populate the menu and assign values to each menu item for data processing. 

Students learn to create checkbox and radio input buttons. We explore several attributes associated with each input for data processing.

Students learn to create text area input fields on HTML forms. 

We explore various attributes associated with the <textarea></textarea> tags.

Students learn to embed iframes into html documents to incorporate external content on an existing page. 

We explore several attributes relevant to the <iframe></iframe> tags.

In this project, students learn to create a web page using HTML. The project will encompass all the material that has been presented in this section of the course. 

This Quiz includes materials from Section 10.

This lecutre provides an introduction into CSS (Cascading Style Sheets).

We provide an overview of Style sheet usage and placement using the <style></style> tags.

Students learn to work with CSS Selectors to apply customized style rules to individual HTML elements.

Students learn the different methods of embedding style rules into there HTML document. We explore internal, inline and external style sheets.

Students learn how to work with color codes in CSS. We explore RGB and Hexadecimal web codes for styling and customization. 

Students learn how to apply style rules to specific HTML elements using CSS Class Selectors.

Students learn to work with CSS layout elements using DIVs. 

We also explore several attributes relevant to the <div></div> tags.

Students learn to work with CSS ID selectors to apply customized style rules to DIVs and other page elements.

Students learn to apply margins to HTML elements using the "Margin" attribute.

Students learn to apply padding to HTML elements using the "padding" attribute.

Students learn to apply various style formatting options to text elements.

We explore:

• letter-spacing
• text-decoration
• text-transform
• color
• text-align

Students learn to apply various font properties to text style definitions.

We explore:

• font-family
• font-size
• font-style
• line-height

Students learn to add borders around page elements and various border attributes.

Students learn to apply background attributes to CSS elements using the "background" property.

We explore:

• background-color
• background-image
• background-position
• background-repeat

Students learn to work with CSS transparency to increase and decrease the level of opaqueness of an element.

Students learn to set the width and height of page elements using the CSS "width" and "height" property.

We explore:

• min-width
• max-width
• width
• height
• min-height
• max-height

Students learn to place elements on top of one another using nested DIVs. 

Students learn to apply the display property to page elements to change the visibility or positioning of an element, relevant to another.

Students learn to apply "static" positioning to page elements.

Students learn to apply "relative" positioning to page elements.

Students learn to apply "relative" positioning to page elements.

Students learn to apply "fixed" positioning to page elements.

Students learn to us the "float" property to wrap text around html objects such as images. 

Students learn to use the clear property to control the behavior of floating elements.

Students learn to specify the stack order of page elements using the "z-index" property.

This lecture explores styling links in each link state:

• unvisited
• visited
• hover
• active

Students learn to create and style tables using CSS. 

In this project, students learn to create a responsive three-column web page layout using CSS. The project will encompass all the material that has been presented in this section of the course. 

This Quiz includes materials from Section 11.

Students are introduced to the Document Object Model (DOM). 

We demonstrate how the DOM is used to interpret and display web page content.

This lesson provides examples of DOM manipulation using JavaScript.

This lecture introduces students to one of the most powerful client-side programming languages: JavaScript.

Students learn the uses and limitations of JavaScript and a summary of how it differs from other languages. 

Students learn the placement of JavaScript code within web documents.

Students learn how to call JavaScript functions from external script files.

Students learn how to output data using the JavaScript document.write() and window.alert methods.

Students learn to output data using the JavaScript innerHTML method.

Students learn to embed single and multi-line comments into JavaScript syntax.

Students learn to work with fixed value constants.

This lecture introduces the concept of variables in JavaScript coding. 

We explore variable identifiers and provide important rules when defining the identifiers.

This lecture explores the usage of assignment operators to compute values of two different data types.

This lecture explores arithmetic operations to perform calculations on numbers, both constants and variables.

This lecture explores operator precedence to determine the order in which operations will be performed in an arithmetic expression.

This lecture provides an introduction into JavaScript Data Types. We explore numbers, strings, arrays, and objects.

Students learn to work with JavaScript objects and object properties.

This lecture explores Object Output using the "getElementByID" method.

This lecture explores JavaScript String variables for storing characters.

Students learn to use the "length" property to calculate the length of a string variable.

This lecture demonstrates methods to effectively handle special characters in string variables.

Students learn to generate random numbers using the "math.random()" function.

Students learn to find the lowest and highest value in a list of arguments using the "math.min" and "math.max" functions.

Students learn to round decimal numbers using the "math.round()" function.

We also explore the "math.ceil" and "math.floor" functions.

Students learn to use JavaScript arrays to store multiple values in a single variable.

We also explore variable index numbers.

Students learn to output each value in an array using the "toString()" method.

We also explore the "join" method for separating values in an array with a specified character.

Students learn to add and remove elements of an array using the JavaScript pop, push, shift and unshift methods.

Students learn to change and delete specific elements in an array.

Students learn to use the "splice()" method to add multiple new items to an array.

Students learn to use the "sort()" method to sort items in an array alphabetically.

We also explore reverse sorting using the "reverse()" method.

Students learn to use the "concat()" method to combine multiple arrays.

Students learn to use conditional statements to perform different actions based on one ore more conditions.

We explore the if, else, and elseif statements.

Students learn to use comparison operators to compare the equality or difference between variables or values.

Students learn to use the "boolean()" function to test if an expression is true.

Students learn to use "for loops" to execute a block of code repeatedly, with a different value for each iteration.

Students learn to use the "for-in" loop to loop through the properties of an object.

This lesson demonstrates how to use the "while loop" to loop through a block of code as long as specified condition is met.

Students learn to use the "do...while" loop to execute a block of code, as long as a specific condition is met through each iteration.

This lesson explores the 'break and continue" statements to exit a loop or skip an iteration of a loop.

Students learn to use JavaScript functions to create blocks of code that perform particular tasks when called upon.

Students learn to use event triggers to execute JavaScript code. 

We explore:

• Mouse clicks
• Mouse overs
• Mouse Out
• Key Down
• Document Load

In this project, students utilize skills taught in previous lectures to create a background color changer using JavaScript.

In this project, students utilize skills taught in previous lectures to create an interactive Photo Gallery using JavaScript.

This Quiz includes materials from Section 12-13 Inclusive.

This lecture introduces students to the jQuery library and it's various applications in development.

Students learn to embed jQuery library into their documents using the Google Content Delivery network (CDN). 

Students learn to work with jQuery selectors to perform actions on individual elements or element groups.

This lecture explores the jQuery "id" selector to manipulate specified elements.

This lecture explores the jQuery "class" selector to manipulate specified elements.

Students learn to embed an external jQuery file into the existing web page document.

Students learn to trigger specified events when certain actions are performed.

We explore: mouse clicks, mouse move, and page load events. 

Students learn to use the jQuery "mouseenter" and "mouseleave" events to trigger actions.

Students learn to use the jQuery "mousedown" and "mouseup" events to trigger actions.

Students learn to apply multiple event triggers to an element.

Students learn to use the "hide" and "show" event triggers to make an element visible and invisible.

Students learn to toggle between actions and animations using the jQuery "toggle" method.

This lecture explores the jQuery "fadeIn()" and "fadeOut()" methods of animating an element.

Students learn to toggle between the "fadeIn()" and "fadeOut()" methods using the "fadeToggle()" method.

Students learn to use the "fadeTo()" method to fade an element to a specified opacity.

Students learn to use the "slideDown()" method to animate an element using specified parameters. 

Students learn to use the "slideUp()" method to animate an element using specified parameters. 

Students learn to toggle between the "slideUp()" and "slideDown()" methods using the "slideToggle()" method.

Students learn to animate objects and elements using the jQuery "animate()" method,

We explore various animate parameters and event triggers.

Students learn to apply multiple parameters to the "animate()" method. We explore position, opacity, and toggle parameters.

Students learn to define relative width and height properties to an element within the "animate()" method.

Students learn to run multiple "animate()" calls in sequence using the jQuery Queue functionality. 

Students learn to terminate an animation sequence before completion, using the "stop()" method.

Students learn to apply the jQuery callback function to ensure all JavaScript statements are executed line-by-line.

Students learn to chain multiple jQuery commands on the same element.

Students learn to develop draggable elements using jQuery.

Students learn to develop accordion menus using jQuery and jQuery-UI.

Students learn to manipulate the Document Object Model (DOM) using the <.text()> and <.html()> methods.

Students learn to retrieve the value of an input field using the .val() method.

Students learn to retrieve attribute values using the jQuery "attribute" method.

Students learn to set the content of an element using the .text(), .html(), and .val() methods.

Students learn to use the jQuery attribute method to set or change attribute values of an html element.

Students learn to use the jQuery append() method to append data to the end of a specified html element.

Students learn to use the jQuery after() and before() methods to add content after or before a html element.

Students learn to use the jQuery remove() method to remove specified elements from our web page.

This lecture demonstrates how to remove html elements using the filter " remove() " method.

Students learn to add class attributes to different elements. We can select single or multiple elements to apply the class to using the addClass() method.

Students learn to remove class attributes using the removeClass() method.

Students learn to switch between adding and removing classes using the toggleClass() method.

This Quiz includes materials from Section 14.

This lecture provides students with an introduction into the Mobile-Responsive, Bootstrap development framework.

Bootstrap is an open-source software, and is one of the most popular frameworks available. It is widely used for even the most complex web applications.

Students learn to embed Bootstrap into their web documents using the Boostrap Content Delivery Network (CDN).

Students learn the basic structure of a web page developed using Bootstrap. 

Here we discuss several important topics including the "viewport" meta tag, as well as fixed-width and fluid containers.

Students learn to use the Bootstrap mobile-first grid system allows you to easily control how website layouts will be displayed on different types of devices. 

Students learn to develop a responsive three-column web layout using Bootstrap.

Students learn to work with some of the most commonly used text formatting options that Bootstrap offers.

Students learn to develop tables using Bootstrap. 

We explore several unique styling options for table layouts.

Students learn to style images using Bootstrap. We explore rounded corners, and making images mobile-responsive.

Students learn to create Bootstrap Jumbotrons to allow special content areas for emphasized headings and text.

Students learn to use Bootstrap wells to create headings or emphasize content. 

Students learn to create pre-defined alert messages using different alert classes, including: success, info, warning, and, danger.

We also explore dismissible alerts.

Students learn to create styled buttons using Bootstraps built in button classes.

Students learn to group a series of buttons together using button groups.

Students learn to create button groups that span the entire width of a screen using Bootstrap Justified Button Groups.

Students learn to create Bootstrap Glyphicons using the "glyphicon" class.

This lecture demonstrates how to create badges and labels to add emphasis to different HTML elements.

Students learn to create progress bars that can be used to track the amount of progress made during a process.

This lecture demonstrates how to create Bootstrap Pagination to add a page numbering system to content that stretches across multiple pages.

When applied to an unordered list, the pager class creates previous and next buttons to content that stretches accross multiple pages.

Students learn to create list groups and attach various classes to apply different styles.

This lecture demonstrates how to use Bootstrap panels to contain different types of content.

We also explore various classes that can be used to style panels.

Students learn to create drop-down navigation menus using Bootstrap classes.

We also explore drop-up menus. 

Students learn to create collapsible elements that give users the ability to show or hide content on a web page.

In this lecture, students learn to create a collapsible panel.

We explore several classes applicable to the collapse panel.

Students learn to create a collapsible list group using an unordered list element.

Students learn to create an accordion menu using various Bootstrap classes.

Students learn to create Tab Menus using various Bootstrap classes.

Students learn to create Pill Menus using various Bootstrap classes.

Students learn to create Bootstrap Navigation bars with various forms of sizing and alignment.

Students learn to create collapsible navigation bars to accommodate smaller screen sizes.

Students learn to apply Bootstrap styling to form elements using various classes. 

Students learn to apply Bootstrap styling to various form inputs, including: text fields, text areas, check boxes, radio buttons, and select menus.

Students learn to apply form control states to validate form data prior to submission. 

Students learn to adjust the height of a form input field for customization.

Students learn to create a Bootstrap Carousel used to create animated slide shows that cycle through html elements and objects.

Students learn to work with Bootstrap Modals to display web page content in the form of a "pop-over" dialogue box.

Students learn to create "pop-up" text boxes using Bootstrap Tool-tips. A tool tip can be triggered using various events, such as "mouse over" or "on-click".

Students learn to create Bootstrap Popovers. These pop-up dialogue boxes are similar to Tool-tips, but accommodate more content.

Students learn to create dynamic page links and page scroll functions using the Bootstrap Scrollspy plugin.

This Plug-in can be used to create modern, Bootstrap themed web page layouts.

Students learn to work with free, Bootstrap web page templates and modify them for a customized look.

In this lecture, students will begin creating their own Bootstrap web page from scratch. 

Students will utilize skills acquired in all the previous lectures in this section.

This Quiz includes material from Section 15.

This lecture presents an introduction into PHP development. 

We discuss PHP essentials and various system requirements to make sure scripts are running properly.

Students learn to prepare their local system for PHP development. We conduct an overview of WAMP/MAMP and the Web Root Folder (www).

Students will conduct a PHP file test on their local system, to make sure the script is working.

Students learn the basics of PHP syntax and rules for variable declaration

This lecture explores variable declaration and different rules applicable to naming variables. 

We also explore variable output methods.

This lecture explores Variable scope as applicable to Global and local scope variables.

This lecture explores the "Global" keyword, used to access global variables that are inside a function.

This lecture explores that "static" keyword to retain a variables value, even if the variable is declared inside a function.

Students learn to output data using the "echo" and "print" commands.

Students learn how to store variables into various data types, including Strings, Integers, Floats, Arrays, Booleans, and Objects.

This lecture provides an in-depth look into the "Object" variable data type. 

We demonstrate various use cases for objects, and important rules in object variable declaration.

Students learn to work with string variables, including the "str_replace" function to replace a work or specified word in a String.

This lecture explores variable constants. A constant is an identifier for a given value. A constant cannot be changed during the script, as a variable can.

Students learn how to perform various operations on variables and values using several different types of PHP operators. We explore:

• Arithmetic operators
• Assignment operators
• Comparison operators
• Increment/Decrement operators
• Logical operators
• String operators
• Array operators

Students learn to work with conditional statements to execute a block of code if certain events or conditions are met. Here, we explore:

• if statements
• if-else stements
• if-else-elseif statements
• switch statements

This lecture explores the PHP Elseif statement, used for multiple conditional statements. 

Students learn to use the switch statement to compare the value of an expression against a set of predefined conditions, also referred to as cases.

Students learn to work with PHP Loops, in order to execute the same block of code multiple times. Here we explore:

• while loop
• do...While Loop
• for loop
• foreach loop

This lecture explores the PHP "for", and "foreach" loop.

The "for" loop is used when you know in advance how many times you want the code block to execute.

Students learn to work with built-in PHP functions and create custom functions.

A function is a block of statements that can be called upon whenever they are required.

Functions are very useful and help keep coding organized and efficient.

This lecture explores PHP arrays. An array is a variable used to store multiple values.

We explore three types of arrays:

• Indexed arrays
• Associative arrays
• Multidimensional arrays

Students learn to create arrays that hold multiple key/value pairs, known as Multidimensional Arrays.

Students learn to sort the elements of an array using the "sort()" function.

We also explore reverse sorting, and various methods of sort order using "rsort()", "asort()", and "krsort()".

Students learn to work with "superglobal" variables.

Superglobals are variables that are built into PHP and are always available for use.

Students learn to process HTML form data using PHP. 

We explore both email processing and insertion of data into a MySQL Database.

Students are also introduced to the concept of server-side data validation using PHP.

This lecture explores the difference between the POST and GET method of form data transmission.

Students learn to output form data onto the same HTML page that contains the form and input fields.

We also discuss various data validation methods to ensure data integrity is preserved. 

Students learn to create required inputs and avoid empty fields when processing form data.

This lecture explores the PHP "preg_match()" function to determine if a string meets a specified pattern. 

This Quiz includes material from Section 16.

This lecture introduces students to MySQL Database administration and database properties.

This lecture introduces students to PhpMyAdmin, used to administer MySQL Databases. 

We explore theoretical use cases for PhpMyAdmin, such as:

• Importing data from CSV and SQL
• Exporting Data in various formats
• Creating graphical layouts of database structures.

Students learn to navigate through the PhpMyAdmin interface. 

Students learn to configure user privileges on MySQL Databases, using PhpMyAdmin.

We also explore the importance of administering databases using non-root user accounts.

Students learn to create new databases and database tables using PhpMyAdmin.

Students learn to create new users and assign user privileges using PhpMyAdmin.

We explore password authentication along with Global, Database-Specific, and Table-Specific Privileges.

Students learn to assign table-specific privileges to a MySQL database.

Students learn to modify the structure of existing databases using PhpMyAdmin.

We also explore deleting tables and emptying table contents. 

Students learn to modify and delete databases.

We also explore database exportation.

Students are introduced to SQL (Structured Query Language) used to communicate with relational database management systems (RDBMS).

Students learn to execute basic SQL Statements using the PhpMyAdmin interface, to modify data stored in a table.

Students learn to import data into a database from an existing SQL file.

This lecture explores the SQL "Select" Statement for data retrieval from a database table. 

Students learn to use the SQL "Distinct" keyword to output unique values from specified columns in a table.

Students learn to utilize the SQL "Where" clause, to extract records from a database that meet a certain condition.

Students learn to utilize the SQL "AND" operator to filter records using multiple conditions.

This lecture explores the SQL "OR" operator to select all the statements in a database as long as one out of two conditions is met.

Students learn to sort data queries by one or more columns, using the "ORDER BY" method.

Students learn to insert new records into a database using the MySQL "Insert Into" statement.

Students learn to retrieve the record ID of the last record inserted into a database.

Students learn to insert multiple records into a table using the "mysqli_multi-query()" function.

Students learn to execute the same (or similar) SQL statements using Prepared Statements.

Students learn to delete records in a table using the SQL "DELETE" statement.

Students learn to apply URL redirection using the PHP "header()" function.

Students learn to determine if a variable value is set, using the PHP "ISSET()" function and "$_GET" method.

Students learn to modify and update records in a table using the SQL "UPDATE" statement.

This lecture provides students with an introduction into XML (Extensible Markup Language).

We explore several use cases and a detailed overview of the characteristics of XML.

This lecture provides an overview of the some of the basic components of XML, including:

• Declaration
• Tags
• Elements
• Attributes
• Comments

Students gain exposure to XML Schema languages, including Document Type Definition (DTD) and XML Schema (W3C).

We also introduce several examples of industry specific schema's used to exchange structured data.

Students learn to parse an XML document using JavaScript.

Students learn how "XMLHttpRequest" objects can be used to seamlessly exchange data with our web server.

This lecture provides an introduction into AJAX (Asynchronous JavaScript and XML). 

In this lecture students learn to use AJAX to create a search field that displays "suggestions" from a pre-defined list of values (without page reload).

Students learn to seamlessly retrieve information from a database, using AJAX.

This Quiz includes materials from Section 17-18 Inclusive.

In this section, students will use the skills learned in several of the previous sections to develop a web application. 

This web application will include several components such as:

• Login Authentication
• Validated User Registration
• Database Creation
• PHP-Mailer Installation
• Email Data Transmission using SMTP
• AJAX calls for alert messages without page-refresh.

Students learn to use Google Apps for work to register and administer a custom business email address with unlimited aliases.

This Exam covers materials from all sections presented in the course.