Online SQL SERVER Training in India - Leading Software Training Institute

1
(No Transcript)
2
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content
Concepts Database concepts RDBMS
Concepts Data Models Constraints
Normalization- 1NF,2NF,3NF,BCNF etc ER
Diagrams
http//www.nareshit.com/course/sql-server-online-t
raining/
3
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content
Sql Server Concepts Introduction to Sql Server
2008 R2 Sql Server 2008 Features Server
types Editions Components Management
Studio T-SQL Features New Operators DML
Statements
http//www.nareshit.com/course/sql-server-online-t
raining/
4
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• T-SQL
• DDL
• Data Types
• System Defined data types
• User defined Data
• Create/modify/delete tables
• Create/modify/delete tables
• Operators
• DML
• DCL
• Using Select Statement

http//www.nareshit.com/course/sql-server-online-t
raining/
5
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• Maintaining Database Integrity
• Constraints
• Rules
• Entity Integrity
• Domain Integrity
• Referential Integrity
• Sub Queries
• Built-in function
• Nested sub queries
• Correlated sub queries
• Derived tables
• Recursive queries
• Common table expression

http//www.nareshit.com/course/sql-server-online-t
raining/
6
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• Joins
• Cross join, inner join, self join, outer join
• Indexes
• Types of Indexes
• Creating indexes
• Modifying indexes
• Dropping indexes

http//www.nareshit.com/course/sql-server-online-t
raining/
7
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• Views
• About View
• Creating Views
• Altering Views
• Materialized views
• Distributed view
• Stored Procedures
• Advantages
• System stored procedures
• Extended stored procedures
• Parameter handling

http//www.nareshit.com/course/sql-server-online-t
raining/
8
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• User Defined functions
• Returning scalar value
• Returning table of data
• Deterministic functions
• Non deterministic functions
• Triggers
• Constraints Vs triggers
• After triggers
• Instead of Trigger
• DDL triggers
• Altering and Dropping Triggers

http//www.nareshit.com/course/sql-server-online-t
raining/
9
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• Cursors
• Select Vs Cursors
• Types of Cursors
• Creating Cursors
• Open/fetch/close cursors
• Using cursors in Stored procedures and Triggers.
• Microsoft .NET Frame Work Integration
• CLR integration
• UDA
• UDF
• Stored Procedures
• Triggers

http//www.nareshit.com/course/sql-server-online-t
raining/
10
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• Transactions and locks
• ACID properties
• Implicit Transactions
• Explicit Transactions
• Transaction process
• Concurrency problems
• Lock Types
• Distributed Transactions
• Dead Locks
• Data Transformation services
• BCP
• DTS

http//www.nareshit.com/course/sql-server-online-t
raining/
11
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• Administrative tasks
• Creating database
• Copy, maintaining database
• Security concepts
• Schemas, permissions
• Backup and Restore database
• Sql Server Agent
• Sql Server Profiler
• Database Engine Tuning Adviser

http//www.nareshit.com/course/sql-server-online-t
raining/
12
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• Sql Server Management Objects
• Programming with SMO
• Connecting to Sql Server
• Scripting
• XML in Sql Server
• Working with Images
• Introduction to MS- BI
• SSRS
• Standard, Ad- hoc Embedded Reports
• SSIS
• SSAS

http//www.nareshit.com/course/sql-server-online-t
raining/
13
SQL SERVER Online Training from India
SQL SERVER Online Training Course Content

• Sql Server 2012 Features
• Sequence
• OFFSET and FETCH
• WITH RESULT SETS in stored procedureTHROW in
  triggers

http//www.nareshit.com/course/sql-server-online-t
raining/
14
Why Naresh i echnologies ?

• We provide Quality IT Training. We are a IT
  Corporate Training and consulting
  company providing expert, professional and
  advanced IT Corporate training courses to our
  clients success and their need for continuous IT
  skilled in latest technologies

http//www.nareshit.com/course/sql-server-online-t
raining/
15
For Online Training Call 91-8179191999
USA404-232-9879

• We look forward to having you as a part
• of
• Team
• For more details Log on to
• http//www.nareshit.com http//www.nareshit.in
  www.facebook.com/nareshit www.youtube.com/nar
  eshit

http//www.nareshit.com/course/sql-server-online-t
raining/