Course details
This course teaches the fundamentals of SQL server 2008. Get the guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL server data in your applications, write queries, develop reports, and employ powerful business intelligence systems. The focus of this course is on providing an overview of each feature in sufficient depth to allow you to build SQL server applications. You will learn how to install each of the components, configure and manage instances, and build databases, as well as how each tool enables you to develop and manage your database environment.
Course Content
- Overview of Microsoft SQL server
- Installing and configuring SQL server 2008
- Using the tools in SQL server 2008
- Creating databases
- Designing tables
- Indexes
- Partitioning
- Data retrieval
- Advanced data retrieval
- Data manipulation
- View
- Stored procedures
- Functions
- Triggers
- Database snapshots
- Service broker
- Full-text indexing
- Security
- Policy-based management
- Data recovery
- SQL agent
- Dynamic management views
- High availability
- SQL Server Integration Services
- SQL Server Reporting Services
- SQL Server Analysis Services
Course Location
About Intec College
INTEC College offers the widest range of distance learning courses covering many disciplines from business to creative studies.
INTEC College is one of the South African market leaders in Further Education and Training via distance learning.
INTEC is a modern South African college with a solid track record spanning more than 100 years. With its proud history, INTEC still remains relevant and continues to meet the cultural and academic needs of today’s student.
See all Intec College courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Azure SQL Course GateZAR 235
ZAR 2,823Duration: Upto 1 Hour - ZAR 916Duration: 1 To 2 Months