Skip to content

README.md

Latest commit

 

History

History
58 lines (56 loc) · 1.5 KB

README.md

File metadata and controls

58 lines (56 loc) · 1.5 KB

SQL-SERVER-AND-NODE-PRACTICE-AND-NOTES

SQL SERVER (SSMS)

Video Suggestions Click here

    Week-1

  1. Install SQL Server
  2. SSMS Overview
  3. Authentication
  4. Permissions
  5. Data Types
  6. Naming Conventions DB Create
  7. Table Create
  8. Add Columns to Table
  9. Identity Column
  10. Rename Column
  11. Drop Column
  12. Schema in SSMS
  13. Relationship between tables
  14. If Else Loops
  15. Aggregate functions
  16. Operators (Union, In, Not in, Null, Between, Like, Exists)/li>
  17. "Constraints : Primary Key Foreign Key Composite Key Check Unique Constraints"

    18. Practical - 1

    Week-2

  18. Select
  19. Insert
  20. Update
  21. Delete
  22. Where
  23. Distinct
  24. Group By
  25. Having,
  26. Order By
  27. Joins
  28. CASE
  29. Dynamic Queries

    30. Practical - 2

    Week-3

  30. CAST
  31. Convert
  32. Copy table
  33. Rename table
  34. Truncate table
  35. User defined functions
  36. Built-In Functions
  37. DATE functions
  38. String Functions

    39. Practical - 3

    Week-4

  39. Views
  40. Stored Procedures
  41. Indexes
  42. Cursors
  43. Triggers
  44. Sequence

    45. Practical - 4