一个数据库,无论是用于网站、簿记、销售和库存、甚或是简单的工作清单,它进行的都是处理数据的工作。本课程旨在帮助读者了解数据库定义最常用的语言— SQL。课程首先简要介绍,导师Bill Weinman讲解了SQL的主要功能特征,以及如何有效率的检索和管理数据。他还通过一个现实例子,运用SQL建立一个CRUD( 创建,读取,更新和删除 ) 应用。sunsource(特殊组-翻译)
SQL Essential Training | 455MB
Duration: 3h 28m | Video: AVC (.mp4) 1280×720 15fps | Audio: AAC 44.1KHz 1ch
Genre: eLearning | Level: Beginner | Language: English
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.
* 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 uploaded
http://uploaded.net/file/uqfnve6k/SQL.Essential.Training.rar
Download rapidgator
http://rg.to/file/f02d80d5e90c70d14c463ae7106d2d26/SQL.Essential.Training.rar.html
Download 百度云
转载请注明:0daytown » SQL Essential Training