最新消息:网盘下载利器JDownloader--|--发布资讯--|--解压出错.密码问题

Lynda – Foundations of Programming: Databases

其他教程 killking 0评论
Poster

Lynda - Foundations of Programming: Databases
Size: 545MB | Duration: 3h 11m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Appropriate for all | 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
Lynda - Foundations of Programming: Databases

以下隐藏内容只提供VIP赞助会员

sorry! The following hidden content sponsorship VIP members only.

您必须 登录 才能发表评论!

网友最新评论 (1)

  1. Lynda - 编程基础:数据库 了解数据库如何对你和你的架构发挥作用,而不用去考虑使用何种编程语言、操作系统或应用程序。在本教程中,学习从个人桌面数据库到大规模地理分布式数据库服务器和经典的关系型数据库,到现代的面向文档系统和数据仓库。从而了解如何选择最适合你的方案。作者Simon Allardice会讲到重要的技术和概念,如正则式,死锁和脏数据读写、ACID和CRUD、参照完整性、回滚。教程还会通过一步步地实例操作讲解数据建模,从而设计出适合你的数据的最佳系统。另外,还会学习到存储、访问、性能、安全和以及对你的数据成功与否的重要技巧。 主要内容:何为数据库;为何需要数据库;选择主键;识别列和选择数据类型;定义关系:一对一、一对多和多对多;理解正则式;创建查询,对数据增删改;理解索引和存储过程;了解你的数据库选择。
    wilde(特殊组-翻译)2年前 (2015-10-03)