Introduction To Transact-SQL
WEBRip | English | MP4 | 960 x 540 | AVC ~328 kbps | 29.970 fps
AAC | 160 Kbps | 48.0 KHz | 2 channels | 4h 46mn | 923.9 MB
Genre: Video Tutorial / Development, Programming
| “ |
Learn how to utilize Transact-SQL to address real business requirements and gain a solid understanding of your SQL Server database. Jeff Jones, an IT professional with over forty years of experience shows you how to use the tools available in Transact-SQL to discover the database definition, access tables, submit queries, and view the results. |
” |
Content:
Introduction
Welcome
1. Discovering the Database
Using SQL Server Management Studio (SSMS)
Identifying table relationships
SSMS diagram support
Preparing to write SQL
2. Accessing Tables
The basic SELECT statement
Combining two tables with a join
Combining multiple tables with a join
3. Filtering the Data
Filtering the data
Using functions
4. Displaying Data
Defining the result set
Manipulating numbers and data types
Using conditional column output
Controlling output rows
5. Aggregating Data
Grouping gata
also You can look my other last: Programming-posts
MediaInfo:General
Complete name : 184140_04_01_MM30_Filtering.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 141 MiB
Duration : 39mn 28s
Overall bit rate : 499 Kbps
Encoded date : UTC 2014-08-20 01:07:02
Tagged date : UTC 2014-08-20 01:07:02
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 5 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 39mn 28s
Bit rate : 328 Kbps
Maximum bit rate : 2 583 Kbps
Width : 960 pixels
Height : 540 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 29.970 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.021
Stream size : 92.5 MiB (66%)
Title : Telestream Inc. Dib Library 5.0.25.121516
Writing library : x264 core 129
Encoding settings : cabac=1 / ref=5 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=14 / lookahead_threads=2 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=1 / b_pyramid=0 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=300 / keyint_min=29 / scenecut=50 / intra_refresh=0 / rc_lookahead=55 / rc=crf / mbtree=1 / crf=26.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=1040 / vbv_bufsize=10400 / crf_max=0.0 / nal_hrd=none / ip_ratio=3.00 / aq=1:1.00
Language : English
Encoded date : UTC 2014-08-20 01:07:02
Tagged date : UTC 2014-08-20 01:07:02
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 39mn 28s
Bit rate mode : Constant
Bit rate : 160 Kbps
Nominal bit rate : 128 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Compression mode : Lossy
Stream size : 45.2 MiB (32%)
Title : Telestream Inc. Dib Library 5.0.25.121516
Language : English
Encoded date : UTC 2014-08-20 01:07:02
Tagged date : UTC 2014-08-20 01:07:02
Screenshots
