Hands-on Guide to SQL and PL/SQL

The Hands-on Guide to SQL and PL/SQL is designed to provide students with practical knowledge of relational database management systems through structured laboratory experiments. Covering the fundamentals of SQL and advanced PL/SQL programming, this manual integrates theory with practice to strengthen problem-solving and database design skills. Students begin with core concepts such as Data Definition and Manipulation Language commands, SQL functions, set operations, and joins, progressing toward advanced topics including nested queries, keys, views, and transactions. The manual further introduces PL/SQL constructs-control structures, cursors, procedures, functions, triggers, and packages-enabling learners to develop real-time applications. Each section is supported with objectives, clear explanations, examples, and outputs for clarity. Case studies on library, college, and sales databases, along with practice problem sets, ensure exposure to industry-relevant scenarios. This guide serves as a comprehensive laboratory companion for undergraduate and postgraduate students of computer science, as well as a practical reference for educators and aspiring database professionals.