Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

MS SQL SERVER Course Details
 

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