SQL 101

Sunrise on Phu Chi Fa
Time to learn!

After helping others learn SQL for several years now, I keep coming back to the same topics over and over.  So, I decided to write down these SQL tutorials, and continually improve them over the years.  What I’ve been able to collect here is just the introduction.

This series is an introduction to Microsoft SQL database programming.  You’ll need to have a good grip on these concepts before the other classes will be as useful to you.  I plan to create several more classes in addition to this class.

  • x01 series will be database programming
  • x02 series will be database administration
  • x03 series will be database architecture
  • x04 series will be about data mining and analysis

I may add in more series as I go, but for now, all the stuff I’ve taught fits easily into one of these categories.  Let me tell you about the lesson plan.


  1. What is a database — Introduction, vocabulary, and basic concepts
  2. SELECT — Getting data out of your database
    1. Filtering Results — limiting the number of results you get
    2. Filtering Results (Part 2)
  3. Advanced LIKE Clauses — an introduction to pattern matching strings in Microsoft SQL
  4. Calculated Fields — Concatenating and performing mathematics
  5. Summarizing Data — counting, finding the maximum and minimum values
  6. GROUP BY — grouping together similar data
  7. Sub Queries — using one query as a value in another
  8. JOIN — using the relationship part of relational database system
  9. INSERT — putting data into your database
  10. UPDATE — making changes to your data
  11. TRANSACTION — as good as a bullet-proof vest!
  12. DELETE — removing data from your database

These articles are here to help you understand Microsoft SQL.  If you have any questions, comments, or concerns, please let me know.  I can only teach you what you want to learn, if you let me know what that is!

Let’s Get Started >

By Shannon Lowder

Shannon Lowder is the Database Engineer you've been looking for! Look no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.


  1. Pingback: Sunrise on Phu Chi Fa

Leave a comment

Your email address will not be published. Required fields are marked *