Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)
[lynda.com] SQL Server 2008 Essential TrainingГод выпуска: 2010
Производитель: lynda.com
Сайт производителя:
http://www.lynda.comАвтор: Simon Allardice
Продолжительность: 06h 54m
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: 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.
[spoiler="Содержание"]
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
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MOV
Видео: Video: MPEG4 Video (H264) 960x540 29.97fps 627kbps
Аудио: Audio: AAC 48000Hz stereo 158kb
[spoiler="Скриншоты"]

[/spoiler]