SQL & Concurrency Concepts

Beginner
  • 13 Videos | 1h 25m 8s
  • Includes Assessment
  • Earns a Badge
Likes 108 Likes 108
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

  • Playable
    1. 
    Introduction to SQL
    5m 13s
    UP NEXT
  • Playable
    2. 
    Functions Performed Using SQL
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 2 Likes 2  
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 141 Likes 141