SQL_in_the_Oracle_Cloud _Student_Learning_Subscription_Table_of_Contentsx Activity Guide SQL Fundamentals
User Manual:
Open the PDF directly: View PDF
Page Count: 190 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- SQL in the Oracle Cloud-Student Learning Subscription - Activity Guide
- Table of Contents
- Practices for Lesson 1: Introduction
- Practices for Lesson 2: Relational Database Overview
- Practices for Lesson 3: Database Storage Structures
- Practices for Lesson 4: Introduction to SQL
- Practices for Lesson 5: Retrieving Data by Using the SQL SELECT Statement
- Practices for Lesson 6: Restricting and Sorting Data
- Practices for Lesson 7: Using Single-Row Functions to Customize Output
- Practices for Lesson 8: Using Conversion Functions
- Practices for Lesson 9: Using Conditional Expressions
- Practices for Lesson 10: Reporting Aggregated Data Using the Group Functions
- Practices for Lesson 11: Retrieving Data from Multiple Tables Using Joins
- Practices for Lesson 12: Using the Set Operators
- Practices for Lesson 13: Using Subqueries to Solve Queries
- Practices for Lesson 14: Introduction to Data Manipulation Language
- Practices for Lesson 15: Introduction to Data Definition Language
- Practices for Lesson 16: Managing Tables Using DML Statements
- Practices for Lesson 17: Introduction to Data Dictionary Views
- Practices for Lesson 18: Creating Views
- Practices for Lesson 19: Creating Sequences, Synonyms, and Indexes
- Practices for Lesson 20: Managing Constraints, Temporary Tables, and External Tables
- Practices for Lesson 21: Using Advanced Subqueries
- Practices for Lesson 22: Manipulating Data by Using Advanced Subqueries
- Practices for Lesson 23: Controlling User Access