Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..
Batch
Date: Apr 21st @9:00AM
Faculty: Mr. Suresh Vadde
Duration : 30 Days
Location: Maitrivanam, Hyderabad
Venue
:
DURGA SOFTWARE SOLUTIONS,
Flat No : 202,
2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038
Ph.No: +91 - 8852 8852 96/97/63/64
Syllabus:
MS SQL SERVER
1. DBMS
2. RDBMS
3. What is SQL server
4. Introduction to SQLSERVER 2019
5. Tools of SQLSERVER 2019
6. Management studio
7. System databases
8. Database Creation
9. Authentications
A. Windows
B. SQL Server
10. Data types
11. TSQL Introduction
12. Data Definition language
13. Data Manipulation Language
14. Data Retrieval Language
15. Commit & Rollback
16. Buffer Management
17. Operators
18. Functions
A. Number Functions
B. Character Functions
C. Date time Functions
D. Aggregate Functions
19. Clauses
A. Group By
B. Having
C. Order by
20. Set Operators
21. Joins
A. Inner Join
B. Outer Join
C. Cross Join
22. Sub Queries
23. Copying table concept
24. Constraints
A. Primary key
B. Unique
C. Foreign key
D. Check Constraint
E. Not Null
25. Normalization
26. Views
27. Indexes & B tree Structure & Execution Plan
28. Synonyms
29. Temp Tables
30. CTE
31. Profiler
32. Introduction to Programming
33. Batches and Basic programs
34. If. Else, While
35. Cursors
36. User Defined Functions
37. Stored Procedures
38. Edit & Recompile SP’s
39. Error Handling
40. Triggers
41. Database Creation
42. Backup
43. Introduction to SSIS
44. Introduction to SSRS