Courses designed to provide the tools necessary to begin to SQL Server2005developer and report technologies that are available and in wide-stream use today.
Navigation
- 1: Home
- 2: Diploma course
- 3: Quality Management
- 4: Business Analyst
- 5: Management
- 6: IT
- 6.1: QA(Software Testing)
- 6.2: Softwate Testing Certificate(CSTE)
- 6.3: .NET(MCAD/MCSD) Certificate
- 6.4: SAS BASE
- 6.5: Advanced SAS
- 6.6: SAS Project
- 6.7: Graphic Design
Current page is 6.8: SQL Server 2005 Developer/Report
- 6.9: Access&VBA
- 6.10: Iava
- 7: Finance & Accounting
- 8: Language Training
- 9: 中文课程信息(Chinese)
- 10: About Us
- 11: Online Course Video
- 12: Contact Us
- 13: ads
News
CSI has partnered with a number of institutions that offer the CSC Volume 1 and CSC Volume 2 seminars. These seminars utilize CSI seminar material and are conducted by experienced and knowledgeable instructors.
SQL Server 2005 Developer/Report
Course Description
Course Outline
Introducing SQL Server 2005
Major features
Editions
Installing SQL Server
Building a Database
Introducing SQL Server Management Studio
Databases
Tables
Indexes
Relations
Administrative Tools
SQL Server Management Studio
Registered Servers
Object Explorer
Review Database Objects
Modify Database Properties
The Maintenance Plans
Query Editor
SQL Agent Jobs
Dynamic Help
Programming with TSQL – the Basics
Using Variables
Control of Flow Statements
Create Views, Stored Procedures, User Defined Functions
Creating Views
Updating Through Views
Indexed Views
Creating Procedures
Passing Parameters
Scalar, Inline Table and Multi-Statement
Data manipulation in UDFs
Profiling UDFs
Create Triggers
Trigger Syntax
Trigger Events
Enabling/Disabling Triggers
Advance Transact – SQL
Transactions
Distributed Transactions
Ranking Functions
Cursors
Structured Error Handling
Using SQL Server 2005 Integration Services (SSIS)
Work Flow and Data Flow
Package Design
Deployment
Using SQL 2005 Reporting Services (SSRS)
Report Manager
Report Server
Creating Reports
Deploying Reports
Viewing Reports
Using SQL Server 2005 Analysis Services (SSIS)
1. Data Sources and views
2. Creating cubes
3. Refining Dimensions and Measures
Previous page: Graphic Design
Next page: Access&VBA