gs gs116 video lectures

gs gs116 - Microsoft SQL Server Video Lectures The book/course code gs gs116 Microsoft SQL Server belongs to gs organization and contains 150 in total video lectures. The students of Gegasoft organiztion can watch these video lecture on NVAEducation. These videos are also availble on Youtube and students can watch these video lectures of Microsoft SQL Server on Youtube, however, NVAEducation facilitates students to be able to download these video lectures without using any VPS or third-party tool.

List of video lectures of gs gs116

Here bellow is a list of 150 video lectures related to the course gs gs116 Microsoft SQL Server of organization Gegasoft (gs). To play a lecture choose a lecture from the list bellow.

Video Lectures of gs116 Microsoft SQL Server

#1 - Install SQL Server 2019 Step by Step

gs116 Microsoft SQL Server

#2 - Connecting to SQL Server using SSMS

gs116 Microsoft SQL Server

#3 - Creating altering and dropping a database

gs116 Microsoft SQL Server

#4 - Creating and working with tables

gs116 Microsoft SQL Server

#5 - Adding a default constraint

gs116 Microsoft SQL Server

#6 - Cascading referential integrity constraint

gs116 Microsoft SQL Server

#7 - Adding a check constraint

gs116 Microsoft SQL Server

#8 - Identity Column in SQL Server

gs116 Microsoft SQL Server

#9 - How to get the last generated identity column value in SQL Server

gs116 Microsoft SQL Server

#10 - Unique key constraint

gs116 Microsoft SQL Server

#11 - Select statement in sql server

gs116 Microsoft SQL Server

#12 - Group by in sql server

gs116 Microsoft SQL Server

#13 - Joins in sql server

gs116 Microsoft SQL Server

#14 - Advanced or intelligent joins in sql server

gs116 Microsoft SQL Server

#15 - Self join in sql server

gs116 Microsoft SQL Server

#16 - Different ways to replace NULL in sql server

gs116 Microsoft SQL Server

#17 - Coalesce function in sql server

gs116 Microsoft SQL Server

#18 - Union and union all in sql server

gs116 Microsoft SQL Server

#19 - Stored procedures in sql server

gs116 Microsoft SQL Server

#20 - Stored procedures with output parameters

gs116 Microsoft SQL Server

#21 - Stored procedure output parameters or return values

gs116 Microsoft SQL Server

#22 - Advantages of stored procedures

gs116 Microsoft SQL Server

#23 - Built in string functions in sql server 2008

gs116 Microsoft SQL Server

#24 - LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server

gs116 Microsoft SQL Server

#25 - Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008

gs116 Microsoft SQL Server

#26 - DateTime functions in SQL Server

gs116 Microsoft SQL Server

#27 - IsDate, Day, Month, Year and DateName DateTime functions in SQL Server

gs116 Microsoft SQL Server

#28 - DatePart, DateAdd and DateDiff functions in SQL Server

gs116 Microsoft SQL Server

#29 - Cast and Convert functions in SQL Server

gs116 Microsoft SQL Server

#30 - Mathematical functions in sql server

gs116 Microsoft SQL Server

#31 - Scalar user defined functions in sql server

gs116 Microsoft SQL Server

#32 - Inline table valued functions in sql server

gs116 Microsoft SQL Server

#33 - Multi statement table valued functions in sql server

gs116 Microsoft SQL Server

#34 - Important concepts related to functions in sql server

gs116 Microsoft SQL Server

#35 - Temporary tables in SQL Server

gs116 Microsoft SQL Server

#36 - Indexes in sql server

gs116 Microsoft SQL Server

#37 - Clustered and nonclustered indexes in sql server

gs116 Microsoft SQL Server

#38 - Unique and Non Unique Indexes in sql server

gs116 Microsoft SQL Server

#39 - Advantages and disadvantages of indexes in sql server

gs116 Microsoft SQL Server

#40 - Views in sql server

gs116 Microsoft SQL Server

#41 - Updatable views in sql server

gs116 Microsoft SQL Server

#42 - Indexed views in sql server

gs116 Microsoft SQL Server

#43 - View limitations in sql server

gs116 Microsoft SQL Server

#44 - DML triggers in sql server

gs116 Microsoft SQL Server

#45 - After update trigger

gs116 Microsoft SQL Server

#46 - Instead of insert trigger

