T-SQL Online Training

Name: T-SQL Online Training
Rating: 4.2 (220 reviews)
Author: Tutorialspoint

Learn T-SQL from scratch with no prior experience.

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Tutorialspoint

category icon Development,T SQL

Lectures -45

Duration -4.5 hours

4.2 ★★★★ ★

Enroll Course

Training 5 or more people ?

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

What will you learn in this course:

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

What are the prerequisites for this course?

Basic understanding of databases.
Basic knowledge of the English language.

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

T-SQL DDL Statements
6 Lectures

T-SQL DML Statements
4 Lectures

T-SQL Constraints
5 Lectures

T-SQL Advanced
12 Lectures

Instructor Details

Tutorialspoint

Simply 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.