HF | 149.9 MB | Exercise files incl.
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
Download