Getting Productive with SQL Developer
This course will teach you how to boost your productivity using Oracle SQL Developer. It's packed with tons of cool features and useful wizards which can make doing common database tasks, against databases, both on-prem and cloud, a breeze.
What you'll learn
Oracle SQL Developer is a fantastic productivity tool. In this course, Getting Productive with SQL Developer, you’ll learn to use this free database IDE efficiently and effectively, against databases both in cloud and on-prem. First, you’ll explore how to perform common development tasks like query writing, creating, and browsing database objects like tables, views, procedures, functions, and packages. Next, you’ll discover various features of the tool like exporting and importing data in various formats, data modeling utility, extensive monitoring and debugging capabilities, and support for performing critical DBA tasks. Finally, you’ll learn how to use several productivity enhancement features and wizards like creating code snippets and code templates as well as writing reports and using the command line interface for automating tasks.When you’re finished with this course, you’ll have the skills and knowledge of using this powerful tool to efficiently perform your day to day development and DBA tasks.
Table of contents
- Module Overview 1m
- Downloading and Installing SQL Developer 9m
- Establishing a Database Connection 2m
- Pointing to TNSNAMES.ORA File 2m
- Establishing a Database Connection Using tnsnames.ora File 2m
- Connecting to Oracle Database in the Cloud 3m
- Exporting and Importing Database Connections 3m
- Summary 1m
- Module Overview 1m
- Built-in Reports 5m
- Creating User Defined Reports 3m
- Adding Input Parameters 3m
- Master Detail Reports 2m
- Drill Down Reports 3m
- Exporting Report Output in HTML Format 2m
- Chart Reports 11m
- Gauge Display with SQL Query 6m
- Managing and Sharing Reports 4m
- Introduction to SQL Developer Command line Interface 3m
- 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.