SQL and Transact-SQL (T-SQL) For Beginners

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

Tags:

Tutorial Bar
Logo