So you’re ready to dump that Excel “database” and join the SQL Server crowd? Take a whirlwind tour of Transact-SQL. You’ll learn a little about its history, what Data Definition Language (DDL) and Data Manipulation Language (DML) are, and how to write basic statements of your own. Finally, go home with some resources that will take your T-SQL skills to the next level.
Downloads
Zipped package of all Intro to TSQL materials including presentation, SQL Server scripts and read me.
Resources
- Edgar F. Codd’s A Relational Model of Data for Large Shared Data Banks
- Itzik Ben Gan’s T-SQL Fundamentals
- Jen McCown’s Blog
- Audrey Hammond’s blog on Datachix
- Aaron Bertrand’s blog on SQLblog
- Adam Mechanic’s Invite to the 1st T-SQL Tuesday
- Jorge Seggara’s SQL University
- T-SQL Reference in SQL Server Books Online
- Brent Ozar’s free Twitter book
- SQL Saturday Home
- PASS’ Virtual Chapters
- 24 Hours of PASS Videos