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 -- User-defined functions -- Transactions and locks -- Triggers -- A brief XML primer -- Reporting for duty, sir! A look at reporting services -- Playing administrator.