FlexStack: SQL Fundamentals 2 - Perking Up Your Lagging Database

  • Overview
  • Requirements & Materials
Overview

FlexStack: SQL Fundamentals 2 - Perking Up Your Lagging Database

Course Description

The second course in the FlexStack: SQL Fundamentals Certificate takes a deeper dive into topics that involve database performance and optimization. In addition, learners will review database programming techniques and perform practice database administration tasks. Non-SQL database options will also be explored at a high level.

Requirements & Materials

Requirements

A Windows or Mac computer with a webcam is required to participate in the course. Tablets or other devices are not supported. Familiarity with using a computer and adequate typing ability.

Prerequisites

Completion of FlexStack: SQL Fundamentals 1 - Pulling Up to the Database Table.

Session Details

Who Should Attend

This course is perfect for those wanting more control over the data collected and stored through their work. Everyone, including managers, programmers, engineers, teachers, accountants, and more, are surrounded by data and accesses databases every day. This certificate teaches participants how to use structured query language (SQL) databases to appropriately store and manage data, query and update the data within them, and gain essential skills for implementing database-centric programs.  

A person sitting at a desk with a computer

What You Will Learn

  • Creation of indices to improve database performance and optimize queries
  • Analysis and application of normalization to create efficient data storage
  • Preparation of stored procedures and triggers to easily perform and automate more complex database tasks
  • Identification of scenarios where denormalization of data can improve database performance
  • Construction of database transactions to provide more structure and prevent failures of database operations
  • Ability to survey various methods to create new tables from existing data
  • Preparation of common table expressions to allow repeated use of a subquery within a transaction
  • Database management system (DBMS) installation, including setting up a database and administration tasks for granting user access and analyzing database performance
  • SQL data types and appropriate data conversions to prevent information loss
  • Differences between SQL and NoSQL databases to determine the best storage method based on application requirements
A person looking at a screen

How You Will Benefit

  • Utilize SQL to store, retrieve and manipulate data, and create and modify database schemas within a database management system (DBMS).
  • Use aggregation, filters, and sorting for additional data insights beyond basic data retrieval.
  • Implement keys, constraints, indices and normalization for improving database performance and ensuring data integrity.
  • Create stored procedures, triggers, and use transactions to facilitate easier database usage for applications.
  • Build basic database-driven web applications for humans and structured data interfaces for machines using the Python programming language and associated frameworks.
  • Recognize applications of the object-relational model and its usage for rapid application development.
  • Assess AI-generated code for accuracy and effectiveness.
  • Grow Your Professional Network icon
    Grow Your Professional Network
  • Taught by Experts in the Field icon
    Taught by Experts in the Field

Want to learn more about this course?