Home » Tutorials

Category Archives: Tutorials

Installing Adventureworks database

Installing AdventureWorks

Please visit SQLVERSITY.COM for more details.

My next article onward, we are going to start writing queries. So you should have some data to work on and which should be in sync with my data.

One of the possibility for you guys to get in sync with me is to install AdventureWorks database. This is a sample database which can be used for testing & practicing purpose. Let’s install AdventureWorks in your SQL Server.

(more…)

SQL Server Management Studio(SSMS) – The SQL Server UI

Connecting to  SSMS

Please visit SQLVERSITY.COM for more details.

Follow the below steps to connect & work with SQL Server.

Step 1: Click on Start button — All programs — Microsoft SQL Server 2008/2008 R2/2012 — SQL Server Management tudio

The following window appears.

(more…)

Microsoft SQL Server

Please visit SQLVERSITY.COM for more details.

Microsoft SQL Server is a relational database management system(RDBMS) developed by Microsoft. As we already know that, database stores the data and we can retrieve/modify the data in database. SQL Server is not case sensitive. SQL Server uses T – SQL(Transact Structured Query Language) which is the extension of SQL. If you are strong in SQL basics, you can easily learn T – SQL.

(more…)

SQL Query – Order of execution

Order of execution

Please visit SQLVERSITY.COM for more details.

When you execute a SQL Query, it will be executed in the following sequence.

(more…)

SQL Syntax

SQL Syntax

Please visit SQLVERSITY.COM for more details.

I hope you guys have gone through my previous tutorial SQL – A database language. Now let’s move little bit further to write basic SQL queries.

Since you guys are beginners in SQL, i am going to start with a basic SQL query syntax. Later we will go through lots of complex syntaxes.

(more…)

SQL – A database language

SQL

Please visit SQLVERSITY.COM for more details.

SQL Stands for Structured Query Language.

It is a programming language to interact with databases. By executing SQL queries, we can Access, Insert, Update and Delete the data from databases. In earlier 1970’s, Donald D. Chamberlin and Raymond F. Boyce developed SQL at IBM.

(more…)

CODD Rules

CODD Rules

Please visit SQLVERSITY.COM for more details.

Edgar F. Codd, proposed thirteen rules (0 to 12) to define what is require d from a DBMS in order for it to be considered relational. Currently there is no commercial database management system which fully satisfies all the CODD’s rules.

(more…)

ACID Properties

ACID Properties

Please visit SQLVERSITY.COM for more details.

The acronym ACID stands for Atomicity, Consistency, Isolation and Durability.

These are group of properties that every DBMS must satisfy. Any database is said to be reliable, if it meets all these properties. Otherwise, we consider that DBMS as not reliable.

 Let’s drown deep in ACID 🙂 🙂 🙂

(more…)

The Table family

A Database table

Please visit SQLVERSITY.COM for more details.

 A table is a basic unit of data storage in database which organizes the data in rows(Tuples) and columns(Attributes/fields). Each row in a table contains one record and it simply refers to a two dimensional representation of your data using rows and columns. A table has a specified number of columns, but can have any number of rows. In short, a table is the only thing for storing data in the database.

(more…)