Linux Academy – SQL Primer (Associate Level)

Linux Academy – SQL Primer (Associate Level)

English | Size: 1.30 GB (1,396,448,156 Bytes)
Category: CBTs

Creation and Setup
EXERCISE: Exercise: Install and Configure MySQL Database Server
SQL Functions and Statements
EXERCISE: Exercise: Create Database, Database User and Tables
EXERCISE: Exercise: Creating Tables with Constraints
EXERCISE: Exercise: Altering Table Structures
EXERCISE: Exercise: Insert and Select Records in a Table
EXERCISE: Exercise: Count Records and Execute Functions in a Table
EXERCISE: Exercise: Use Joins to View Multi-Table Data
EXERCISE: Exercise: Sort Records and Determine Min/Max Values
EXERCISE: Exercise: SQL Functions (Average and Sum)
Exercise: Count Records and Execute Functions in a Table