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.
Carga horária deste curso 8h
Conteúdo do curso
(8 aulas)
Aula 1 - Types of joins
Aula 2 - CASE expression
Aula 3 - PIVOT operators, Full Text Search function and the TABLESAMPLE clause
Aula 4 - System Functions
Aula 5 - User Defined Functions, Column Alias, Temporary Tables and the Select Into Clause
Aula 6 - Use of transactions
Aula 7 - TRY and Catch Blocks
Recomendado - 10 tips about SQL Server that every developer should know
Aula 8 - T-SQL Debugger
Para marcar o curso como favorito é preciso estar logado. Caso não tenha um cadastro DevMedia, clique aqui para se cadastrar (gratuito)
Curso adicionado aos favoritos. Clique aqui para ver todos seus favoritos