DBMS Lab Manual

This DBMS Lab Manual introduces SQL, a vital language for database management, focusing on data stored and queried in tables. It aligns with the ANSI SQL '92 Standard, covering essential commands like SELECT and INSERT. Tailored for students in Computer Engineering and IT, it delves into SQL and PL-SQL, including DDL, DML, and DCL. The manual offers practical insights into Views, Group by clauses, and PL-SQL features like loops, functions, and triggers, ensuring a comprehensive understanding of database development.

Purchase Your Copy

About

Author Photo
About the Author: Jitendra Patel
Jitendra Patel(DOB:26th April 1981) grew up in one of a small village of Gujarat State, completed his Primary Education in his own village school. He completed distincted his Graduation in Computer Science from M.S.University Of Baroda and Post Graduation from Gujarat Technological University Ahmedabad. He has been teaching technical students for many years in various Engineering Colleges of Gujarat State. His first book published through local state publisher was "Programming in Visual Basic 6.0" in 2007 and was accepted by wide range of readers. In 2008, He published two more technical subject books for this field readers in Java Programming and C# Programming. Till date he has continued publishing books for students in Computer engineering and information technology . Mean while he has been also efforted in publishing Technical Papers in National and International Conferences and successfully published 5 papers in various proceedings. He is also a life member of CRSI(Cryptography Research Society of India) since 2009. Also, the EDAS conference chair has selected as one of Reviewer for their papers in conferences to him.
DBMS LAB MANUAL

The Structured Query Language (SQL) is a computer language for accessing and manipulating databases.

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.

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.

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.

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.

Purchase Your Copy

Available in the following formats: .epub, .mobi

Price: $5.99 USD

Purchase

Do You Know That Book You Always Wanted to Publish? We Can Help With That!

We have been providing authors and small presses with ebook publishing and book marketing services since 2010. We offer ebook publishing (creation, formatting, distribution), print on demand services, audiobook creation, editing/proofreading, book/author websites, and book marketing and promotion services. Please let us know how we can help you!

Visit Our Homepage