Notebooks

  Advanced

New Page

SQL Normalization

Introduction to SQL normalization and its forms including 1NF, 2NF, 3NF, and BCNF.

SQL Transactions

Understanding the basics of SQL transactions and ACID properties.

SQL Triggers

Understanding the basics of SQL triggers and how to use them.

SQL Cursors

Introduction to SQL cursors and their usage.

SQL Indexing

Understanding the basics of SQL indexing and its importance.

SQL Stored Procedures

Introduction to SQL stored procedures and how to create them.

SQL Security

Understanding SQL security and how to prevent SQL injection.

SQL Queries and Set Operations

Understanding SQL queries, set operations, and keywords.

SQL Clauses

Introduction to SQL clauses including WHERE, HAVING, and GROUP BY.

SQL Subqueries

Introduction to SQL subqueries, including correlated and non-correlated subqueries.