Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add SQL Developer Tips and Tricks to your Wishlist.

Add to Wishlist

SQL Developer Tips and Tricks

Learn how to perform SQL operations without writing the SQL using SQL Developer Graphical User Interface(GUI)
4.7 (18 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,226 students enrolled
Created by Amarnath Reddy
Last updated 8/2015
$15 $50 70% off
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

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 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
Students Who Viewed This Course Also Viewed
What Will I Learn?
Learn how to use SQL Developer to perform various SQL operations
View Curriculum
  • You should already be familiar with SQL concepts like Table, constraint, Index, synonym, view ..etc
Curriculum For This Course
Expand All 33 Lectures Collapse All 33 Lectures 01:24:33
3 Lectures 04:53

How to make best use of the program
1 page

Software Installation
5 Lectures 12:00

Installing SQL Developer

Running scripts necessary for the course

Scripts for our Assignments
4 pages
Operations on a Table
6 Lectures 16:59
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...
Import and Export operations
3 Lectures 10:12
Importing data from an Excel into the database

Exporting data from the database to an Excel

Exporting data from one database to other database
Querying Data
5 Lectures 15:08
SELECT data from the table

Filtering data

Querying data from multiple tables

Query Data from Multiple Tables (Outer Joins)

Grouping Data
Saving and Monitoring SQL
6 Lectures 12:21
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
Other Operations
5 Lectures 07:00
Creating a Synonym

Creating a Sequence

Creating user and granting privileges

Revoking privileges for a User

Let me know...
1 page
About the Instructor
4.5 Average rating
1,607 Reviews
14,232 Students
8 Courses
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.

Report Abuse