Oracle SQL Hands-On Experience for beginners
5.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.
547 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL Hands-On Experience for beginners to your Wishlist.

Add to Wishlist

Oracle SQL Hands-On Experience for beginners

Practical learn by doing SQL for beginners
5.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.
547 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Retrieve Data with SQL SELECT
  • Use Aliases
  • Remove Duplicates with SQL DISTINCT
  • Write SQL Queries with WHERE Clause
  • Create Views
  • Update data with SQL
  • Add new data with SQL INSERT
  • Use SQL to Sort data
  • Use various operators in your queries
View Curriculum
Requirements
  • You should an understanding of database concepts e.g table.
  • You should be comfortable using a computer
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 .

This is a practical hands on video based course designed for  beginners.


You will Learn how to :

• Retrieve Data with SQL SELECT
• Use Aliases
• Remove Duplicates with SQL DISTINCT
• Write SQL Queries with WHERE Clause
• Create Views
• Update data with SQL
• Add new data with SQL INSERT
• Use ORDER BY clause
• Use SQL to Sort data
• Use SQL IN operator 
• Use SQL NULL
• Use LIKE Operator
• Write SQL Queries with ISNULL












Who is the target audience?
  • Beginner database administrators
  • Data Analyst
  • Data Scientist
  • Students
  • Graduates who want to explore something new
Students Who Viewed This Course Also Viewed
Curriculum For This Course
20 Lectures
02:06:33
+
Oracle Database Setup
7 Lectures 34:41



Unlock Schema
03:30

Download TOAD
05:29

Install TOAD
03:33

Connect TOAD to Oracle
08:11
+
Practical Hands-on SQL
13 Lectures 01:31:52
Retrieving Data with SQL SELECT
09:15

Using Aliases
07:47

Removing Duplicates with SQL DISTINCT
05:52

Writing SQL Queries with WHERE Clause
05:22

Creating Views
11:02

Updating data with SQL
07:02

Adding new data with SQL INSERT
09:32

Using ORDER BY clause
04:02

Using SQL to Sort data
07:18

SQL IN operator
04:48

SQL NULL
07:51

LIKE Operator
09:18

Writing SQL Queries with ISNULL
02:43
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,556 Reviews
35,094 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.