Curso
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, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL.
Esse curso inclui:
Suporte em tempo real
Certificado
Carga horária:
37 horas
(10 aulas)
Aula 1 - Introduction
In this video, we will start our course on T-SQL. T-SQL is Microsoft version of SQL.
Aula 2 - Select Statement
In this video, we will start discussing the select statement. We will start writing queries against the AdventureWorks 2012 database.
Aula 3 - Functions
In this video, we will discuss some of the T-SQL functions that we need in our day-to-day development.
Aula 4 - Working with mathematical and date functions
In this video, we will continue the discussion of some of the T-SQL functions that we need in our day-to-day development.
Aula 5 - Working with numbers, strings and dates in Select Statement
In this video, we will continue the select statement discussion.
Aula 6 - Use Statement
In this video, we will continue the select statement discussion.
Aula 7 - Group by
After discussing the ‘use’ statement in the previous video, now we move to the group by, distinct, top and count clauses.
Aula 8 - Percent Keyword
In this video, we will discuss the use of the ‘percent’ keyword, also we will talk about the use of ‘with ties’ when using ‘top’ and what effect it will have on the result and finally we will see the use of comments (single line and multi-line comments).
Aula 9 - Paging in SQL
In this video, we will talk about paging. If you have done any work with web page technologies, you would know that paging is an important concept.
Aula 10 - DataType
In this video, we will discuss data types. Data types are very important when it comes to creating tables and working with variables.
Veja outros cursos de Canal Mais
Oracle PL SQL Course
Introduction to MongoDB
Course OLAP with open source tools