XYZ軟體急先鋒


LYNDA SQL ESSENTIAL TRAINING 2014 視頻教學 英文教學版




-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
軟體名稱:LYNDA SQL ESSENTIAL TRAINING 2014 視頻教學 英文教學版
語系版本:英文教學版
光碟片數:單片裝
破解說明:
系統支援:For Windows XP/Vista/7
軟體類型:視頻教學
硬體需求:PC
更新日期:2014-04-20
官方網站:http://www.lynda.com/SQL-tutorials/SQL-Essential-Training/139988-2.html
中文網站:
軟體簡介:
銷售價格:$80元
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 



 
軟體簡介:
 
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

 


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=