Databases

CBT Nuggets – Microsoft SQL Server 2012 Administering Databases (70-462)

CBT Nuggets – Microsoft SQL Server 2012: Administering Databases (70-462)
English | Size: 3.53 GB
Category: Tutorial


CBT Nuggets is pleased to introduce “Microsoft SQL Server 2012 70-462,” a new training series. If you’ve got your eye on MCSA SQL Server certification, check out this series.

PluralSight – Modeling and Schema Design Patterns for Document Databases

PluralSight – Modeling and Schema Design Patterns for Document Databases BOOKWARE-KNiSO
English | Size: 134.23 MB
Category: Tutorial


Release Notes: Document databases have been gaining in popularity for a number of years now and much of their power can be traced to the ease of working with data defined in the JSON format. In this course, Modeling and Schema Design Patterns for Document Databases, you will see how entities and relationships can be modeled for document databases. First, you will explore how data is represented in different types of databases; from relational DBs to wide-column stores, and how this influences the way data is modeled. You will see concepts such as normalized and denormalized representations of data including the benefits and drawbacks of each approach. Next, you will move on to modeling data for document databases based on the nature of the relationship between entities. This covers the modeling of one-to-one, one-to-many and many-to-many relationships and how content from related documents can be combined while running queries.

Lynda – Programming Foundations – Databases

Lynda – Programming Foundations – Databases [AhLaN]
English | Size: 333.70 MB
Category: Tutorial


Once you get beyond basic programming, you’ll need a database. Databases provide a consistent, organized structure for storing and retrieving large amounts of data. They allow programmers to build more complex applications that can take orders, process payments, make recommendations, authenticate users, and more. This course provides the foundation you need to get started in database programming. Explore the terminology: normal forms, ACID and CRUD, referential integrity, transactions, records, and tables. Learn what role keys and unique values play in a relational model. Discover how to design the best system to contain your data, starting with the tables and relationships at the core of your database. Find out how to write queries to extract the data you need, and how to juggle the different demands of storage, access, performance, and security. Instructor Scott Simpson provides practical examples and clear explanations that will help you design databases that can withstand the needs of your applications, your data, and your users.

Linux Academy – Introduction to Databases on Linux

Linux Academy – Introduction to Databases on Linux-APoLLo
English | Size: 392.70 MB
Category: Tutorial


A database is, essentially, an organized collection of data. That’s it. There are no big words here, no complex diagrams. They’re both essential and often misunderstood. Many an introduction to database basics overcomplicates this, but we’re aiming for straightforward. A database is just a simple, organized collection of data.

Cloud Academy – Working with AWS Databases

Cloud Academy – Working with AWS Databases
English | Size: 3.71 GB
Category: Tutorial


In almost every enterprise solution there will be a requirement for some sort of database, but which service should you use, and how should you architect it? This learning path has been compiled to introduce you to the different AWS database services and some of the features relating to AWS database types.