SQL Primer

Training Architect
course instructor image
Terrence Cox
A veteran of twenty years in Information Technology in a variety of roles. He has worked in development, security and infrastructure well before they merged into what we now call DevOps. He provides training in Linux, VMWare, DevOps (Ansible, Jenkins, etc) as well as containers and AWS topics.

Creation and Setup

Exercise: Install and Configure MySQL Database Server

00:30:00

SQL Functions and Statements

Exercise: Create Database, Database User and Tables

00:30:00

Exercise: Creating Tables with Constraints

00:30:00

Exercise: Altering Table Structures

00:30:00

Exercise: Insert and Select Records in a Table

00:30:00

Exercise: Count Records and Execute Functions in a Table

00:30:00

Exercise: Use Joins to View Multi-Table Data

00:30:00

Exercise: Sort Records and Determine Min/Max Values

00:30:00

Exercise: SQL Functions (Average and Sum)

00:30:00

Details

The Structured Query Language (or SQL) is how we both define and manipulate data within a traditional Relational Database Management System (or RDBMS). In this course, we are going to learn how to structure SQL statements that do just that. Learn how to create databases, manage access, create tables, insert and update data, create indexes and more. We will demonstrate SQL functions and talk about how they differ from the more traditional SQL statements. All of this will be accomplished at a SQL command line within MySQL, but will apply equally to SQL compliant RDBMS systems in general.

Study Guides

Instructor Deck

Community

certificate ribbon icon

Earn a Certificate of Completion

When you complete this course, you’ll receive a certificate of completion as proof of your accomplishment.

Looking For Team Training?

Learn More