Search 6,000+ CA Community College Courses

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Server Questions and Answers

via Pluralsight

Go to class Write review

Overview

This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works.

This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works. This course is for anyone working with SQL Server databases who wants to improve her knowledge and understanding of this complex platform.

Syllabus

  • Introduction 0mins
  • Retrieving IDENTITY value using @@IDENTITY 8mins
  • Concepts Related to Identity Values 4mins
  • Difference between WHERE and HAVING 5mins
  • Order in WHERE clause 7mins
  • Concepts Around Temporary Tables and Table Variables 9mins
  • Are stored procedures pre-compiled? 5mins
  • UNIQUE INDEX and NULLs problem 6mins
  • DELETE VS TRUNCATE 6mins
  • Locks and Duration of Transactions 15mins
  • Nested Transaction and Rollback 9mins
  • Understanding Date/Time Datatypes 7mins
  • Differences between VARCHAR and NVARCHAR datatypes 6mins
  • Precedence of DENY and GRANT security permissions 5mins
  • Identify Blocking Process 6mins
  • NULLS usage with Dynamic SQL 8mins
  • Appendix Tips and Tricks with Tools 20mins

Taught by

Vinod Kumar

Reviews

4.1 rating at Pluralsight based on 295 ratings

Start your review of SQL Server Questions and Answers

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.