Advanced Microsoft SQL Server (2016/Azure): Become a Master! (08/2021)
Advanced Microsoft SQL Server (2016/Azure): Become a Master!
WEBRip | English | MP4 | 1280 x 720 | AVC ~571 Kbps | 30 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~15.5 hours | 6.26 GB
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~15.5 hours | 6.26 GB
Genre: eLearning Video / IT & Software, Operating Systems & Servers, SQL Server
This course is designed for DBAs to implement, monitor, and maintain enterprise database solutions.What you'll learn
Learn How to Configure data access and auditing
Learn How to Manage backup and restore of databases
Learn How to Manage and monitor SQL Server instances
Learn How to Manage high availability and disaster recovery
Learn How to Implement SQL in Azure
Learn How to Manage databases and instances
Learn How to Manage Storage
Requirements
A PC
Internet Access
Description
Microsoft SQL Server comes equipped with industry-leading features and the best online transaction processing capabilities. It is one of the most popular relational database management systems developed by Microsoft. If you are looking to work with data processing and management, getting up to speed with Microsoft SQL Server is key. This course will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable.
This course takes you through the latest features in SQL Server and their importance. You’ll start by learning how to set up your SQL Server and configure new and existing environments for optimal use. You will also learn to unlock faster querying speeds and understand how to leverage the new and improved security features to build robust data management solutions. This course then takes you through designing aspects and delves into performance tuning by showing you how to use indexes effectively. Further lectures will assist you with integrating, managing, and analyzing all data, including relational, NoSQL, and unstructured big data using SQL Server. You’ll understand certain choices that need to be made about backups, implement security policy, and discover how to keep your environment healthy. Tools available for monitoring and managing a SQL Server database, including automating health reviews, performance checks, and much more, will also be discussed in detail. As you advance, the course covers essential topics such as migration, upgrading, and consolidation, along with the techniques that will help you when things go wrong. Dedicated sections in the course will also demonstrate how you can use SQL Server to leverage data processing platforms, such as Apache Hadoop and Spark, and containerization technologies like Docker and Kubernetes to control your data and efficiently monitor it. Once you’ve got to grips with integration with Azure and streamlining big data pipelines, you’ll learn best practices from industry experts for maintaining a highly reliable database solution.
Whether you are an administrator or are looking to get started with database administration, this course will help you develop the skills you need to successfully build robust data management solutions.
Who this course is for:
Web Developers
Software Developers
Programmers
Anyone interested in MS SQL Server
also You can find my other useful: IT-posts
General
Complete name : 004 Understanding Copy-Only Backups.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 51.7 MiB
Duration : 10 min 12 s
Overall bit rate : 708 kb/s
Writing application : Lavf58.12.100
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, RefFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 10 min 12 s
Bit rate : 571 kb/s
Nominal bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.021
Stream size : 41.7 MiB (81%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / 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=22 / lookahead_threads=3 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : mp4a-40-2
Duration : 10 min 12 s
Bit rate mode : Constant
Bit rate : 128 kb/s
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 kHz
Frame rate : 43.066 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 9.35 MiB (18%)
Default : Yes
Alternate group : 1
Complete name : 004 Understanding Copy-Only Backups.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 51.7 MiB
Duration : 10 min 12 s
Overall bit rate : 708 kb/s
Writing application : Lavf58.12.100
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, RefFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 10 min 12 s
Bit rate : 571 kb/s
Nominal bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.021
Stream size : 41.7 MiB (81%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / 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=22 / lookahead_threads=3 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : mp4a-40-2
Duration : 10 min 12 s
Bit rate mode : Constant
Bit rate : 128 kb/s
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 kHz
Frame rate : 43.066 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 9.35 MiB (18%)
Default : Yes
Alternate group : 1
Screenshots
Advanced Microsoft SQL Server (2016/Azure): Become a Master! (08/2021)
Advanced Microsoft SQL Server (2016/Azure): Become a Master! (08/2021)
Advanced Microsoft SQL Server (2016/Azure): Become a Master! (08/2021)
Advanced Microsoft SQL Server (2016/Azure): Become a Master! (08/2021)
Exclusive eLearning Videos ParRus-blog ← add to bookmarks
Advanced Microsoft SQL Server (2016/Azure): Become a Master! (08/2021)
