sql tutorial

Data

Transaction SQL tutorial : SQL Commit and Rollback

A great tutorial on the ACID capabilities of SQL. A transaction is the propagation of one or more changes to the database. For example, if you are creating a record or updating a record or deleting a record from the table, then you are performing transaction on the table. It is important to control transactions […]

Read More
Data

Normalization In SQL Tutorial

Normalization in SQL is a fundamental concept of database design. In this video, you will learn the basics of normalization and understand the different types of keys in a database. In this video, you will look the various types of normal formals and address issues such as partial dependency and transitive dependency. You will understand […]

Read More
Data

Database Design Course for Beginners

This database design course by Caleb Curry will help you understand database concepts and give you a deeper grasp of database design. Contents / Time stamps: ⌨️ (0:00:00) Introduction ⌨️ (0:03:12) What is a Database? ⌨️ (0:11:04) What is a Relational Database? ⌨️ (0:23:42) RDBMS ⌨️ (0:37:32) Introduction to SQL ⌨️ (0:44:01) Naming Conventions ⌨️ […]

Read More