How to become ASP.NET Developer dot net video tutorials download kudvenkat videos Subscribe Kudvenkat Blog follow pragimtech on facebook follow pragimtech on twitter follow pragimtech on google plus
Home C# ASP.NET MVC GridView JavaScript Placements Contact Feedback Subscribe Careers Support us
Contact Details Phone:
+91 99456 99393
+91 80958 31888
WhatsApp:
+91 99001 13931
Email:
pragim@pragimtech.com
pragim@gmail.com
Address:
2nd Floor
Above Pick 'N' Move
Adjacent to HP Petrol Pump
Marathalli, Bangalore

Course Contents Oracle Apps Advanced Pricing
Oracle Apps ASCP Functional
Oracle Apps SCM Functional
DOT NET | MVC
Sharepoint
MSBI
Siebel CRM
Informatica (9.1)
Informatica Data Quality (9.5.1)
Java J2EE
EMC SAN
Testing Tools
Selenium Testing
HADOOP
TIBCO
Tableau
Oracle DBA
Oracle PL/SQL
Oracle OFSAA
Oracle OBIEE
QlikView
IBM MQ Admin
Android
Salesforce
Devops
UI Development

Interview Questions Dot Net Video Tutorials
C#
C# Programs
ASP.NET
WCF
SQL Server
MVC
HR
Back to all products page

For any issues with your order, please contact us on kudvenkat@gmail.com

Download SQL Server Videos & Slides (Price - $50)



Please Note: You may either pay with your PayPal account or Credit/Debit card.

What does the download contain
  • SQL Server (149 Videos & Slides - 26 Hours 57 Minutes)

    1. Connecting to SQL Server
    2. Working with databases
    3. Creating and working with tables
    4. Default Constraint
    5. Cascading referential integrity
    6. Check Constraint
    7. Identity Column
    8. Retrieving identity column value
    9. Unique key constraint
    10. All about select statement
    11. Group By
    12. Basic Joins
    13. Advanced Joins
    14. Self join
    15. Different ways to replace NULL
    16. Coalesce function
    17. Union and Union All
    18. Stored Procedures
    19. Stored Procedures with output parameters
    20. Difference between output parameters and return values
    21. Advantages of stored procedures
    22. Built in string functions
    23. Left, Reight, Charindex and Substring functions
    24. Replicate, Space, Patindex, Replace and Stuff functions
    25. DateTime functions
    26. IsDate, Day, Month, Year and DateName functions
    27. DatePart, DateAdd and DateDiff functions
    28. Convert and Cast functions
    29. Mathematical functions
    30. Scalar User Defined functions
    31. Inline Table Valued functions
    32. Multi-Statement Table Valued functions
    33. Important concepts related to functions in sql server
    34. Temporary tables
    35. Indexes
    36. Clustered and NonClustered Indexes
    37. Unique and Non-Unique Indexes
    38. Advantages and disadvantages of indexes
    39. Views
    40. Updateable Views
    41. Indexed Views
    42. View Limitations
    43. DML Triggers
    44. DML After Update Trigger
    45. Instead of insert trigger
    46. Instead of update trigger
    47. Instead of delete trigger
    48. Derived table and CTE's
    49. Common Table Expressions
    50. Updatable CTE
    51. Recursive CTE
    52. Normalization & First Normal Form
    53. 2NF and 3NF
    54. Pivot Operator
    55. Error handling in SQL Server 2000
    56. Error handling in SQL Server 2005 and later versions
    57. Transactions in SQL Server
    58. Transaction ACID Tests
    59. Subqueries in sql
    60. Correlated subquery
    61. Creating a large table with random data for performance testing
    62. What to choose for performance - SubQuery or Joins
    63. Cursors in sql server
    64. Replacing cursors using joins
    65. List all tables in a sql server database using a query
    66. Writing re-runnable sql server scripts
    67. Alter database table columns without dropping table
    68. Optional parameters in sql server stored procedures
    69. Merge in SQL Server
    70. SQL Server concurrent transactions
    71. SQL Server dirty read example
    72. SQL Server lost update problem
    73. Non repeatable read example in sql server
    74. Phantom reads example in sql server
    75. Snapshot isolation level in sql server
    76. Read committed snapshot isolation level in sql server
    77. Difference between snapshot isolation and read committed snapshot
    78. SQL Server deadlock example
    79. SQL Server deadlock victim selection
    80. Logging deadlocks in sql server
    81. SQL Server deadlock analysis and prevention
    82. Capturing deadlocks in sql profiler
    83. SQL Server deadlock error handling
    84. Handling deadlocks in ado.net
    85. Retry logic for deadlock exceptions
    86. How to find blocking queries in sql server
    87. SQL Server except operator
    88. Difference between except and not in sql server
    89. Intersect operator in sql server
    90. Difference between union intersect and except in sql server
    91. Cross apply and outer apply in sql server
    92. DDL Triggers in sql server
    93. Server-scoped ddl triggers
    94. SQL Server trigger execution order
    95. Audit table changes in sql server
    96. Logon triggers in sql server
    97. Select into in sql server
    98. Difference between where and having in sql server
    99. Table valued parameters in SQL Server
    100. Send datatable as parameter to stored procedure
    101. Grouping Sets in SQL Server
    102. Rollup in SQL Server
    103. Cube in SQL Server
    104. Difference between cube and rollup in SQL Server
    105. Grouping function in SQL Server
    106. GROUPING_ID function in SQL Server
    107. Debugging sql server stored procedures
    108. Over clause in SQL Server
    109. Row_Number function in SQL Server
    110. Rank and Dense_Rank in SQL Server
    111. Difference between rank dense_rank and row_number in SQL
    112. Calculate running total in SQL Server 2012
    113. NTILE function in SQL Server
    114. Lead and Lag functions in SQL Server 2012
    115. FIRST_VALUE function in SQL Server
    116. Window functions in SQL Server
    117. Difference between rows and range
    118. LAST_VALUE function in SQL Server
    119. UNPIVOT in SQL Server
    120. Reverse PIVOT table in SQL Server
    121. Choose function in SQL Server
    122. IIF function in SQL Server
    123. TRY_PARSE function in SQL Server 2012
    124. TRY_CONVERT function in SQL Server 2012
    125. EOMONTH function in SQL Server 2012
    126. DATEFROMPARTS function
    127. Difference between DateTime and SmallDateTime in SQL Server
    128. DateTime2FromParts function in SQL Server 2012
    129. Difference between DateTime and DateTime2 in SQL Server
    130. Offset fetch next in SQL Server 2012
    131. Identifying object dependencies in SQL Server
    132. sys.dm_sql_referencing_entities in SQL Server
    133. sp_depends in SQL Server
    134. Sequence object in SQL Server 2012
    135. Difference between sequence and identity in SQL Server
    136. Guid in SQL Server
    137. How to check GUID is null or empty in SQL Server
    138. Dynamic SQL in SQL Server
    139. Implement search web page using ASP.NET and Stored Procedure
    140. Implement search web page using ASP.NET and Dynamic SQL
    141. Prevent sql injection with dynamic sql
    142. Dynamic SQL in Stored Procedure
    143. Sql server query plan cache
    144. exec vs sp_executesql in sql server
    145. Dynamic sql table name variable
    146. Quotename function in SQL Server
    147. Dynamic SQL vs Stored Procedure
    148. Dynamic sql output parameter
    149. Temp tables in dynamic sql
Back to all products page
Disclaimer - Terms of use - Contact Us