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.

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.

• Course Overview 1min
• Overview 9mins
• Installing Oracle SQL Developer and Connecting to Databases 19mins
• Browsing the Database, Creating, and Modifying Objects 28mins
• Easy SQL Querying and Reuse with Snippets and Code Templates 28mins
• Discovering Database Using Data Modeler 19mins
• Exporting & Importing Data 17mins
• Debugging Program Units Using SQL Developer 25mins
• Executing DBA Tasks 24mins
• SQL Developer Reports & Command-line Interface 60mins