Home » Applied SQL »sql server »sqlserverpedia-syndication »SSC » Currently Reading:

Applied SQL: You Have Homework

August 17, 2011 Applied SQL, sql server, sqlserverpedia-syndication, SSC 9 Comments

I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything.  What do we really need to understand SQL Server and internalize it?  Practice.

Bearing this in mind, I’m starting up an Applied SQL series of blogs, with the sole purpose of giving you homework. You’re welcome.

No really, you’re very, very welcome.  If you work through the exercises in these blogs, you’ll start thinking, working, exploring, and really internalizing SQL Server. With any luck, you’ll start assigning yourself work as you read blogs and study books. 

So here comes the first of many blogs dedicated to Applied SQL. 

  • Each assignment includes prerequisites, reading, and different levels of assignments.
  • Read, work through, ask questions, and if you’re feeling froggy, post your solutions in the comments.
  • I will post my solution in the comments, too. I strongly recommend that you work out the solution on your own first. You will get a lot more out of figuring out your own solution (before reading mine), and there is often more than one way to get the correct result.
  • You can see ALL the Applied SQL blogs (including this one) on the Applied SQL page.
  • Since it’s universally available (and familiar), I’ll probably use AdventureWorks for my assignments and solutions.

And as always, if you have suggestions for Applied SQL topics, leave a comment or email me!

Happy learning,
Jen McCown

Currently there are "9 comments" on this Article:

  1. Colleen says:

    OOOoooooo! As a kid I hated homework. As an adult, I *love* homework!

  2. [...] Applied SQL ← Applied SQL: You Have Homework [...]

  3. [...] introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL [...]

  4. [...] Applied SQL: You Have Homework – As if your free time was not already in demand enough, Jen McCown (Blog|Twitter) is giving you homework. Remember that it’s compulsory that you get your homework done and being a traditional British institution here at SFTW we have ways of “encouraging” you to get it done. [...]

  5. [...] vital, it isn’t everything. What do we really need to understand SQL.View original post here: Applied SQL: You Have Homework | SQL Awesomesauce This entry was posted in Work From Home and tagged archives, august-2009, december-2009, [...]

  6. [...] introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL [...]

  7. [...] McCown (blog | twitter) recently last month started a new blog series on applied sql. The introductory post states, “…while studying is vital, it isn’t everything.  What do we really need [...]

  8. [...] introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL [...]

  9. Hello to every body, it’s my first pay a visit of this website;
    this weblog carries remarkable and genuinely excellent material for readers.

Comment on this Article:

Release Date: Minion by MidnightDBA

Just 22 hours 22 minutes 27 seconds until we release Minion Redindex: index maintenance done right!

MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

November 3-7: PASS Summit, Seattle, WA

PASS Summit: Jen is presenting How to Interview a DBA: A Panel Debate on Thursday 11/6 1:30pm, room 401 (along with Adam Machanic, Sean McCown, Bob Pusateri, and Michelle Ufford).

PASS Summit: Sean is presenting Performance Tuning Your Backups on Wednesday 11/5 3:00pm, room 602-604.

December 11: Presenting "Powershell Cmdlets.." at Alaska SQL Server User Group

January 30: "Become an Enterprise DBA" precon at Austin SQL Saturday

Blog Posts by Category


How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!


The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/