Transact- SQL (T-SQL) For Beginners

preview_player
Показать описание
Transact-SQL (T-SQL) is Microsoft's own implementation of the Structural Query Language (SQL)
T-SQL can be used to perform CRUD (Create |Read|Update|Delete) operations on an SQL Server.
CRUD is the post popular operations you can perform on any database system.

This video will teach you :

How to install Microsoft SQLServer
How to create a new database
How to create a table
How to insert data into a table
How to delete records from a table
How to truncate a table
How to drop a table
How to drop a database

Video Content:

00:00 What is SQL Server
00:02 Hardware and Software Requirements
00:06 Install SQL Server Developer Edition 2019
00:22 Installing SQL Server Management Studio (SSMS)
00:27 Connecting to SQL Server with SSMS
00:35 What is SQL
00:38 What is T-SQL
00:40 What is CRUD
00:41 Creating a new database
00:44 Creating a new table
00:50 Inserting Records into a table
00:56 Reading data from a table
01:02 Updating records in a table
01:07 Deleting Records from a table
01:11 Truncate table
01:13 Drop Table
01:15 Drop Database

Get Free Udemy Course Coupons
Рекомендации по теме