DBMS Lab Manual. Jitendra Inc. Patel

• Тип: Текст
• Автор: Jitendra Inc. Patel
• Издательство: Ingram(2020)
• ISBN: 9781300485452
• Страниц: 42
• Язык: Английский

• Жанры: Программы, Базы данных

DBMS LAB MANUAL<br><br>The Structured Query Language (SQL) is a computer language for accessing and manipulating databases. <br><br>The fundamental concept is to think of the data as being stored in one or more tables. When a request is made to retrieve data from these tables, which is called a "query", the resultant output is also presented in as table. <br><br>There are many different versions of the SQL language, but to be in compliance with the ANSI SQL '92 Standard, they must use and support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others.<br><br>This manual is specially written for Students who are interested in understanding Structured Query Language and PL-SQL concepts in the Computer Engineering and Information technology field and wants to gain enhance knowledge about power of SQL Language in Relational Database Management System Development. <br><br>The manual covers practical point of view in all aspects of SQL and PL/SQL including DDL, DML,DCL sublanguages, also there are practices for Views, Group by, Having Clause. All PL-SQL concepts like Condition and Loop Structures, Functions and Procedures, Cursor, Triggers, Locks are illustrated using best examples.