Udemy – Build MySQL Databases Bootcamp (Beginner to Expert Course)

Udemy – Build MySQL Databases Bootcamp (Beginner to Expert Course)
English | Size: 2.2GB
Category: tUTORIAL


Become an In-demand SQL Master by creating complex databases and building reports through real-world projects [Read more…]

CBT Nuggets – Microsoft SQL Server 2012 Developing Databases (70-464)

CBT Nuggets – Microsoft SQL Server 2012: Developing Databases (70-464)
English | Size: 2.81 GB

Category: Tutorial


This Microsoft SQL Server video training course with Garth Schulte covers Microsoft’s in-demand server, including how to build, implement, optimize and troubleshoot SQL Server database, and programming objects. [Read more…]

CBT Nuggets – Microsoft SQL Server 2014 Developing Databases (70-464)

CBT Nuggets – Microsoft SQL Server 2014: Developing Databases (70-464)
English | Size: 2.50 GB
Category: Tutorial


Garth Schulte just completed his Microsoft MCSE SQL Server 2014 70-464 course. In 36 videos, he covers the latest version of developing against Microsoft’s SQL Server database server, including how to design, implement, optimize, and troubleshoot SQL Server 2014 database and programming objects. This course also prepares you for the MCSE: SQL Server 2014 Data Platform exam. [Read more…]

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. [Read more…]

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. [Read more…]

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. [Read more…]