SQL & Concurrency Concepts

Beginner
  • 13 videos | 1h 19m 8s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 245 users Rating 4.6 of 245 users (245)
SQL is the main query language used by most DBMSs. Learn how to use SQL to manage data, how transactions and concurrency control ensure data integrity and consistency, and how security is implemented in a relational database.

WHAT YOU WILL LEARN

  • Describe sql and its advantages and disadvantages to a relational database
    Describe the different functions that can be performed using sql in a relational database
    Identify the different dml statements and their uses
    Identify the different ddl and dcl statements and their uses
    Describe dbms transactions and the acid properties used to maintain data integrity
    Describe the ansi/iso model and the sql statements used to process transactions
    Identify the concurrency issues that can occur within a relational database
  • Identify the concurrency issues that can occur within a relational database
    Recognize the fundamentals of locking in a relational database
    Describe advanced locking techniques in a relational database
    Recognize security concepts in a relational database
    Recognize how the role of a dba can ensure security within a relational database
    Identify relational algebra concepts, how transactions are implemented, and concurrency and locking concepts

IN THIS COURSE

  • 5m 13s
  • 4m 27s
  • Locked
    3.  DML Statements
    9m 13s
  • Locked
    4.  DDL and DCL Statements
    6m 15s
  • Locked
    5.  DBMS Transactions and ACID Properties
    7m 33s
  • Locked
    6.  The ANSI/ISO Model SQL Transaction Statements
    7m 26s
  • Locked
    7.  Concurrency Problems (Part 1)
    5m 33s
  • Locked
    8.  Concurrency Problems (Part 2)
    3m 52s
  • Locked
    9.  Fundamentals of Locking
    6m 42s
  • Locked
    10.  Advanced Locking Techniques
    6m 20s
  • Locked
    11.  SQL Security Concepts
    5m 34s
  • Locked
    12.  DBA and the Role of Views in Security
    7m
  • Locked
    13.  Exercise: Describing Concepts for Managing Data
    4m 3s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Job Ready SQL
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Channel Wintellect SQL Server

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Advanced SQL Queries
Rating 4.6 of 321 users Rating 4.6 of 321 users (321)
Book Fundamental of Database Management System
Course Backup Management
Rating 4.5 of 82 users Rating 4.5 of 82 users (82)