About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
SQL Server Tutorial
Lab1 :- Basic fundamentals Database, Tables, rows and columns
Lab1 :- Basic fundamentals Database, Tables, rows and columns
Preview
Lab 2:- Primary key, foreign key, referential integrity and constraints.
Lab 2:- Primary key, foreign key, referential integrity and constraints.
Preview
Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).
Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).
Preview
Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).
Lab 4: - SQL basics(Select, Insert, Update and Delete).
Lab 4: - SQL basics(Select, Insert, Update and Delete).
Preview
Lab 4: - SQL basics(Select, Insert, Update and Delete).
Lab 5 :- DDL (Data definition language) Queries.
Lab 5 :- DDL (Data definition language) Queries.
Preview
Lab 6: - Transactions, Locks and Isolation level in SQL Server.
Lab 6: - Transactions, Locks and Isolation level in SQL Server.
Preview
Lab 7: - ISNULL and Coalesce functions.
Lab 7: - ISNULL and Coalesce functions.
Preview
Lab 8: - Row_Number, Partition, Rank and DenseRank.
Lab 8: - Row_Number, Partition, Rank and DenseRank
Preview
Lab 9: - Triggers, inserted and deleted tables
Lab 9: - Triggers, inserted and deleted tables
Preview
Lab 10: - Instead of and after triggers.
Lab 10: - Instead of and after triggers.
Preview
Lab 11: - Denormalization, OLTP and OLAP.
Lab 11: - Denormalization, OLTP and OLAP.
Preview
Lab 12: - Understanding Star schema and Snow flake design.
Lab 12: - Understanding Star schema and Snow flake design.
Preview
Lab 13: - SQL Server 8 kb pages.
Lab 13: - SQL Server 8 kb pages.
Preview
Lab 14 :- Index and performances.
Lab 14 :- Index and performances.
Preview
Lab 15 :- Page Split and indexes.
Lab 15 :- Page Split and indexes.
Preview
Lab 16 :- Clustered vs non-clustered.
Lab 16 :- Clustered vs non-clustered.
Preview
Lab 17: - Stored procedures and their importance.
Lab 17: - Stored procedures and their importance.
Preview
Lab 18: - Change Data Capture.
Lab 18: - Change Data Capture.
Preview
Lab 19: - Explain Columnstore Indexes?
Lab 19: - Explain Columnstore Indexes?
Preview
Lab 20: - SQL Server agent.
Lab 20: - SQL Server agent.
Preview
Lab 21: - How can we implement Pivot & Unpivot in SQL Server?
Lab 21: - How can we implement Pivot & Unpivot in SQL Server?
Preview
Lab 15 :- Page Split and indexes.
SQL Server Tutorial
Lab 15 :- Page Split and indexes.
By:
Quest Pond
8 minutes
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
In this video we will see how in indexes affect performance for insert, update and delete operations.
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
Share
Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.
Share with Google Contacts