
Mastering HTML, CSS, and PHP for Dynamic Websites
Integrate frontend and backend technologies to create responsive and interactive websites.

Track
Software Development
Level
Intermediate
Language
English
Duration
30 hours
Learning Mode
Learn at ALC or at Home
Introduction
- Explain ACID properties, transaction states, and concurrency control mechanisms.
- Demonstrate lock-based protocols and deadlock prevention techniques.
- Create triggers for automating database operations using BEFORE, AFTER, and INSTEAD OF triggers.
- Analyze authentication methods, SQL injection prevention, and access control mechanisms.
- Design structured web pages using HTML elements, forms, and attributes.
- Implement CSS properties, layouts, and responsive design techniques.
- Integrate PHP with HTML and CSS to create dynamic web pages.
What you'll learn ?
- Apply locking techniques to ensure database consistency.
- Develop triggers to automate database modifications.
- Analyze and apply SQL security measures to protect against unauthorized access.
- Construct static web pages with forms, tables, and multimedia elements.
- Implement CSS styling techniques for modern and responsive web layouts.
- Develop PHP scripts that interact with web pages dynamically.
- Structure PHP projects effectively using namespaces.
Syllabus
Transaction Control
- ACID Properties
- Transaction States
- Lost Update Problem
- Serial schedule vs non-Serial schedule
- View and Conflict Serializability
- Examples
Locking in DBMS & Deadlock
- lock Based protocol in DBMS and its properties
- Properties of Lock Based protocol
- Conservative locking
- Rigorous Locking
- Strict locking
- Deadlock handling
- Deadlock prevention
Triggers
- Need for Trigger
- Trigger in SQL
- Trigger Example
- Instead Trigger
- Instead Trigger Example
Security and Authorization in SQL
- Security
- Authentication
- Authorization
- Difference between authentication and Authorization
- SQL Injection
- Stored Procedure
- Stored procedure for select
- Stored procedure for update
- Stored procedure for delete
- Stored procedure for insert
- Single procedure
HTML
- Introduction
- Creating Basic Html file
- html Elements
- html heading
- html paragraph
- Including link and images
- Example showing Demo of all
HTML formatting
- Introduction
- html styles
- html Quotation
- html comments
- html colour
- html list
- html block inline and outline
HTML forms & Tags
- Introduction
- html Forms Attributes
- html Forms Elements
- html Input Types
- html Input Attributes
- Html Listing Tags
- html marquee Tag
- html perforated and horizontal rule
- html audio Tag
- Html Audio Tag
- html Anchor Tag
- html Website Layout
CSS
- Introduction
- CSS Syntax
- CSS Selectors
- Multiple style sheet
- Cascading order
- CSS background with examples
CSS Styling
- CSS Borders
- CSS margin
- CSS Padding
- CSS Height and width
- CSS box model
- CSS z index
- CSS Overflow
- CSS Align
- CSS forms
- CSS counter
- CSS Website Layout
CSS Responsive
- CSS viewport
- CSS container and Grid
- CSS Image and video
- PHP Basics
PHP Basics
- HTML Embedding
- Comments
- Variables
- Constants
- String & int
- Float & Boolean
- Object, Null &array
- Resource
Practical PHP
- PHP Forms
- How to create form
- PHP form with live examples
- PHP Date and time
- Building PHP Scripts
- Example
PHP using JavaScript and jQuery validation
- PHP JavaScript using name validation
- PHP JavaScript using for range validation
- PHP JavaScript using field validation
Namespace in PHP
- Introduction
- Sub Namespace
- Multiple Namespace
- Global Namespace
- Namespace with PHP build in Names
- Namespace use operator
Cookies & Sessions
- Cookies
- Creating, accessing & deleting cookie
- Replace and append cookie
- Session
- Query String
- Example of Query String
Work-Centric Approach
The academic approach of the course focuses on ‘work-centric’ education. With this hands-on approach, derive knowledge from and while working to make it more wholesome, delightful and useful. The ultimate objective is to empower learners to also engage in socially useful and productive work. It aims at bringing learners closer to their rewarding careers as well as to the development of the community.
- Step 1: Learners are given an overview of the course and its connection to life and work
- Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
- Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
- Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
- Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
- Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
- Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
- Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
- Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
- Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
- Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
- Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!