SQL For Web Developers

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.

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.

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.

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.

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.

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.