Part II: Programming with T-SQL
Congratulations on finishing your first week! You now have a pretty good working knowledge of SQL to get by in most common situations. The first week taught you quite a bit about the SELECT statement. In the second week, you will start learning some of the more advanced SQL topics.
On Day 8, "Defining Data," you will learn how to create databases, tables, and columns using DDL or Data Definition Language. This enables you to manipulate the database without having to use one of the Windows-based tools such as Enterprise Manager.
On Day 9, "Indexes and Performance," we will take a look at how adding indexes to your tables will affect the performance of your SQL queries. In addition, you will learn how to use a ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
