SQL Developer Tips and Tricks (Udemy.com)

Learn how to perform SQL operations without writing the SQL using SQL Developer Graphical User Interface(GUI)

( 12 Reviews )

Created by: Amarnath Reddy

Produced in 2018

What you will learn

Learn how to use SQL Developer to perform various SQL operations

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 96 / 100

Course Description

Are you TIRED!!!! of remembering the Syntax of SQL to perform your day to day database operations??
The solution to this problem is: Use a Oracle SQL Developer Graphical User Interface(GUI).
Oracle SQL Developer is a powerful SQL client with Graphical User Interface(GUI) for querying and administration of databases.
In this course I will be teaching you step by step how to perform various SQL operations using this GUI environment.
You will learn how to... (All of this using Graphical user Interface without typing)

Create tables
Add new columns to the tables
Add Indexes to the tables
Add constraints to the tables
Insert, Update and Delete data from the table
Save your SQL as a View
Save your SQL to Desktop
Export data to an Excel worksheet
Import data from an Excel worksheet to database table
Monitoring other User activities
Building SQL's using Query Builder
and many more...

and of course I will be there to answer your questions.....Who this course is for:

This SQL course is meant for newbies who already know the SQL concepts and looking to perform the SQL operations using SQL Developer
This course is probably not for you if you're looking to learn SQL concepts
No prior programming knowledge is needed

Time: 1.5h

Instructor Details

Amarnath Reddy

4.8 Rating
12 Reviews

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.
Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.
Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.8

12 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Veronica Turnage

Very well presented

By Ali Raza

Awesome!

By Datta Desai

Excellent Course......

By Nomi

i am very happy to take this course.the content is comprehensive and informative.Thank you very much Amarnath Reddy

By Martyn

Done at a good pace and easy to digest. I have enjoyed a few of Amarnath's courses and look forward to more in future.

By Stephen Goldberg

As always, great teacher and lessons on how to use SQL Developer and make it work fast to do things. Great. Take this course.

By Rukai Lou

I was expecting some tips on using SQL Developer such as shortcuts or tricks, while this course is mainly talking about generating SQL with GUI. Found this insightful website while listening the course: http://www.thatjeffsmith.com/archive/category/general/pedia/sqldev/

By Richard Valdez

I got this course at the discounted $24 price instead of original $99. Content was good, but just seemed to be a bit overpriced for an overview of what SQL Developer can do.

By Wilfred

I AM SO GLAD I REGISTERED FOR THIS COURSE. I AM A COMMAND LINE GUY. WITH SQL, I WILL BE ABLE TO DO MY JOB MUCH FASTER AND SAFER. I RECOMMEND THIS COURSE FOR EVERYONE

By Alex See