FB

Single Videos

This course contains a series of individual SQL and database videos.


You'll learn a range of topics, techniques, and tips on improving your database design and SQL queries.


See the list to the right for more details.

Get Access to All Courses Now

Access this course and all other courses (and more) in Database Star Academy instantly:

Course Topics:

Single Videos

  • Creating a Materialized View (Case Study)
  • Update Using CREATE TABLE AS SELECT
  • Working with Dates
  • How to Read an Explain Plan
  • How to Rewrite Code Using Cursors
  • How to Use the MERGE Statement
  • Getting Started with SQLPlus
  • Analytic Functions
  • Connect By
  • Constraints
  • Insert All
  • Insert From a Spreadsheet
  • Set Operators Explained
  • UNION vs CASE
  • NOT IN vs NOT EXISTS
  • CASE vs DECODE
  • Select More than 1000 Values Using IN
  • Hierarchical Data
  • Update with Join
  • Realistic Analytic Functions
  • Creating Complicated Views
  • EAV Design

Sample Database Videos

  • Sample Database: HR
  • Sample Database: Website
  • Sample Database: Sports

© 2019 Database Star | Privacy | Terms of Service