What you'll Learn
- Design and Implement Tables, Constraints, Index etc.
- SQL Server Views, Sequence, Triggers etc.
- Get familiar with T-SQL - SQL Server query language
- Working with XML data in Database
- Create Stored Procedures and using it in Applications
- Working with SQL Server Sapital data
SQL Server Development
This course is for those who are looking to build application based on SQL Server tools. Microsoft SQL Server is a SQL-based relational database management system designed for use in corporate applications, both on premises and in the cloud.
Duration : 30 Hrs
SQL Server Development Course Content
- Introduction to SQL Server 2012 and its Tool set
- Working with Data Types
- Designing and Implementing Tables
- Ensuring Data Integrity through Constraints
- Planning for SQL Server 2012 Indexing
- Implementing Table Structures in SQL Server 2012
- Reading SQL Server 2012 Execution Plans
- Improving Performance through Non-clustered Indexes
- Designing and Implementing Views
- Designing and Implementing Stored Procedures
- Merging Data and Passing Tables
- Designing and Implementing User-Defined Functions
- Creating Highly Concurrent SQL Server 2012 Applications
- Handling Errors in T-SQL Code
- Responding to Data Manipulation via Triggers
- Implementing Managed Code in SQL Server 2012
- Storing XML Data in SQL Server 2012
- Querying XML Data in SQL Server
- Working with SQL Server 2012 Spatial Data
- Working with Full-Text Indexes and Queries
