Könyv Database Management Systems John Livingston S

Database Management Systems

Oracle Lab: 20 Beginner Experiments

Nyelv: Angol
Kötés: Puha kötésű
Elérhetőség: Beszállítói készleten
Küldés 9-13 napon belül
4 105 Ft
Kézbesítjük karácsonyig
Learn Oracle SQL and PL/SQL by doing - one short, guided experiment at a time. Written for undergrad...

Információk a könyvről

Nyelv
Angol
Kötés
Könyv - Puha kötésű
Kiadva
2026
oldal
102
EAN
9798143577169
Enbook ID
54566881
Súly
149
Méretek
152 x 229 x 5

Teljes leírás

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.