In this course, Ami Levin continues his Advanced SQL series with a new installment focused on conquering relational division challenges. As Ami points out, you’ve probably encountered relational division before, even if you’re unfamiliar with the term. Ami therefore starts with a background of relational division, including how relational algebra and the Cartesian product fit in to the picture. He then dives into SQL and shows the challenging aspects of relational division and three different techniques to solve them, highlighting the pros and cons of each approach. Along the way, Amin challenges you to write your own queries before walking through the methodology he uses. By the end of this course, you will gain valuable insight into how SQL works, be able to identify relational division challenges, and know how to implement the best solutions.

Take your SQL skills to the next level. Continue learning about aspects of logical query processing: from subqueries to ordered set functions, and from lateral joins to cursors.

Interpolation challenges are quite common, especially for time series and sequence analyses. In this course, data educator Ami Levin offers several techniques to solve these types of challenges seamlessly and efficiently. Ami explains what interpolation is and shows you how interpolation challenges and solutions work, using the database for Formula 1 race car telemetry. He goes over streamlining your solution with auxiliary data and explores the solution methodology for SQL challenges in general. Ami dives into definitions and challenges for proximal interpolations and linear interpolations, then concludes with a review of what you’ve learned.

Note: This course was created by Ami Levin. We are pleased to host this training in our library.

This course takes a deep dive into the many advanced features of Storyboard Pro.

Go beyond the basics with Terraform. Learn how to use this infrastructure as code solution to manage and automate your infrastructure.

Learn how to use advanced threading to perform concurrent processes in C#, with TPL, PLINQ, and TAP.

Learn how to use the advanced features in Trimble Accubid Classic Pro to more efficiently complete bid estimates.

Learn about the future of typography in transmedia and mediatecture, which is changing the way designers develop and apply type to solve design challenges.

Learn everything you would need to know about creating player movement and behaviors into 2D platformer-style games.

Build beautiful and effective visualizations driven by external data (such as Excel or Access data) with Visio 2016.

Learn how to build your advertising plan with training from former NYC ad executive Jane Barratt.

Amplify your reach with Facebook advertising. Learn how to create and manage Facebook ads campaigns that grow your business and boost your brand.

Amplify your reach with Facebook advertising. Learn how to create and manage Facebook ads campaigns that grow your business and boost your brand. This course helps you get started in Facebook advertising—while avoiding some of the platform’s main pitfalls. Megan Adams is a Facebook advertising expert that will help you craft campaigns that make sense, starting with a strategy that clearly aligns with your business goals. She shows how to write your ads, plan your budget, and boost your posts, and leverage the most powerful Facebook tools, like Ads Manager. By the end, you’ll be armed with knowledge to use Facebook Ads to its greatest potential, creating campaigns that deliver engaging campaigns to the right audiences and drive business back to your brand.

Amplify your reach with Facebook advertising. Learn how to create and manage Facebook ads campaigns that grow your business and boost your brand. This course helps you get started in Facebook advertising—while avoiding some of the platform’s main pitfalls. Megan Adams is a Facebook advertising expert that will help you craft campaigns that make sense, starting with a strategy that clearly aligns with your business goals. She shows how to write your ads, plan your budget, and boost your posts, and leverage the most powerful Facebook tools, like Ads Manager and Analytics. By the end, you’ll be armed with knowledge to use Facebook Ads to its greatest potential, creating campaigns that deliver engaging campaigns to the right audiences and drive business back to your brand.

Explore advanced techniques for advertising on Facebook, including how to manage multiple campaigns, use tags, create custom audiences and ads, and use retargeting tools.

Join marketing expert Anson Alexander as he covers the basics of creating, running, measuring, and tracking ads on Instagram.

Advertising on social media platforms like Instagram has become a vital part of many companies’ marketing strategies, but there’s a world of difference between hastily placing an ad and advertising effectively. In this course, marketing expert Anson Alexander explains how to create engaging content for Instagram advertising, demonstrating how to build a campaign and how to leverage Facebook Ads Manager along the way. Anson goes over the types of content you can use to advertise on Instagram and then shows how to create, upload, and format ads. He shows you different tools and demonstrates how to target specific audiences, implement a budget, and run scheduled campaigns. Anson discusses ad sets and placement configuration, as well as how to use Instagram Stories and Instant Experience ads to improve your marketing and increase your user engagement. He also covers analytics, so you can discover how to adjust your advertising efforts based on performance information.

LinkedIn ads are highly-targeted social ads, which differ significantly from search marketing. Join instructor AJ Wilcox as he digs into LinkedIn ads, providing practical strategies that can help you make this powerful platform work for you. He details what makes LinkedIn ads so valuable, helps you get acquainted with the platform’s capabilities, and demonstrates how to create effective ads on LinkedIn. AJ shows how to best use Text Ads, Sponsored Content, Sponsored Messaging ads, Dynamic Ads and more. He also shares approaches for audience targeting and organizing your campaigns for simple reporting and performance evaluation. Finally, he shows you how to view and interpret the metrics in the Campaign Manager to find out what you need to know about your advertising efficiency and ability to scale.

Learn all about advertising on LinkedIn. Get acquainted with the platform’s capabilities, as well as how to prepare a strategy for creating effective ads on LinkedIn.

Harness the power of the promoted pin. Learn how to create effective, engaging pins and winning campaigns on Pinterest, as well as track conversions and audience engagement.