Database Design SQL Lab

The world of data is constantly changing and evolving every second. This, in turn, has created a completely new dimension of growth and challenges for companies around the globe. By accurately recording data, updating and tracking them on an efficient and regular basis, companies can address their challenges on one hand and make use of the immense potential offered by this sector on the other hand. To store and manage data, there is a need for specialized computer program known as Database Management System (DBMS).
In B. S. Anangpuria Institute of Technology & Management at our department of Bachelors of Computer Application, we make our students understand the role of a database management system in an organization. The major objective of this lab is to provide a strong formal foundation in database concepts, technology, and practice to the participants to groom them into well-informed database application developers. It includes just enough concepts and theory to motivate and enrich the practical component and to include technology component to maximize the relevance of the course to the industry without sacrificing the long-term objectives of rigor and foundational strength that can withstand the vagaries of technological advances.

First of all, to familiarize the participant with the nuances of database environments towards an information-oriented and data-processing oriented framework they are introduced to basic terminologies and concepts and to form the interaction to environment an interface is needed in the form of SQL. Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Also to form the base to language students are introduced with the data types used in SQL and The syntax awareness is given.

To begin with the lab, we start with the basic Data Definition Language(DDL) statements like Create, Alter, Drop, Truncate and also Data Manipulation Language statements like Insert, Select, Update, Delete, Like’%’, Relational Operator. Beside above, to enhance the security of a database, there is a requirement of controlling the access to the table. Thus, Data Control Languages is used to provide certain privileges to a particular user like Commit, Rollback, Savepoint, etc.

After gaining the basic knowledge, they will learn how to apply various constraints on the table such as Primary key, Foreign Key, Check, Unique, Null, Not null, Default, Enable Constraints, Disable Constraints, Drop Constraints etc.
Then students are incorporated to implement the set operations, Aggregate functions, Numeric functions (like avg, count, max, min, sum, etc.), various String functions and Date functions. Additionally, they are made to understand the concept to work on Groups, to implement Nested Queries & Join Queries such as Inner join, Left join, Right join and Full join and to implement various Views.

We at Department of Bachelors of Computer Applications make sure that at the completion of this lab, they will be able to design and implement a small menu is driven database projects like Employee information System, Inventory control system, Student Information System, Ticket booking management system.