Oracle SQL Hands-On Experience for beginners
3.9 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
567 students enrolled

Oracle SQL Hands-On Experience for beginners

Practical learn by doing SQL for beginners
3.9 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
567 students enrolled
Last updated 4/2017
English
English [Auto]
Current price: $86.99 Original price: $124.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 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 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 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
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 this course is for:
  • Beginner database administrators
  • Data Analyst
  • Data Scientist
  • Students
  • Graduates who want to explore something new