
SQL
Andy Vickler
Many companies worldwide suffer from one fundamental problem, and that is the inefficient functioning of their databases. While many know of database tuning and work to cover that aspect, professional database developers, managers, and administrators...
Location:
United States
Description:
Many companies worldwide suffer from one fundamental problem, and that is the inefficient functioning of their databases. While many know of database tuning and work to cover that aspect, professional database developers, managers, and administrators always miss one thing: optimizing their queries to save maximum time and cost and provide the query efficiently. Those who are aware of query optimization often lack the skillset and resources to implement this process at an advanced level efficiently. This book aims to make it easier for them. Here are some ways this book will prove beneficial for readers of all types, e.g., database administrators, teachers, students, or people genuinely interested in databases: By the end of this book, readers will have a greater understanding of databases and understand all the considerations of efficient use of databases. The contents of this book will equip readers with the capability to practically apply the given concepts for efficient querying. So click the buy now button and take your database career to the next level! Duration - 4h 20m. Author - Andy Vickler. Narrator - Helpful Matthew. Published Date - Thursday, 04 January 2024. Copyright - © 2021 Andy Vickler ©.
Language:
English
Opening Credits
Duration:00:00:11
Introduction
Duration:00:09:55
Chapter 1 structured query language in oracle
Duration:00:29:47
Chapter 2 query processing & query optimization
Duration:00:12:50
Chapter 3 query optimization techniques
Duration:00:29:04
Chapter 4 query optimization tips and tricks
Duration:00:41:18
Chapter 5 using the rule based optimizer
Duration:00:39:26
Chapter 6 using the cost based optimizer and database
Duration:00:30:25
Chapter 7 reading an execution plan
Duration:00:12:14
Chapter 8 sql server query optimization techniques
Duration:00:52:07
Conclusion
Duration:00:03:09
Ending Credits
Duration:00:00:19