Recently, I was asked to share my SQL experience with an interested professional. Since it has almost been three years since this coursework, I struggled to remember the training received.
I have been out of school now for over two years. My last SQL class was Spring term 2012. This class was an Advanced SQL class. We used Microsoft® SQL Server® 2008 Management Studio Express along with AdventureWorksLT database throughout our coursework.
Later that day after being asked to share my SQL knowledge, I remembered that I had samples of my knowledge on an old, now useless WordPress site. This site was originally created with intent to share knowledge I acquired over the years in school and work, etc. The samples were practice questions for my Advance SQL final. It was acceptable to use these problems as notes during our final, so I placed them on web pages so I could reference using another screen.
Since I still have these sample question posts, I figure I can share them on this new website I am creating (stantonlesieur.com).
If interested, here are some items to know:
I believe the database for some of these sample problems can be found here: AdventureWorksLT2008 database.
Additionally, we were given another database called Northwind.
I used the following reference books:
- Microsoft SQL Server 2008: T-SQL Fundamentals (MSPress, 2008)
- Inside Microsoft SQL Server 2008: T-SQL Querying (MSPress, 2009)
- Inside Microsoft SQL Server 2008: T-SQL Programming (MSPress, 2009)
Sample of my SQL Knowledge
Here are links to each sample question; notes for my class SQL final:
- SQL Question 1
- SQL Question 2
- SQL Question 3
- SQL Question 4
- SQL Question 5
- SQL Question 6
- SQL Question 7
- SQL Question 8
- SQL Question 9
- SQL Question 10
- SQL Question 11
- SQL Question 12
- SQL Question 13
- SQL Question 14
- SQL Question 15
- SQL Question 16
- SQL Question 17
- SQL Question 18
- SQL Question 19
- SQL Question 20
- SQL Question 21
- SQL Question 22