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.
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)
and of course I will be there to answer your questions.....
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
How to make best use of the program
SQL Developer IntroductionPreview
|Section 1: Software Installation|
Installing Java SDKPreview
Installing SQL Developer
Running scripts necessary for the course
Scripts for our Assignments
|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
Querying data from multiple tables
Query Data from Multiple Tables (Outer Joins)
|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...
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.