Developing SQL queries for oracle databases
4.0 (2 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.
245 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Developing SQL queries for oracle databases to your Wishlist.

Add to Wishlist

Developing SQL queries for oracle databases

Learn to build SQL queries to manipulate oracle databases
4.0 (2 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.
245 students enrolled
Last updated 11/2016
English
Curiosity Sale
Current price: $10 Original price: $85 Discount: 88% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build sub queries
  • Optimize queries using indexes
  • Leverage SQL Aggregate functions to build queries
  • Use single row functions to build to develop SQL queries
  • Perform analysis using analytic functions
  • Develop complex queries through table joins
View Curriculum
Requirements
  • Oracle database is required -we will cover the installation in the course
  • Basic Computer Skills
  • Basic SQL knowledge
Description

SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language.In this course, you learn to use the full potential of SQL to write simple to complex queries for Oracle databases. You will gain the practical skills to choose the best query method to ensure accuracy and avoid common errors or pitfalls.

SQL Skills will greatly improve your job prospects either as a contractor 
or full time employment. It is a useful skill that is always in demand due
 to its usefulness. It’s everywhere there is a database. The skills you learn
 on this course will be enough to confidently work as an SQL professional.

This is a practical hands on video based course with 40 lectures and  4 hours of content.

This course is designed for anyone who has some basic SQL knowledge and can write and understand simple SQL Queries. Also knowing the basics of relational database management systems (RDBMS) would be an advantage.

You will Learn how to :

  •  Use some essential components to build queries for oracle databases
  •  Leverage SQL Aggregate functions to build queries
  •  Leverage the analytical functions of Oracle
  •  Use single -row functions
  •  Manipulate SET queries to build queries
  •  Use temporary Tables



Who is the target audience?
  • SQL Aspiring developers
  • Aspiring Database administrators
  • Data Analyst
Students Who Viewed This Course Also Viewed
Curriculum For This Course
40 Lectures
03:50:05
+
Introduction and Oracle Database Setup
11 Lectures 52:24



Installing Oracle Database
04:47

Attach sample schema
05:09

Install Java JDK
05:24

Install Oracle developer
06:07

Exploring Oracle Developer
03:40

Download TOAD
03:36

Install TOAD
04:08

Connecting TOAD to Oracle Database
05:21
+
Essentials SQL Query building components
4 Lectures 31:49
Sub Queries
08:38

Query optimisation
06:17

Removing duplicates
05:52

Views
11:02
+
Leveraging SQL Aggregate Functions to Build Queries
5 Lectures 21:18
AVG
03:20

COUNT
04:40

MAX
03:13

MIN
02:48

SUM
07:17
+
Single-row functions
4 Lectures 25:05
Character
07:50

Conversion
06:48

Date
05:02

Numeric
05:25
+
Perform Analysis with Analytical functions
7 Lectures 46:57
Rank
06:04

Dense Rank
05:57

Lead
06:43

ListAgg
06:14

Lag
03:37

Row Number
09:26

First and Last
08:56
+
Developing complex queries using Joins
5 Lectures 39:38
SELF Join
09:53

EQUI Join
07:46

NON -EQUI Join
07:26

Cartesian Join
06:19

OUTER Join
08:14
+
Manipulating SET operators to build queries
4 Lectures 12:54
UNION
05:23

UNION ALL
02:53

INTERSECT
02:50

MINUS
01:48
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,562 Reviews
35,132 Students
85 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.