Learn SQL server step by step

47+ SQL/SQL Performance Tuning videos with Essential Source Code | Online Access with Download Facility

by ShivPrasad Koirala

Best Seller
Learn SQL server step by step

Includes

47+ SQL/SQL Performance Tuning videos with Essential Source Code

Online Access with Download Facility

1600 OR 23

: +91-99675 90707

Buy 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

Best Seller
  • Learn SQL server step by step


  • Email: questpond@questpond.com
  • Phone: +91-9967590707