CompTIA Data+: Query Optimization

CompTIA    |    Intermediate
  • 10 videos | 1h 7m 53s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
You have received a large dataset, spent the time and requisite care cleansing and manipulating it to make it the best possible dataset so that you can extract useful information from it. Now what? Well, now you can begin querying the data. But queries can get complicated fast, especially when dealing with massive amounts of data. That's where query optimization comes in. Queries can be optimized to make your results faster and more meaningful. In this course, you will explore the key concepts of query optimization, beginning with query optimization and typical tools used in query optimization. Then you will conduct parameterized queries, perform index scans, use temporary tables, and use record subsets. Finally, you will dig into execution plans and common best practices for query optimization. This course can be used to prepare for CompTIA Data+ (DA0-001) exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Identify the purpose and role of query optimization
    Provide an overview of typical query optimization tools
    Conduct parameterized queries
    Perform index scans
  • Use temporary tables with a dataset
    Use record subsets with a dataset
    Use execution plans
    Outline query optimization best practices
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 54s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 13m 54s
    After completing this video, you will be able to identify the purpose and role of query optimization. FREE ACCESS
  • Locked
    3.  Query Optimization Tools
    9m 26s
    Upon completion of this video, you will be able to provide an overview of typical query optimization tools. FREE ACCESS
  • Locked
    4.  Using Parameterization
    10m 58s
    During this video, you will learn how to conduct parameterized queries. FREE ACCESS
  • Locked
    5.  Performing Index Scans
    7m 37s
    Find out how to perform index scans. FREE ACCESS
  • Locked
    6.  Using Temporary Tables
    4m 52s
    In this video, discover how to use temporary tables with a dataset. FREE ACCESS
  • Locked
    7.  Using Record Subsets
    6m 33s
    Learn how to use record subsets with a dataset. FREE ACCESS
  • Locked
    8.  Using Execution Plans
    4m 54s
    During this video, discover how to use execution plans. FREE ACCESS
  • Locked
    9.  Query Optimization Best Practices
    8m 11s
    After completing this video, you will be able to outline query optimization best practices. FREE ACCESS
  • Locked
    10.  Course Summary
    35s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

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

Course CompTIA Data+: Data Visualization Dashboards
Rating 4.8 of 6 users Rating 4.8 of 6 users (6)
Course CompTIA Data+: Understanding Data
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)
Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course CompTIA Data+: Understanding Databases
Rating 4.8 of 44 users Rating 4.8 of 44 users (44)
Course CompTIA Data+: Inferential Statistical Methods
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)
Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)