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"

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

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

Practical - 3

---

Week-4

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

Practical - 4

---