Lynda – Programming Foundations Databases

Lynda – Programming Foundations Databases
English | Size: 559.18 MB
Category: Tutorial

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

Lynda – Migrating Access Databases to SQL Server

Lynda – Migrating Access Databases to SQL Server
English | Size: 389.93 MB
Category: CBTs

At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server’s advanced features, and maintain a link to the data in Access.
[Read more…]

LinkedIn – PHP Object-Oriented Programming with Databases

LinkedIn – PHP Object-Oriented Programming with Databases
English | Size: 713.58 MB
Category: Tutorial

Learn how to interact with databases using object-oriented PHP code. In this intermediate course, Kevin Skoglund teaches powerful PHP techniques that streamline interactions with MySQL databases. PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that object-oriented programming (OOP) offers. Kevin shows how OOP techniques can optimize database queries, help manage sessions, and simplify user logins. He provides practical examples and tips to create objects that interact seamlessly with database rows, to build a content management system with HTML forms, to authenticate users, and to break up long lists of database data into smaller pages. [Read more…]

Lynda – Developing Microsoft SQL Server 2014 Databases


Lynda – Developing Microsoft SQL Server 2014 Databases[/b]
English | Size: 500.3 MB
Genre: eLearning

[Read more…]

Pluralsight – Accessing SQL Server Databases from PowerShell

Pluralsight – Accessing SQL Server Databases from PowerShell
English | Size: 106.35 MB
Category: Tutorial

SQL Server is the Database engine used for all the enterprise tools part of the Microsoft ecosystem and PowerShell is the most popular scripting language. This course will teach you how to use PowerShell to read and write data from/to SQL Databases.
[Read more…]

Packt – Elastic Databases and Data Processing with AWS

Packt – Elastic Databases and Data Processing with AWS
English | Size: 684.41 MB
Category: Tutorial

This course will show you how to expand your database and data processing capabilities by leveraging some of the fully managed data processing technologies available through AWS. Filled with practical, real-life examples, this course will cover scalable, next-generation NoSQL database technologies such as DynamoDB, which will help you build fault-tolerant applications and understand the benefits from fully managed SQL services such as RDS, Redshift, and Athena. [Read more…]

Lynda – Learning Relational Databases

Lynda – Learning Relational Databases
English | Size: 246.31 MB
Category: Tutorial

Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don’t know how to speak their language? This course can help you overcome these hurdles.
[Read more…]

Pluralsight – Amazon Web Services Databases in Depth by Richard Seroter

Pluralsight – Amazon Web Services Databases in Depth by Richard Seroter
English | Size: 688.34 MB
Category: Tutorial

Learn how to incorporate Amazon RDS, DynamoDB, and Redshift into your data-driven applications. Explore each database and learn how to use it effectively. [Read more…]

Packt Publishing – Elastic Databases and Data Processing with AWS

Packt Publishing – Elastic Databases and Data Processing with AWS
English | Size: 616.05 MB
Category: Tutorial

Drastically reducing the time it takes to setup, and also minimize the errors or challenges faced by administrators in real life!

This course will show you how to expand your database and data processing capabilities by leveraging some of the fully managed data processing technologies available through AWS. Filled with practical, real-life examples, this course will cover scalable, next-generation NoSQL database technologies such as DynamoDB, which will help you build fault-tolerant applications and understand the benefits from fully managed SQL services such as RDS, Redshift, and Athena. By the end of the course, viewers will be able to build a fully managed Elastic Database that can be managed with a single click. This will also help you drastically reduce the time it takes to set it up, and also minimize the errors or challenges faced by administrators in real life. [Read more…]

Team Treehouse Querying Relational Databases Course

Team Treehouse Querying Relational Databases Course
English | Size: 243.19 MB
Category: CBTs

Building off of previous SQL courses, this course will begin to introduce the student to more complex database concepts. Students will learn to think about data as sets and subsets and practice achieving desired query results via such operations as inner and outer joins, unions and except. They will also be introduced to the concepts of Set Theory and Database Normalization to aid in understanding good query practices. [Read more…]