From the course: SQL Server 2008 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Introduction to Transact-SQL - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
Introduction to Transact-SQL
Structured Query Language or SQL is the common language that lies at the heart of not only Microsoft SQL Server, but every RDBMS that you're likely to use. Now, you've probably noticed the different pronunciation of this. Some people say "Sequel." Others say "S-Q-L." I tend to say S-Q-L when I talk about the original language itself and "Sequel" when it's combined as an SQL Server, T-SQL or MySQL. SQL the language has been around since the 70s. It's actually one of the few languages that I was writing 25 years ago and I'm still writing now. A lot of programming languages have come and gone, become fashionable and unfashionable, but SQL has stuck around and I still expect it to stay for a long time to come. Now SQL is a pretty small language and the key to learning it is to understand that it's a little different from other programming languages you might have come across, things like C, Java, or Python. SQL is what's called a declarative language whereas those others are what are…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
Introduction to Transact-SQL3m 43s
-
Using SELECT statements7m 16s
-
Changing the default database2m 21s
-
Creating conditions in SQL8m 10s
-
Sorting your output3m 23s
-
Using aggregate functions7m 12s
-
Finding unique values2m 14s
-
Joining multiple tables together8m
-
Using subqueries9m 33s
-
Viewing execution plans3m 37s
-
-
-
-
-
-
-
-
-
-