FlexStack: SQL Fundamentals 2 - Perking Up Your Lagging Database

  • Overview
  • Course Content
  • Requirements & Materials
Overview

FlexStack: SQL Fundamentals 2 - Perking Up Your Lagging Database

Course Description

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

Course Content
  • Individual modules to help participants learn SQL databases one step at a time
  • Interactive sessions for gaining knowledge and asking questions in real-time
  • Immersive exercises to practice using SQL right away
  • Hands-on guidance during every class session
Requirements & Materials

Requirements

A Windows or Mac laptop with a webcam is required to participate in the course. Tablets or other devices are not supported. Recommended: Additional monitor.

Familiarity with using a computer and adequate typing ability. 

Participants are expected to have their cameras on during the interactive sessions and must attend 80% of the sessions to pass the course.

Prerequisites

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

The third course in the FlexStack: SQL Fundamentals Certificate series requires previous Python programming experience or successful completion of the FlexStack: Python Fundamentals Certificate

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, is 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?