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: Database Concepts
CHANNEL NoSQL
Likes 30 Likes 30  
BOOK Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance, Sixth Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 285 Likes 285  
COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE Logical & Physical Design
Likes 106 Likes 106