Nature Season 35 Episode 6 s35e06 | Členové | Crow2016
Search in!

Training Spot - Transact SQL 101

语言: English

标签: 数据库

The poster (email) is not available. 收藏推荐: Bookmark this: Training Spot Transact SQL 101


Training Spot Transact SQL 101

Training Spot - Transact SQL 101

English | .WMV | wmv3, yuv420p, 800x600, 124 kb/s, 15.00 fps | 0x000a, 22050 Hz, 1 channels, s16, 20 kb/s | 230 MB
Genre: eLearning

This series will introduce you to the Transact-SQL (T-SQL) language. T-SQL is used to interact with your relational database for such tasks as retrieving records from your tables, updating, inserting and deleting data. This series is geared towards the absolute beginner and will give you the foundation needed to becoming a T-SQL expert.
Tutorials In This Series
Lesson 1: SQL Server 2005 and Transact-SQL
Introduction to SQL
Duration: 6 Minutes 34 Seconds
Using SQL Server Management Studio (SSMS)
Duration: 20 Minutes 24 Seconds
Installing the Sample Databases
Duration: 4 Minutes 58 Seconds
Lesson 2: SQL Server Data Types
Understanding and Using Data Types
Duration: 16 Minutes 02 Seconds
Understanding and Enforcing Data Integrity
Duration: 7 Minutes 36 Seconds
Lesson 3: Retrieving Data (Part I)
Retrieving Data Using the SELECT Statement
Duration: 10 Minutes 55 Seconds
Limiting Your Result Set Using TOP
Duration: 3 Minutes 38 Seconds
Lesson 4: Retrieving Data (Part II)
Filtering Results Using the WHERE clause
Duration: 9 Minutes 15 Seconds
Using AND, OR and Other Logical Operators
Duration: 9 Minutes 10 Seconds
Finding Data Using the LIKE Operator
Duration: 13 Minutes 23 Seconds
Lesson 5: Joining Tables
Joining Tables Using INNER Joins
Duration: 10 Minutes 22 Seconds
Using Inner Joins to Join More Than Two Tables
Duration: 7 Minutes 15 Seconds
Joining Tables Using LEFT, RIGHT and FULL OUTER Joins
Duration: 10 Minutes 54 Seconds
Lesson 6: Modifying Data
Inserting Records Using INSERT
Duration: 10 Minutes 56 Seconds
Updating Records Using UPDATE
Duration: 9 Minutes 13 Seconds
Deleting Records Using DELETE
Duration: 3 Minutes 36 Seconds
Lesson 7: Using String and Data Functions
Introduction to SQL Server 2005 Functions
Duration: 10 Minutes 59 Seconds
Using the LEFT, RIGHT and SUBSTRING Functions
Duration: 9 Minutes 05 Seconds
Manipulating Strings Using LTRIM, RTRIM and Other String Functions
Duration: 8 Minutes 47 Seconds
Understanding and Using SQL Server Date Functions
Duration: 5 Minutes 14 Seconds
Performing Date Calculations Using DATEADD and DATEDIFF
Duration: 5 Minutes 50 Seconds
Lesson 8: Aggregate, Ranking and Other Functions
Using Aggregate Functions to Group Data
Duration: 15 Minutes 15 Seconds
ROWNUMBER, RANK and Other Ranking Functions
Duration: 9 Minutes 08 Seconds
Changing Data Types Using CAST and CONVERT
Duration: 11 Minutes 31 Seconds
Lesson 9: Subqueries
Understanding and Using Subqueries
Duration: 10 Minutes 49 Seconds
Lesson 10: Control-Of-Flow Language
Display Alternate Values Using the CASE Function
Duration: 9 Minutes 38 Seconds
Lesson 11: Introduction to Temporary and Derived Tables
Using Common Table Expressions (CTE)
Duration: 7 Minutes 02 Seconds
Writing Recursive Queries Using Common Table Expressions
Duration: 9 Minutes 25 Seconds
Lesson 12: Variables
Introduction to SQL Server Variables
Duration: 10 Minutes 43 Seconds

Training Spot Transact SQL 101



[Directly Download] Training Spot - Transact SQL 101!

Download this book
DOWNLOAD Free download ezdownloader, then you can free download.

Download "Training Spot - Transact SQL 101"


Copyright Disclaimer:
本站一切内容源于互联网搜索,禁止商用! 如有任何不妥请联系:[email protected],我们将在24小时内删除相关内容。

浏览量:0 添加时间:2014-04-22 09:19:03, 更新时间:2014-04-22 09:19:03, shared by honhungoc


Search mirrors of "Training Spot - Transact SQL 101"...

Search in!


Free Magazine Subscriptions & Technical Document Downloads



如果不能下载或者在“图书介绍”中找不到 "Training Spot - Transact SQL 101" 的下载链接请留言。下次访问本站时察看 所有留言 看是否有人已经更新了该书。

该书可能有其它下载链接,请点 这里查询相关图书


"Training Spot - Transact SQL 101" 相关链接:


"Training Spot - Transact SQL 101" 没有评论.

    Leave a Comment




    email addresses


    Not clear? Click to refresh.

    1. 艺术设计
    2. 有声读物
    3. 语言文化
    4. 家庭生活
    5. 法律
    6. 音乐歌词
    7. 软件相关
    8. BT种子
    9. 其它图书
    10. 所有留言
    11. 留言评论
    12. Download Thousands of Books two weeks for FREE!
    13. Download millions of Usenet resources!
    14. 海淀驾校
    Back to Top