Foundations of Programming: Databases [2013, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Foundations of Programming: Databases

Год выпуска: 2013
Производитель: Lynda.com
Автор: Simon Allardice
Продолжительность: 03:11 ч
Тип раздаваемого материала: Видеоурок
Язык: Английский
Файлы примеров: не предусмотрены

Описание: Discover how a database can benefit both you and your architecture, whatever the programming language, operating system, or application type you use. In this course, explore options that range from personal desktop databases to large-scale geographically distributed database servers and classic relational databases to modern document-oriented systems and data warehouses—and learn how to choose the best solution for you. Author Simon Allardice covers key terminology and concepts, such as normalization, "deadly embraces" and "dirty reads," ACID and CRUD, referential integrity, deadlocks, and rollbacks. The course also explores data modeling step by step through hands-on examples to design the best system for our data. Plus, learn to juggle the competing demands of storage, access, performance, and security—management tasks that are critical to your database's success.
[spoiler="Содержание"]
* What is a database?
* Why do you need a database?
* Choosing primary keys
* Identifying columns and selecting data types
* Defining relationships: one-to-one, one-to-many, and many-to-many
* Understanding normalization
* Creating queries to create, insert, update, and delete data
* Understanding indexing and stored procedures
* Exploring your database options
[/spoiler]
[spoiler="MediaInfo"]
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
Duration : 1mn 6s
Overall bit rate mode : Variable
Overall bit rate : 1 245 Kbps
Encoded date : UTC 2013-01-21 16:58:47
Tagged date : UTC 2013-01-21 16:58:47
Writing library : Apple QuickTime
Copyright : lynda.com

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : [email protected]
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 1mn 6s
Bit rate : 1 081 Kbps
Width : 960 pixels
Height : 540 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 fps
Standard : PAL
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.069
Stream size : 8.57 MiB (87%)
Language : English
Encoded date : UTC 2013-01-21 16:58:47
Tagged date : UTC 2013-01-21 16:58:47
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]