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
English
$15 $50 70% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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 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
Requirements
  • 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
+
Welcome!!
3 Lectures 04:53

How to make best use of the program
1 page

+
Software Installation
5 Lectures 12:00


Installing SQL Developer
03:21

Running scripts necessary for the course
02:12

Scripts for our Assignments
4 pages
+
Operations on a Table
6 Lectures 16:59
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
+
Import and Export operations
3 Lectures 10:12
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
+
Querying Data
5 Lectures 15:08
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
+
Saving and Monitoring SQL
6 Lectures 12:21
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
+
Other Operations
5 Lectures 07:00
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
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