T-SQL Step by Step Course
Welcome everyone to the T-SQL course. Here you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2012 (which is a free download). As a sample, we will use AdventureWorks 2012 as our database. Along the way, we will be creating our own sample databases to illustrate some key points. But AdventureWorks 2012 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins,
Carga horária deste curso 37h
Conteúdo do curso
(37 aulas)
Aula 1 - Introduction
Aula 2 - Select Statement
Aula 3 - Functions
Aula 4 - Working with mathematical and date functions
Aula 5 - Working with numbers, strings and dates in Select Statement
Aula 6 - Use Statement
Aula 7 - Group by
Aula 8 - Percent Keyword
Aula 9 - Paging in SQL
Aula 10 - DataType
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