Oracle SQL : Hands on Practical Step by Step Training

Learn how to build SQL Query and manipulate data from a database step by step using TOAD for oracle to connect .
4.0 (3 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.
1,744 students enrolled
$19
$75
75% off
Take This Course
  • Lectures 17
  • Length 2 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 7/2014 English

Course Description

This course teaches beginners what SQL is and how it works. The course materials are all videos making it easy to follow along. The course is less than 2 hours long and structured in a logical and easy to follow functional way. This course is easy to follow and will teach a beginner how to create , read , update and delete data from a database. (C.R.U.D) which are the four main things that SQL is used for on a database.

The video courses includes:

  • SQL SUB LANGUAGES
  • Creating Tables
  • Updating Data
  • Deleting Data
  • Reading Data
  • Restricting and Sorting Data
  • Adding Data to Database
  • Operators
  • Data types and Constraints

What are the requirements?

  • Sample Oracle Database
  • Toad For Oracle Editor

What am I going to get from this course?

  • The goal and objective of this course is to teach the basics of SQL . At the end of this course you should be able to perform the four basic functions SQL is used for on a database which are to: Create, Read,Update and delete data from a database.

What is the target audience?

  • This course is suitable for IT Professionals and anyone who wants to learn SQL quickly with easy to follow videos.

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 Your Lab
Introduction
Preview
02:00
Download and Install Oracle Database
Preview
07:18
How to Unlock Sample HR Account
Preview
04:53
Download and Install Toad For Oracle
05:21
Connecting to Database with Toad
03:40
Section 2: How SQL Works
SQL Sub Languages
03:05
Creating Tables Part 1
08:49
Creating Tables Part 2
08:03
View and dual table
06:06
Reading Data Using Select
09:15
Restricting and Sorting Data
07:18
Adding Data To Tables
09:32
Updating and Deleting Data
07:02
How to Alter , Truncate and Drop A Table
08:38
Operators
09:57
Data Types and Constraints
09:37
Section 3: Conclusion
Conclusion
01:31

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Skill Tree, Skill based learning

We are experienced company that provides quality video based training .
Our courses are easy to follow and understand and will take you from
an absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.
We have worked with companies of various sizes and provided consultancy services at various levels.
Thank you for learning with us and we hope your experience will be pleasant.

Ready to start learning?
Take This Course