Lynda Sql Essential Training 2014 Tutorial

Description

TITLE: SQL ESSENTIAL TRAINING

PUBLISHER: LYNDA LANGUAGE: ENGLISH

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


Size: 390 MB

Download
https://top4top.io/downloadf-2381ywj8h1-rar.html
https://top4top.io/downloadf-2381gp85r2-rar.html