Set up the database servers

Contents

• Introduction Introduction

  • Managing database performance

    1m 2s
  • What you should know

    50s
  • Set up the database servers

    7m 19s
  • Create the Two Trees database

    7m 9s
• 1. Database Views 1. Database Views

  • (Locked)
    Save queries as database view objects

    2m 27s
  • Create a database view

    6m 34s
  • (Locked)
    Views and database maintenance

    6m 39s
  • (Locked)
    Views and database security

    2m 30s
  • (Locked)
    Challenge: Create a view

    1m 5s
  • (Locked)
    Solution: Create a view

    10m 59s
• 2. Query Performance 2. Query Performance

  • (Locked)
    The query optimizer

    5m 1s
  • (Locked)
    Reading execution plans

    6m 54s
  • (Locked)
    View a SQL Server execution plan

    6m 20s
  • (Locked)
    View a PostgreSQL execution plan

    3m 16s
  • (Locked)
    Control query plans with hints

    3m 11s
• 3. Transactions 3. Transactions

  • Transactions and data consistency

    2m 12s
  • (Locked)
    ACID properties

    1m 58s
  • (Locked)
    Commit and rollback transactions

    6m 27s
  • Understanding concurrency and locks

    6m 12s
• 4. Data and Object Management 4. Data and Object Management

  • (Locked)
    Explore the system tables

    4m 57s
  • (Locked)
    Duplicate tables

    4m 8s
  • (Locked)
    Delete data with TRUNCATE

    2m 28s
  • (Locked)
    Remove database objects with DROP

    2m 19s
  • (Locked)
    Create temporary tables

    6m 26s
• 5. Functions and Stored Procedures 5. Functions and Stored Procedures

  • (Locked)
    Add programming elements to the database

    3m 54s
  • (Locked)
    Create a function

    4m 51s
  • (Locked)
    Create a stored procedure in PostgreSQL

    4m 30s
  • (Locked)
    Create a stored procedure in SQL Server

    3m 6s
  • (Locked)
    Challenge: Write a stored procedure

    58s
  • (Locked)
    Solution: Write a stored procedure

    8m 7s
• Conclusion Conclusion

  • (Locked)
    Next steps

    1m 4s