SQL Developer Tips and Tricks

Learn how to perform SQL operations without writing the SQL using SQL Developer Graphical User Interface(GUI)
4.7 (17 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,220 students enrolled
Instructed by Amarnath Reddy IT & Software / Other
Take This Course
  • Lectures 33
  • Length 1.5 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

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.....

What are the requirements?

  • You should already be familiar with SQL concepts like Table, constraint, Index, synonym, view ..etc

What am I going to get from this course?

  • Learn how to use SQL Developer to perform various SQL operations

Who is the target audience?

  • 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

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.


How to make best use of the program
1 page
SQL Developer Introduction
Section 1: Software Installation
Installing Oracle
Installing Java SDK
Installing SQL Developer
Running scripts necessary for the course
Scripts for our Assignments
4 pages
Section 2: Operations on a Table
Lets Create a Table
Lets Add columns to Table, create index and an constraint
Lets Insert some data into a table
Lets Update data in the table
Lets Delete data from the table
Lets learn about Truncate, Copy and Drop...
Section 3: Import and Export operations
Importing data from an Excel into the database
Exporting data from the database to an Excel
Exporting data from one database to other database
Section 4: Querying Data
SELECT data from the table
Filtering data
Querying data from multiple tables
Query Data from Multiple Tables (Outer Joins)
Grouping Data
Section 5: Saving and Monitoring SQL
Saving SQL as a View
Saving SQL to your desktop
What are the SQL's I ran?
Searching Database for Data Objects
Monitoring Sessions of other users...
Running the Execution plan of a SQL
Section 6: Other Operations
Creating a Synonym
Creating a Sequence
Creating user and granting privileges
Revoking privileges for a User
Let me know...
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Amarnath Reddy, Oracle Architect

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.

Ready to start learning?
Take This Course