VTC - Database Optimization
WEBRip | English | MP4 + Project Files | 800 x 600 | AVC ~43.3 kbps | 10 fps
AAC | 66.2 Kbps | 44.1 KHz | 1 channel | 7h 50mn | 460 MB
AAC | 66.2 Kbps | 44.1 KHz | 1 channel | 7h 50mn | 460 MB
Genre: Video Tutorial / Development, Programming
This Database Optimization course provides viewers with important techniques and checklists to configure, monitor, and manage their databases. You will learn how to develop a tuning strategy, explore the tuning and diagnostic tools, understand the relational database model and implications on performance, evaluate the application for efficient design, structure, and other factors affecting performance and evaluate hardware for effects on performance. Join us as we review best practices in designing, optimizing, and maintaining your database. You will benefit from this course whether you have some experience with optimizing databases or are just starting out. Work files are included. To begin learning today, simply click on the movie links.Content:
Introduction
Introduction & Disclaimers
Optimizing a Database
Some Common Problems
Designing for Performance
Planning & Process Principles
Design Principles
Client/Server Interaction
Troubleshooting & Testing
What to Look for
Types of Testing
SQLdiag Tool
Conducting an Audit
Understanding Audits
Components of Audits
Examples of Components
Creating Audits Through Procedures
Relationships & Joins
Relationships
Understanding Joins
Optimizing Joins
Joins & Indexing
Referential Integrity
Proper Use of Integrity
Integrity Continued
Primary/Foreign/Candidate Keys
Troubleshooting Integrity
Data Types & Validations
Unions
UNION in SQL
Standards
Validation
Creating a Data Model
Conceptual/Logical/Physical Models
Relational Modeling
Entity Model
Schemas
Database Normalization
First Normal Form
Second Normal Form
Third Normal Form
Denormalization
Temporary Tables
Creating & Using Temporary Tables
Heap & Memory Tables
EXPLAIN Statement
Query/Views Optimization
Introduction to Execution Plans
Running the SQL Execution Plan
Using Profiler for the Execution Plan
SET SHOWPLAN_TEXT
Index Strategies
Effective Indexes
Short & Distinct Keys
Looking at Indexes in SQL
Optimizing & Indexes
Clustered Indexes
Clustered vs. Non-Clustered Indexes
Tips for Clustered Indexes
Significance on Performance
More Tuning
Eliminating Unwanted Data
SHRINKFILE Examples
Database Tuning Advisor
DTA Example
Data Types & Quality
Data Quality
Overview of Data Types
SQL vs. Oracle Data Types
Examples in SQL
Best Practices
Creating a Sustainable Database
Documentation
Most Common Practices
Stored Procedures & Triggers
Stored Procedures/Functions/Triggers
Writing Stored Procedures
Creating a Function & When to Use
Working with Triggers
Hardware Performance Concepts
CPU & Input/Output
Memory Management
Network Infrastructure
Applying Performance Concepts
Task Manager
System vs. Performance Monitor
Performance Monitor
SQL Database I/O Report
Examples for sys.dm_io_virtual_file_stats
Monitoring
Event Viewer
SQL Activity Monitor
Locks & Deadlocks
Monitoring Services
Database Security
Privileges
Role Based Authorization
GRANT & REVOKE Statements
Reviewing Security in SQL
Understanding Lifecycles
Lifecycle Management
The Database Lifecycle
Using the SQL Management Plan
Using Baselines & Profiler
Importance of Baselines
SQL Profiler
Trace & Other Profiler Tools
Terminology in Work Files
Analyzing Slow Performance
Database Testing
Thoughts on Troubleshooting
Generalized Tips
Optimizing Code
Levels of Optimization
UNION vs. OR Optimization
JOIN vs. WHERE
Weak Joins
Coding Tips
Statistics
Overview of Statistics
Seeing Statistics in SQL
Auditing
Auditing in SQL
Other Components
Database Consistency Checker (DBCC)
DBCC in SQL
System Catalog
System Catalog in SQL
Checklists
Architecture & Design
Constraints & Influences
Performance Tuning
Index Checklist
General Checklist
Odds & Ends
Business Intelligence
Archiving
ADONET
Conclusion
Wrap Up & Work Files
Credits
About the Author
also You can look my other last: Programming-posts
General
Complete name : 5 Client Server Interaction.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 4.02 MiB
Duration : 5mn 2s
Overall bit rate mode : Variable
Overall bit rate : 112 Kbps
Encoded date : UTC 2013-06-13 14:43:51
Tagged date : UTC 2013-06-13 14:43:59
Writing application : HandBrake 0.9.9 2013051800
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : High@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 5mn 2s
Bit rate mode : Variable
Bit rate : 43.3 Kbps
Width : 800 pixels
Height : 600 pixels
Display aspect ratio : 4:3
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.009
Stream size : 1.56 MiB (39%)
Writing library : x264 core 130 r2273 b3065e6
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x3:0x113 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=1 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / lookahead_threads=2 / 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=100 / keyint_min=10 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=20.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2013-06-13 14:43:51
Tagged date : UTC 2013-06-13 14:43:59
Color primaries : BT.601-6 525, BT.1358 525, BT.1700 NTSC, SMPTE 170M
Transfer characteristics : BT.709-5, BT.1361
Matrix coefficients : BT.601-6 525, BT.1358 525, BT.1700 NTSC, SMPTE 170M
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 5mn 1s
Bit rate mode : Variable
Bit rate : 66.2 Kbps
Maximum bit rate : 76.0 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 2.37 MiB (59%)
Language : English
Encoded date : UTC 2013-06-13 14:43:51
Tagged date : UTC 2013-06-13 14:43:58
Complete name : 5 Client Server Interaction.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 4.02 MiB
Duration : 5mn 2s
Overall bit rate mode : Variable
Overall bit rate : 112 Kbps
Encoded date : UTC 2013-06-13 14:43:51
Tagged date : UTC 2013-06-13 14:43:59
Writing application : HandBrake 0.9.9 2013051800
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : High@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 5mn 2s
Bit rate mode : Variable
Bit rate : 43.3 Kbps
Width : 800 pixels
Height : 600 pixels
Display aspect ratio : 4:3
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.009
Stream size : 1.56 MiB (39%)
Writing library : x264 core 130 r2273 b3065e6
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x3:0x113 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=1 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / lookahead_threads=2 / 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=100 / keyint_min=10 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=20.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2013-06-13 14:43:51
Tagged date : UTC 2013-06-13 14:43:59
Color primaries : BT.601-6 525, BT.1358 525, BT.1700 NTSC, SMPTE 170M
Transfer characteristics : BT.709-5, BT.1361
Matrix coefficients : BT.601-6 525, BT.1358 525, BT.1700 NTSC, SMPTE 170M
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 5mn 1s
Bit rate mode : Variable
Bit rate : 66.2 Kbps
Maximum bit rate : 76.0 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 2.37 MiB (59%)
Language : English
Encoded date : UTC 2013-06-13 14:43:51
Tagged date : UTC 2013-06-13 14:43:58
Screenshots
For more Exclusive material, Visit my AH-blog