While learning about the individual components of a software development stack like databases, programming languages, and interfaces is important, combining multiple technologies that each contribute a piece to the whole is where all the knowledge really comes together. In this fifth and final course of his Database Foundations series, database expert Adam Wilbert explores the role of relational databases in the larger landscape of application development. He examines the architecture of modern apps and how databases integrate with presentation and logic, and how all these building blocks of software development fit together. To do so, Adam shows two different approaches of how to integrate a database with a web server and details the components that allow you to build custom interfaces for your data, in order to provide end users access to your databases from any web browser.

Understand the core concepts every IT professional should know to start working with databases.

Learn all about getting data in and out of tables and databases, including assigning data types, creating tables, writing queries, and inserting and deleting records.

Learn how to properly structure your data tables to develop well-formed databases that adhere to time-tested standards.

Part three of the Database Foundations series focuses on data management.

Learn the basics of building databases in a platform agnostic way so you can continue on to other platforms later. Explore database setup, servers, GUIs, tables, objects, and more.

Prep for MTA Exam 98-364 and get a baseline understanding of the core concepts of database storage: normalization, key fields, and indexing.

Node.js developers often consider MongoDB to be their main choice when building a data-driven application—but many alternatives may provide better solutions. In this course, learn about the various database options available for Node.js applications, so that you can select the right database for your app. Daniel Khan reviews the basics of relational and nonrelational databases, and explains how—and when—to use document databases with Node.js. He also covers using key-value stores and relational databases with Node.js, demonstrating how to work with MySQL and Sequelize.

CG artist and environmental designer David Lesperance explains how he creates the rich, lifelike backdrops for popular games like World of Warcraft, Halo, Diablo, and StarCraft.

Learn how to enhance the color, contrast, mood, and style of your video projects with DaVinci Resolve 12, the powerful color grading and color correction software from BlackMagic.

Are you new to DaVinci Resolve? Are you intrigued by the power of this digital video media creation tool? Do you find the power of this tool intimidating or confusing? Then this title is for you. Join instructor and professional colorist Patrick Inhofer in this course designed to get you up to speed in as little time as possible. This course includes a 60-second commercial for you to work with so you can get comfortable with the layout and workflow as you follow along. Patrick starts with the process of importing your media, using both manual and automated tools, before showing how to start building a rough cut in Resolve. He then explains how to refine your rough cut using trim tools and adding titles and transitions, details the important aspects of color correction, and shows how to organize and mix sound clips. Patrick finishes the course covering the export process, showing how to use preset templates as well as how to create your own reusable custom templates.

Learn about the differences between log, raw, and flat recordings, and explore two different methods for color correcting that footage in DaVinci Resolve.

Understand the many hardware choices, components, and compromises involved when building a DaVinci Resolve-based color correction system.

Learn how to use video scopes in DaVinci Resolve to properly evaluate footage.

Understand the process of sharing timeline data between editing apps like Premiere Pro, Final Cut Pro X, and Avid Media Composer, and DaVinci Resolve.

DaVinci Resolve is a leading professional color grading solution used for digital intermediates (the digital color grading of film-acquired sources, to be printed back out to film for theatrical exhibition). It’s not surprising that its color management tools are used every day in major film productions all over the world. In this course, professional colorist Patrick Inhofer takes an extensive look at the color page in DaVinci Resolve, starting with the settings and preferences that have a significant impact on color manipulations. He then covers the concept of primary corrections and the tools used for establishing a base color correction, as well as secondary corrections and how to isolate and minimize problematic areas of the image. Patrick also shows how to combine primary and secondary color operations to enhance viewer engagement, and shares tips for improving your shot-matching skills to help your story have a better visual flow.

This course was created by Patrick Inhofer. We are pleased to host this training in our library

Learn the key techniques video editors need to transition to DaVinci Resolve. Learn how to edit video, adjust audio, correct color, apply effects, and more.

DaVinci Resolve is constantly being updated and refined. In this course, instructor Patrick Inhofer shows you how to work smarter with this feature-rich platform, sharing important workflows and options that every Resolve editor, colorist, VFX artist, or audio mixer should understand. Learn how to efficiently manage databases and project files, customize the user interface to suit your personal preferences, and optimize playback performance—including how to leverage Render Cache and proxy options. Plus, discover how to move a project between Premiere Pro or Final Cut Pro and DaVinci Resolve, as well as add additional hardware to speed up your editing, color grading, or mixing workflows.

Are you looking for an alternative to your database platform’s native tools? DBeaver is the universal database client that allows you to work with a wide variety of data platforms from a single interface. In this course, database expert Adam Wilbert shows you how to leverage this powerful tool. Adam gives you a tour of the interface and explains how to create your own database connections and add a PostgreSQL connection. He steps through how to use projects to organize your workspace, as well as the views, filters, and panels you might use when working with tabular data. After exploring how to create and modify database objects and structures, Adam covers how to configure, save, and print an entity relationship (ER) diagram. He offers useful tips on writing commands with the SQL Editor, then concludes with a discussion of some additional features that you might use in the Enterprise Edition.

Learn how to use DC.js in coordination with Crossfilter and D3.js to create interactive dashboards and widgets that display bar charts, scatterplots, heatmaps, and more.