SQL Server

  • Part 1 – Connecting to SQL Server
  • Part 2 – Creating, altering and dropping a database
  • Part 3 – Creating and working with tables
  • Part 4 – Default Constraint
  • Part 5 – Cascading referential integrity constraint

  • Part 6 – CHECK constraint
  • Part 7 – Identity Column
  • Part 8 – Retrieving Identity Column values
  • Part 9 – Unique key constraint
  • Part 10 – All about “SELECT”
  • Part 11 – Group By
  • Part 12 – JOINS
  • Part 13 – Advanced JOINS
  • Part 14 – Self Join
  • Part 15 – Different ways to replace NULL in SQL Server
  • Part 16 – COALESCE() function in SQL Server
  • Part 17 – UNION and UNION ALL
  • Part 18 – Stored Procedures
  • Part 19 – Stored procedures with output parameters
  • Part 20 - Stored procedure output parameters or return values
  • Part 21 – Advantages of stored procedures
  • Part 22 – String functions
  • Part 23 – String functions Continued
  • Part 24 – String functions Continued
  • Part 25 – DateTime functions in SQL Server
  • Part 26 –DateTime functions continued
  • Part 27 –DateTime functions continued
  • Part 28 –Cast and Convert functions
  • Part 29 –Mathematical functions
  • Part 30 – User defined functions
  • Part 31 – Inline Table Valued Functions
  • Part 32 – Multi-Statement Table Valued Functions
  • Part 33 – Functions – Important Concepts
  • Part 34 – Temporary Tables
  • Part 35 – Indexes
  • Part 36 - Clustered & NonClustered indexes
  • Part 37 – Unique & Non-Unique indexes
  • Part 38 – Adv. & Dis-adv. of Indexes
  • Part 39 – Views in SQL Server
  • Part 40 – Updateable Views
  • Part 41 – Indexed Views
  • Part 42 –View Limitations
  • Part 43 –DML Triggers
  • Part 44 –DML Triggers
  • Part 45 –Instead Of Insert Trigger
  • Part 46 –Instead Of Update Trigger
  • Part 47 –Instead Of Delete Trigger
  • Part 48 –Derived Tables & CTE
  • Part 49 – CTE
  • Part 50 – Updatable CTEs
  • Part 51 – Recursive CTEs
  • Part 52 – Normalization
  • Part 53 – 2NF & 3NF
  • Part 54 – Pivot in SQL Server 2008
  • Part 55 – Error Handling in SQL Server 2000
  • Part 56 – Error Handling in SQL Server 2005 & Later versions
  • Part 57 – Transactions in SQL Server
  • Part 58 – Transaction ACID Test
  • Part 59 – SubQueries in SQL Server
  • Part 60 – Co related SubQueries
  • Part 61 – Creating a large table with random data for performance testing
  • Part 62 – What to choose for performance - SubQueries or Joins?
  • Part 63 – Cursors in SQL Server
  • Part 64 – Replacing cursors using joins
  • Part 65 – List all tables in a sql server database using a query
  • Part 66 – Writing re-runnable SQL Server scripts
  • Part 67 – Alter database table columns without dropping table
  • Part 68 - Optional parameters in sql server stored procedures
  • Part 69 - Merge in SQL Server
  • Part 70 - SQL Server concurrent transactions
  • Part 71 - SQL Server dirty read example
  • Part 72 - SQL Server lost update problem
  • Part 73 - Non repeatable read example in sql server
  • Part 74 - Phantom reads example in sql server
  • Part 75 - Snapshot isolation level in sql server
  • Part 76 - Read committed snapshot isolation level in sql server
  • Part 77 - Difference between snapshot isolation and read committed snapshot
  • Part 78 - SQL Server deadlock example
  • Part 79 - SQL Server deadlock victim selection
  • Part 80 - Logging deadlocks in sql server
  • Part 81 - SQL Server deadlock analysis and prevention
  • Part 82 - Capturing deadlocks in sql profiler
  • Part 83 - SQL Server deadlock error handling
  • Part 84 - Handling deadlocks in ado.net
  • Part 85 - Retry logic for deadlock exceptions
  • Part 86 - How to find blocking queries in sql server
  • Part 87 - SQL Server except operator
  • Part 88 - Difference between except and not in sql server
  • Part 89 - Intersect operator in sql server
  • Part 90 - Difference between union intersect and except in sql server
  • Part 91 - Cross apply and outer apply in sql server
  • Part 92 - DDL Triggers in sql server
  • Part 93 - Server-scoped DDL triggers
  • Part 94 - SQL Server trigger execution order
  • Part 95 - Audit table changes in sql server
  • Part 96 - Logon triggers in sql server
  • Part 97 - Select into in sql server
  • Part 98 - Difference between where and having in sql server
  • Part 99 - Table valued parameters in SQL Server
  • Part 100 - Send datatable as parameter to stored procedure
  • Part 101 - Grouping Sets in SQL Server
  • Part 102 - Rollup in SQL Server
  • Part 103 - Cube in SQL Server
  • Part 104 - Difference between cube and rollup in SQL Server
  • Part 105 - Grouping function in SQL Server
  • Part 106 - GROUPING_ID function in SQL Server
  • Part 107 - Debugging sql server stored procedures
  • Part 108 - Over clause in SQL Server
  • Part 109 - Row_Number function in SQL Server
  • Part 110 - Rank and Dense_Rank in SQL Server
  • Part 111 - Difference between rank dense_rank and row_number in SQL
  • Part 112 - Calculate running total in SQL Server 2012
  • Part 113 - NTILE function in SQL Server
  • Part 114 - Lead and Lag functions in SQL Server 2012
  • Part 115 - FIRST_VALUE function in SQL Server
  • Part 116 - Window functions in SQL Server
  • Part 117 - Difference between rows and range
  • Part 118 - LAST_VALUE function in SQL Server
  • Part 119 - UNPIVOT in SQL Server
  • Part 120 - Reverse PIVOT table in SQL Server
  • Part 121 - Choose function in SQL Server
  • Part 122 - IIF function in SQL Server
  • Part 123 - TRY_PARSE function in SQL Server 2012
  • Part 124 - TRY_CONVERT function in SQL Server 2012
  • Part 125 - EOMONTH function in SQL Server 2012
  • Part 126 - DATEFROMPARTS function
  • Part 127 - Difference between DateTime and SmallDateTime in SQL Server
  • Part 128 - DateTime2FromParts function in SQL Server 2012
  • Part 129 - Difference between DateTime and DateTime2 in SQL Server
  • Part 130 - Offset fetch next in SQL Server 2012
  • Part 131 - Identifying object dependencies in SQL Server
  • Part 132 - sys.dm_sql_referencing_entities in SQL Server
  • Part 133 - sp_depends in SQL Server
  • Part 134 - Sequence object in SQL Server 2012
  • Part 135 - Difference between sequence and identity in SQL Server
  • Part 136 - Guid in SQL Server
  • Part 137 - How to check GUID is null or empty in SQL Server
  • Part 138 - Dynamic SQL in SQL Server
  • Part 139 - Implement search web page using ASP.NET and Stored Procedure
  • Part 140 - Implement search web page using ASP.NET and Dynamic SQL
  • Part 141 - Prevent sql injection with dynamic sql
  • Part 142 - Dynamic SQL in Stored Procedure
  • Part 143 - Sql server query plan cache
  • Part 144 - exec vs sp_executesql in sql server
  • Part 145 - Dynamic sql table name variable
  • Part 146 - Quotename function in SQL Server
  • Part 147 - Dynamic SQL vs Stored Procedure
  • Part 148 - Dynamic sql output parameter
  • Part 149 - Temp tables in dynamic sql

    • 17 comments:

    1. Hello Venkat,
      Will you do ETL processes (SSIS) and Reporting: SSRS with SQL Server?

      Thanks
      Maran

      Reply Delete

    2. Hi Venkat,
      Thanks for uploading your videos. It is very Help me gain knowledge in .NET. Sir, can you explain What is Schema and Schema Binding?

      Reply Delete

    3. Hi Venkat,
      Thanks a lot for your videos I am a big fan of your videos. can you please upload SSIS and SSRS videos?

      thanks
      Varun

      Reply Delete
      Replies

      1. Hello Sir,

        We request to you, please upload some video related to SSIS, SSRS and SSAS

        Regards,
        Jitendra, India

        Delete

    4. Hi Venkat,
      Like SRK in bollywood you are in ITwood for us. I really like all of your posts. Looking for detail videos on SSIS,SSRS and SSAS . And also rest parts of Index. All of us will be waiting for you posts.

      Thanks & Regards
      Sukant

      Reply Delete

    5. hi Venkat,
      Can you please Post the video on Debugging in Sql Server.

      Thank you,

      Reply Delete

    6. Hi Venkat ,

      Thank you for your videos for MVC and WCF and all related to .NET.

      Do you have any plan to start videos for WPF in coming months? Could you please let us know?

      Thanks again...

      Reply Delete

    7. Hi Venkat

      I have watched quite a few video's especially about CTEs. Your explanations are very good and easy to understand.

      I was wondering if you would have a copy of the scripts that you use in your demo's for table creation and sample data. If you have that would be great.

      Thanks & keep up the great work !!

      Cheers
      Anup..

      Reply Delete

    8. Hi Venkat,

      How can we find all stored procedures from all database present on a server?
      for ex: Server:a1 has 30 databases and each database has around 60 stored procedures. I should get an output where it shows all 1800 stored proc names.
      Quick response will be greatly appreciated.
      Regards,
      Rushi

      Reply Delete


    9. HELLO

      EXCELLENT

      I would like you to explain the (dts) THE DATA TRANSFORMATION SERVICES

      Reply Delete

    10. Really U are like God for me.

      Reply Delete

    11. sahi ho yaar aap. explained in simple terms rather than the deep complex technical language just to show off! Hats off bro!

      Reply Delete

    12. Very very Thank you Venkat Sir,

      I request you to please make videos for Database Designs i.e. how to design database for different kind of projects or applications.

      Please Sir. Thanks :)

      Reply Delete

    13. Hello Venkat, thank for sharing the information for free. Your videos are on point and way better than university classes.
      Could you please share the db which you use the demos?
      Thanks
      KKS

      Reply Delete

    14. Hello Venkat
      is the slides allowed in PDF, or presentation?
      and need to download all slides about one playlist in one click

      Reply Delete

    15. Hi Venkat,

      Thanks much for sharing your knowledge with us in such a best way. I always share your channel to my circle. A big thank to you once again for this kind effort. Appreciable!!!

      Thanks,
      Harish Saini

      Reply Delete

    16. Hello Venkat,

      It is amazing that such a good materials are found for free. We owe you big! Thank you very much for your hard work.

      Reply Delete

    It would be great if you can help share these free resources

    [フレーム]

    Subscribe to: Posts (Atom)

    AltStyle によって変換されたページ (->オリジナル) /