DBMS Lab Manual - Jitendra Inc. Patel
| Автор: | Jitendra Inc. Patel |
| Издательство: | Ingram |
| Серия: | |
| Жанр произведения: | Программы |
| Год издания: | 0 |
| isbn: | 9781300485452 |
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.