SQL & Concurrency Concepts

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

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

COURSE Database Fundamentals: Working with SQL Commands
CHANNEL NoSQL
Likes 39 Likes 39  
BOOK Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Models & Applications
Likes 43 Likes 43  
COURSE Cloud Data Architecture: Data Management & Adoption Frameworks
Likes 59 Likes 59  
COURSE Concepts & Conceptual Design
Likes 298 Likes 298