gs116 Microsoft SQL Server

#47 - Instead of update triggers in sql server

gs116 Microsoft SQL Server

#48 - Instead of delete triggers in sql server

gs116 Microsoft SQL Server

#49 - Derived tables and common table expressions in sql server

gs116 Microsoft SQL Server

#50 - CTE in sql server

gs116 Microsoft SQL Server

#51 - Updatable common table expressions in sql server

gs116 Microsoft SQL Server

#52 - Recursive CTE in sql server

gs116 Microsoft SQL Server

#53 - Database normalization

gs116 Microsoft SQL Server

#54 - Second normal form and third normal form

gs116 Microsoft SQL Server

#55 - Pivot in sql server 2008

gs116 Microsoft SQL Server

#56 - Error handling in sql server 2000

gs116 Microsoft SQL Server

#57 - Error handling in sql server

gs116 Microsoft SQL Server

#58 - Transactions in sql server

gs116 Microsoft SQL Server

#59 - Transactions in sql server and ACID Tests

gs116 Microsoft SQL Server

#60 - Subqueries in sql

gs116 Microsoft SQL Server

#61 - Correlated subquery in sql

gs116 Microsoft SQL Server

#62 - Creating a large table with random data for performance testing

gs116 Microsoft SQL Server

#63 - What to choose for performance SubQuery or Joins

gs116 Microsoft SQL Server

#64 - Cursors in sql server

gs116 Microsoft SQL Server

#65 - Replacing cursors using joins in sql server

gs116 Microsoft SQL Server

#66 - List all tables in a sql server database using a query

gs116 Microsoft SQL Server

#67 - Writing re runnable sql server scripts

gs116 Microsoft SQL Server

#68 - Alter database table columns without dropping table

gs116 Microsoft SQL Server

#69 - Optional parameters in sql server stored procedures

gs116 Microsoft SQL Server

#70 - Merge in SQL Server

gs116 Microsoft SQL Server

#71 - sql server concurrent transactions

gs116 Microsoft SQL Server

#72 - sql server dirty read example

gs116 Microsoft SQL Server

#73 - sql server lost update problem

gs116 Microsoft SQL Server

#74 - Non repeatable read example in sql server

gs116 Microsoft SQL Server

#75 - Phantom reads example in sql server

gs116 Microsoft SQL Server

#76 - Snapshot isolation level in sql server

gs116 Microsoft SQL Server

#77 - Read committed snapshot isolation level in sql server

gs116 Microsoft SQL Server

#78 - Difference between snapshot isolation and read committed snapshot

gs116 Microsoft SQL Server

#79 - SQL Server deadlock example

gs116 Microsoft SQL Server

#80 - SQL Server deadlock victim selection

gs116 Microsoft SQL Server

#81 - Logging deadlocks in sql server

gs116 Microsoft SQL Server

#82 - SQL Server deadlock analysis and prevention

gs116 Microsoft SQL Server

#83 - Capturing deadlocks in sql profiler

gs116 Microsoft SQL Server

#84 - SQL Server deadlock error handling

gs116 Microsoft SQL Server

#85 - Handling deadlocks in ado net

gs116 Microsoft SQL Server

#86 - Retry logic for deadlock exceptions

gs116 Microsoft SQL Server

#87 - How to find blocking queries in sql server

gs116 Microsoft SQL Server

#88 - SQL Server except operator

gs116 Microsoft SQL Server

#89 - Difference between except and not in sql server

gs116 Microsoft SQL Server

#90 - Intersect operator in sql server

gs116 Microsoft SQL Server

#91 - Difference between union intersect and except in sql server

gs116 Microsoft SQL Server

#92 - Cross apply and outer apply in sql server

gs116 Microsoft SQL Server

#93 - DDL Triggers in sql server

gs116 Microsoft SQL Server

#94 - Server scoped ddl triggers

gs116 Microsoft SQL Server

#95 - sql server trigger execution order

gs116 Microsoft SQL Server

#96 - Audit table changes in sql server

gs116 Microsoft SQL Server

#97 - Logon Triggers in SQL Server

gs116 Microsoft SQL Server

#98 - Select into in sql server

gs116 Microsoft SQL Server

#99 - Difference between where and having in sql server

gs116 Microsoft SQL Server

#100 - Table valued parameters in SQL Server

gs116 Microsoft SQL Server

