MP4 | Video: 1278×720 | 62 kbps | 44 KHz | Duration: 2 Hours | 332 MB
Genre: eLearning | Language: English
Learn how to perform SQL operations without writing the SQL using SQL Developer Graphical User Interface(GUI)
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 be learn how to… (All of this using Graphical user Interface without typing)
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?
Over 33 lectures and 1.5 hours of content!
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