Getting Productive with SQL Developer
Oracle SQL Developer is a very popular free Graphical user interface. This course will teach you about this tool and see how it makes database development and management a breeze, for database developers, DBAs, and analysts.
What you'll learn
This IDE is packed with tons of cool features to significantly boost productivity and making executing the day to day tasks for both the database developers and DBAs a breeze. This tool allows you to write complex queries, explore the database and provides a complete development platform for Oracle PL/SQL applications. In this course, Getting Productive with SQL Developer, you will get an in-depth look at this tool. First, you'll discover how to download, install, and get started with Oracle SQL Developer. Next, you'll explore schemas and creating database objects. Then, you'll discover how to run and debug programs. Finally, you'll learn how to write powerful and visually appealing reports and automating tasks using the SQL Developer Command Line interface. By the end of this course, you'll have a solid foundation to get started and be productive with Oracle SQL Developer.
Table of contents
- Module Overview 2m
- Built-in Reports 5m
- Creating User Defined Reports 3m
- Adding Input Parameters 3m
- Master Detail Reports 2m
- Drill Down Reports 2m
- Customizing PDF Output Settings 5m
- Chart Reports 11m
- Gauge Reports 6m
- Managing and Sharing Reports 4m
- Introduction to SQL Developer Command Line Interface 2m
- SQL Developer Command-line Interface: Running Reports 2m
- SQL Developer Command-line Interface: Formatting SQL 1m
- SQL Developer Command-line Interface: Loading Data 4m
- SQL Developer Command-line Interface: Cart 5m
- Summary 2m
About the author
Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.