Questions and Answers 0/151

• Lecture1.1
  Introduction

  Preview
  2m
• Lecture1.2
  Tell me about yourself
  3m
• Lecture1.3
  DBA roles on daily basis
  2m
• Lecture1.4
  Any third party databases tools have you worked so far
  1m
• Lecture1.5
  Difference between TRUNCATE and DELETE statements ?
  3m
• Lecture1.6
  Demo – Difference between TRUNCATE and DELETE statements ?
  5m
• Lecture1.7
  What is the Difference between IDENTITY and SEQUENCE object ?
  2m
• Lecture1.8
  Demo – What is the Difference between IDENTITY and SEQUENCE object ?
  3m
• Lecture1.9
  What is the difference between THROW and RAISERROR ?
  2m
• Lecture1.10
  Demo – What is the difference between THROW and RAISERROR ?
  5m
• Lecture1.11
  What is Transaction ?
  2m
• Lecture1.12
  Demo – What is Transaction ?
  3m
• Lecture1.13
  What is ROLLBACK?
  1m
• Lecture1.14
  What is COMMIT TRANSACTION ?
  1m
• Lecture1.15
  How would you find DEAD LOCK and BLOCKING ?
  1m
• Lecture1.16
  What is the difference between DEAD LOCK and BLOCKING ?
  2m
• Lecture1.17
  Demo – What is the difference between DEAD LOCK and BLOCKING ?
  5m
• Lecture1.18
  How would you deploy the code in multiple servers ?
  2m
• Lecture1.19
  What is the use of OFFSET – FETCH clause ?
  1m
• Lecture1.20
  Can we use OFFSET – FETCH clause without ORDER BY clause ?
  1m
• Lecture1.21
  Demo – Use of OFFSET – FETCH clause ?
  3m
• Lecture1.22
  What are the different types of relationships in relational database?
  3m
• Lecture1.23
  What is Collation?
  1m
• Lecture1.24
  What is Normalization? What are the different types of Normalization’s?
  3m
• Lecture1.25
  What are Statistics in SQL Server?
  2m
• Lecture1.26
  Demo-What are the Statistics in SQL Server?
  5m
• Lecture1.27
  What is Fragmentation?
  2m
• Lecture1.28
  Demo-What is Fragmentation?
  3m
• Lecture1.29
  How would you solve the worst performing query?
  4m
• Lecture1.30
  Demo-How would you solve the worst performing query?
  8m
• Lecture1.31
  What is the difference between INDEX SEEK and INDEX SCAN?

  Preview
  2m
• Lecture1.32
  Demo-What is the difference between INDEX SEEK and INDEX SCAN?

  Preview
  3m
• Lecture1.33
  Can I create additional indexes after column stored clustered index?
  1m
• Lecture1.34
  What is HEAP?
  2m
• Lecture1.35
  What is the difference between traditional index and columnstore index?
  3m
• Lecture1.36
  How many clustered Indexes can we create per table? why?
  2m
• Lecture1.37
  How many columns can we add in NonClustered index?
  3m
• Lecture1.38
  What are the advantages for Columnstore Index?
  3m
• Lecture1.39
  What are the advantages of Indexes in SQL Server?
  4m
• Lecture1.40
  What are the different types of indexes in SQL Server?
  3m
• Lecture1.41
  What is ROW LOCATOR?
  2m
• Lecture1.42
  Demo – Indexes Overview PART1
  10m
• Lecture1.43
  Demo – Indexes Overview PART2
  9m
• Lecture1.44
  What is the difference between Stored Procedure and Function?
  2m
• Lecture1.45
  Demo-How would you replace the values or text into existing data?
  3m
• Lecture1.46
  How can you convert one datatype to another datatype in SQL Server?
  2m
• Lecture1.47
  Demo-How can you convert one datatype to another datatype in SQL Server?
  2m
• Lecture1.48
  What is Indexed View?
  2m
• Lecture1.49
  Demo-Indexed View?
  3m
• Lecture1.50
  What is a Trigger?
  2m
• Lecture1.51
  What are the different types of Triggers in SQL Server?
  2m
• Lecture1.52
  When do we use Trigger?
  1m
