SQL Server 2008 Essential Training

Product type
Level
Logo Lynda

Need more information? Get more details on the site of the provider.

Description

Explores all the major features of SQL Server 2008, beginning with core concepts.In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server's database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course. Topics include: Using T-SQL (Transact-SQL) Managing databases…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Explores all the major features of SQL Server 2008, beginning with core concepts.In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server's database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course. Topics include: Using T-SQL (Transact-SQL) Managing databases with SQL Server Management Studio Understanding database normalization Using SELECT statements Building indexes Monitoring database size and integrity Backing up and restoring databases Creating functions and stored procedures Managing database permissions Creating and formatting reports Adding charts to reports Creating and executing a simple SSIS package

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.