SQL Tutorials

Welcome! Take a look at the SQL Tutorial Categories or try a Search of the site!

Basic SQL Functions

SQL has many built-in useful functions that will help perform calculations on data within your database. This will help organize and optimize your workflow when working within a SQL database. […]

Creating Random Numbers in SQL

Filed in: Beginner

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 […]

Create and Display SQL Compact Database using Visual Studios

This tutorial will go over how to setup a SQL Compact Database and displaying it on your Website using Visual Studios 2012. In most cases, you may need a small […]

Installing MySQL on Windows

Filed in: MySQL

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 […]

thumbnail.png

How to Return Previous or Next Values in SQL Server 2008 R2

This tutorial will show how to create a query that returns previous and next values of a table column in SQL Server 2008 R2. Since rows in a table have […]

thumbnail.png

How to Create a Correlated Subquery in SQL Server 2008 R2

This tutorial will show how to create a correlated subquery in SQL Server 2008 R2. Correlated subqueries are subqueries that refer to attributes from the table that appears in the […]

thumbnail.png

How to Call the LEN Function on a String in SQL Server 2008 R2

Filed in: Queries, SQL Server

This tutorial will show how to use the LEN function in SQL Server 2008 R2. The LEN function returns the number of characters in an input string, excluding trailing blanks. […]

thumbnail.png

How to Concatenate Non Numerical Columns in SQL Server 2008 R2

Filed in: Queries, SQL Server

This tutorial will show how to use the string concatenation in SQL Server 2008 R2. The string concatenation uses a plus sign(+) operator to concatenate strings. It allows two strings […]

thumbnail.png

How to Use the OVER Clause in SQL Server 2008 R2

Filed in: Queries, SQL Server

This tutorial will show how to use the OVER clause in SQL Server 2008 R2. The OVER clause exposes a window of rows to certain kinds of calculations. The window […]

thumbnail.png

How to Insert Values into a Table Within a Database in SQL Server 2008 R2

This tutorial will show how to insert values into table within a database. In SQL, there are two ways to insert data into a table:  one row at a time […]

Page 1 of 41234
Server Intellect Server Management

Recent Activity

  • server-intellect


About Us

SQLAtoms.com is a site devoted to bringing you easy to understand, simple to implement tutorials and query examples for SQL.

Learn More About Us