• Lecture1.53
  Demo-Triggers Overview
  10m
• Lecture1.54
  What is a View?
  2m
• Lecture1.55
  Demo-What is View?
  4m
• Lecture1.56
  What are the advantages for using stored procedure?
  3m
• Lecture1.57
  Demo-What are the advantages for using stored procedure?
  5m
• Lecture1.58
  What are the different types of SQL Server JOIN’s?
  3m
• Lecture1.59
  Demo-What are the different types of SQL Server JOIN’s?
  6m
• Lecture1.60
  What is Global and Local Temporary table?
  2m
• Lecture1.61
  Demo-What is Global and Local Temporary table?
  5m
• Lecture1.62
  What is the difference between Table Variable and Temporary Table?
  2m
• Lecture1.63
  Demo-What is the difference between Table Variable and Temporary Table?
  4m
• Lecture1.64
  What are the types of SQL Server Constraints?
  3m
• Lecture1.65
  What is Composite Key?
  1m
• Lecture1.66
  What is the difference between Primary key and Foreign Key?
  1m
• Lecture1.67
  What is the difference between Primary Key and Unique Key?
  1m
• Lecture1.68
  Demo-SQL Server Constraints Overview.
  10m
• Lecture1.69
  Are logins and passwords replicated?
  1m
• Lecture1.70
  Demo-Are logins and passwords replicated
  1m
• Lecture1.71
  Can multiple publications use the same distribution database?
  2m
• Lecture1.72
  Demo-Can multiple publications use the same distribution database
  2m
• Lecture1.73
  Database Mirroring steps in sql server?
  1m
• Lecture1.74
  Demo-Database Mirroring steps in sql server
  2m
• Lecture1.75
  Can you explain Log shipping steps in SQL Server?
  2m
• Lecture1.76
  Demo-Can you explain Log shipping steps in SQL Server
  1m
• Lecture1.77
  Does replication encrypt the data?
  1m
• Lecture1.78
  Demo-Does replication encrypt the data
  1m
• Lecture1.79
  Does replication resume if a connection is dropped?
  1m
• Lecture1.80
  Demo-Does replication resume if a connection is dropped
  2m
• Lecture1.81
  How would you manage constraints on published tables?
  2m
• Lecture1.82
  Demo-How would you manage constraints on published tables
  2m
• Lecture1.83
  Log shipping – Secondary server being ‘Restore’ vs ‘Standby’?
  1m
• Lecture1.84
  Demo-Log shipping – Secondary server being ‘Restore’ vs ‘Standby’
  1m
• Lecture1.85
  Tables lock during the snapshot generation?
  2m
• Lecture1.86
  Demo-Tables lock during the snapshot generation
  2m
• Lecture1.87
  Under what circumstances Availability group FAILOVER?
  2m
• Lecture1.88
  Demo-Under what circumstances Availability group FAILOVER
  5m
• Lecture1.89
  What are the prerequisites of ALWAYS ON?
  2m
• Lecture1.90
  Demo-What are the prerequisited of ALWAYS ON
  1m
• Lecture1.91
  What heppens if the sanpshot agent has not completed when the distribution or Merge Agent starts?
  2m
• Lecture1.92
  Demo-What heppens if the sanpshot agent has not completed when the distribution or Merge Agent starts
  3m
• Lecture1.93
  What is ALWAYS ON in Sql Server 2014?
  2m
• Lecture1.94
  Demo-What is ALWAYS ON in Sql Server 2014
  2m
• Lecture1.95
  What is Availability Group?
  1m
• Lecture1.96
  Demo-What is Availability Group
  1m
• Lecture1.97
  What is Primary and Secondary Replica in Availability Group?
  2m
• Lecture1.98
  Demo-What is Primary and Secondary Replica in Availabilty Group

  Preview
  2m
• Lecture1.99
  What recovery model is required on a replicated databases?
  2m
• Lecture1.100
  Demo-What recovery model is required on a replicated databases
  2m
• Lecture1.101
  Why can’t I run TRUNCATE TABLE on a published table?
  1m
• Lecture1.102
  Demo-Why can’t I run TRUNCATE TABLE on a published table
  2m
