SQL From Scratch Using Oracle SQL Developer and TOAD

Learn how to query databases using SQL

4.05 (442 reviews)

Udemy

platform

English

language

Databases

What you will learn

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

Why take this course?

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.

Reviews

Veerendranath

August 29, 2020

Instructor's voice, teaching is clear and engaging. The content of this course is essential for all the SQL beginners who wants to learn and make a career as SQL developer ?

John

March 19, 2020

This is very good for beginners who want to learn new skills. Very easy to follow and replicate in your own environment.

Ray

February 14, 2020

Love the course. This is exactly the course I need to use for TOAD. Might be beneficial to have a how-to course for the tool itself. Excellent delivery on how to set this up on a personal workstation.

Sateesh

March 5, 2018

Session are too basic which will for the fresher's are B.tech students but not for the experienced. And Quiz even the LKG can answer the questions.

King

November 20, 2017

Very, very useful for a beginner (such as myself). Most videos are a few minutes long which makes it ideal for learning. It only includes easy examples. I would've love to see a section dedicated to more difficult queries; not to go in depth (as this is a basic SQL course) but to show what kind of queries are done out there in the real world to combine multiple tables, with multiple data types (timestamps, dates, Unix time stamps, etc). This was my first course in Udemy . I found that playing the course at 1.5x speed feels right. At 2x speed it's also good in some lectures. Normal speed was way too slow. If you have zero experience with dbs or have just a little, then, this is a good course. Worth it!

Patrick

January 7, 2017

Very thorough, but a few issues: - he pauses a lot making the videos very slow, I have to watch in 1.5x or 2x speed for it to keep my attention. - he repeats himself often within the same video, often back to-back statements being the exact same information. - there are several mistakes here and there. Examples, he types IP address 128.0.0.0 but says 128.0.0.1, and the popup says 128.0.0.1. Little details like that are extremely important with this kind of software. - he teaches in TOAD but TOAD is not free software. Oracle SQL developer is more accessible software for most people and should be the development tool of choice for an introductory video. Want to learn TOAD? Put a separate section of videos at the end to teach what's unique about TOAD vs Oracle SQL Developer, or make a separate course entirely about TOAD. All in all it feels like his first or second draft. Remaking these videos with a script and the help of someone else (who can tell you when to redo the video yet again to eliminate mistakes) would make for a much more professional, engaging course.

Imanuel

September 8, 2016

I am currently about 1/3 of the way through this course. I really like the content and would give it 4-5 stars if the video quality could be improved.

Matt

August 26, 2016

I like how methodical the course syllabus is thus far -- very thorough, step by step. However, some of the screenshots have poor resolution. Sometimes, I wish he would move things along more quickly. I'd also like it if there were a walk-through of the Toad UI.

Sam

July 9, 2016

The lecture showing you how to download and install Oracle SQL skipped straight to the installation part without describing where to download from or which version. The static slides are very boring to watch when the tutor just repeats (multiple times) what is written on them. He also just explains what he is doing and describes what we can already see on screen without any real in-depth explanation of why he is doing it.

Charts

Price

Rating

Enrollment distribution

SQL From Scratch Using Oracle SQL Developer and TOAD - Distribution chart