SQL Primer

Course Instructor
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

Introduction

00:06:09

Create Database

00:14:24

Create Table

00:07:53

Create Table With Constraints

00:07:23

Oracle MySQL Installation: Ubuntu

00:06:26

Oracle MySQL Secure Setup: Ubuntu

00:08:01

Oracle MySQL Installation: CentOS

00:07:02

Oracle MySQL Secure Setup: CentOS

00:12:08

MariaDB Installation: Ubuntu

00:07:16

MariaDB Secure Setup: Ubuntu

00:07:38

MariaDB Installation: CentOS

00:07:15

MariaDB Secure Setup: CentOS

00:07:15

Exercise: Exercise: Install and Configure MySQL Database Server

00:30:00

SQL Functions and Statements

Insert Into

00:08:55

Select From

00:07:10

Alter Table

00:08:15

Delete From

00:05:50

Create Index

00:06:57

Drop Table

00:07:07

Truncate Table

00:04:40

Auto Increment

00:08:36

Count Function

00:07:10

Average and Sum Functions

00:08:20

Like Operator

00:09:22

Create View

00:07:31

Inner Join

00:08:34

Left Join

00:07:59

Right Join

00:07:15

Full Join

00:05:02

Unions

00:10:02

Sorting Records

00:06:31

Minimum and Maximum Values

00:08:15

Upper and Lower Case Conversions

00:05:31

Now()

00:06:02

Exercise: Exercise: Create Database, Database User and Tables

00:30:00

Exercise: Exercise: Creating Tables with Constraints

00:30:00

Exercise: Exercise: Altering Table Structures

00:30:00

Exercise: Exercise: Insert and Select Records in a Table

00:30:00

Exercise: Exercise: Count Records and Execute Functions in a Table

00:30:00

Exercise: Exercise: Use Joins to View Multi-Table Data

00:30:00

Exercise: Exercise: Sort Records and Determine Min/Max Values

00:30:00

Exercise: 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

Looking For Team Training?

Learn More