RDBMS basics : what makes up a SQL server database? -- Tools of the trade -- The foundation statements of T-SQL -- JOINs -- Creating and altering tables -- Constraints -- Adding more to our queries -- Being normal : normalization and other basic design issues -- SQL server storage and index structures -- Views -- Writing scripts and batches -- Stored procedures.
Summary
This introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself. Progresses on to an explanation of how to implement fundamental concepts with the new 2008 version of SQL Server.