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.
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 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 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 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 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
