Curso
E-learning-Transact-Sql
In this T-SQL training course you will learn about the Transact-SQL that expands on the SQL standard. The query language that uses Microsoft SQL Server is a variant of the ANSI-standard Structured Query Language, SQL. The SQL Server variant is called Transact-SQL. Database developers and database administrators must have a thorough knowledge of Transact-SQL to read data from and write date to SQL Server databases. Using Transact SQL is the only way to work with the data.
Esse curso inclui:
Suporte em tempo real
Certificado
Carga horária:
8 horas
(8 aulas)
Aula 1 - Types of joins
In this first lesson you will learn about how to, when use and the types of joins used by TSQL in Sql Server.
Aula 2 - CASE expression
In this second lesson you will learn the importance of determine the amount of columns to return and how to create subqueries.
Aula 3 - PIVOT operators, Full Text Search function and the TABLESAMPLE clause
In this third lesson you will learn about PIVOT operators, Full Text Search function and the TABLESAMPLE clause.
Aula 4 - System Functions
In this fourth lesson we will learn about using system functions.
Aula 5 - User Defined Functions, Column Alias, Temporary Tables and the Select Into Clause
In this fifth lesson we will learn about Column Alias, Temporary Tables and the Select Into Clause.
Aula 6 - Use of transactions
In this lesson you will learn about the use of transactions.
Aula 7 - TRY and Catch Blocks
In this lesson you will learn about how to handle errors using TRY and Catch Blocks.
Aula 8 - T-SQL Debugger
In this video we will see how to debug a programable object in SQL Server, such as a stored procedure or a user defined funcion.
Veja outros cursos de Canal Mais
Oracle PL SQL Course
T-SQL Step by Step Course
Introduction to MongoDB