Table vs View is a topic of debate among DBAs and beginners because the similarities they both share . We will discuss various aspects of both tables and views . Such as: Difference between Table vs View. Table vs View Performance. Advantages of Views in SQL In SQL Beginner’s Guide we have developed basic understanding about views. …
SQL Server Concurrency & Transaction Management is a process which allows multiple users to access data and perform multiple operations maintaining data integrity and smooth execution all at the same time. Microsoft SQL Server manages concurrency control by using locks to help protect data. The locks control how multiple users can access and change shared data …
SQL Subquery is another tool SQL Server has which can be used to fetch data from other tables to be used in main query according to the needs. Inner query and nested query are other names of SQL Subquery. SQL Subquery can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators …
Data Normalization is the process widely used and implemented in industry . While this concepts has it’s use it comes with a price. However , Designing a DBMS is fundamental and of utmost importance to the success of any software. You can think of DBMS as human brain and this is true because DBMS design …
In Part 1 for ERD Case Study Case Study University Management System , we discussed how can you crack any case study and convert it into DBMS . We did that step by step and had a wonderful feedback . In another article on best practices for ERD , we discussed the pitfalls that we need to …
ERD Case Study; University Management System Part 2 Read More »