Very Very good full range summary of functionality in Transact Sql
T-SQL Online Training
Learn T-SQL from scratch with no prior experience.
Lectures -45
Duration -4.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
T-SQL is a powerful extension of the SQL language from Microsoft. This course will help you master the fundamentals of T-SQL from scratch. If you are interested in building a career in database administration or development, this course is for you.
T-SQL Online Training Overview
T-SQL Online Training is designed for beginners and includes a comprehensive set of learning materials. This course is a great way to learn the basics of T-SQL. You will learn how to use T-SQL to manage data in a Microsoft SQL Server database. The course will cover the following topics:
T-SQL basics: This section will cover the fundamentals of T-SQL, such as data types, variables, operators, and statements.
T-SQL DQL statements: This section will cover the Data Query Language (DQL) statements, which are used to retrieve data from a database.
T-SQL DDL statements: This section will cover the Data Definition Language (DDL) statements, which are used to create, modify, and delete database objects.
T-SQL DML statements: This section will cover the Data Manipulation Language (DML) statements, which are used to insert, update, and delete data from a database.
T-SQL constraints: This section will cover the constraints that can be used to enforce data integrity in a database.
T-SQL advanced: This section will cover more advanced topics in T-SQL, such as stored procedures, triggers, and transactions.
Goals
Use T-SQL to manage data in a Microsoft SQL Server database.
Write T-SQL statements to retrieve, insert, update, and delete data.
Create and use T-SQL constraints to enforce data integrity.
Use T-SQL stored procedures, triggers, and transactions to automate tasks and manage data.
Gain the skills you need to start a career as a database administrator or developer.
Prerequisites
Basic understanding of databases.
Basic knowledge of the English language.
![T-SQL Online Training T-SQL Online Training](https://d3mxt5v3yxgcsr.cloudfront.net/courses/2117/course_2117_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
T-SQL Basics
5 Lectures
-
T-SQL - Overview 10:22 10:22
-
T-SQL - Server Overview 03:43 03:43
-
T-SQL - Environment Setup 07:30 07:30
-
T-SQL - Data Types 05:59 05:59
-
T-SQL - Getting Started 12:06 12:06
T-SQL DQL Statements
12 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
T-SQL DDL Statements
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
T-SQL DML Statements
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
T-SQL Constraints
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
T-SQL Advanced
12 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Tutorialspoint](https://www.tutorialspoint.com/assets/profiles/154476/profile/200_2935653-1686047025.jpg)
Tutorialspoint
Simple and Easy Learning
Tutorials Point originated from the idea that there exists a class of readers who respond better to online content and prefer to learn new skills at their own pace from the comforts of their drawing rooms.
The journey commenced with a single tutorial on HTML in 2006 and elated by the response it generated, we worked our way to adding fresh tutorials to our repository which now proudly flaunts a wealth of tutorials and allied articles on topics ranging from programming languages to web designing to academics and much more.
40 million readers read 100 million pages every month
Our Text Library Content and resources are freely available and we prefer to keep it that way to encourage our readers acquire as many skills as they would like to. We don't force our readers to sign up with us or submit their details either to use our Free Text Tutorials Library. No preconditions and no impediments, Just Simply Easy Learning!
We have established a Digital Content Marketplace to sell Video Courses and eBooks at a very nominal cost. You will have to register with us to avail these premium services.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Feedbacks
good
Hi I am Oracle DBA with 20 years of experience working with Oracle. Wanted to learn SQLSERVER. This class was very helpful. Tutor is excellent.
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)