• Lecture1.103
  What is a Fill Factor?
  2m
• Lecture1.104
  Demo -SQL Server Fill Factor
  2m
• Lecture1.105
  Difference between Index reorganization and Index rebuild?
  2m
• Lecture1.106
  Demo-Difference between Index reorganization and rebuild Index
  2m
• Lecture1.107
  How would you find out how much space is allocated to database log file and how much is used?
  3m
• Lecture1.108
  Demo-How would you find out how much space is allocated to dataabse log file and how much is used
  1m
• Lecture1.109
  How would you shrink the log file?
  3m
• Lecture1.110
  Demo-How would you shrink the log file
  2m
• Lecture1.111
  How would you troubleshoot errors in a SQL Server Agent Job?
  2m
• Lecture1.112
  Demo-How would you troubleshoot errors in a SQL Server Agent Job
  2m
• Lecture1.113
  What are the different types of Recovery Models in SQL Server?
  4m
• Lecture1.114
  Demo-What are the different types of Recovery Models in SQL Server
  2m
• Lecture1.115
  What are the different types of restoring process in SQL Server?
  2m
• Lecture1.116
  Demo-What are the different types of restoring process in SQL Server
  2m
• Lecture1.117
  How can you get SQLServer instance name,version and operating system?
  1m
• Lecture1.118
  Demo-How can you get SQLServer instance name,version and operating system
  2m
• Lecture1.119
  What is the best practice to configure TEMPDB
  2m
• Lecture1.120
  Demo-What is the best practice to configure TEMPDB
  2m
• Lecture1.121
  What is the difference between Actual and Estimate execution plan?
  2m
• Lecture1.122
  Demo-What is the difference between Actual and Estimate execution plan
  2m
• Lecture1.123
  What is the difference between Default and Named instance?
  2m
• Lecture1.124
  What are the default port numbers for SQL Server Browser and Default Instance?
  2m
• Lecture1.125
  What is page Split in SQL Server?
  1m
• Lecture1.126
  Demo-What is page Split in SQL Server
  1m
• Lecture1.127
  What is the default collation in SQL Server?
  1m
• Lecture1.128
  Can you change the existing collation in SQL Server?
  1m
• Lecture1.129
  Demo-What is the default collation in SQL Server
  2m
• Lecture1.130
  What is Page and Extent in SQL Server?
  1m
• Lecture1.131
  Demo-What is Page and Extent in SQL Server
  2m
• Lecture1.132
  Have you used any SQL Server DMV’s so far?
  2m
• Lecture1.133
  Demo-Have you used any SQL Server DMV’s so far
  2m
• Lecture1.134
  Have you used any DBCC Commands before?
  2m
• Lecture1.135
  Demo-Have you used any DBCC Commands before?
  2m
• Lecture1.136
  What are the different types Database files in SQL Server?
  2m
• Lecture1.137
  Demo-What are the different types Database files in SQL Server?
  2m
• Lecture1.138
  What are the different types of Backups in SQL Server?
  2m
• Lecture1.139
  Demo-What are the different types of Backups in SQL Server
  3m
• Lecture1.140
  Scenario: How can you restore a database at the Point of Failure?
  4m
• Lecture1.141
  What are the different types of file groups in SQL Server?
  2m
• Lecture1.142
  Demo-What are the different types of file groups in SQL Server
  2m
• Lecture1.143
  What are the different types of System Databases in SQL Server?
  2m
• Lecture1.144
  Demo-What are the different types of System Databases in SQL Server
  3m
• Lecture1.145
  What is the difference between backup/restore and detach/attach the database?
  2m
• Lecture1.146
  Demo-What is the difference between backup/restore and detach/attach the database?
  2m
• Lecture1.147
  What is the difference between Offline and Emergency state of a database
  2m
• Lecture1.148
  Demo-What is the difference between Offline and Emergency state of a database
  2m
• Lecture1.149
  What are the default port numbers for SQL Server Browser and Default instance
  3m
• Lecture1.150
  Demo-What are the default port numbers for SQL Server Browser and Default instance?
  3m
• Lecture1.151
  Contact us
  1m