xyz軟體王

DVD29273--數據分析師八大能力培養 MP4格式 中文教學版(DVD一片裝)
TIC3081--SQL語法查詢入門 PDF電子書 繁體中文版
TIC3080--SQL達人的工作現場攻略筆記 PDF電子書 一本告訴您如何正確編寫與思考SQL的書籍 繁體中文版
DVD27695--72節課：跟李銳學Excel 從入門到精通 中文教學版(DVD一片裝)
DVD27696--Docker與微服務實戰 2022版 中文教學版(DVD一片裝)

　



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