Category Archives for "Learn SQL Server"

Listed here is my series on learning SQL Server. These lessons are perfectly suited for anyone that desires to learn how to query a database. We start with the basics, using SQL Server Express Edition (Free), and focus on the commands that are used retrieve the data.

Sign up for our news letter and get instructions on getting started the right way. We will help you set up SQL Server as well as SQL Server Management Studio. Both of these tool are free, I’ll show you how to download and configure them.

Learn SQL now! You’ll never feel limited by what you can do, nor frustrated that you’re restricted to a few canned report to rely upon. You don’t have to be a computer wiz to follow along. I try to use plain English to explain the concepts. Though the courses can help the tech minded, such as developers, I really wrote them for the average computer user. It is my hope all you HR, Business Analysts, Engineers, and Accountants will find my site, learn SQL, and make your jobs and lives easier.

What is the difference between a primary and unique key?

Primary and Unique Key

In this article we learn the difference between a primary and unique key, and why both are important to maintaining a relational database structure. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide Getting Started Using SQL […]

Continue reading

What is the Difference Between Merge and Update?

When modifying one table based on the contents of another it may be tempting to simply use the merge statement, but before you throw away all other forms of modifying data, I think it’s important for you to know the difference between merge and update. What is the Difference Between MERGE and UPDATE? Both the […]

Continue reading
1 2 3 10