Learning SQL For Oracle

Learning SQL For Oracle, available at $19.99, has an average rating of 3.9, with 111 lectures, based on 61 reviews, and has 568 subscribers.

You will learn about Learn about SQL for Oracle This course is ideal for individuals who are Anyone wishing to learn about SQL for Oracle It is particularly useful for Anyone wishing to learn about SQL for Oracle.

Enroll now: Learning SQL For Oracle

Summary

Title: Learning SQL For Oracle

Price: $19.99

Average Rating: 3.9

Number of Lectures: 111

Number of Published Lectures: 111

Number of Curriculum Items: 111

Number of Published Curriculum Objects: 111

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Learn about SQL for Oracle

Who Should Attend

Anyone wishing to learn about SQL for Oracle

Target Audiences

Anyone wishing to learn about SQL for Oracle

This Oracle SQL training course from Infinite Skills teaches you everything you need to know about this graphical user interface. This course is designed for the absolute beginner, meaning no prior knowledge of Oracle SQL is required.

You will start by learning about a basic SQL select statement, including how to retrieve data from a table, use mathematical and text expressions, and sort the results using column names. This course will then show you how to restrict data, join tables, and summarize data. This video tutorial will also cover data subsets, restricting data, using subqueries, and data modeling. Other topics that are covered include creating tables and manipulating data, single-row functions, creating and using views, database management, and legacy SQL techniques.

Once you have completed this computer based training course, you will be able to use Oracle SQL as your main productivity tool for development. Working files are included, allowing you to follow along with the author throughout the lessons.

Course Curriculum

Chapter 1: Introduction To Oracle SQL

Lecture 1: Important – Download These First – Working Files

Lecture 2: 0102 What Is SQL?

Lecture 3: 0103 Relational Databases Explained – Part 1

Lecture 4: 0104 Relational Databases Explained – Part 2

Lecture 5: 0105 How To Query Data From A Database

Lecture 6: 0106 The Difference Between SQL And PL/SQL

Lecture 7: 0107 Setting Up An Oracle Apex Account

Lecture 8: 0108 Running SQL Using Oracle Apex

Lecture 9: 0109 Assignment 1

Lecture 10: 0110 Assignment 1 – Solution

Lecture 11: 0111 How To Access Your Working Files

Chapter 2: Basic SQL Select Statement

Lecture 1: 0201 Retrieving All Data From A Table

Lecture 2: 0202 Retrieving Some Data From A Table

Lecture 3: 0203 Restricting The Retrieval Of Rows From A Table

Lecture 4: 0204 Using Mathematical And Text Expressions

Lecture 5: 0205 Sorting The Results Using Column Names

Lecture 6: 0206 Assignment 2

Lecture 7: 0207 Assignment 2 – Solution

Chapter 3: Restricting Data – The Basics

Lecture 1: 0301 What Is A Primary Key?

Lecture 2: 0302 Comparison Operators

Lecture 3: 0303 Logical Operators

Lecture 4: 0304 Dealing With Null Values

Lecture 5: 0305 Sorting The Results Using Column Position

Lecture 6: 0306 Assignment 3

Lecture 7: 0307 Assignment 3 – Solution

Chapter 4: Joining Tables – The Basics

Lecture 1: 0401 What Is A Foreign Key?

Lecture 2: 0402 Inner Joins With The Using Clause

Lecture 3: 0403 Joins With The On Clause

Lecture 4: 0404 Joins And The Order Of Processing

Lecture 5: 0405 Assignment 4

Lecture 6: 0406 Assignment 4 – Solution

Chapter 5: Summarizing Data

Lecture 1: 0501 Aggregate Functions

Lecture 2: 0502 The Count Functions

Lecture 3: 0503 The Min And Max Functions

Lecture 4: 0504 The Avg And Sum Functions

Lecture 5: 0505 Concatenating Data

Lecture 6: 0506 Aggregates – Order Of Processing

Lecture 7: 0507 Assignment 5

Lecture 8: 0508 Assignment 5 – Solution

Chapter 6: Joining Multiple Tables

Lecture 1: 0601 Many-To-Many Relationships – Part 1

Lecture 2: 0602 Many-To-Many Relationships – Part 2

Lecture 3: 0603 Join Multiple Tables With The Using Clause

Lecture 4: 0604 Join Multiple Tables With The On Clause

Lecture 5: 0605 Eliminating Duplicate Rows From The Results

Lecture 6: 0606 Sorting The Results Using Column Aliases

Lecture 7: 0607 Assignment 6

Lecture 8: 0608 Assignment 6 – Solution

Chapter 7: Data Subsets

Lecture 1: 0701 Using The Group By Clause

Lecture 2: 0702 Using The Having Clause

Lecture 3: 0703 Having With Compound Conditions

Lecture 4: 0704 Assignment 7

Lecture 5: 0705 Assignment 7 – Solution

Chapter 8: Restricting Data – Advanced Concepts

Lecture 1: 0801 Using The In Operator

Lecture 2: 0802 Using The Between Operator

Lecture 3: 0803 Using The Like Operator For Pattern Matching

Lecture 4: 0804 Outer Joins

Lecture 5: 0805 Assignment 8

Lecture 6: 0806 Assignment 8 – Solution

Chapter 9: Using Subqueries – The Basics

Lecture 1: 0901 How Do Subqueries Work?

Lecture 2: 0902 Subqueries With The In Operator

Lecture 3: 0903 Subqueries Using A Comparison Operator

Lecture 4: 0904 Subqueries Vs. Joins

Lecture 5: 0905 Using A Subquery Vs. A Self-Join

Lecture 6: 0906 Assignment 9

Lecture 7: 0907 Assignment 9 – Solution

Chapter 10: Data Modeling – The Basics

Lecture 1: 1001 How Data Is Organized In A Relational Database

Lecture 2: 1002 The Entity-Relationship Approach

Lecture 3: 1003 Normalization Guidelines – Part 1

Lecture 4: 1004 Normalization Guidelines – Part 2

Lecture 5: 1005 Assignment 10

Lecture 6: 1006 Assignment 10 – Solution

Chapter 11: Creating Tables And Manipulating Data

Lecture 1: 1101 Creating Tables – Part 1

Lecture 2: 1102 Creating Tables – Part 2

Lecture 3: 1103 Specifying Keys

Lecture 4: 1104 The Check Constraint

Lecture 5: 1105 Creating Indexes

Lecture 6: 1106 Modifying And Removing Tables

Lecture 7: 1107 More Constraints

Lecture 8: 1108 Adding Data To A Table

Lecture 9: 1109 Changing Data In A Table – Part 1

Lecture 10: 1110 Changing Data In A Table – Part 2

Lecture 11: 1111 Removing Data From A Table

Lecture 12: 1112 Assignment 11

Lecture 13: 1113 Assignment 11 – Solution

Chapter 12: Single-Row Functions

Lecture 1: 1201 String Functions – Part 1

Lecture 2: 1202 String Functions – Part 2

Lecture 3: 1203 Number Functions

Lecture 4: 1204 Date Functions

Instructors

Infinite Skills
High Quality Training

Rating Distribution

1 stars: 2 votes

2 stars: 2 votes

3 stars: 9 votes

4 stars: 22 votes

5 stars: 26 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!