Top 10 Features Of SQL Developer Everybody Should Use, Even In .

1y ago

52 Views

1 Downloads

5.58 MB

86 Pages

Report/dmca

Download PDF

Transcription

Top 10 Features of SQL Developer everybodyshould use,even in the CloudHeli Helskyaho, Elise Valin-Raki

Introduction, Heli Graduated from University of Helsinki (Master of Science, computer science), currently a doctoralstudent, researcher and lecturer (databases, Big Data, Multi-model Databases, methods and tools forutilizing semi-structured data for decision making) at University of Helsinki Worked with Oracle products since 1993, worked for IT since 1990 Data and Database! CEO for Miracle Finland Oy Oracle ACE Director Ambassador for EOUC (EMEA Oracle Users Group Community) Public speaker and an author Winner of Devvy for Database Design Category, 2015 Author of the book Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press,2015), co-author for Real World SQL and PL/SQL: Advice from the Experts (Oracle Press, 2016)Copyright Miracle Finland Oy

Helskyaho Heli, Valin-Raki EliseCopyright Miracle Finland Oy

Introduction, Elise Oracle Database Lead for Fennia Insurance Company Master of Science degree from Helsinki High School of Economics (withmajor in Management Science) IT sector since 1987, different positions OUGF (Oracle User Group Finland): Exa-SIG founder Oracle ACE Associate DBACopyright Miracle Finland Oy

500 Technical ExpertsHelping Peers Globally3 Membership Tiers Oracle ACE Director Oracle ACE Oracle ACE Associatebit.ly/OracleACEProgramConnect:oracle-ace nate yourself or someone you know: acenomination.oracle.com

Oracle SQL Developer vs Oracle SQL DeveloperData Modeler Two separate products BUT There is a version of Data Modeler that is integrated in SQL Developer To see the datastructures and objects in the database and to maintainthe data: SQL Developer To design the database and to maintain the data structures: DataModeler To design the data architecture: Data ModelerCopyright Miracle Finland Oy

In this session1. Useful shortcuts2. Queries3. Debugger4. Compile5. Export the result set6. Data Modeling7. Documentation and Reports8. Database Copy and Diff9. Schema Browser10. Explain PlanMiscCopyright Miracle Finland Oy

1. Useful shortcutsCopyright Miracle Finland Oy

Run Statement: Ctrl Enter or F9Copyright Miracle Finland Oy

Shift F4Copyright Miracle Finland Oy

Add your own shortcutsCopyright Miracle Finland Oy

Code TemplatesCopyright Miracle Finland Oy

2. QueriesCopyright Miracle Finland Oy

Easy querying: Drag-and-drop from the BrowserCopyright Miracle Finland Oy

Drag-and-drop from the BrowserCopyright Miracle Finland Oy

Preferences, Line NumbersCopyright Miracle Finland Oy

The Query ResultCopyright Miracle Finland Oy

Copy: Ctrl Shift CCopyright Miracle Finland Oy

Paste (Ctrl Shift C) with Ctrl opyright Miracle Finland Oy

What was the SQL for the result set?Copyright Miracle Finland Oy

SQL HistoryCopyright Miracle Finland Oy

3. DebuggerCopyright Miracle Finland Oy

PreferencesCopyright Miracle Finland Oy

Compile for DebugCopyright Miracle Finland Oy

Toggle BreakpointCopyright Miracle Finland Oy

DebugCopyright Miracle Finland Oy

Worth reading o-start-the-plsqldebugger/ elopers-plsqldebugger-and-oracle-12c/Copyright Miracle Finland Oy

4. CompileCopyright Miracle Finland Oy

Compile Invalid, Compile AllCopyright Miracle Finland Oy

5. Export the result setCopyright Miracle Finland Oy

Export the result setCopyright Miracle Finland Oy

PreferencesCopyright Miracle Finland Oy

Add data from Excel, Ctrl CCopyright Miracle Finland Oy

Add data from Excel,Ctrl VCopyright Miracle Finland Oy

6. Data ModelingCopyright Miracle Finland Oy

RedactionCopyright Miracle Finland Oy

Quick DDLCopyright Miracle Finland Oy

IndexesCopyright Miracle Finland Oy

Table (Model)Copyright Miracle Finland Oy

Data Modeler Reports from Reporting RepositoryCopyright Miracle Finland Oy

Data ModelerCopyright Miracle Finland Oy

7. Documentation and ReportsCopyright Miracle Finland Oy

DocumentationCopyright Miracle Finland Oy

Data DictionaryCopyright Miracle Finland Oy

Database AdministrationCopyright Miracle Finland Oy

Database Administration, TOP SQLCopyright Miracle Finland Oy

DBACopyright Miracle Finland Oy

Instance ViewerCopyright Miracle Finland Oy

Instance Viewer, 4.2TOP SQLCopyright Miracle Finland Oy

8. Database Copy and DiffCopyright Miracle Finland Oy

Database CopyCopyright Miracle Finland Oy

Database DiffCopyright Miracle Finland Oy

PreferencesCopyright Miracle Finland Oy

9. Schema BrowserCopyright Miracle Finland Oy

Schema BrowserCopyright Miracle Finland Oy

Find DB ObjectCopyright Miracle Finland Oy

10. Explain Plan (F10)Copyright Miracle Finland Oy

Explain Plan (F10)Copyright Miracle Finland Oy

Autotrace (F6)Copyright Miracle Finland Oy

PreferencesCopyright Miracle Finland Oy

MiscCopyright Miracle Finland Oy

Connection Color Test or Production?Copyright Miracle Finland Oy

Licensing?Copyright Miracle Finland Oy

PreferencesCopyright Miracle Finland Oy

4.2: support for 12c rel 2,Analytic ViewsCopyright Miracle Finland Oy

4.2: Real Time SQL MonitorCopyright Miracle Finland Oy

4.2: Reset PasswordCopyright Miracle Finland Oy

Feedback? THAT Jeff Smith says HI to everybody! Any feedback about SQL Developer, please let him know:jeff.d.smith@oracle.comCopyright Miracle Finland Oy

THANK YOU!QUESTIONS?Heli:Email: heli@miracleoy.fiTwitter: @HeliFromFinlandBlog: Helifromfinland.comElise:Email: elise.valin-raki@fennia.fiTwitter: @ValinRakiBlog: evrellai.wordpress.comJeff’s blog: ThatJeffSmith.com

Top 10 Features of SQL Developer everybody should use, even in the Cloud Heli Helskyaho, Elise Valin-Raki . Author of the book Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press, 2015), co-author for Real World SQL and PL/SQL: Advice from the Experts (Oracle Press, 2016) . Database Copy and Diff 9. Schema Browser 10 .