最新消息:请大家多多支持

Using T-SQL Functions and Summarizing Results

教程/Tutorials dsgsd 168浏览 0评论



MP4 | Video: AVC 1920 x 1080 | Audio: AAC 48 KHz 2ch | Duration: 00:48:24 | 1.01 GB
Genre: eLearning | Language: English

Enhance your SELECT statements by invoking a vast library of built-in features and capabilities that SQL Server exposes in the form of functions. This video shows how these functions enable data type conversions, null detections, date and number formatting, and much more. Also available are functions helping you to analyze data in the database itself. These functions enable you to summarize data to count occurrences, compute averages, and generate statistics.

The video begins with an introduction to basic functions to work with character data and NULL values. From there you’ll move on to functions dealing with conditional structures, NULL values, and formatting. You’ll also cover aggregate functions to average, count, and summarize data. Finally, this video discusses how to group result sets by a field using the GROUP BY clause, and how to filter those results after they have been grouped — using the HAVING clause.

Functions are the doorway to an ever-increasing number of powerful database engine features and capabilities. There is so much more that you can do in SQL other than simply SELECT data. Functions enable you to take full advantage of the power that’s available to you in Microsoft’s flagship database engine. This video is the second in a series and leaves you well positioned to step into the next video covering how to select data from multiple tables.

What You Will Learn

Sort data into groups and count the records in each group
Compute max, min, and mean values for records in a group
Format dates and numbers for display to end users
Filter to eliminate unwanted groupings from your result set
Search, concatenate, and manipulate strings
Detect NULL values and replace them with real values

Password/解压密码-0daydown

Download rapidgator
https://rg.to/file/f5d918c9cc51fb2aeb8db56742dbfd60/Using_TSQL_Functions_and_Summarizing.part1.rar.html
https://rg.to/file/8934035159bdb472abbd5851a3936854/Using_TSQL_Functions_and_Summarizing.part2.rar.html

Download nitroflare
http://nitroflare.com/view/3195FB19921FF71/Using_TSQL_Functions_and_Summarizing.part1.rar
http://nitroflare.com/view/25DD63E7C8BC6BB/Using_TSQL_Functions_and_Summarizing.part2.rar

Download 百度云

你是VIP 1个月(1 month)赞助会员,

资源下载此资源仅限VIP下载,请先

转载请注明:0daytown » Using T-SQL Functions and Summarizing Results

您必须 登录 才能发表评论!