SQL101

microsoft sql

SQL 101 — the 11/24 presentation

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

SQL101

SQL 101 Training

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

microsoft sql

Alias

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.

SQL101

SQL101-Homework Assignment #5 Answer Key

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

SQL101

SQL101-Homework Assignment #5

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

SQL101

SQL101-Homework Assignment #4 Answer Key

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

SQL101

SQL101-Homework Assignment #4

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

t-sql

SQL 101 – DELETE

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.

microsoft sql

SQL 101 – TRANSACTION

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

SQL101

SQL101-Homework Assignment #3 Answer Key

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

SQL101

SQL101-Homework Assignment #3

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

t-sql

SQL 101 – INSERT

In all the previous articles I've written on SQL I've showed you how to get data out of the database. Now, we're switching gears. I'm going to show you how to