Post Description

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