#101 - Send datatable as parameter to stored procedure

gs116 Microsoft SQL Server

#102 - Grouping Sets in SQL Server

gs116 Microsoft SQL Server

#103 - Rollup in SQL Server

gs116 Microsoft SQL Server

#104 - Cube in SQL Server

gs116 Microsoft SQL Server

#105 - Difference between cube and rollup in SQL Server

gs116 Microsoft SQL Server

#106 - Grouping function in SQL Server

gs116 Microsoft SQL Server

#107 - GROUPING ID function in SQL Server

gs116 Microsoft SQL Server

#108 - Debugging sql server stored procedures

gs116 Microsoft SQL Server

#109 - Over clause in SQL Server

gs116 Microsoft SQL Server

#110 - Row Number function in SQL Server

gs116 Microsoft SQL Server

#111 - Rank and Dense Rank in SQL Server

gs116 Microsoft SQL Server

#112 - Difference between rank dense rank and row number in SQL

gs116 Microsoft SQL Server

#113 - Calculate running total in SQL Server 2012

gs116 Microsoft SQL Server

#114 - NTILE function in SQL Server

gs116 Microsoft SQL Server

#115 - Lead and Lag functions in SQL Server 2012

gs116 Microsoft SQL Server

#116 - FIRST VALUE function in SQL Server

gs116 Microsoft SQL Server

#117 - Window functions in SQL Server

gs116 Microsoft SQL Server

#118 - Difference between rows and range

gs116 Microsoft SQL Server

#119 - LAST VALUE function in SQL Server

gs116 Microsoft SQL Server

#120 - UNPIVOT in SQL Server

gs116 Microsoft SQL Server

#121 - Reverse PIVOT table in SQL Server

gs116 Microsoft SQL Server

#122 - Choose function in SQL Server

gs116 Microsoft SQL Server

#123 - IIF function in SQL Server

gs116 Microsoft SQL Server

#124 - TRY PARSE function in SQL Server 2012

gs116 Microsoft SQL Server

#125 - TRY CONVERT function in SQL Server 2012

gs116 Microsoft SQL Server

#126 - EOMONTH function in SQL Server 2012

gs116 Microsoft SQL Server

#127 - DATEFROMPARTS function in SQL Server

gs116 Microsoft SQL Server

#128 - Difference between DateTime and SmallDateTime in SQL Server

gs116 Microsoft SQL Server

#129 - DateTime2FromParts function in SQL Server 2012

gs116 Microsoft SQL Server

#130 - Difference between DateTime and DateTime2 in SQL Server

gs116 Microsoft SQL Server

#131 - Offset fetch next in SQL Server 2012

gs116 Microsoft SQL Server

#132 - Identifying object dependencies in SQL Server

gs116 Microsoft SQL Server

#133 - sys dm sql referencing entities in SQL Server

gs116 Microsoft SQL Server

#134 - sp depends in SQL Server

gs116 Microsoft SQL Server

#135 - Sequence object in SQL Server 2012

gs116 Microsoft SQL Server

#136 - Difference between sequence and identity in SQL Server

gs116 Microsoft SQL Server

#137 - Guid in SQL Server

gs116 Microsoft SQL Server

#138 - How to check GUID is null or empty in SQL Server

gs116 Microsoft SQL Server

#139 - Dynamic SQL in SQL Server

gs116 Microsoft SQL Server

#140 - Implement search web page using ASP NET and Stored Procedure

gs116 Microsoft SQL Server

#141 - Implement search web page using ASP NET and Dynamic SQL

gs116 Microsoft SQL Server

#142 - Prevent sql injection with dynamic sql

gs116 Microsoft SQL Server

#143 - Dynamic SQL in Stored Procedure

gs116 Microsoft SQL Server

#144 - Sql server query plan cache

gs116 Microsoft SQL Server

#145 - exec vs sp executesql in sql server

gs116 Microsoft SQL Server

#146 - Dynamic sql table name variable

gs116 Microsoft SQL Server

#147 - Quotename function in SQL Server

gs116 Microsoft SQL Server

#148 - Dynamic SQL vs Stored Procedure

gs116 Microsoft SQL Server

#149 - Dynamic sql output parameter

gs116 Microsoft SQL Server

#150 - Temp tables in dynamic sql

gs116 Microsoft SQL Server