Bibliography/References

  1. Home
  2. Q/A
Originality and Attribution Statement
  • The chapter notes (PDF) shown on each chapter page are the course study material and are credited to their author, P. Srikanth (Oracle For Beginners), in every chapter’s reference list.
  • The explanations, summaries, questions, answers and MCQs on the chapter pages are original study aids written for this course from the topics covered in those notes; where a listing in the notes contains a typing slip, the corrected statement is shown and marked.
  • The official documentation and textbooks below are cited for verification and further reading; no text is reproduced from them beyond SQL/PL/SQL keywords, function names and standard terms.
  • Oracle, SQL*Plus and PL/SQL are trademarks of Oracle Corporation. Other names belong to their respective owners. Links lead to external websites not controlled by Ishaanvi InfoSoft.
Chapter Notes (PDF)
  1. Srikanth, P. (n.d.). Oracle For Beginners (chapter notes – the PDF shown on each chapter page). Srikanth Technologies. http://www.srikanthtechnologies.com/
    Cited in: Chapter-1, Chapter-2, Chapter-3, Chapter-4, Chapter-5, Chapter-6, Chapter-7, Chapter-8, Chapter-9, Chapter-10, Chapter-11, Chapter-12, Chapter-13, Chapter-14, Chapter-15, Chapter-16, Chapter-17, Chapter-18, Chapter-19, Chapter-20, Chapter-21, Chapter-22, Chapter-23, Chapter-24
Foundational Paper
  1. Codd, E. F. (1970). A Relational Model of Data for Large Shared Data Banks. Communications of the ACM, 13(6), 377–387. https://doi.org/10.1145/362384.362685
    Cited in: Chapter-1, Chapter-9
Oracle Database Documentation (19c)
  1. Oracle Corporation. (n.d.). Oracle Database Concepts, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/
    Cited in: Chapter-1, Chapter-2, Chapter-3, Chapter-4, Chapter-5, Chapter-6, Chapter-7, Chapter-10, Chapter-12, Chapter-20
  2. Oracle Corporation. (n.d.). Oracle Database SQL Language Reference, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/
    Cited in: Chapter-3, Chapter-4, Chapter-5, Chapter-6, Chapter-7, Chapter-8, Chapter-9, Chapter-10, Chapter-11, Chapter-12, Chapter-13, Chapter-14, Chapter-21, Chapter-22
  3. Oracle Corporation. (n.d.). Oracle Database PL/SQL Language Reference, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/
    Cited in: Chapter-15, Chapter-16, Chapter-17, Chapter-18, Chapter-19, Chapter-20, Chapter-22, Chapter-23, Chapter-24
  4. Oracle Corporation. (n.d.). SQL*Plus User’s Guide and Reference, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/
    Cited in: Chapter-2, Chapter-3, Chapter-14
  5. Oracle Corporation. (n.d.). Oracle Database Administrator’s Guide, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/
    Cited in: Chapter-2, Chapter-12, Chapter-13
  6. Oracle Corporation. (n.d.). Oracle Database Net Services Administrator’s Guide, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/
    Cited in: Chapter-2
  7. Oracle Corporation. (n.d.). Oracle Database Error Messages, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/errmg/
    Cited in: Chapter-2, Chapter-17
  8. Oracle Corporation. (n.d.). Oracle Database Security Guide, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/
    Cited in: Chapter-13, Chapter-19
  9. Oracle Corporation. (n.d.). Oracle Database Reference (initialization parameters and data dictionary views), 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/
    Cited in: Chapter-4, Chapter-10, Chapter-13
  10. Oracle Corporation. (n.d.). Oracle Database Development Guide, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/
    Cited in: Chapter-8, Chapter-11, Chapter-19
  11. Oracle Corporation. (n.d.). Oracle Database SecureFiles and Large Objects Developer’s Guide, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/adlob/
    Cited in: Chapter-21
  12. Oracle Corporation. (n.d.). Oracle Database Object-Relational Developer’s Guide, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/adobj/
    Cited in: Chapter-22, Chapter-23
  13. Oracle Corporation. (n.d.). Oracle Database PL/SQL Packages and Types Reference, 19c. https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/
    Cited in: Chapter-15, Chapter-21, Chapter-24
Text Books and Standards
  1. Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (7th ed.). Pearson.
    Cited in: Chapter-1, Chapter-3, Chapter-4, Chapter-6, Chapter-8, Chapter-9, Chapter-11
  2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database System Concepts (7th ed.). McGraw-Hill Education.
    Cited in: Chapter-1, Chapter-5, Chapter-8, Chapter-9, Chapter-11, Chapter-12
  3. Date, C. J. (2003). An Introduction to Database Systems (8th ed.). Addison-Wesley.
    Cited in: Chapter-1, Chapter-4, Chapter-10
  4. Feuerstein, S., & Pribyl, B. (2014). Oracle PL/SQL Programming (6th ed.). O’Reilly Media.
    Cited in: Chapter-7, Chapter-15, Chapter-16, Chapter-17, Chapter-18, Chapter-19, Chapter-20, Chapter-23, Chapter-24
  5. Gray, J., & Reuter, A. (1992). Transaction Processing: Concepts and Techniques. Morgan Kaufmann.
    Cited in: Chapter-5
  6. International Organization for Standardization / International Electrotechnical Commission. ISO/IEC 9075 – Information technology – Database languages – SQL (multi-part standard).
    Cited in: Chapter-1
Software Used on this Site
  1. Mozilla Foundation. (n.d.). PDF.js – a free, open-source PDF viewer library (Apache License 2.0), used for the chapter PDF viewer. https://mozilla.github.io/pdf.js/