Database Triggers Guide: Syntax & Examples Explained
Learn how database triggers work in MySQL — BEFORE vs AFTER, OLD vs NEW keywords, SIGNAL SQLSTATE, and 10 real Accenture assessment MCQs with answers
divya sachan
SQL
11 NotesSQL Quick Recap: Mastering SQL Queries and Functions
Learn SQL queries, functions, and more with our comprehensive SQL quick recap. Master SQL basics, functions, and advanced topics.
divya sachan
Learn SQL Basics: Create Tables | Notehub Official
Learn SQL basics hands-on — create your first table, insert records with NULL values, and run SELECT queries to filter and retrieve real data.
divya sachan
SQL DML : Update, Delete, Filter and Sort Data | Notehub
Learn SQL DML Language with hands-on examples — update and delete rows, filter with WHERE and LIKE, sort with ORDER BY, and use column aliases on table.
divya sachan
Data Constraints: Implementing Rules on Tables Effectively
Learn all SQL data constraints — PRIMARY KEY, FOREIGN KEY, CHECK, UNIQUE, DEFAULT and NOT NULL — with a real two-table Employee and Department example.
divya sachan
Mastering Single Row Functions in SQL for Oracle | Notehub
Learn SQL single row functions in Oracle — character, number, date and conversion functions with real queries, expected outputs and practical explanations.
divya sachan
SQL Aggregate Functions: GROUP BY, HAVING & Examples
Learn SQL aggregate functions AVG, SUM, MIN, MAX, and COUNT with GROUP BY and HAVING. Includes 11 real Oracle SQL queries with expected outputs.
divya sachan
Mastering SQL Joins and Subqueries for Efficient Data
Master SQL Joins and Subqueries with 20 solved Oracle SQL queries. Covers INNER, LEFT, RIGHT, FULL OUTER JOIN, self-joins, and nested subquery patterns.
divya sachan
PL/SQL Basics: Loops, Cursors and Procedural Logic in Oracle
Learn PL/SQL basics with hands-on examples — FOR and WHILE loops, cursors, exception handling, SELECT INTO, and SQL%ROWCOUNT in Oracle SQL blocks.
divya sachan
SQL Views & Set Operations: CREATE VIEW With Examples
Learn how to create SQL Views using CREATE VIEW, WITH CHECK OPTION, and WITH READ ONLY. Includes Oracle SQL assignment queries with expected outputs.
divya sachan
SQL DDL Commands & Constraints: CREATE, ALTER & Examples
Learn SQL DDL commands CREATE, ALTER, DROP, RENAME and all constraint types with 11 solved Oracle SQL queries including PRIMARY KEY and FOREIGN KEY setup.
divya sachan