Inf3707 Study guides, Study notes & Summaries

Full summary of all chapters for INF3707 - Database Design and Implementation of the prescribed book, Oracle 12c by Joan Casteel. Headings and figures / pictures included with page references to the text book. Screenshots of SQL+ queries also included as screenshots.

Latest exam pack questions and answers and summarized notes for exam preparation. Whatsapp 067 171 1739 for assistance. All the best on your exams!!

Latest summarized notes for exam preparation. Whatsapp 067 171 1739 for assistance. All the best on your exams!!

INF3707 - Database Design & Implementation Summary - covers the entire module. Great for assignments and exams, document is searchable. The work has been done for you :-)

Objectives After completing this lesson, you should be able to do the following: • List the course objectives • Describe the sample tables used in the course Copyright © 2004, Oracle. All rights reserved. Course Objectives After completing this course, you should be able to do the following: • Use advanced SQL data retrieval techniques to retrieve data from database tables • Apply advanced techniques in a practice that simulates real life Copyright © 2004, Oracle. All righ...

This summary contains in depth concepts, explanations and examples which will not only allow you to reduce the amount of time you have to study, but will also assist you with getting a distinction for this module. This summary will replace your prescribe book entirely!

MQC 1.1 b.View – virtual table, not table on its own but mirrors table(temp table). Multiple tables – complex, single table – simple. In addition, the function and GROUP BY clause prevent changing the displayed data because each record might represent more than one row in the underlying key-preserved Reasons for view table – security, not direct DB access, efficiency – less direct DB hits table. CH. 13, text book pg 517 e-book pg 539 1.2 c. _ and % allows white characters - _ a...