Oracle Sql Developer - Narayanan, Ajith Ebook

Oracle Sql Developer - Narayanan, Ajith Ebook - Opis

At times, DBAs support 100s of databases at work. In such scenarios, using a command-line tool like putty adds to the difficulty, while SQL Developer makes the life of a developer, DBA, or DB architect easier by providing a graphical user interface equipped with features that can bolster and enhance the user experience and boost efficiency. Features such as DBA panel, Reports, Data Modeler, and Data Miner are just a few examples of its rich features, and its support for APEX, REST Services, timesten, and third-party database drivers demonstrate its extensibility.You may be a newbie to databases or a seasoned database expert, either way this book will help you understand the database structure and the different types of objects that organize enterprise data in an efficient manner. This book introduces the features of the SQL Developer 4.1 tool in an incremental fashion, starting with installing them, making the database connections, and using the different panels. By sequentially walking through the steps in each chapter, you will quickly master SQL Developer 4.1. Spis treści: 1. Getting Started with SQL Developer2. Database Connections and SQL Worksheets3. The Power of SQL Reports4. Working with SQL, PL/SQL, and Tuning Tools5. SQL Developer for DBA6. SQL Developer Accessibility Information7. Importing, Exporting, and Working with Data8. Database Connections and JDBC Drivers9. SQL Developer Data Modeler10. Extending SQL Developer11. Working with Application Express12. Working with SQL Developer Migrations13. Oracle Data Miner 4.114. REST Data Services and REST Development