sql tutorial

Data SQL Server

SQL Crash Course for Beginners

When learning data science, students typically focus on Python or R for data analysis and machine learning. In the real world, data is usually stored in databases, and that data is best used by directly using SQL against the database.. This crash course is intended for beginners with no prior experience in SQL. By the […]

Read More
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