LankaPage.lk | Web App Dev + DB Management

🔥 LIVE Online Classes · Sri Lanka & Global

Master Web Apps
+ Database Management

Full-stack development, modern frameworks, SQL/NoSQL, real-world projects. From beginner to job-ready. Interactive online sessions with recorded backup.

🎓 500+ Students

📅 12+ Years Experience

💻 100% Practical

🧑‍🏫 A.G. Ananda Aberathne
B.Sc, M.I.T. (Master in Information Technology)

🚀 Start Free Trial Lesson

💻📘

Full Stack
+ DB Design

🎬 Featured YouTube Lessons

Watch hands-on tutorials covering PHP, Python, JavaScript, MySQL, MongoDB & modern web stacks.

🔰 Modern Web App Development with DB Integration

Learn how to connect front-end to back-end database (MySQL + Node.js)

🗄️ Database Management Essentials

Normalization, indexing, relationships, and cloud DB (MongoDB Atlas).

⚡ Full Stack CRUD Application

Step-by-step: React frontend, Node API, and MySQL database.

📺 View full YouTube playlist →

📖 Short Lessons — Learn Bite-Sized

Quick concepts you can apply immediately. Each lesson includes a code snippet or practical tip.

🔹 Lesson 1: Connecting PHP to MySQL (PDO) 5 min read

Secure database connection using PDO to prevent SQL injection. Example:

// db_connect.php
$dsn = "mysql:host=localhost;dbname=webapp_db;charset=utf8mb4";
$pdo = new PDO($dsn, "username", "password");
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

🔹 Lesson 2: JavaScript Fetch API + JSON 4 min read

How to fetch data from REST API and display dynamically.

fetch('https://api.example.com/users')
.then(res => res.json())
.then(data => console.table(data))
.catch(err => console.error(err));

🔹 Lesson 3: Indexing for Faster Queries 3 min lesson

Add indexes to speed up SELECT queries on large tables. Real-world impact.

CREATE INDEX idx_email ON users(email);
EXPLAIN SELECT * FROM users WHERE email = 'student@lankapage.lk';

🔹 Lesson 4: MongoDB CRUD with Node.js 7 min demo

Insert & find documents in NoSQL database for flexible data models.

const { MongoClient } = require('mongodb');
await client.db('lms').collection('courses').insertOne({ title: 'Web Dev', level: 'Advanced' });

📚 Access All 20+ Mini Lessons →

📌 Course Modules: Web App Dev + DB Management

🌐 Frontend Development

HTML5, CSS3, Tailwind, JavaScript (ES6), React.js basics. Responsive design, interactive UI.

⚙️ Backend & APIs

Node.js / Express, PHP, Python Flask, RESTful API design, authentication, JWT.

🗄️ Database Management

MySQL, PostgreSQL, MongoDB, Firebase. Query optimization, indexing, transactions, backups.

🚀 Deployment & DevOps

Git, GitHub, Vercel, AWS basics, Docker intro, CI/CD fundamentals.

🎯 What makes our course unique:
Live coding sessions, real group projects, and lifetime access to recorded classes. Instructor: A.G. Ananda Aberathne (B.Sc, M.I.T) with industry experience.

Join the Next Batch 🧑‍💻

Classes start every month | Limited seats | Live online via Zoom + recordings + hands-on projects

📲 Send inquiry via WhatsApp

📧 info@lankapage.lk 📞 +94 714394219

📍 Online classes for Sri Lanka & International Students — flexible schedules

Master Web Apps + Database Management