Kick off your SQL skills with Oracle Database SQL Workshop
4.6 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,136 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Kick off your SQL skills with Oracle Database SQL Workshop to your Wishlist.

Add to Wishlist

Kick off your SQL skills with Oracle Database SQL Workshop

Build your SQL Skills with this Oracle Database SQL Workshop
4.6 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,136 students enrolled
Last updated 12/2016
English
Current price: $12 Original price: $155 Discount: 92% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Retrieve data from Oracle Database
  • Restrict Data from Oracle Database
  • Sort Data from Oracle Database
  • Identify SQL Statement
  • Understand Oracle Relational Database
  • Use TOAD
  • Manipulate data in Oracle Database
  • Create Database Objects using Data Definition Language
  • Create Views
  • Use SET operators
  • Display data from multiple tables
View Curriculum
Requirements
  • Basic database concepts
  • Basic SQL
  • Basic computer knowledge
  • Basic internet navigation
Description

This Oracle Database SQL Workshop course offers students an introduction to relational databases  like  Oracle Database  

technology. 
Students will learn the concepts of relational databases and the powerful SQL programming language. This course provides the
essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables,
and create database objects.

Learning SQL is a very useful skill to have as every business and organisation is so dependent on data. There are not enough skilled SQL professionals hence the demand and pay rate for SQL professionals is quite high. 

SQL stands for structured query language. It is an international standard language
used to query and manipulate databases. There are different types of database 
vendors like Oracle, Microsoft ,MySQL and so on . They all support SQL and
performs certain operations in the same way. Keywords like CREATE,SELECT,UPDATE,
DELETE,WHERE and FROM are used the same way with various database vendors.

This course will teach you the skills you need to get your foot in the door
 as an SQL professional. With the skills you learn on this course you can work 
confidently as a data analyst or even progress to be a database administrator.
This course will take from scratch to more advanced SQL using TOAD 

Students will Learn To:
Identify what a SQL statement is.
Understand the Oracle Relational Database.
Use TOAD to connect to Oracle database and perform SQL tasks
Manipulate data in relational tables 
Display data from multiple tables
Use of the DESCRIBE command
Create reports of sorted and restricted data
Retrieve row and column data from tables with the SELECT statement
Students will  use TOAD as the main environment tool for writing SQL. 
How to retrieve data using SELECT   Statement
How to restrict and sort data
How to use Single Row functions
How to display data from multiple tables using joins
How to use SET operators
How to use Data Definition Language
How to use Data Manipulation Language
How to use Clauses

Who is the target audience?
  • Application Developers
  • Database Administrators
  • Forms Developers
  • Functional Implementer
  • PL/SQL Develpper
  • System Analysts
Compare to Other Oracle Database Courses
Curriculum For This Course
47 Lectures
04:37:56
+
Database Setup
10 Lectures 44:19



Oracle database download
04:58

Oracle database installation
04:47

Unlock database schema
05:09

TOAD download
03:36

TOAD installation
04:08

Connect TOAD to Oracle Database
05:21

Exploring TOAD
05:41
+
Retrieving Data using SQL SELECT Statement
9 Lectures 58:15
SUB QUERY
08:38

The IN operator
04:48

IS NULL Values
02:42

NULL
07:51

Removing duplicates entries with SQL DISTINCT
05:52

VIEWS
11:02

Using Aliases with SELECT Statement
07:47

Checking table structure with DESCRIBE command
03:18

Using INDEX
06:17
+
Restricting and Sorting Data
5 Lectures 33:35
Limiting Rows
07:18

Sorting rows with ORDER BY clause
04:02

Using the WHERE clause
05:22

Using GROUP BY and HAVING clause
07:35

The LIKE operator and WILD card
09:18
+
Using Single -Row Functions to Customize Output
5 Lectures 26:04
What are single row functions
00:59

Conversion functions
06:48

Numeric functions
05:25

Date functions
05:02

Character functions
07:50
+
Displaying Data From Multiple Tables Using Joins
6 Lectures 43:49
Introduction to JOINS
04:11

SELF join
09:53

OUTER join
08:14

CARTESIAN join
06:19

NON EQUI join
07:26

EQUI join
07:46
+
Using the SET operators
5 Lectures 17:29
Introduction
04:35

UNION ALL
02:53

UNION
05:23

INTERSECT
02:50

MINUS
01:48
+
Introduction to Data Definition Language |Data Manipulation Language
7 Lectures 54:25
Introduction
03:05

DDL CREATE
08:50

DDL CREATE Part 2
08:03

DDL | ALTER| TRUNCATE DROP
08:38

DML INSERT
09:32

DML SELECT
09:15

DML UPDATE | DELETE
07:02
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,780 Reviews
39,052 Students
92 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.