• No products in the cart.

Students

76

Lectures

111

Course Duration

Unlimited Duration

Updated

October 24, 2022

An SQL Query is used to retrieve the required data from the database. However, there may be multiple SQL queries that yield the same results but with different levels of efficiency. An inefficient query can drain the database resources, reduce the database speed or result in a loss of service for other users.
Profile Photo
Samantha Rodriguez
0
1

Courses

76

Students

In Writing SQL Queries you will:

• Identify the major components of Oracle Database

• Retrieve row and column data from tables with the SELECT

statement

• Create reports of sorted and restricted data

• Employ SQL functions to generate and retrieve customized data

• Run complex queries to retrieve data from multiple tables

• Run data manipulation language (DML) statements to update 

data in Oracle Database

• Run data definition language (DDL) statements to create and 

manage schema objects

    • Lesson 1: Introduction Unlimited
    • Oracle Database 19c Unlimited
    • Relational Database Management Concepts Unlimited
    • Data Models and the Entity-Relationship Model Unlimited
    • Relational Database Terminologies Unlimited
    • Tables Used in This Course Unlimited
    • Introduction to SQL and its Development Enviroments Unlimited
    • Oracle Database 19c SQL Documentation and Additional Resources Unlimited
    • Lesson 1: Summary Unlimited
    • Practice 1: Overview Unlimited
    • Lesson 2: Retrieving Data Using SQL SELECT Unlimited
    • Capabilities of SQL SELECT Statements Unlimited
    • Arithmetic Expressions and NULL Values in the SELECT Statement Unlimited
    • Column Aliases Unlimited
    • Use of the Concatenation Operator, Literal Character Strings, the Alternative Quote Operator, and the DISTINCT Keyword Unlimited
    • DESCRIBE Command Unlimited
    • Lesson 2: Quiz 00:05:00
    • Lesson 2: Summary Unlimited
    • Practice 2: Overview Unlimited
    • Lesson 3: Restricting and Sorting Data Unlimited
    • Limiting Rows Unlimited
    • Rules of Precedence for Operators in an Expression Unlimited
    • Sorting Rows Using the ORDER BY Clause Unlimited
    • SQL Row Limiting Clause in a Query Unlimited
    • Substitution Variables Unlimited
    • DEFINE and VERIFY Commands Unlimited
    • Lesson 3: Quiz 00:05:00
    • Lesson 3: Summary Unlimited
    • Practice 3: Overview Unlimited
    • Lesson 4: Using Single-Row Functions to Customize Input Unlimited
    • Single-Row SQL Functions Unlimited
    • Character Functions Unlimited
    • Nesting Functions Unlimited
    • Number Functions Unlimited
    • Working With Dates Unlimited
    • Date Functions Unlimited
    • Lesson 4: Quiz 00:05:00
    • Lesson 4: Summary Unlimited
    • Practice 4: Overview Unlimited
    • Lesson 5: Using Conversion Functions and Conditional Expressions Unlimited
    • Implicit and Explicit Data Type Conversion Unlimited
    • TO_CHAR, TO_DATE, TO_NUMBER functions Unlimited
    • General Functions Unlimited
    • Conditional Expressions Unlimited
    • Lesson 5: Quiz 00:05:00
    • Lesson 5: Summary Unlimited
    • Practice 5: Overview Unlimited
    • Lesson 6: Reporting Aggregated Data Using the Group Functions Unlimited
    • Group Functions Unlimited
    • Grouping Rows Unlimited
    • Nesting Group Functions Unlimited
    • Lesson 6: Quiz 00:05:00
    • Lesson 6: Summary Unlimited
    • Practice 6: Overview Unlimited
    • Lesson 7: Displaying Data from Multiple Tables Using Joins Unlimited
    • Types of JOINS and their syntax Unlimited
    • Natural Join Unlimited
    • Join with the USING Clause Unlimited
    • Join with the ON Clause Unlimited
    • Self-Join Unlimited
    • Nonequijoins Unlimited
    • OUTER Join Unlimited
    • Cartesian Product Unlimited
    • Lesson 7: Quiz 00:05:00
    • Lesson 7: Summary Unlimited
    • Practice 7: Overview Unlimited
    • Lesson 8: Using Subqueries to Solve Queries Unlimited
    • Subquery: Types, Syntax, and Guidelines Unlimited
    • Single-Row Subqueries Unlimited
    • Multiple-Row Subqueries Unlimited
    • Multiple-Column Subqueries Unlimited
    • Null Values in a Subquery Unlimited
    • Lesson 8: Quiz 00:05:00
    • Lesson 8: Summary Unlimited
    • Practice 8: Overview Unlimited
    • Lesson 9: Using Set Operators Unlimited
    • Set Operators: Types and Guidelines Unlimited
    • Tables Used In This Lesson Unlimited
    • UNION and UNION ALL Operator Unlimited
    • INTERSECT Operator Unlimited
    • MINUS Operator Unlimited
    • Matching SELECT Statements Unlimited
    • Using the ORDER BY Clause in Set Operators Unlimited
    • Lesson 9: Quiz 00:05:00
    • Lesson 9: Summary Unlimited
    • Practice 9: Overview Unlimited
    • Lesson 10: Managing Tables Using DML Statements Unlimited
    • Adding New Rows in a Table Unlimited
    • Changing Data in a Table Unlimited
    • Removing Rows From a Table Unlimited
    • Database Transaction Control Using COMMIT, ROLLBACK, and SAVEPOINT Unlimited
    • Read Consistency Unlimited
    • Manual Data Locking Unlimited
    • Lesson 10: Quiz 00:05:00
    • Lession 10: Summary Unlimited
    • Practice 10: Overview Unlimited
    • Lesson 11: Introduction to Data Definition Language Unlimited
    • Database Objects Unlimited
    • CREATE TABLE Statement Unlimited
    • Data Types Unlimited
    • Overview of Constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK constraints Unlimited
    • Creating a Table Using Subquery Unlimited
    • ALTER TABLE Statement Unlimited
    • DROP TABLE Statement Unlimited
    • Lesson 11: Quiz 00:05:00
    • Lesson 11: Summary Unlimited
    • Practice 11: Overview Unlimited
    • Lesson 12: Oracle Cloud Overview Unlimited
    • Overview of Oracle Cloud Unlimited
    • Working with Oracle Database Exadata Express Cloud Service Unlimited
    • Lesson 12: Summary Unlimited

Popular Courses

top
Managed by Ernesto.net © 2021. All rights reserved.