by phuongdzu on 01 October 2015 - 938 views - 0 comments

[Tutorials] Foundations of Programming: Databases - English

Foundations of Programming: Databases
Duration: 3hr 11m | Video: h264, yuv420p, 1280x720 30fps | Audio: aac, 44100 Hz, 1 ch | 540MB
Genre: eLearning | Language: English

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.

Topics include:

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

DOWNLOAD HERE :

Tags:

[Tutorials] Digital-Tutors - Using DataTables to Create Data Driven Gameplay in Unreal Engine

[Tutorials] Transitioning from Data Warehousing to Big Data

Foundations 0F Typography: Color, Contrast, and Scale

[Tutorials] SkillShare - Fundamentals of Lightroom I: Organize Files and Boost Your Workflow

Infographic Data Elements 7