SQL Essential Training

Teaches the major features of SQL, a solid working knowledge of the language, and how to retrieve and manage data efficiently.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