Course Details
- Understand the architecture of SQL Server
- Understand how SQL Server handles memory and threading
- Read query plans
- Assign indexes
- Use the new T-SQL operators
- Use the XML data type
- Use Reporting Services
- Take advantage of CLR integration to write great performing applications
What you will Learn
The goal of sql server tutorial is to make the trainee to manipulate and design
the database easily using the queries. Our sql tutorial teaches you how to manipulate
data using SQL Server, Access and other database systems. Deccansoft also provide
online sql server tutorial for Developers, which provides hands-on training. At
the end of this course you will Learn to write code for maximum database performance,
re-usability, and application modularity. Discover how and when to use .NET support
built into SQL Server 2005. Find out about new programming techniques enabled by
SQL Server 2008 and Visual Studio 2010.
You'll get answers to these questions:
- How can I improve and evaluate the performance of my queries?
- How can I take advantage of query plans to optimize database performance?
- How can I write multi-threaded and asynchronous Transact-SQL (T-SQL) code?
- How can I integrate SQL Server with other applications and database servers?
- What's the best way to secure my data?
Come and learn how to utilize SQL Server to the max!
Develop Mentor's Essential courses provide five days of instructor-led training
for the experienced developer. Gain deep understanding of your development platform.
Acquire skills you need to be productive today. Build a solid foundation for more
advanced topics.
Course Details
SQL Server
- Overview of Database Concepts
- Basic Database Concepts
- Concepts of Data, Metadata, Files
- Concepts of DBMS
- Database Models
- File Management Systems
- Relational Database Systems
- Procedural & Non procedural approaches
- Database Design
- E.F.Codd's Rules
- NORMALIZATION
- First Normal Form
- Second Normal Form
- Third Normal Form
- Introduction to SQL Server
- Features of SQL Server
- Different Editions of SQL Server
- Components of SQL Server
- Services of SQL Server
- Comparision of SQL Server with Oracle
- Database Design
- Logical & Physical database design
- Relational database design
- Creating databases
- Management Studio
- Basics of SQL
- Datatypes, expressions, operators
- Working with Queries & Clauses
- Creating Databases
- Creating Tables, Stored Procedures
- Working with Indexes & Views
- Sub queries
- Nested sub queries
- Correlated sub queries
- Derived tables
- Implementation of Data integrity
- Entity integrity
- Domain integrity
- Referential integrity
- Types of constraints
- Data Definition Language(DDL)
- Creation of table
- Modifying the structure of a table
- Dropping a table
- Working with different options
- Data Manipulation Language(DML)
- Inserting, updating & deleting operations
- Operators, Built-in functions, Grouping
- Working with multiple tables
- Joins
- Introduction to Joins
- Inner join
- Outer join
- Cross joins
- Unions
- Working with Indexes
- Introduction to indexes
- Creating, dropping indexes
- Complex indexes
- Clusstered & non clustered indexes
- Implementing Views
- Introduction & advantages of views
- Creating views
- Altering, dropping views
- Data Control Language(DCL)
- Creating Users and Roles
- Granting & Revoking of Roles & Priviliges
- Transaction Control Language (TCL)
- Introduction
- Transactions process & types of transactions (Implicit, Explicit)
- Working with Locks and Types of locks
- Transact-SQL (T-SQL)
- Introduction
- Data types
- Statements
- Batch Execution
- Working with Cursors
- Creating Cursors
- Cursors vs. Select
- Types of cursors, locks on cursors
- Advantages of cursors
- Implementing stored procedures
- Introduction to stored procedures
- Creating, executing, modifying, dropping sp's
- Executing extended sp's
- Implementing User Defined Functions
- Introduction
- Creating, executing, altering, dropping UDF's
- Deterministic, non-deterministic functions
- Scalar, multistatement, built-in functions
- Implementing Triggers
- Introduction to Triggers
- Constraints vs Triggers
- Creating, altering, dropping triggers
- for/after/instead of triggers
Why should you choose Deccansoft?
For further information, please
fill the enquiry form
.
Dates and Locations
For regular batches at Deccansoft
Click Here..
For Corporate training
submit request