SQL & Concurrency Concepts
Beginner
- 13 videos | 1h 19m 8s
- Includes Assessment
- Earns a Badge
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 13sAfter completing this video, you will be able to describe SQL and its advantages and disadvantages in relation to a relational database. FREE ACCESS
-
4m 27sAfter completing this video, you will be able to describe the different functions that can be performed using SQL in a relational database. FREE ACCESS
-
3. DML Statements9m 13sIn this video, learn how to identify and use different DML statements. FREE ACCESS
-
4. DDL and DCL Statements6m 15sDuring this video, you will learn how to identify the different DDL and DCL statements and what they are used for. FREE ACCESS
-
5. DBMS Transactions and ACID Properties7m 33sAfter completing this video, you will be able to describe DBMS transactions and the ACID properties used to maintain data integrity. FREE ACCESS
-
6. The ANSI/ISO Model SQL Transaction Statements7m 26sUpon completion of this video, you will be able to describe the ANSI/ISO model and the SQL statements used to process transactions. FREE ACCESS
-
7. Concurrency Problems (Part 1)5m 33sIn this video, you will learn how to identify concurrency issues that can occur within a relational database. FREE ACCESS
-
8. Concurrency Problems (Part 2)3m 52sIn this video, you will learn how to identify concurrency issues that can occur within a relational database. FREE ACCESS
-
9. Fundamentals of Locking6m 42sUpon completion of this video, you will be able to recognize the fundamentals of locking in a relational database. FREE ACCESS
-
10. Advanced Locking Techniques6m 20sAfter completing this video, you will be able to describe advanced locking techniques used in a relational database. FREE ACCESS
-
11. SQL Security Concepts5m 34sAfter completing this video, you will be able to recognize security concepts in a relational database. FREE ACCESS
-
12. DBA and the Role of Views in Security7mAfter completing this video, you will be able to recognize the role of a DBA in ensuring security within a relational database. FREE ACCESS
-
13. Exercise: Describing Concepts for Managing Data4m 3sIn this video, you will identify relational algebra concepts, how transactions are implemented, and concurrency and locking concepts. 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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
