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
-
5m 13s
-
4m 27s
-
9m 13s
-
6m 15s
-
7m 33s
-
7m 26s
-
5m 33s
-
3m 52s
-
6m 42s
-
6m 20s
-
5m 34s
-
7m
-
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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
Channel
Wintellect SQL Server
Channel
Wintellect NoSQL