Normalization and its Types: 1NF, 2NF, 3NF, and BCNF
Summary: In this tutorial, we will learn what is normalization and what is its purpose in DBMS. In addition, we will also look at different types of normal forms (such…
Articles related to core DBMS topics such as normalization, DDL & DML statements, ACID properties, different databases, etc.
Summary: In this tutorial, we will learn what is normalization and what is its purpose in DBMS. In addition, we will also look at different types of normal forms (such…
The TRUNCATE TABLE statement is faster and more efficient than the DELETE statement in SQL databases. This is because TRUNCATE TABLE is a DDL command, unlike DELETE it does not…
Summary: In this tutorial, we will learn to update a table in MySQL using the UPDATE TABLE statement. Introduction to MySQL UPDATE statement The UPDATE statement in MySQL updates existing…
Summary: In this tutorial, we will learn what are Joins in MySQL, what are the different types of MySQL Joins and how and when to use different joins in MySQL.…
Summary: In this tutorial, we will learn how to use MySQL INSERT INTO statement to insert records into a MySQL table along with examples. Introduction to MySQL INSERT INTO statement…
Summary: In this post, we will discuss everything about the MySQL Temporary table. Introduction to MySQL Temporary Table A temporary table in MySQL is a special type of table which…
In this post, we will discuss all MySQL Data Types along with their properties, so that at the time of designing a new database, we would be able to use…
Summary: In this post, we will learn to create a new table like another existing table using the CREATE TABLE statement in MySQL. Introduction to CREATE TABLE LIKE and CREATE…
Summary: In this post, we will learn how to rename an existing table using the MySQL RENAME TABLE statement in MySQL. Introduction to RENAME TABLE The general syntax to rename…
In our earlier post, we discussed how to create a new user account in MySQL. Now in this post, we will discuss how to delete a MySQL user account using…