As some of you may know, I began work on a book titled Microsoft SQL Server 2008 Beginners Roadmap. I completed roughly around 100 pages and stopped working on the title. Nevertheless, there is plenty of useful information contained within the text. I will publish the following chapters online in the tutorials section of this website.
I will post the text in the tutorials section of this website. Hope you enjoy.
Chapter 1 – Database Fundamentals and SQL Server 2008
In this chapter we’ll examine the basics of the relational database structure. We’ll define a relational database management system (RDBMS) and how one can be used to structure data relationally. While there are many other widely used powerful RDBMSs, in this book we’re going to focus on that of Microsoft’s latest incarnation – SQL Server 2008. We’ll examine the power of Microsoft’s implementation while keeping with the general ease of use seen with many other Microsoft products, how Wizards can be used to simplify almost all administration tasks, and finally we’ll examine the Command Line Interface (CLI) distributed with SQL Server 2008.
Note that in this chapter we’ll keep it fairly simply and spend much of the time focusing on the GUI management interface; however the remaining portion of the book will focus more on Transact-SQL statements and commands as opposed to the GUI wizards.
Chapter 2 - Speak to me, Transact-SQL Fundamentals
In this chapter we’ll take a look at the basic SQL structure and how the different elements are broken into different sublanguages per the 12 rules defined by Dr. Codd. We’ll analyze Microsoft’s dialect to SQL, Transact-SQL (often referred to as simply T-SQL) and some of the supported features. We’ll also examine each available data type exposed by Transact-SQL as well as the basic syntax and how we can compose proper Transact-SQL code.
In the previous chapter, while we in fact did cover some Transact-SQL statements, we, for the most part stuck strictly to examining the different tools bundled with SQL Server 2008 and how common management and administrative tasks could be performed via the SQL Server Management Studio interface. This chapter should serve as an introduction to Transact-SQL so that we can begin developing, managing and administering database objects by way of Transact-SQL statements.