Part I: Working with Rows and Columns
Learning SQL to extract data from SQL Server is as simple as using the Select statement. On Day 1, "Introduction to SQL and the Query Analyzer," I will start by explaining what SQL really is and how it relates to databases. In addition, you will install the Query Analyzer and see how to use it to access data in SQL Server by using SQL.
On Day 2, "Filtering and Sorting Data," you will learn how to retrieve specific data and how to sort the data by using SELECT, WHERE, and ORDER BY.
Day 3, "Working with Columns," will discuss how to manipulate the data columns and what different types of data are available, such as integers and dates.
Day 4, "Working with Row Aggregates and Grouping," will show you how to ...
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.
