SQL Developer Tips and Tricks

Course details

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