SQL SELECT Query & SQL Statements | SQL Beginner’s Guide

In our recent tutorial we learned how to install MS SQL Server Management Studio 2012 . Today , we will learn basic SQL SELECT query & SQL Statements & how to write SQL Statements. MS SQL is the extended version of SQL ( Check the link for explanation) and it is known as T-SQL . Therefore , … Continue reading SQL SELECT Query & SQL Statements | SQL Beginner’s Guide

What is SQL ? | SQL Beginner’s Guide

Welcome to the SQL Beginner's Guide series . In this series we will learn , What is SQL ? What is SQL used for and SQL database management. The objective is to give SQL training to beginners and apply DBMS Concepts we learned in our DBMS Concepts series and code them into an actual database and … Continue reading What is SQL ? | SQL Beginner’s Guide

ERD Best Practices | Resolving DBMS Relationships Issues

Previously , we resolved a case study by creating an ERD for University Management System . Today , we will focus on ERD best practices and resolving dbms relationship issues . This can make our life a whole lot easier . So far , we have established the fact that an Entity-relation diagram is the first … Continue reading ERD Best Practices | Resolving DBMS Relationships Issues

Role of Keys In Database Management System | Data Modelling

Best thing about being a business intelligence consultant is that my work is closely related to real-life scenarios and objects that I use daily . Every time when i come across new concepts or even problems , I have always been able to map in my world . Such is our topic for today-Role of … Continue reading Role of Keys In Database Management System | Data Modelling

Entity Relation Diagram | University Management System Part 1

Exciting stuff today people. Today , we are actually going to get our hands-dirty and do a hands-on practice for designing a database management system by creating ERD Case Study for University Management System . In case , you need an overview of previous articles : What is a database?Database management systemDBMS Models & RelationshipsData Modelling … Continue reading Entity Relation Diagram | University Management System Part 1

Crow’s Foot Notation

When we design a database management system , we set some basic rules and define a limit and relation between different entities . In other words , we decide in what capacity the entities will interact each other.  Cardinality & Modality are two concepts that take care of these rules. Hence , today's article is … Continue reading Crow’s Foot Notation

DBMS Models | DBMS Concepts

DBMS Models defines the logical design and structure of a database and defines how data will be stored, accessed and updated in a database management system. There have been few proposed models which were used & then due to limitations in each of them . They got replaced by new DBMS Models. Most widely used … Continue reading DBMS Models | DBMS Concepts

What is Database Management System

Database Management System Definition : Database Management System ( DBMS) is a software that handles creation, manipulation and data integrity in a database by providing appropriate tools. It manages all users and transactions that are trying to access the database in a way that no transaction is lost and no users are disturbed. When desktop … Continue reading What is Database Management System