Advanced Techniques in SQL

Advanced Techniques in SQL

0%

1. ACID

Now we explore the basic principles of ACID (Atomicity, Consistency, Isolation, Durability) in database management. Learn how these principles ensure reliable transactions by guaranteeing complete operations, keeping data consistent, isolating concurrent transactions, and ensuring permanent data storage.

Course Overview

Challenge: Transaction Creation

Isolation. Read Committed and Uncommitted Levels

Isolation. Repeatable Read and Serializable Levels

Challenge: Specifying Isolation Level for Transaction

2. Query optimization.Indexes

Explore how to enhance the efficiency of your SQL queries through index optimization. Delve into the significance of indexes in database performance, learning how to design, implement, and utilize them effectively. Discover strategies for choosing the appropriate indexes, understanding their impact on query execution plans, and optimizing query performance through index selection and utilization.

What are Indexes

B-tree Indexing

Challenge: Creating B-tree Index

General Optimization Strategies

Challenge: Query Optimization

3. Some Additional Topics

This section explores pivotal topics such as Triggers, Window Functions, and DCL (Data Control Language), offering comprehensive insights into their implementation and optimization strategies. Furthermore, it navigates the landscape of NoSQL DBMS, providing a thorough understanding of its architecture, advantages, and practical applications.

Challenge: Creating After Trigger

Window Functions

Types of Window Functions

Challenge: Using Window Function

Data Control Language

Contenido del Curso

Advanced Techniques in SQL

Challenge: Specifying Isolation Level for Transaction

Tarea

Swipe to show code editor

We will now create a simple transaction using the BankAccounts table and specify the isolation level for it.

This transaction will involve increasing the balance of one of the accounts and logging information about it in the log table.

Your task is to set the isolation level to SERIALIZABLE for this transaction.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 1. Capítulo 8

toggle bottom row

Challenge: Specifying Isolation Level for Transaction

Tarea

Swipe to show code editor

We will now create a simple transaction using the BankAccounts table and specify the isolation level for it.

This transaction will involve increasing the balance of one of the accounts and logging information about it in the log table.

Your task is to set the isolation level to SERIALIZABLE for this transaction.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 1. Capítulo 8

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

some-alt