Linux Academy – SQL Primer (Associate Level)
English | Size: 1.3 GB
Category: Programming

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. [Read more…]

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 [Read more…]