Trending

Thursday, July 3, 2014

SQL Essential Training

Lynda – 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

No comments:

Post a Comment

About

Contact Form

Name

Email *

Message *

Copyright © 2013 TOTdownload.com
Designed By Blogger Templates