Sunday, February 3, 2019

SQL Server Tutorial


  1. SQL Server Introduction
  2. Install SQL server dtabase
  3. SQL Server Management Studio
  4. Create a Database
  5. New User in database
  6. Rename Database
  7. Drop database
  8. Permissions for a specific user
  9. Backup of database
  10. Restore a database
  11. Export database from SQL server
  12. Import database
  13. Generate SQL script of whole database
  14. Shrink database
  15. Creating table
  16. Create table, Insert, Update, Delete, Search in table in SQL SERVER
  17. ALTER TABLE Statement in SQL
  18. SQL DROP TABLE, DROP DATABASE and DROP INDEX
  19. Difference between Drop and Delete
  20. DISTINCT Statement
  21. SQL Join With Types
  22. Self join in sql server
  23. Different ways to replace NULL in sql server
  24. Coalesce() function in sql server
  25. SQL Union and All Union
  26. What is Stored Procedures in SQL Server
  27. Stored procedures with output parameters
  28. Stored procedure output parameters or return values
  29. Advantages of using stored procedures
  30. Indexes in SQL Server
  31. Clustered and Non-Clustered indexes
  32. Unique and Non-Unique Indexes
  33. SQL Server - Advantages and disadvantages of indexes
  34. Row_Number function in SQL Server
  35. Rank and Dense_Rank in SQL Server
  36. What is Difference between rank dense_rank and row_number in SQL?
  37. What is Derived table and CTE in SQL Server?
  38. What is Common Table Expressions?
  39. Updatable CTE
  40. Recursive CTE
  41. Pivot operator in sql server
  42. What is Triggers in Sql Server
  43. Different Types of SQL Server Triggers
  44. After Trigger, Instead of Trigger Example
  45. SQL Server Setting Triggers Firing Order
  46. SQL Server Exception Handling by TRY…CATCH
  47. SQL Server XML Data Type
  48. Remove duplicate records from a table in SQL Server
  49. Get nth highest and lowest salary of an employee
  50. Different Types of SQL Server Functions
  51. SQL Server Transactions Management
  52. SQL Server Different Types of Cursors
  53. SQL Server Cursor Alternatives
  54. Tips to improve SQL Server database design and performance
  55. Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to register multiple implementations of the same interface in Asp.Net Core?

 Problem: I have services that are derived from the same interface. public interface IService { } public class ServiceA : IService { ...

  • What is a synonym in SQL Server
    In SQL Server, a synonym is an alias or alternative name for a database object such as a table,  view ,  stored procedure ,  user-defined fu...
  • What is Microservices?
    Microservice architecture, or simply microservices , is a distinctive method of developing software systems that tries to focus on buildi...