SQL Essential Training

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

 Table of content

• Introduction
  • Welcome
  • Using the exercise files
  • Course overview
  • Installing the test environment on a Mac
  • Installing the test environment on a PC
  • What is SQL?
• SQL Quick Start
  • Quick-start introduction
  • Using the basic SELECT statement
  • Selecting rows
  • Selecting columns
  • Counting rows
  • Inserting data
  • Updating data
  • Deleting data
• Fundamentals
  • Databases and tables
  • SQL syntax overview
  • Formatting SQL
  • Creating tables
  • Deleting a table with DROP TABLE
  • Inserting rows into a table
  • Deleting rows from a table
  • Understanding NULL
  • Controlling column behaviors with constraints
  • Changing a schema with ALTER
  • Creating an ID column
  • Filtering data with WHERE, LIKE, and IN
  • Removing duplicates with SELECT DISTINCT
  • Sorting with ORDER BY
  • Conditional expressions with CASE
•  Relationships
  • Understanding joins
  • Accessing related tables with JOIN
  • Using multiple related tables
• Strings
  • About SQL strings
  • Finding the length of a string
  • Selecting part of a string
  • Removing spaces with TRIM
  • Making strings uppercase and lowercase
• Numbers
  • About numeric types
  • Finding the type of a value
  • Integer division and remainders
  • Rounding numbers
• Dates
  • Dates and times
  • Date- and time-related functions
• Aggregates
  • How aggregates work
  • Using aggregate functions
  • Aggregating DISTINCT values
• Transactions
  • Why use transactions?
  • Using transactions
•  Triggers
  • Updating a table with a trigger
  • Preventing automatic updates with a trigger
  • Automating timestamps with a trigger
•  Subselects and Views
  • Creating a simple subselect
  • Searching within a result set
  • Creating a view
  • Creating a joined view
•  A Simple CRUD Application
  • Touring the CRUD application
  • The SELECT functions
  • The INSERT, UPDATE, and DELETE functions
• Conclusion
  • Goodbye

Uploaded.net 

1. http://ul.to/6uf4b9y2

Rapidgator.net 

1. bit.ly/1xoCFYA

Uploadable.ch 

1. bit.ly/1mYkRQE