Author:Bill Weinman
Duration (hr:min):2:22
Released on:4/8/2009
Software works on:Mac and Windows
Homepage:http://www.lynda.com/home/displaycourse.aspx?lpk2=769
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
Lynda.com-SQL Essential Training.part1
Lynda.com-SQL Essential Training.part2
If you like this post then consider sharing it with others.
Stay Updated via Email Newsletter
Post a Comment