Skip to content

shannonlowder.com

Menu
  • About
  • Biml Interrogator Demo
  • Latest Posts
Menu

Tag: SQL101

SQL 101 — the 11/24 presentation

Posted on November 29, 2010February 3, 2011 by slowder

Wednesday night I had the opportunity to give my SQL 101, the basics presentation. I hadn’t given this one since just before leaving IntegrationPoint earlier this year.  I spent a little time updating the presentation based on past evaluations and some changes in SQL.  My new version includes some newer data types that have been…

Continue reading

SQL 101 Training

Posted on November 15, 2010February 3, 2011 by slowder

Wednesday November 24th, from 5 – 7pm I’ll be offering my SQL 101 course.  I was thinking about adding a remote option for those of you who can’t make it up to Concord.  I’d like to know how many of you there will be so I can arrange GoToMeeting, or something similar so you can…

Continue reading

Alias

Posted on March 1, 2007February 9, 2011 by slowder

Within a few days of using SQL, you’re going to start wondering if there is a way to speed up your code writing. The good news is you can do that with Aliases. You can give a table or a column another name by using an alias. This can be a good thing to do…

Continue reading

SQL101-Homework Assignment #5 Answer Key

Posted on March 24, 2006February 24, 2011 by slowder

These answers have been updated to work with Adventureworks on 2008R2. 1. Write an UPDATE query that would set your middle name, for only your record by personID. (if there is no record for you, add it in first, then show me the update to set your middle name.) UPDATE Person.Contact SET MiddleName = ‘Dwight’…

Continue reading

SQL101-Homework Assignment #5

Posted on March 22, 2006February 24, 2011 by slowder

Here’s another set of questions for you to practice on.  As always, if you have any questions, let me know and I’ll help you. UPDATE 1. Write an UPDATE query that would set your middle name, for only your record by personID. (if there is no record for you, add it in first, then show…

Continue reading

SQL101-Homework Assignment #4 Answer Key

Posted on March 20, 2006February 16, 2011 by slowder

Here are my solutions updated to work with AdventureWorks on 2008R2. 1. Write a DELETE query that would remove a record from person.contact by contactID, pick a contactID that does not exist in person.contact. DELETE FROM Person.Contact WHERE ContactID = -1 2. Write a DELETE query that would remove a record from person.contact by first…

Continue reading

SQL101-Homework Assignment #4

Posted on March 17, 2006February 16, 2011 by slowder

Here are some more practice problems.  This time you’re going to practice using DELETE. 1. Write a DELETE query that would remove a record from person.contact by contactID, pick a contactID that does not exist in person.contact. 2. Write a DELETE query that would remove a record from person.contact by first and last name. 3….

Continue reading

SQL 101 – DELETE

Posted on March 15, 2006March 14, 2016 by slowder

It looks like I’m getting close to the end of my 101 series.  After I show you how to remove data from tables, the last topic I plan to cover is creating tables.  It’s been quite a journey, collecting all this knowledge and putting it out there for you.  I had hoped to get some…

Continue reading

SQL 101 – TRANSACTION

Posted on March 1, 2006February 9, 2011 by slowder

As I mentioned in my previous post, before you move on to more difficult topics I need to share with you what a TRANSACTION is, and how to use them.  By now I’m sure you’ve seen t-SQL on tutorials.  The T stands for transactional.  If you don’t know what a TRANSACTION is, that’s pretty meaningless,…

Continue reading

SQL101-Homework Assignment #3 Answer Key

Posted on February 19, 2006February 16, 2011 by slowder

Here are the answers to the previous practice problems. 1. Write the query that would put the full name (as much of it as you know)  of your favorite Star Wars character into the Person.Contact table.  Use the title field to identify them as  ‘SWChar’. You can use the INSERT that uses VALUES or SELECT…

Continue reading
  • 1
  • 2
  • 3
  • Next
  • Career Development
  • Data Engineering
  • Data Science
  • Infrastructure
  • Microsoft SQL
  • Modern Data Estate
  • Personal
  • Random Technology
© 2023 shannonlowder.com | Powered by Minimalist Blog WordPress Theme