47+ SQL/SQL Performance Tuning videos with Essential Source Code
Online Access with Download Facility
1600 OR 23
: +91-99675 90707Buy now
What you'll learn :This course teaches SQL Server step by step from the perspective of developers beginners level to advance. We have also included SQL Performance tuning videos for high tuning and to achieve professionalism in SQL. Complete 12+ hrs of total learning.
Our Demo Video :
Learn SQL Server Step by Step ==================================== Lab 1: - Basic Fundamentals Database, Tables, rows and columns. Lab 2: - Primary key, foreign key, referential integrity and constraints. Lab 3: - Database Normalization (1st, 2nd and 3rd normal forms). Lab 4: - SQL basics(Select, Insert, Update and Delete) Lab 5: - DDL (Data definition language) Queries. Lab 6: - Transactions, Locks and Isolation level in SQL Server. Lab 7: - ISNULL and Coalesce functions. Lab 8: - Row_Number, Partition, Rank and DenseRank Lab 9: - Triggers, inserted and deleted tables Lab 10: - Instead of and after triggers. Lab 11: - Denormalization, OLTP and OLAP. Lab 12: - Understanding Star schema and Snow flake design. Lab 13: - SQL Server 8 kb pages. Lab 14: - Index and performances Lab 15: - Page Split and indexes Lab 16:- Clustered vs non-clustered Lab 17: - Stored procedures and their importance. Lab 18: - Change Data Capture. Lab 19: - Explain Columnstore Indexes? Lab 20: - SQL Server agent Lab 21: - How can we implement Pivot & Unpivot in SQL Server? SQL Performance Tuning =========================== Basics:- Query plan, Logical operators and Logical reads Point 1:- Unique keys improve table scan performance. Point 2:- Choose Table scan for small & Seek scan for large records Point 3:- Use Covering index to reduce RID (Row Identifier) lookup Point 4:- Keep index size as small as possible. Point 5:- use numeric as compared to text data type. Point 6:- use indexed view for aggregated SQL Queries Point 7:- Database Engine tuning advisor is your best friend. Part 1 - Profiler, Tuning advisor, Clustered/Non-clustered indexes,DBCC command & Reading SQL Plan, OLTP & OLAP. Part 2 - Estimated vs Actual plan/rows, SQL Plan revised, Table/Index scan, Indexes seek, Physical/Logical opertn, Execution mode, columnstore, Rebinds, Rewinds, Nested loop, Hash/Merge join Part 3 - Interleaved Execution, Fragmentation, Performance counters, Page splits and Unused Indexes Part 4 - Extended events, RID lookup and Covering indexes Part 5 - Indexed views, Page splits & unused indexes, Dead locks, Query store Parameter sniffing Statistics Part 6 - Inline vs Stored procedure SQL, Cache miss, Cache hit, Parameter sniffing and Query store. Part 7 - Partitioning, Wait stats, Resource Governor, Inmemory Tables