SQL Developer Tips and Tricks

Offered byUDEMY

SQL Developer Tips and Tricks
at
UDEMY
Overview

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

Duration	2 hours
Total fee	₹389
Mode of learning	Online
Credential	Certificate

SQL Developer Tips and Tricks
at
UDEMY
Highlights

Certificate of completion
5 downloadable resources
Full lifetime access
30-Day Money-Back Guarantee

SQL Developer Tips and Tricks
at
UDEMY
Course details

Skills you will learn

Excel Installation Operations Java

Who should do this course?

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

What are the course deliverables?

Learn how to use SQL Developer to perform various SQL operations

More about this course

In this course learner will learn step by step how to perform various SQL operations using this GUI environment

SQL Developer Tips and Tricks
at
UDEMY
Curriculum

Welcome!!

Welcome!!

How to make best use of the program

SQL Developer Introduction

Software Installation

Installing Oracle

Installing Java SDK

Installing SQL Developer

Running scripts necessary for the course

Scripts for our Assignments

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

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

Querying Data

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

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

Creating a Synonym

Creating a Sequence

Creating user and granting privileges

Revoking privileges for a User

SQL Developer Tips and Tricks
at
UDEMY
Faculty details

Amarnath Reddy, Oracle Architect & Best Selling Instructor

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.