SQL From Scratch Using Oracle SQL Developer and TOAD

Learn how to query databases using SQL
4.2 (14 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.
206 students enrolled
Instructed by 247 Learning Development / Databases
$19
$185
90% off
Take This Course
  • Lectures 105
  • Length 10 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2016 English

Course Description

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 and SQL Developer TOOL

Some of what you will learn on this course includes:

  • Database concepts
  • SQL SUB Languages -DDL and DML
  • Aggregate Functions
  • Logical Operators
  • SET Operators
  • Table Joins
  • Analytic Functions
  • Single Row Functions
  • Creating Tables
  • Creating Views
  • Creating Sequences
  • Creating Indexes
  • Using Aliases
  • Using Sub Queries
  • NULL Values
  • Restricting and Limiting Data

By the end of this course you will confidently be able to write SQL queries
to create,read,update and delete data which are the key functions that are performed
on a database.

What are the requirements?

  • Download Oracle Database and Tools. We will cover this in the course

What am I going to get from this course?

  • Choose the right logical operators for your queries
  • Choose the right logical SET operators for your queries
  • Write SQL Queries to extract data
  • Write SQL Queries to modify data
  • Write SQL Queries to delete data
  • Write SQL Queries to create tables
  • Write SQL Queries to extract data from multiple tables
  • Write Advanced SQL Queries using analytic functions
  • Write SQL Queries to generate reports

What is the target audience?

  • Anyone who wants to learn SQL
  • Anyone who is interested in databases
  • This course is meant for those not familiar with SQL syntax

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Setting up Tools and Database
Introduction
Preview
06:05
What is SQL ?
01:57
Download Oracle Database
Preview
04:58
Install Oracle Database
04:47
Accessing Database Schema
05:09
Download TOAD
03:36
Install TOAD
04:08
Exploring TOAD
05:41
Making Database Connection using TOAD
05:21
JDK download and Intallation
05:24
Download and Install Oracle SQL Developer Tool
06:07
Explore Oracle SQL Developer
03:40
Section 2: Database Concepts and Terminlogy
Basic Database Concepts
04:31
Basic Database Concepts Continued
Preview
10:16
Database Views and Dual Tables
06:06
Using Describe
03:18
Using Synonyms
06:05
Creating and using Indexes
06:17
Section 3: What Are SQL SUB Languages
Introduction to SQL Sub-languages
03:05
Data Definition Language :DDL CREATE
08:50
Data Definition Language :DDL CREATE Continued
08:03
Data Definition Language :DDL DROP,TRUNCATE and ALTER
08:38
Data Manipulation Language: DML SELECT
09:15
Data Manipulation Language: DML INSERT
09:32
Data Manipulation Language: DML UPDATE and DELETE
07:02
Section 4: Single Row Functions
What are Single Row Functions
00:59
Character Functions
07:50
Conversions Functions
06:48
Date Functions
05:02
Numeric Functions
05:25
Section 5: Manipulating Data using SQL
Data Types and Constraints
09:37
NULL Values
07:51
What are Sequences
06:34
How to create Sequences
04:57
How to use Sequences
07:48
Using Aliases
07:47
Restricting and Sorting Data
07:18
Using Sub -Queries
08:38
Removing Duplicate records
05:52
Using SQL FROM Clause
02:51
Using SQL WHERE Clause
05:22
Using SQL ORDER BY Clause
05:48
Using SQL GROUP BY & HAVING Clause
07:35
SQL LIKE Operator
09:18
Section 6: Joining Database Tables using SQL
Why the need to join tables
04:11
Equi Join
07:46
Non Equi Join
07:26
Cartesian Join
06:19
Outer Join
08:14
Self Join
09:53
Section 7: Using Aggregate Functions
What are Aggregate Functions
01:38
AVG () Aggregate Functions
03:20
COUNT () Aggregate Function
04:40
MAX () Aggregate Function
03:13
MIN () Aggregate Function
02:48
SUM () Aggregate Function
07:17
Section 8: Viewing Data Using SET Operators
What are SET Operators
04:35
Union All SET Operator
05:23
UNION SET Operator
05:23
INTERSECT SET Operator
02:50
MINUS SET Operator
01:48
SET Operators Summary
03:31
Section 9: Advanced ORACLE SQL: Analytic Functions and Rolling Back Data
What are Analytic Functions
06:43
How to write Analytic Functions
04:07
The PARTITION BY Clause
08:04
ORDER BY Clause
05:48
Windowing Clause
02:10
Row number Functions
09:26
Rank Function
06:04
Dense Rank Function
05:57
Lag Function
03:37
ListAgg Function
06:14
Lead Function
06:43
First and Last Functions
08:56
What is a Flashback Query
05:18
Undo Parameters
05:11
Session level flashback
08:59
Rolling Back Data
05:35
Rolling Back Data Continued
10:57
Session Flashback
06:57
Section 10: Logical Operators
Introduction
00:40
ANY Operator
04:01
ALL Operator
04:01
SQL IN Operator
04:48
SQL IS NULL Operator
02:42
AND operator
04:46
NOT Operator
02:49
OR Operator
04:12
Section 11: Real World SQL Query Examples
SQL Query To Determine Employees Count
03:27

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

247 Learning, An investment in knowledge pays the best interest

Hello and welcome to 247 Learning.

We are a small company from the united kingdom that create and teach designs.Our teaching style is designed to be simple and step by step.

We have taught courses like Adobe Photoshop, Adobe Illustrator,Adobe Indesign as well as web design related courses .
Our very first Udemy course was "How to create resume /cv for profit" which has over 500 students.
We will continue to add more courses on the Udemy platform.
Our tutors have  over 7 years of a wide range of industry experience and understand how to teach in a way that students can understand.

Ready to start learning?
Take This Course