thumb

Web Technology and Database

TBA 1 Month

Program Outcomes

At the completion of the program, learners will be able to:


Design well-structured and visually appealing web pages using HTML5 and CSS3, incorporating forms, tables, and lists.

Apply JavaScript to enhance user experience by handling events, manipulating the DOM, and implementing ES6+ features for modular and efficient scripting.

Implement asynchronous programming concepts and utilise Local Storage and Session Storage to effectively manage client-side data.

Demonstrate an understanding of MySQL database fundamentals by performing CRUD operations and constructing SQL queries using joins and subqueries.

Integrate frontend technologies to develop interactive, user-centric web applications focusing on functionality, usability, and performance.

HTML & CSS

  • Introduction to web development
  • Fundamental HTML Elements, Relative URLs, Lists, Table, Frames, Forms, HTML 5.0, HTML and HTML5
  • Introduction to CSS
  • Colors, Text, Boxes, Styling List and Tables, create a Registration Form, Positions (Relative, Absolute, Fixed and Sticky)
  • Float, Media queries, Gradients, Flexbox, CSS grids, Transition and Animation
  • Hands-on: Building a Webpage

JavaScript

  • Variables
  • Data Types, Operators
  • Functions
  • Arrays and Objects
  • Loops
  • DOM Manipulation
  • Events and Event Listeners
  • ES6+ Features
  • Async Programming
  • Local Storage & Session Storage

MySQL & Git and GitHub

  • Introduction to RDBMS (MySQL)
  • Database Design: Tables, Primary & Foreign Keys
  • CRUD Operations, SQL Joins, Grouping
  • Subqueries
  • Introduction to Git, Staging Environment, Commit, Branch, Branch Merge
  • Introduction to GitHub Pull from GitHub, Push to GitHub, GitHub Branch, Pull
  • Branch from GitHub, Push Branch to GitHub, GitHub Flow and Pages
  • Git Contribute - GitHub Fork, Git Clone from GitHub, GitHub Send Pull Request
  • Git Advanced - Git Security SSH, GitHub Add SSH
  • Git Undo - Revert, Reset and Amend
Enquire Now