IIRF Online > Development > Database Design & Development > Oracle SQL > Oracle SQL Developer: Mastering its Features + Tips & Tricks
Oracle SQL Developer: Mastering its Features + Tips & Tricks by Udemy
Use Oracle SQL Developer like a Pro: Learn the features & tricks that will help you be the most admired SQL developer
Course Highlights
- You will take advantage of many useful features that will make you more effective and efficient at work
- You will learn a lot of tricks and enjoy being seen as an SQL Developer expert
- You will learn how to create and share beautiful and interactive reports
- You will learn how to Install and customize SQL Developer in a way that works and feels best for you
- You will learn how to take full advantage of all the basic features of the tool
Skills you will learn!
Curriculum
2 Topics
Course Structure and How to Take Advantage of it
What this course IS and IS NOT
2 Topics
Reminder: You need an Oracle Database Already Installed! Don’t have one?
Downloading and installing SQL Developer
5 Topics
Introduction (SDB)
User Interface Basics
Creating and Organizing Database Connections
Working with the Worksheet
Working with the Results’ Grid
7 Topics
Introduction (UC)
Changing the Language
Disabling Features you Don't Need
Improving the way Data is Displayed
Advanced Code Formatting
Navigation Filtering
Customizing Fonts and Syntax Colors for Eye Comfort
8 Topics
Introduction (R)
Predefined Reports Overview and Reports Basics
User-Defined Reports Basics
Master-Detail and Drill Down Reports
Gauge Reports
Chart Reports
Exporting and Sharing Reports
A Final Reports' Trick
18 Topics
Introduction (MUF)
Splitting Worksheets and Document Groups
Exporting data
Code Templates
Code Snippets
Taking Advantage of The Line Gutter
Performing Local Searches on Your Results
Testing Program Units Smartly
Debugging Program Units Smartly
Finding Database Objects
Getting Information about a Database Object
Oracle Folks Love Drag & Drop
Generating Relational Diagrams
Navigating Your Code
Performance Tuning Features
Displaying Gauges
Useful Tips and Shortcuts 1
Useful Tips and Shortcuts 2
3 Topics
Using HTML in SQL and in preferences
Appendix 1: Installing Oracle Database Express Edition 18c On Windows
Bonus Lecture: Discounts for other courses
Oracle SQL Developer: Mastering its Features + Tips & Tricks
Related Oracle SQL Courses
Thank You!
Your review has been submitted successfully.