Back to course list
- Level: Beginner
- Duration: 04h 54m 26s
- Release date: 2021-11-17
- Author: Pankaj Jain
- Provider: Pluralsight
Getting Productive with SQL Developer
Description
Content
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.
- Course Overview02m
- Course Overview02m
- Introduction12m
- Module Overview07m
- Audience01m
- Prerequisites02m
- Tools01m
- Summary01m
- Installing SQL Developer and Connecting to Databases23m
- Module Overview01m
- Downloading and Installing SQL Developer09m
- Establishing a Database Connection02m
- Pointing to TNSNAMES.ORA File02m
- Establishing a Database Connection Using tnsnames.ora File02m
- Connecting to Oracle Database in the Cloud03m
- Exporting and Importing Database Connections03m
- Summary01m
- Browsing the Database, Creating, and Modifying Objects30m
- Module Overview01m
- Exploring the IDE04m
- Browsing Schema Objects04m
- Setting Bookmarks and Compiling Stored Program Units03m
- Creating and Modifying Objects08m
- Generating Code to Run Stored Program Units03m
- Code Formatting06m
- Summary01m
- Easy SQL Querying and Reuse with Code Snippets and Code Templates32m
- Module Overview02m
- Running Queries04m
- Query Builder Tool05m
- Query Results in a New Tab03m
- Running Scripts03m
- SQL History02m
- SQL Snippets04m
- SQL Editor Code Template05m
- Shortcut Keys03m
- Summary01m
- Discovering Database Using Data Modeler21m
- Module Overview01m
- Model Tab01m
- Reverse Engineering Using Oracle Data Modeler05m
- Generating Logical ERD02m
- Working with Data Modeler Diagrams04m
- Data Modeling02m
- Generating Database Documentation02m
- Finding Database Objects03m
- Summary01m
- Exporting and Importing Data19m
- Module Overview02m
- Exporting and Importing Data in Excel Format04m
- Moving Table Definition and Data05m
- Exporting Multiple Objects04m
- Exporting in JSON, HTML, or XML format02m
- SQL Hints00m
- Demo: SQL Hints01m
- Summary01m
- Debugging Program Units Using SQL Developer30m
- Module Overview01m
- Debugging Options01m
- Demo: Debugging with DBMS_OUTPUT and DBMS_UTILITY08m
- SQL Developer Debugger Interface14m
- SQL Developer Debugger Execution Flow05m
- Summary01m
- Executing DBA tasks23m
- Module Overview01m
- DBA View05m
- Performing DBA Tasks07m
- Database Copy06m
- Finding Database Differences03m
- Summary01m
- SQL Developer Reports and Command Line Interface57m
- Module Overview01m
- Built-in Reports05m
- Creating User Defined Reports03m
- Adding Input Parameters03m
- Master Detail Reports02m
- Drill Down Reports03m
- Exporting Report Output in HTML Format02m
- Chart Reports11m
- Gauge Display with SQL Query06m
- Managing and Sharing Reports04m
- Introduction to SQL Developer Command line Interface03m
- SQL Developer Command line Interface: Running Reports02m
- SQL Developer Command line Interface: Formatting SQL01m
- SQL Developer Command line Interface: Loading Data04m
- SQL Developer Command line Interface: Cart05m
- Summary02m
- Exploring Database Actions46m
- Module Overview02m
- Overview of Database Actions03m
- SQL: Exploring Schema, Running Queries, and Scripts07m
- SQL: Creating Objects, Generating DDL, Exporting, and Importing Data07m
- Data Modeler05m
- REST04m
- JSON08m
- Charts04m
- Database Administration and Monitoring04m
- Summary02m
Random courses
- 《Superb Zen》DaZuo and ZhangZhuang Column
- Customizing UI Settings Using the AndroidX Preference Library
- SVG Fundamentals
- Mindfulness: A Critical Skill for Project Managers
- Arts Therapy - Arts Therapy For Self Healing (Part One)
- Balance Sheet Primer
- Longevity Self Practice (moxa, acupuncture and meditation)
- Adobe Lightroom CC Mobile Editing | iPhone, Android + Tablet
- Watercolor Painting For Beginners | By Award Winning Artist
- Developing React.js Apps with Docker
Latest courses
- Ember.js: The Documentary
- GraphQL: The Documentary
- AWS Certified Solutions Architect - Professional (SAP-C01) Cert Prep: 1 Design for Organizational Complexity
- CCSP Cert Prep: 4 Cloud Application Security
- What Business Leaders Need to Know about Web3 (+ Metaverse)
- Building No-Code Apps with AppSheet: Implementation
- Automation Anywhere: The Big Picture
- Protective Technology with Apache Kafka
- Coding for Visual Learners: Learning JavaScript from Scratch
- StringBuilder Internals