SQL Developer Tips and Tricks

Learn how to perform SQL operations without writing the SQL using SQL Developer Graphical User Interface(GUI)
4.7 (16 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,200 students enrolled
Instructed by Amarnath Reddy IT & Software / Other
$19
$50
62% off
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

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

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

Curriculum

Welcome!!
Preview
02:02
How to make best use of the program
1 page
SQL Developer Introduction
Preview
02:51
Section 1: Software Installation
Installing Oracle
Preview
04:07
Installing Java SDK
Preview
02:20
Installing SQL Developer
03:21
Running scripts necessary for the course
02:12
Scripts for our Assignments
4 pages
Section 2: Operations on a Table
Lets Create a Table
03:17
Lets Add columns to Table, create index and an constraint
04:02
Lets Insert some data into a table
02:38
Lets Update data in the table
01:17
Lets Delete data from the table
02:06
Lets learn about Truncate, Copy and Drop...
03:39
Section 3: Import and Export operations
Importing data from an Excel into the database
03:03
Exporting data from the database to an Excel
04:25
Exporting data from one database to other database
02:44
Section 4: Querying Data
SELECT data from the table
03:05
Filtering data
04:15
Querying data from multiple tables
02:15
Query Data from Multiple Tables (Outer Joins)
02:36
Grouping Data
02:57
Section 5: Saving and Monitoring SQL
Saving SQL as a View
02:22
Saving SQL to your desktop
01:34
What are the SQL's I ran?
01:53
Searching Database for Data Objects
01:58
Monitoring Sessions of other users...
02:38
Running the Execution plan of a SQL
01:56
Section 6: Other Operations
Creating a Synonym
01:46
Creating a Sequence
01:20
Creating user and granting privileges
02:48
Revoking privileges for a User
01:06
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