Notebooks

  Advanced

New Page

Garbage Collection

Learning about garbage collection in Java.

Basics of SQL

Introduction to SQL, its purpose and its comparison with NoSQL.

SQL vs MySQL

Understanding the differences and similarities between SQL and MySQL.

Relational Databases

Introduction to the concept of relational databases.

SQL Commands

Understanding the different SQL commands including DDL, DML, TCL, and DCL.

Database Connection

Learning about database connection in PHP and MySQL.

SQL Keys

Understanding the different types of SQL keys including primary key, foreign key, candidate key, super key, unique key, and surrogate key.

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.