Lynda - SQL Essential Training
Lynda.com - SQL Essential Training
English | MOV | 880x660 | 3.289 fps | AVC ~ 50 kbps | AAC ~ 70 kbps | 166 MB
Whatever a database is being used for—web sites, bookkeeping, sales and inventory, or even the lowly to-do list—it’s all about the data. SQL Essential Training is designed to help users understand the most common language for database wrangling—SQL. Beginning with a brief introduction, instructor Bill Weinman teaches the major features of SQL; he offers a solid working knowledge of the language, and how to retrieve and manage data efficiently. He also works through a real-world example of building a CRUD (Create, Read, Update, and Delete) application using SQL. Exercise files accompany the course.
Topics include:
•Understanding SQL terminology and syntax
•Writing basic SQL queries
•Sorting and filtering
•Inserting and updating data
•Writing string and numeric functions
•Finding and deleting duplicate data
