LIBRISTO
LIBROAMANTO
mandatory
Become part of a community of book lovers from all over the world and get access to a whole bunch of benefits. Create an account for free
0
Austrian Post 5.99 € GLS courier 5.49 € DPD courier 4.99 € DPD point 3.99 €

Database Management Systems

Oracle Lab: 20 Beginner Experiments

Language EnglishEnglish
Book Paperback
Book Database Management Systems John Livingston S
Libristo code: 54566881
Publishers Independently published, November 2026
Learn Oracle SQL and PL/SQL by doing - one short, guided experiment at a time. Written for undergrad... Full description
? points 24 b New New
9.89 € VAT included
christmas Christmas delivery ▾ In stock at our supplier Shipping in 9-13 days
Austria Delivery to Austria

Up to 30 days for returns

Learn Oracle SQL and PL/SQL by doing - one short, guided experiment at a time.

Written for undergraduate students, including learners from non-computer-science backgrounds, this lab manual turns the Oracle DBMS practical syllabus into 20 step-by-step experiments you can predict, run, test and explain. Every experiment uses the same clear layout, so you always know what to do next in the lab and what to write in your record.

Each experiment gives you:


  • Aim, syllabus link and the idea explained in plain words

  • A syntax box showing the general form of every new command

  • A complete, ready-to-run Oracle script

  • Line-by-line sample output, so you can check your own results

  • A quick-reference table, trace table or data-model diagram

  • A test-and-record task and viva questions


What you will practise:


  • SQL: CREATE and ALTER tables, primary and foreign keys, CHECK and NOT NULL constraints, INSERT, SELECT, WHERE, ORDER BY, NULL handling, single-row functions, GROUP BY and HAVING, joins, subqueries, UPDATE, DELETE, COMMIT, ROLLBACK and SAVEPOINT

  • PL/SQL: Fibonacci series, factorial, string reverse, sum of series, stored functions, exception handling and row-level triggers

  • Cursors: student mark analysis with an explicit cursor

  • Two mini-applications: a Library Management system and a Student Marks report-card system built with tables, sequences, procedures and MERGE


Start today, with or without installation. Clear setup guides cover the free browser-based Oracle FreeSQL and Oracle Database Free on Windows. Appendices add a smoke-test script, a teacher script for creating learner accounts, an optional Python menu application, a troubleshooting table of common ORA- errors, a marking rubric and a record-sheet template.

Ideal for B.Sc. Computer Science, BCA, B.Com (CA), diploma and first-course DBMS students, and for teachers who want a ready, well-organised lab plan. Aligned to course 24COS1402 at The American College, Madurai, and easily adapted to any Oracle DBMS practical syllabus.

About the author: S. John Livingston has been with The American College, Madurai, since 2020 and is pursuing a Ph.D. in Computer Science and Engineering at Karunya Institute of Technology and Sciences, Coimbatore.

Actress & Polyglot
EWA KASP for
Play video
Ewa Kasp
Libristo has the largest selection of foreign-language books. That’s why I buy my books there.

About the book

Full name Database Management Systems
Language English
Binding Book - Paperback
Date of issue 2026
Number of pages 102
EAN 9798143577169
Libristo code 54566881
Weight 149
Dimensions 152 x 229 x 5
Give this book today
It's easy
1 Add to cart and choose Deliver as present at the checkout 2 We'll send you a voucher 3 The book will arrive at the recipient's address

Login

Log in to your account. Don't have a Libristo account? Create one now!

 
mandatory
mandatory

Don’t have an account? Discover the benefits of having a Libristo account!

With a Libristo account, you'll have everything under control.

Create a Libristo account
Book advisor Libroamiko
Hi, I'm Libroamiko, can I help?