1 / 15

Online SQL SERVER Training in India

SQL SERVER Online Training in India - Leading Software Training Institute<br>http://www.nareshit.com/course/sql-server-online-training/

NareshIT
Download Presentation

Online SQL SERVER Training in India

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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-training/

  2. 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-training/

  3. 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-training/

  4. 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-training/

  5. 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-training/

  6. 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-training/

  7. 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-training/

  8. 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-training/

  9. 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-training/

  10. 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-training/

  11. 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-training/

  12. 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-training/

  13. Why Naresh iechnologies? • 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-training/

  14. For Online Training Call: +91-8179191999 USA:404-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/nareshit http://www.nareshit.com/course/sql-server-online-training/

More Related