Back to course list
- Level: Advanced
- Duration: 02h 01m
- Release date: 2021-02-18
- Author: Bob Bryla
- Provider: Lynda
Oracle Database 19c: Advanced SQL
Description
Content
Mastering SQL is an essential skill for any Oracle Database professional. If you feel like you’ve got a firm handle on the basics and want to take your skills up a notch, this course is for you. Join Oracle Database administrator Bob Bryla as he covers the advanced features of Oracle SQL in an Oracle 19c Database environment. Bob explains advanced topics like database concurrency and isolation levels, Oracle-specific schema objects, data types, data models, and many more features you need to understand to become an Oracle SQL expert. At the end of this course, if you’re still hungry for more, Bob provides a list of resources to help you continue your learning.
- Introduction01m 03s
- Oracle Database Advanced SQL: Why 19c?01m 03s
- 1. Single- and Multi-Row Functions15m 53s
- Hierarchical functions05m 36s
- NULL-handling functions05m 22s
- Analytic functions, grouping in a window04m 55s
- 2. Set Operators23m 42s
- Set operators and their order04m 14s
- UNION04m 31s
- UNION ALL03m 49s
- INTERSECT03m 41s
- MINUS04m 37s
- Using ORDER BY with set operators02m 50s
- 3. DML: MERGE24m 06s
- Overview of DML statements05m 03s
- MERGE statement overview03m 48s
- INTO clause02m 47s
- USING clause02m 33s
- WHEN MATCHED . . . UPDATE clause03m 37s
- WHEN NOT MATCHED . . . INSERT clause03m 10s
- DELETE clause03m 08s
- 4. Data Definition Language Overview06m 27s
- DDL command types03m 35s
- Transactions and DDL commands02m 52s
- 5. DML: Transaction Processing10m 33s
- Using COMMIT05m 06s
- Using ROLLBACK02m
- Using SAVEPOINTs03m 27s
- 6. DDL: Creating and Manipulating Objects14m 02s
- Truncating tables04m 17s
- Synonyms05m 13s
- Sequences04m 32s
- 7. DDL: Managing Constraints with Indexes24m 36s
- Row-level constraints (same column or another column)04m 43s
- Unique indexes and constraints04m 06s
- Overview of indexes05m 36s
- Primary key constraints03m 57s
- Foreign key constraints06m 14s
- Conclusion01m 12s
- After Advanced 19c SQL01m 12s
Random courses
- SwiftUI Essential Training
- Apex Academy: Bulkification and Governor Limits
- Power BI Mistakes to Avoid
- Marvelous Designer: ArchViz Cloth Simulation and Details
- Developing and Extending a Salesforce Community Experience with Code
- RHEL 8: Creating Shell Scripts
- Developing Diversity Intelligence
- Exam Alert: Implement the IoT Solution Infrastructure in Microsoft Azure
- 3D Animation and Rigging Weekly
- CQ: The AWS Certification Quiz Show
Latest courses
- Creating a Short Film: 13 Marketing Your Film
- Marvelous Designer: ArchViz Cloth Simulation and Details
- Microsoft 365 Security Administration (MS-500) Cert Prep: 2 Implement and Manage Information Protection
- PHP Techniques: Working with Files and Directories
- Marketing on Facebook: Managing a Company Page
- Finding a New Market: Modest Fashion
- Enterprise Database Migration
- Microsoft Azure IoT Developer: Configure Health Monitoring
- Hardwiring Diversity and Inclusion into Everything You Do and Say
- What Is Disciplined Agile?