MYSQL

Comprehensive MySQL guide covering database design, queries, joins, indexing, and performance optimization.

59 Topics Beginner to Advanced 5+ Hours

This SQL section of the Web Application Backend Development course provides a comprehensive guide to managing, querying, and securing relational databases. Learn essential SQL concepts including SELECT statements, filtering, joins, aggregate functions, stored procedures, constraints, indexes, views, and database design. The tutorial also covers database creation, table management, data manipulation, and security topics such as SQL Injection prevention. By mastering these skills, you'll build a strong foundation for Web Application Development and efficient database management.

SQL Introduction

Syntax

Select statement

Select Distinct

WHERE Clause

Order By

SQL AND Operator

SQL OR Operator

SQL NOT Operator

SQL LIKE

SQL IN

SQL BETWEEN

SQL INSERT INTO

SQL NULL Values

SQL UPDATE

SQL DELETE

SQL TOP, LIMIT, FETCH FIRST or ROWNUM Clause

SQL MIN() and MAX() Functions

SQL COUNT() Function

SQL SUM()

SQL AVG()

SQL Aliases

SQL JOIN

SQL INNER JOIN

SQL LEFT JOIN

SQL RIGHT JOIN

SQL FULL OUTER JOIN

SQL Self Join

SQL UNION

SQL GROUP BY

SQL HAVING

SQL EXISTS

SQL ANY and ALL

SQL SELECT INTO

SQL INSERT INTO SELECT

SQL CASE

SQL NULL Functions

SQL Stored Procedures

SQL Comments

SQL Operators

SQL CREATE DATABASE

SQL DROP DATABASE

SQL BACKUP DATABASE

SQL CREATE TABLE

SQL DROP TABLE

SQL ALTER TABLE

SQL Constraints

SQL NOT NULL

SQL UNIQUE Constraint

SQL PRIMARY KEY

SQL FOREIGN KEY

SQL CHECK Constraint

SQL CREATE INDEX

SQL AUTO INCREMENT

SQL Dates

SQL Views

SQL Injection

SQL Hosting

SQL Data Types

Online Learner helps developers master programming, database concepts, interview preparation, and real-world implementation through structured learning paths.

MYSQL

Quick Links

Company