SQL Server Development
0 STUDENTS ENROLLED
SQL Server Development Course Content:
1.A Tour of SQL Server 2008
- SQL Server 2008 Editions, Components, and Tools
- Using SQL Server Management Studio (SSMS)
- Working with Tables and Queries
- New Transact-SQL Features
- Business Intelligence Services
2.Installing SQL Server 2008
- Preparing for Installation
- Upgrading an Earlier Version
- Installation Steps
- Configuring the Server
3.Designing and Creating a Database
- Relational Database Design Principles
- Implementing the Design
4.Data Selection Queries
- Understanding Transact-SQL
- The SELECT Statement
- The WHERE Clause
- Using ORDER BY to Sort Data
- The GROUP BY Clause
- Joining Tables
5.Modifying Data
- Modifying Data
- Inserting Data
- Updating Data
- Deleting Data
- Understanding Transaction Isolation
6.Working with SQL Server Management Studio
- Getting Started with SSMS
- Exploring the Object Explorer
- Working with the Query Editor
7.Transact-SQL Programming
- Overview of Transact-SQL
- Using Built-In Functions
- Controlling Flow
- Ranking Results
8.Transactions and Error Handling
- Transaction Concepts
- Using TRY/CATCH Error Handling
9.Creating Views, Stored Procedures, Cursors and Triggers
- What Is a View?
- Creating Views
- Creating Stored Procedures
- Creating Cursors
- Creating Triggers
10.Creating User-Defined Functions
- User-Defined Function Overview
- Scalar Functions
- Inline Table-Valued Functions
- Multi-Statement Table-Valued Functions
- Using Functions, Views, and Stored Procedures
11.Advanced Query Techniques
- Generating XML with FOR XML
- Using APPLY
- Creating Recursive Queries
- Creating Pivot Queries
- Executing Dynamic SQL
12.Understanding and Implementing Security
- Security Overview
- Authentication
- Authorization
- Permissions
13.Analyzing and Tuning Performance
- Evaluating Performance
- Monitoring with SQL Server Profiler
- Tuning Queries
- Indexes
Course Reviews
No Reviews found for this course.
Write a Review