Master Laravel, optimized database queries

Explain the Laravel request lifecycle and the role of the Service Container.

Differentiate between Facades, helper functions, and dependency injection for accessing services.

Bind and resolve services from the container manually and using automatic injection.

Implement advanced routing patterns including route model binding customization and rate limiting.

Organize controller logic using Form Requests for validation.

Implement custom exception handling for application-specific errors.

Explain the principles of database normalization (1NF, 2NF, 3NF).

Design a normalized database schema for a given application specification.

Create and manage database schema using Laravel migrations.

Define foreign key constraints and indexes within migrations.

Seed the database with realistic test data using model factories and seeders.

Apply accessors, mutators, and attribute casting to transform model data.

Implement local and global query scopes to create reusable query constraints.

Define and query polymorphic relationships for flexible data structures.

Utilize subqueries and advanced relationship queries (whereHas, withCount) for complex lookups.

Identify the N+1 query problem and resolve it using eager loading ('with').

Use constrained and nested eager loading for optimizing complex relationship queries.

Implement soft deletes to manage non-destructive record removal.

Configure a Laravel application to connect to a Microsoft SQL Server (MSSQL) database.

Write complex SELECT queries in MSSQL using JOINs, GROUP BY, and window functions.

Translate complex SQL queries into Laravel's Query Builder syntax.

Execute raw SQL queries securely within Laravel when necessary.

Evaluate the trade-offs between using Eloquent ORM, the Query Builder, and raw SQL.

Analyze MSSQL query performance using execution plans to identify bottlenecks.

Create and manage clustered and non-clustered indexes to optimize query speed.

Resolve inefficient table scans by applying appropriate indexing strategies.

Optimize queries involving sorting, filtering, and aggregation in MSSQL.

Process large datasets efficiently using 'chunkById' and 'cursor' methods.

Implement query caching to reduce database load on frequently executed queries.

Build API Resource classes to control and standardize JSON responses.

Use Resource Collections to format paginated and grouped data.

Conditionally include attributes and relationships in API resources.

Implement a URI-based API versioning strategy using route groups.

Generate API documentation from code using Swagger/OpenAPI standards.

Implement secure password storage using Laravel's hashing mechanisms.

Explain how Laravel's ORM and Blade templating help prevent SQL Injection and XSS attacks.

Implement Cross-Site Request Forgery (CSRF) protection for web routes.

Configure Cross-Origin Resource Sharing (CORS) for your API.

Apply API rate limiting and throttling to prevent abuse.

Implement session-based authentication for web applications using a starter kit like Breeze.

Implement token-based authentication for stateless APIs using Laravel Sanctum.

Define authorization rules for users using Gates.

Create and register Policies to organize authorization logic for specific models.

Authorize user actions within controllers and Blade templates.

Create and dispatch jobs to be processed asynchronously.

Configure and use different queue drivers, such as 'database' and 'Redis'.

Run queue workers to process jobs from the queue.

Implement strategies for handling and retrying failed jobs.

Offload long-running tasks like sending emails or notifications to a queue.

Process large file uploads and data imports using queued jobs.

Create and dispatch application events with corresponding listeners.

Use Eloquent observers to automatically dispatch events on model lifecycle hooks.

Configure Laravel for broadcasting events over WebSockets.

Broadcast events to public and private channels.

Configure Laravel Echo on the frontend to listen for broadcasted events.

Update a UI component dynamically in response to a received event.

Differentiate between unit, feature, and integration tests.

Write feature tests for API endpoints, asserting status codes and JSON structure.

Write unit tests for individual classes and methods, isolating their logic.

Test database interactions using transactions and factories to ensure a clean test state.

Use mocks and fakes to simulate dependencies and external services in tests.

Configure and run a full test suite using PHPUnit or Pest.