Join Simon Allardice for an in-depth discussion in this video Introduction to Transact-SQL, part of SQL Server 2008 Essential Training.
- View Offline
- Exercise Files
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…referred to as procedural or imperative languages.…
- Using T-SQL (Transact-SQL)
- Managing databases with SQL Server Management Studio
- Understanding database normalization
- Using SELECT statements
- Building indexes
- Monitoring database size and integrity
- Backing up and restoring databases
- Creating functions and stored procedures
- Managing database permissions
- Creating and formatting reports
- Adding charts to reports
- Creating and executing a simple SSIS package
Skill Level Beginner
1. Getting Started
2. Installing SQL Server 2008 R2
3. Tools and System Databases
SQL Server system databases2m 22s
4. Creating Databases
5. Importing Existing Data
6. Retrieving Data with SQL
7. Inserting and Updating Data
8. SQL Functions
9. Stored Procedures and Transactions
10. Core Administration Tasks
11. Backing Up and Restoring
12. Security Features
13. Reporting Services
14. Integration Services
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.