Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..
Batch
Date: Feb 4th @7:00PM
Faculty: Mr. Mohan Reddy (12+ Yrs of Exp,..)
Duration: 30 Days
Venue
:
DURGA SOFTWARE SOLUTIONS,
Flat No : 202,
2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038
Ph.No: +91 - 9246212143, 80 96 96 96 96
Syllabus:
Name: Mr. Mohan Reddy (12+ Yrs of Exp,..)
SQL SERVER DEVELOPMENT
Introduction To SQL Server
• Understanding Data & Information
• Database
• DBMS
• RDBMS
• DB Design
• Types of Databases
• Client Server Architecture
• SQL Server versions
• SQL Server Management Studio
• Creating DB
• Sub Languages of TSQL
• Creating Tables
• Insert,Delete,Update Data into Tables
• Normalization
• Constraints
• Unique
• Not Null
• Primary key
• Check
• Default
• Foreign Key
• Working With Single Table Queries
• Writing Queries using SELECT Statement
• Understanding Query Flow
• Operators in SQL Server
• Clauses in SQL Server
• Filtering Data Using WHERE Clause
• Sorting Data using ORDER BY Clause
• Avoid Duplicates using DISTINCT Clause
• Using Top Clause
• DML Commands
• Copying Data From one Table to Another
• Insert Command
• Update Command
• Delete Command
• DDL Commands
• Create command
• Alter Command
• Drop Command
• Truncate Command
• Delete vs Truncate
• Built in Functions
• Scalar Functions
- String
- Date
- Mathematical
- Conversion
- Coalesce
- Rank and Dense Rank
- EOMONTH
- DateFromParts
- ISNULL
- IIF
- Row Number
- Running Total
• Group Functions
• Aggregate Functions
- Cunt(*)
- MAX()
- MIN()
- AVG()
- SUM()
• Deterministic Functions
• Non-Deterministic Functions
• SET Operators
• Sub Queries
• Importance of Sub Query
• Types of Sub Queries
• Nested Queries
• JOINS
• Importance of Joins
• Types of Joins
- Inner Join or Equi Join
- Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Self Join
- Cross Join
- Advanced Joins
• Database Transactions
• Transactions Using Commit & Rollback
• ACID Properties
• Working with Locks
• Viewing Dead Locks
• Database Security
• Understanding Privileges
• Types of Privileges
• Granting & Revoking Privileges
• Temporary Tables
• Local Temp Tables
• Global Temp Tables
• Views
• Importance of Views
• Types of views
• Indexes
• Clustered & Non Clustered
• Stored Procedures
• Triggers
• Cursors
• Schemas
• Backup & Restore
• SQL Server Agent
• Advanced Topics in SQL Server
