How to Use Wild Cards in SQL Server

In this tutorial you will learn how to use wildcards in SQL Server. SQL wildcards can be used when searching for data in a database. SQL wildcards are used with the LIKE operator, which acts as a comparison when searching the database.  We will use the ‘%’ and ‘_’ wildcards in SQL Server: % – A substitute for zero or …

How to Use the CASE Expression in SQL Server

In this tutorial you will learn how to use the CASE expression. A CASE expression is given a value that runs through the conditional logic and returns a value. Because CASE can hold only one value at a time, it is allowed with similar expressions such as the SELECT, WHERE, HAVING, and ORDER BY clauses. …

Installing MySQL on Windows

MySQL is by far, the most popular open source database software on the web. Today we will learn how to install MySQL on the windows platform. The Easy Method Mysql’s site offers a pre-packaged installer for Windows systems. The install is an easy to follow GUI wizard that can be completed in three minutes. The installer …

How to Create a Database in SQL Server 2008 R2

This tutorial will show how to create a database in SQL Server 2008 R2. Think of a database as a container of objects such as tables, views, stored procedures, and so on. There are four system databases that the setup program creates: master, model, msdb, and tempdb. Though, after installation we are able to create …

How to Use the INNER JOIN Keyword in SQL Server

In this tutorial you will learn how to use the INNER JOIN keyword. The INNER JOIN keyword returns rows when there is at least one match in two tables. This is especially important when working with multiple tables because it can join them and provide data that is linked to each one. For this tutorial we …

How to Self-Join a Table in SQL Server

This tutorial will show you how to self-join a table in SQL Server. By self-joining a table we are able to manipulate SQL Server into thinking that a self-joined table is split in two tables, thus allowing us to run queries that otherwise wouldn’t be possible. A self-join runs just like any other join with …

Creating Random Numbers in SQL

In this SQL Server tutorial, we will go over how to use the RAND which is one of the many useful built-in function in to create random numbers in SQL Server. Once you have a database to test with let’s start exploring how to work and change this function and use it to your advantage. How to …