Database
Overview In this tutorial, we will learn about relational database design using Entity-Relationship Model. An Entity-Relationship Model is the most common used model for relational database design. An Entity-Relationship Model is used to model a relational database using a top-down method. This method starts with an overall black box view, then adds detail as the […]
Overview In this tutorial, we will learn about database design process. The database design process includes the following basic steps: Database Requirements Conceptual Design Logical Design Physical Schema Database Requirements Collection This phase consists of collecting and evaluating database requirements from various stake holders of the proposed system. Conceptual design In Conceptual Design we will […]
Overview Subquery also called as inner query is used to return a value to the outer or the main query. There are two types of sub queries. Nested Sub-query Nested sub-query is executed first and its results are inserted in the WHERE clause of the outer main query. Sub queries can be single row or […]
Overview In this post, we will discuss about different types of SQL statements and SQL Questions for Beginners frequently asked during testing interviews. What is SQL? SQL is an acronym for Structured Query Language. It is a structured query language for Relational Database Management Systems (RDBMS). It is a data language for creating/manipulating/processing data & […]
Overview In this tutorial, we will learn to construct a Database Design Plan. A database is a container for the database objects. We must first prepare a plan when creating a new database. Database Design Plan The design plan should answer many important decisions regarding the database. The primary purpose of this database. […]
Overview In this tutorial, we will learn about Database Modeling. Prior to building the actual database, we should spend time modeling the database structure. This process of specifying the table/data structure is based upon the specific type and use of the data that it will contain. The most commonly used model for relational database design […]