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

t-sql

SQL 101 – UPDATE

Previously, I showed you how to get new information into a SQL database. This time I'll show you how to make changes to that data, once it's in there. The basic

microsoft sql

Comparing Query Performance

A significant portion of your time as a database programmer or administrator will be to improve the performance of queries. While there are several benchmarks

microsoft sql

SQL101-Homework Assignment #2 Answer Key

Here are my answers to the questions based on AdventureWorks. I recently updated the answers to work with the 2008R2 version of Adventureworks. If your

SQL101

SQL101-Homework Assignment #2

SELECT with JOIN Here are a few more problems to practice with. Again, practice these queries against a copy of AdventureWorks. Now we're going to start

SQL101

SQL101-Homework Assignment #1 Answer Key

As promised, here are my answers to the first homework assignment. If you have something different, please get in touch with me so we can discuss the

microsoft sql

SQL101-Homework Assignment #1

Here are some practice problems for you to attempt using what you've learned so far about SELECT Statements.  Please write the following queries against any