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 databasedescribe the different functions that can be performed using SQL in a relational databaseidentify the different DML statements and their usesidentify the different DDL and DCL statements and their usesdescribe DBMS transactions and the ACID properties used to maintain data integritydescribe the ANSI/ISO model and the SQL statements used to process transactionsidentify the concurrency issues that can occur within a relational database
-
identify the concurrency issues that can occur within a relational databaserecognize the fundamentals of locking in a relational databasedescribe advanced locking techniques in a relational databaserecognize security concepts in a relational databaserecognize how the role of a DBA can ensure security within a relational databaseidentify relational algebra concepts, how transactions are implemented, and concurrency and locking concepts
IN THIS COURSE
-
1.Introduction to SQL5m 13sUP NEXT
-
2.Functions Performed Using SQL4m 27s
-
3.DML Statements9m 13s
-
4.DDL and DCL Statements6m 15s
-
5.DBMS Transactions and ACID Properties7m 33s
-
6.The ANSI/ISO Model SQL Transaction Statements7m 26s
-
7.Concurrency Problems (Part 1)5m 33s
-
8.Concurrency Problems (Part 2)3m 52s
-
9.Fundamentals of Locking6m 42s
-
10.Advanced Locking Techniques6m 20s
-
11.SQL Security Concepts5m 34s
-
12.DBA and the Role of Views in Security7m
-
13.Exercise: Describing Concepts for Managing Data4m 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.