Getting started with MySQL, Data Types, SELECT, Backticks, NULL, Limit and Offset, Creating databases, Using Variables, Comment MySQL, INSERT, DELETE, UPDATE, ORDER BY, Group By, Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ..., Joins…

Getting started with Oracle Database, Getting started with PL/SQL, Anonymous PL/SQL Block, PL/SQL procedure, Data Dictionary, Dates, Working with Dates, DUAL table, JOINS, Handling NULL values, String Manipulation, IF-THEN-ELSE Statement, Different ways to…

Getting started with PostgreSQL, Data Types, Dates, Timestamps, and Intervals, Table Creation, SELECT, Find String Length / Character Length, COALESCE, INSERT, UPDATE, JSON Support, Aggregate Functions, Common Table Expressions (WITH), Window Functions and…

Getting started with SQL, Identifier, Data Types, NULL, Example Databases and Tables, SELECT, GROUP BY, ORDER BY, AND & OR Operators, CASE, LIKE operator, IN clause, Filter results using WHERE and HAVING, SKIP TAKE (Pagination), EXCEPT, EXPLAIN and DESCRIBE…