SQL Essential Training

SQL Essential Training
SQL Essential Training

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3h 27m | 502 MB
eLearning | Skill level: All Levels


Whatever a database is being used for—websites, bookkeeping, sales and inventory, or even the lowly to-do list—it’s still all about the data. Completely updated for 2014, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. Beginning with a quick start introduction for those who want to start working with data immediately, instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and working with subselects and views. He offers a solid working knowledge of the language, and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple CRUD (Create, Read, Update, and Delete) application using SQL.

Topics include:

  • Understanding SQL terminology and syntax
  • Creating new tables and records
  • Inserting and updating data
  • Writing basic SQL queries
  • Sorting and filtering
  • Accessing related tables with JOIN
  • Working with strings
  • Finding the numeric type of a value
  • Using aggregate functions and transactions
  • Updating a table with triggers
  • Creating views
Download from Turbobit

Download from DepositFiles