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 , …
SQL SELECT Query & SQL Statements | SQL Beginner’s Guide Read More »
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 …
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 …
Entity Relation Diagram Best Practices | Resolving DBMS Relationships Issues Read More »
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 …
Role of Keys In Database Management System | Data Modelling Read More »
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 system DBMS Models & …
Entity Relation Diagram | University Management System Part 1 Read More »