Sunday, September 13, 2015

Introduction To Transact-SQL




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















For more, Visit my AH-blog