Joes2Pros Querying Microsoft SQL Server 101 (70-461 Exam Prep) and SQL Server Reporting Services 2012

Joes2Pros Querying Microsoft SQL Server 101 (70-461 Exam Prep) and SQL Server Reporting Services 2012
English | Size: 2.83 GB (3,040,010,369 bytes)
Category: Tutorial

Students will learn about queries, joins, transactions, basic stored procedures, basic security and code commenting. This course is designed for beginners who have already completed our introductory course “Introduction to Microsoft SQL Server and Databases”. Students who wish to follow along with the instructor will need to have a computer that is running SQL Express 2012 (free) or SQL Developer 2012. Links for both of these are located within the resource library. *Note: Courses 201-501 will require SQL Developer to follow along. This course will be useful for technology professionals who need to get to know SQL a little better. In order to truly understand this material it is highly recommended that you follow along with the instructor.

Querying SQL Server

SQL Server Reporting Service 2012
SSRS stands for SQL Server Reporting Services. SSRS development is modeled after many Windows software products that allow you to add graphics and format text. In this course you will learn how to use, build, modify, and connect data to SSRS reports. You will also learn about security and some advanced techniques like how to create data maps, KPIs, and subreports and format all types of reports for a great presentation. In order to truly understand this material it is highly recommended that you follow along with the instructor. In order to follow along this course requires that you have a system running SQL Developer 2012 ($45) and have downloaded the companion files. Links for both are located within the resource library. Tutorial videos for installing SQL Developer 2012 and your lab files are located at joes2pros.com under “Free Videos” then “Getting Started”.

http://joes2pros.com/

[mediainfio]eneral
Complete name : /Joes2Pros/Part 1/1.1) About Databases SQL Server and Basic Queries.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 6.86 MiB
Duration : 2mn 52s
Overall bit rate : 333 Kbps
Encoded date : UTC 2013-07-15 21:24:38
Tagged date : UTC 2013-07-15 21:24:38

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : [email protected]
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Format settings, GOP : M=1, N=50
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 2mn 52s
Source duration : 2mn 52s
Bit rate : 278 Kbps
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 10.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.030
Stream size : 5.71 MiB (83%)
Source stream size : 5.71 MiB (83%)
Language : English
Encoded date : UTC 2013-07-15 21:24:38
Tagged date : UTC 2013-07-15 21:24:38
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709
mdhd_Duration : 172701

Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 2mn 52s
Source duration : 2mn 52s
Bit rate mode : Constant
Bit rate : 53.6 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 1.10 MiB (16%)
Source stream size : 1.10 MiB (16%)
Language : English
Encoded date : UTC 2013-07-15 21:24:38
Tagged date : UTC 2013-07-15 21:24:38
mdhd_Duration : 172708[/mediainfo]

NOTE: All of the downloadable books/course extras are in the books folder. Tried to organize it the best I could but the joes2pros website isn’t particularly well organized. Might have to poke around a bit to make sure you have the right files.

Buy Long-term Premium Accounts To Support Me & Max Speed

DOWNLOAD:

http://uploaded.net/file/bkdbt8ac/Joes2Pros.part1.rar
http://uploaded.net/file/kj5j481n/Joes2Pros.part2.rar
http://uploaded.net/file/i9gsj81h/Joes2Pros.part3.rar
http://uploaded.net/file/9jzguul4/Joes2Pros.part4.rar
http://uploaded.net/file/b991mugx/Joes2Pros.part5.rar
http://uploaded.net/file/23ht6ntc/Joes2Pros.part6.rar
http://uploaded.net/file/kjjen3fe/Joes2Pros.part7.rar

http://rapidgator.net/file/1b215b6f42d177945ead6ab0a4bed4ec/Joes2Pros.part1.rar.html
http://rapidgator.net/file/efec8d7e9e4308f0d9e74796401086dd/Joes2Pros.part2.rar.html
http://rapidgator.net/file/7197531e0c7db44aaa575ee9783fb8f5/Joes2Pros.part3.rar.html
http://rapidgator.net/file/689a2edcc671ac1d9b112a63071226f8/Joes2Pros.part4.rar.html
http://rapidgator.net/file/f5bea6846c845807d2f2b2c10b75e6c9/Joes2Pros.part5.rar.html
http://rapidgator.net/file/5b5453d1c2b2ae981820cbea291fda6e/Joes2Pros.part6.rar.html
http://rapidgator.net/file/859a871ba973dd5f2fb9ec80739b9e68/Joes2Pros.part7.rar.html

If any links die or problem unrar, send request to http://goo.gl/aUHSZc