SQL and Transact-SQL (T-SQL) For Beginners
Learn SQL and T-SQL From Scratch and execute queries on SQL Server
What you’ll learn
-
How to install SQL Server Database Management System
-
How to install SQL Server Management Studio -SSMS
-
How to create a database
-
How to create a table
-
How to create a view
-
How to create a stored procedure
-
How to fetch data from a database with SELECT Statement
-
How to update existing records inside a database table
-
How to backup a whole database
-
How to delete records
-
How to truncate a table
-
How to drop a table
-
How to drop a database
-
How to restore a database from backup copy
Requirements
-
Access to SQL Server ( You will learn how to install a copy)
-
Access SQL Server Management Studio – SSMS ( You will learn how to install a copy)
Who this course is for:
- Beginners to SQL
- Beginners to Transact-SQL