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.