Description

INF3707 – Database Design & Implementation Summary

 

  • 1-L1 Retrieving data using the SQL select statement 22
  • 1-L2 Restricting and sorting data 73
  • 1-L3 Using single row functions to customize output 154
  • 1-L4 Reporting aggregated data using the group functions 255
  • 1-L5 Displaying data from multiple tables 306
  • 1-L6 Using sub-queries to solve queries 377
  • 1-L7 Using the set operators 428
  • 1-L8 Manipulating data 469
  • 1-L9 Using DDL statements to create and manage tables 5410
  • 1-L10 Creating other schema objects 6211
  • 1-L11 Managing objects with data dictionary 6912
  • 2-L1 Controlling user access 7313
  • 2-L2 Managing schema objects 7914
  • 2-L3 Manipulating large data sets 8615
  • 2-L4 Generating reports by grouping data 9216
  • 2-L5 Managing data in different time zones 9817
  • 2-L6 Retrieving data using sub-queries 10118
  • 2-L7 Hierarchical retrieval 10719
  • 2-L8 Regular expression support

 

*Oracle 12C: SQL, Casteel Joan, 2016. Edition 3rd.

Reviews

There are no reviews yet.

Be the first to review “INF3707: Database Design & Implementation: Summary”

Your email address will not be published. Required fields are marked *

Description

INF3707 – Database Design & Implementation Summary

 

  • 1-L1 Retrieving data using the SQL select statement 22
  • 1-L2 Restricting and sorting data 73
  • 1-L3 Using single row functions to customize output 154
  • 1-L4 Reporting aggregated data using the group functions 255
  • 1-L5 Displaying data from multiple tables 306
  • 1-L6 Using sub-queries to solve queries 377
  • 1-L7 Using the set operators 428
  • 1-L8 Manipulating data 469
  • 1-L9 Using DDL statements to create and manage tables 5410
  • 1-L10 Creating other schema objects 6211
  • 1-L11 Managing objects with data dictionary 6912
  • 2-L1 Controlling user access 7313
  • 2-L2 Managing schema objects 7914
  • 2-L3 Manipulating large data sets 8615
  • 2-L4 Generating reports by grouping data 9216
  • 2-L5 Managing data in different time zones 9817
  • 2-L6 Retrieving data using sub-queries 10118
  • 2-L7 Hierarchical retrieval 10719
  • 2-L8 Regular expression support

 

*Oracle 12C: SQL, Casteel Joan, 2016. Edition 3rd.

Reviews

There are no reviews yet.

Be the first to review “INF3707: Database Design & Implementation: Summary”

Your email address will not be published. Required fields are marked *

About this INF3707 resource

This downloadable Summary Notes is listed for the UNISA module INF3707. Review the document title, description, seller information, price and learner reviews before purchasing to make sure it matches your current module requirements.

StudyPass helps distance-learning students search by module code and discover notes, revision material and study resources shared by independent sellers. Always compare the resource details with your latest official UNISA tutorial letters and assessment instructions.

Search for another UNISA module code or visit the UNISA Study Hub for practical distance-learning and exam-preparation tips.

0
    0
    Your Shopping Cart
    Your cart is emptyReturn to Shop