I have attached the AdventureWorks 2012 database

Question

Now that I have attached the AdventureWorks2012 database, I'd like to learn everything that I can.  Is there a tutorial or guide that goes along with it?  With examples and projects to do?

Thanks!

Answer 1

Hello,

Many samples use AdventureWorks. SQL Server BOL uses AdventureWorks2012 extensively to illustrate SQL Server T-SQL. Please see the T-SQL code snippets at the bottom of each topic.

Transact-SQL Reference (Database Engine)

http://msdn.microsoft.com/en-us/library/bb510741

For instance,

Data Manipulation Language (DML) Statements (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ff848766

Data Definition Language (DDL) Statements (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ff848799

Built-in Functions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms174318

Control-of-Flow Language (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms174290

Stored Procedures in AdventureWorks (For SQL Server 2008, but still applies)

http://msdn.microsoft.com/en-us/library/ms124456(v=SQL.100).aspx

AdventureWorks Data Dictionary (For SQL Server 2008, but still applies)

http://msdn.microsoft.com/en-us/library/ms124438(v=sql.100)

Answer 2

This is great!  Thanks!