System databases and Meta data

System Databases If you install SQL Server in your system, four default databases will be created automatically. SQL Server uses these databases for maintaining its databases. By default all these system databases will be created under C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData Master As

Read More

Microsoft SQL Server

Microsoft SQL Server 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

Read More

SQL Query – Order of execution

Order of execution When you execute a SQL Query, it will be executed in the following sequence. FROM ON JOIN WHERE GROUP BY HAVING SELECT DISTINCT ORDER BY TOP

Read More

SQL Syntax

SQL Syntax 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

Read More

SQL – A database language

SQL 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

Read More

CODD Rules

CODD Rules 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.

Read More

ACID Properties

ACID Properties 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

Read More

The Table family

A Database table It  is a basic unit of data storage in database which organizes the data in rows(Tuples) and columns(Attributes/fields). Each row contains one record and it simply refers to a two dimensional representation of your data using rows and columns.

Read More

Object Oriented DBMS (OODBMS)

OODBMS A database management system is said to be object oriented, if the data is stored in the form of objects. The name itself says that Object Oriented(OO) + Database Management System(DBMS). That means, If we integrate the features of object oriented

Read More

Flat File DBMS (FDBMS)

Flat File Database A flat file database is a database which stores the data in plain text file. It is a database consisting of a single table with no structure and relationship. This kind of database holds one record in a row

Read More