SQL For Web Developers

Learn sql fundamentals by creating a school management database, defining classes and subjects tables with primary keys, auto_increment, and varchar fields, and performing create and read operations.

Define streams and students tables with bigint unsigned primary keys, foreign keys to classes, and on delete set null, establishing form and stream relationships across the school schema.

Create exams, student_details, activities, and school_settings tables with primary and foreign keys, compute exam averages and student ranks, assign remarks, track teachers and timestamps, and enforce on delete cascade.

Learn to insert data into related tables using SQL insert into statements for classes, subjects, streams, and students, respecting parent-child relationships and foreign keys.

Insert data into exams, student_details, activities, and school_settings tables using insert statements. The video explains primary and foreign keys, and fields like student_id, subject, exam1–3, average, grid, points, and teacher.

Learn to write basic select queries across the classes, streams, and subjects tables, selecting all or specific columns, using where, order by, and limit clauses.

Learn to perform inner joins and left joins between streams and classes tables, use on and where clauses, and apply multiple conditions for refined web development SQL queries.

Master advanced sql concepts such as subqueries with in and where, multiple joins across streams, students, and classes, and aggregation with count and group by.

Demonstrates inner joins across students, exams, and subjects to display student name, admission number, exam, average, grade, and subject name.

Learn sql to join students with their details and activities using inner and left joins across students, student_details, classes, and streams to display names, admission numbers, class, stream, and activities.

Explore update and delete operations in SQL for web developers, updating single or multiple columns, calculating averages, and filtering changes with where clauses on students and exams.

Learn to perform update using inner join to increment a student's form sequence number, and execute various delete operations (with and without joins) across students, exams, and student activities.

Drop tables safely by removing dependent tables in reverse order of dependencies, account for foreign keys, and understand that dropping a table removes it entirely and requires recreation.

Build a school management system with Laravel query builder by creating a new Laravel project, configuring MySQL, and running migrations to create necessary tables.

Create and relate all tables for a school database with Laravel migrations, defining classes, streams, subjects, students, exams, and student details and activities with foreign keys and cascade rules.

Explains cascade on delete to prevent orphaned records when deleting a parent entry. Shows how to set up a Laravel layout, routes, and a class controller using the query builder.

Builds Laravel class views by creating the index and Blade files, looping through the classes table, and wiring routes, controllers, and a store method to insert and display classes.

Create and wire a stream controller using php artisan make:controller, build a query that joins streams with classes on class_id, and render streams index and create views.

Create a Laravel student controller with PHP artisan, list students by joining streams and classes, and implement create and edit flows with validation and redirects.

Learn to implement update and delete operations for students in a Laravel app using query builders, including validation, existence checks, and index and view scaffolding.

Builds a create student view with a Blade form for name, admission number, class, stream, and term, wired to the store route with validation and class-stream relationships.

Learn to implement the student edit method, including routing, the edit view, and update logic with joins to streams and classes.

Create a student details controller and implement create, show, and store methods that join students, streams, and classes, validate input, insert details via db, and redirect with success.

Create the student_details view and connect routes and a controller to show and store student details via post. Display admission number, class, and stream using object property access.

Use query builders to create a student_activities controller and create view with PHP artisan, implementing create, store, and show methods, with nullable fields, and joining students to streams and classes.

Master query builders to create a student_activities show view and routes, implementing show, create, store, and related navigation in a Laravel 11 student report system.

Develop the exams management workflow with an exams controller, implementing create, store, and show, joining students, streams, classes, and subjects, and calculating averages, grids, and points.

Create exams views in blade to post student exam data, populate subjects from the subjects table, and show exam results with subject, exams, average, and remarks.

Create a subject controller with index, create, and store methods to manage subjects, render subject index and create views, validate input, and save subject names via routes.

Develop a show_report method in the student controller to generate a comprehensive student report by joining students, streams, classes, details, exams, and activities, including average scores and subject-wise performance.

Learn to build show_report views using query builders to assemble a comprehensive student report with basic information, academic background, overall average, subjects taken, subject-wise performance, and co-curricular activities.

Learn Laravel Eloquent, an ORM that simplifies database interactions by creating models (exams, students, streams, subjects) with PHP artisan, defining fillable fields and one-to-many and belongs-to relationships.

Set up Laravel Eloquent models for student, subject, and exams by defining 1-to-1 details and activities and 1-to-many exams, with belongs-to relations to class and stream.

Calculate the exam average and grid in the exam model by filtering exams, and create a student_details model with a belongs-to relation to student and fields student_id, primary_school, and kcp.

Refactor the student controller to use Laravel Eloquent models, add a student activity model, and implement eager loading, unique admission number validation, and CRUD for class and stream relations.

Refactor the student report using Laravel Eloquent relationships and eager loading to fetch stream and class names, calculate averages, and assemble subject performance, exams, and activities in the student report.

Refactor the show report method with Eloquent relationships, replacing object property access and updating overall average and subject performance in the report blade.

Refactor the class and subject controllers using Laravel Eloquent to replace raw DB queries with Eloquent methods, fetch classes with counts, validate requests, and create records efficiently.

Refactor the exam controller with Laravel Eloquent, eager loading related student, class, and stream data, validating requests, and delegating average and points calculations to the exam model.

Refactor the Laravel Eloquent student activity controller to create and list student activities by joining class, stream, and student data, then render the view with compact data.

Refactor the student details controller with Laravel Eloquent to fetch a student along with class and stream, and to create student details using Eloquent relationships.