SQL Complte Guide with 146 LeetCode SQL Solution

What You Will Learn from Our Complete SQL Guide with 140+ LeetCode SQL Solutions
SQL and DBMS Introduction with Examples
SQL Basics
DBMS Overview
Types of SQL Commands
DDL : CREATE, ALTER, DROP, TRUNCATE
DML : SELECT, INSERT, UPDATE, DELETE
DCL : GRANT, REVOKE
Database Types: RDBMS, NoSQL & In-Memory Databases.
Key Types in SQL: Primary, Foreign, Composite & Surrogate Key
SQL Operators: Arithmetic, Comparison,Logical & Bitwise Operators
SQL Commands and Clauses
CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX
SELECT, INSERT INTO, UPDATE, DELETE
WHERE, IN, NOT IN, BETWEEN, LIKE
ORDER BY, GROUP BY, HAVING
CASE, JOIN, UNION, EXISTS
Aggregated Functions : COUNT, SUM, AVG, MIN, MAX
SQL Queries, Subqueries, Nested queries & Correlated Subqueries
SQL Data Types and Constraints
SQL Joins
Advanced Topics: RANK, DENSE_RANK, Triggers, Stored Procedures, Views, Truncate
LeetCode SQL Problems and Solutions
Easy: 68
Medium: 58
Hard: 20

pdf (digital copy)
• This item is NOT downloadable
• Refund is not available for this item
• Access item after purchase at My Account→Orders