Technical Education ARKujur

Introduction to SQL and PL-SQL or defined. Structured Query Language (SQL)    SQL is the standard command set that allows the users to interect with the relational database management system.           All tasks related to relational data management creating table querying the database for information, modifying the data in the database, deleting them, granting access to users and so on can be easily performed using SQL. Different database vendors use different dialects of SQL. Advantages of SQL:-    १) SQL is coded without embedded data. २)Porting could be required when the underlying database management system need to be upgraded or changed. ३) SQL as a language provide a greater degree of abstraction and is independent of the way it is implemented internally. ४)The language in addition to being simple and easy to learn can also handle complex situations. ५) SQL can also be used to define data structures,control access to the data, delete,i...

A Database   is a collection of related data stored in a standardized format capable of being shared by multiple user. A Database management system   (DBMS)is a software that allows users to create and maintain a database.         Database is the software that enables to store, modify and extract data from a database.It process users request for data retrieval updation deletion and also maintain the integrity of the database. The DBMS   provides services for manipulating a database, while maintaining the integrity of the data. Database design:-    Database design enables us to represent the real world entities in a form that can be processed by the computer.The structure of a database is based on the data model - a collection of conceptual tools for describing data their relationship, semantic and consistency constraints.         The data model gives us method to capture the static and dynamic attributes of ...