Oracle Cloud: Basic Oracle SQL with hands on Experience

This training course is suitable for oracle database administration and any Oracle professional who want to learn SQL

4.10 (61 reviews)
Udemy
platform
English
language
Databases
category
10,893
students
4 hours
content
Apr 2018
last update
$19.99
regular price

What you will learn

Who want to start their career as Oracle Database Administrator or Oracle Developer

Description

SQL language is an important skill for any Oracle professional and is the first step in suitable a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, I cover the basics required to code with SQL in an Oracle Database 12c environment. Learn how to select and filter data, and manipulate data using functions, including SUBSTR, UPPER, MIN, MAX, AVG, SUM, and more. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions also include such as constraints and subqueries advance concepts. This training course is suitable for beginning database developers with no prior experience with SQL or Oracle.

Following are including:

  • Using Oracle SQL*Developer, the free development environment
  • Selecting data from tables
  • Filtering data
  • Using functions to manipulate data
  • Joining data from tables
  • Creating tables
  • Updating values
  • Truncating data
  • Grouping and ordering result sets
  • Working with primary keys
  • Checking constraints

Content

Introduction

Introduction

Introduction to SQL

What is SQL?
Database Tables
Overview of table data types
SQL query structure

Setup course environment

Downloading the course VM

Using Oracle SQL Developer

Introduction to Oracle SQL Developer
Creating a connection to the database
Managing existing connections
Exploring database objects
Filtering specific objects
Using SQL Developer tabs
Viewing query output
Case sensitivity of SQL commands
Viewing SQL execution history
Query output as grid or script

Basic SELECT Queries

Writing your first SELECT query
Selecting only specific columns
Using WHERE to filter specific rows
Using multiple WHERE conditions
Using WHERE to filter partial strings
Using WHERE to filter numeric ranges
Using WHERE IN and NOT IN for strings
Using WHERE IN and NOT IN for numbers
Using WHERE to filter dates
Using WHERE to filter exact strings
Using DISTINCT to eliminate duplicates
Performing basic numeric calculations
Using column aliases
Describe the structure of a table
Using ORDER BY

String, Number, and Date Functions

Introduction to functions
Using SUBSTRING, LENGTH, and CONCAT
Using LENGTH
Using CONCAT
Using LOWER and UPPER
Using INSTR
Using RPAD and LPAD
Using TO_CHAR to convert numbers
Using TO_CHAR to format DATE values
Using TO_CHAR to filter DATE values
The special Oracle DUAL table
Using ROUND
Using TRUNC
Using SYSDATE
Using SYSTIMESTAMP
Using MONTHS_BETWEEN
Using ADD_MONTHS

Joining Table Data

Introduction to SQL joins
Joining data from tables
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
Joins with table aliases
Oracle join syntax vs. ANSI syntax

Manipulating Data

Introduction to DML and DDL commands
Creating a simple table
Inserting a new row to a table
COMMIT and ROLLBACK
Introduction to transactions
Deleting rows for a table
Updating values
Multiple-statement transactions
Adding and dropping columns from a table
Truncating all data from a table

Grouping Data

Introduction to aggregate functions
Using aggregate functions
Using GROUP BY
Using GROUP BY with MAX, MIN, and AVG
Using HAVING

Advanced Topics

Primary keys
NOT NULL constraints
Check constraints
Foreign key constraints
Subqueries

Screenshots

Oracle Cloud: Basic Oracle SQL with hands on Experience - Screenshot_01Oracle Cloud: Basic Oracle SQL with hands on Experience - Screenshot_02Oracle Cloud: Basic Oracle SQL with hands on Experience - Screenshot_03Oracle Cloud: Basic Oracle SQL with hands on Experience - Screenshot_04

Reviews

Hora
September 4, 2019
Actually awesome, but if I get power point and datas on each activities more better to exercise. Resources for this course is not enough to perform adequate practice.
Alice
November 11, 2018
Did not cover what I would consider some pretty basic stuff like values and other descriptions to use for the tables. Also did not talk about how to query oracle tables for information about the environment like lists of tables, views etc. Kind of choppy - might have been better to combine some like items together to provide some consistency rather than so many individual videos that seemed to cover only one item but did not feel very substantive.
Matthew
October 10, 2018
Its an excellent course, as an intermediate user, it solidified my SQL knowledge and put me on track to be an experienced SQL user.

Coupons

DateDiscountStatus
10/25/201990% OFF
expired
4/18/2021100% OFF
expired
5/28/202190% OFF
expired
6/10/202190% OFF
expired
8/25/2021100% OFF
expired
7/24/2023100% OFF
expired

Charts

Price

Oracle Cloud: Basic Oracle SQL with hands on Experience - Price chart

Rating

Oracle Cloud: Basic Oracle SQL with hands on Experience - Ratings chart

Enrollment distribution

Oracle Cloud: Basic Oracle SQL with hands on Experience - Distribution chart
1656934
udemy ID
4/21/2018
course created date
10/25/2019
course indexed date
Bot
course submited by