Важное объявление!
У Нас Все раздачи мультитрекерные, при нуле пиров в релизах, можете смело вставать на закачку!
Автор Сообщение


4 года 10 месяцев

Репутация: 101

[+] [-]
Вне форума [Профиль] [ЛС]

Foundations of Programming: Databases
Год выпуска: 2015
Производитель: Lynda
Сайт производителя: lynda.com
Автор: Simon Allardice
Продолжительность: 3: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 your data. Plus, learn to juggle the competing demands of storage, access, performance, and security—management tasks that are critical to your database's success.


What you need to know
1. Understanding Databases
What are databases?
Exploring databases and database management systems
2. Database Fundamentals
The features of a relational database
Exploring unique values and primary keys
Defining table relationships
Describing many-to-many relationships
Transactions and the ACID test
Introduction to Structured Query Language (SQL)
3. Database Modeling: Tables
Introduction to database modeling
Planning your database
Identifying columns and selecting data types
Choosing primary keys
Using composite keys
4. Database Modeling: Relationships
Creating relationships
Defining one-to-many relationships
Exploring one-to-one relationships
Exploring many-to-many relationships
Understanding relationship rules and referential integrity
5. Database Modeling: Optimization
Understanding normalization
First normal form
Second normal form
Third normal form
Database denormalization
6. Database Modeling: Querying
Creating SQL queries
Structuring the WHERE clause
Sorting query results
Using aggregate functions
Joining tables
Inserting, updating, and deleting
The data definition language
7. Database Modeling: Indexing and Optimization
Understanding indexes
Understanding write conflicts
Understanding stored procedures and injection attacks
8. Database Options
Desktop databases
Relational database management systems
Object-based and XML-based databases
NoSQL databases
Final thoughts
Файлы примеров: не предусмотрены
Формат видео: MP4
Видео: AVC, 1280x720, 16:9, 30fps, 367kbps
Аудио: AAC, 48kHz, 128kbps, stereo


Показать сообщения:    

Текущее время: Сегодня 06:13

Часовой пояс: GMT

Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете голосовать в опросах
Вы не можете прикреплять файлы к сообщениям
Вы не можете скачивать файлы