LYNDA SQL ESSENTIAL TRAINING 2014 TUTORIAL-kEISO

TITLE: SQL ESSENTIAL TRAINING
PUBLISHER: LYNDA LANGUAGE: ENGLISH
LINK: http://is.gd/a7hKvT RELEASE TYPE: RETAIL
AUTHOR: BILL WEINMAN RELEASE DATE: 2014.03.14
FORMAT: ISO STORE DATE: 2014.03.13
LEVEL: BEGINNER ISO CHECKSUM: 1AE95A66
ISO SIZE: 472.700.928 B DISKCOUNT: 09 X 50MB
RUNTIME: 03H 27M SAVED MONEY: YOU DID!
DISKNAME: keiso_lsqlet2014

TUTORIAL

Whatever a database is being used for-websites, bookkeeping
sales and inventory, or even the lowly to-do list-it's still all
about the data. Completely updated for 2014, SQL Essential
Training is designed to help users understand the most common
language for database wrangling, SQL. Beginning with a quick
start introduction for those who want to start working with data
immediately, instructor Bill Weinman teaches all the major
features of SQL: creating tables; defining relationships;
manipulating strings, numbers, and dates; using triggers to
automate actions; and working with subselects and views. He
offers a solid working knowledge of the language, and shows how
to retrieve and manage data efficiently. The final chapter
includes a real-world example of building a simple CRUD (Create
Read, Update, and Delete) application using SQL
Topics include:
Understanding SQL terminology and syntax
Creating new tables and records
Inserting and updating data
Writing basic SQL queries
Sorting and filtering
Accessing related tables with JOIN
Working with strings
Finding the numeric type of a value
Using aggregate functions and transactions
Updating a table with triggers
Creating views