Breadcrumb

ActivitatsDetall

Database optimization with advanced SQL

Description
Learn how to improve database performance using advanced SQL techniques. You'll learn how to optimize queries, indexes, and stored procedures for efficient databases.
Duration:
14 hours. Multi-session programme de 4 sessions.
Content

OBJECTIVES

  • Creation of tables and queries to achieve optimal performance
  • Mastery of index usage and execution plans to speed up queries
  • Optimization of stored procedures for specific tasks
  • Mastery of transactions and concurrency controls
  • Application of real-time database performance tuning techniques

SYLLABUS

  1. Review of basic SQL techniques
Teachers
CASTILLO GARROSSET, DANIEL
Driving
Slash Mobility

Calendar

Days and times
Venue
Language of instruction
Places
Registration
Virtual classroom
21 May, 2024
15:00 - 18:30
Virtual classroom
22 May, 2024
15:00 - 18:30
Virtual classroom
23 May, 2024
15:00 - 18:30
Virtual classroom
24 May, 2024
15:00 - 18:30
Catalan
36
Places
Attended session
25 Jun, 2024
15:30 - 19:30
Attended session
26 Jun, 2024
15:30 - 19:30
Attended session
27 Jun, 2024
15:30 - 19:30
Attended session
28 Jun, 2024
15:30 - 19:30
Cibernàrium-22@, Carrer Roc Boronat, 117 - 127, (Sant Martí) BARCELONA
Catalan
-
Opening of registration 10/06/2024 to 08:30 h.

Find out more

>> In case the format is virtual via streaming, it will be carried out through the free platform Microsoft Teams. Registered individuals will receive the invitation link and access instructions by email before the session starts.

>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.

>> The language in which each session is conducted is informed in the description of each activity.

>> Any of the training actions of Cibernàrium may be recorded through an image capture system that aims to subsequently disseminate them through a medium or support within the scope of the mission of Barcelona Activa to contribute to economic promotion and employment. In the recording process, images of attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.

ActivitatsRelacionades

Next edition

Virtual classroom
dt. 21/05/24 15:00-18:30

Virtual classroom
dc. 22/05/24 15:00-18:30

Virtual classroom
dj. 23/05/24 15:00-18:30

Virtual classroom
dv. 24/05/24 15:00-18:30

Free activity
I want to sign up →

ActivitatsAnnexos