Advanced

Egghead.io – Advanced SQL for Professional Developers

Egghead.io – Advanced SQL for Professional Developers-APoLLo
English | Size: 203.47 MB
Category: Tutorial


You’ve got some practice with using SQL to select, update, and join database tables.

But perhaps you’ve found yourself with a sneaking suspicion that you could be more efficient with your PostgreSQL.

O’Reilly – Python Series – Advanced Topics in Python

O’Reilly – Python Series – Advanced Topics in Python
English | Size: 602.19 MB
Category: Programming | Linux


Explore a preview version of Python Series: Advanced Topics in Python right now.
O’Reilly members get unlimited access to live online training experiences, plus books, videos, and digital content from 200+ publishers.

Pluralsight – Selecting Your Fantasy Premier League Team With Advanced Analytics

Pluralsight – Selecting Your Fantasy Premier League Team With Advanced Analytics-NOLEDGE
English | Size: 91.37 MB
Category: Tutorial


Notes: Big Data LDN 2019 | Selecting Your Fantasy Premier League Team with Advanced Analytics | William Davis
Learn how to utilize the advanced analytics capabilities in Alteryx toselect your top Premier League players for your fantasy team. By connecting to the FPL website via API and a database, Alteryx can prep and blend data together and perform predictive analytics to generate your winning fantasy team. William Davis will also show how you can push this data into visualization tools, such as Tableau

Linkedin Learning – Excel Advanced Formulas and Functions

Linkedin Learning – Excel Advanced Formulas and Functions-ZH
English | Size: 696.54 MB
Category: Tutorial


Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel’s most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version-including 2019, 2016, and 2013-will be able to follow along.

Lynda – Advanced Selenium Page Objects and GUI Automation

Lynda – Advanced Selenium Page Objects and GUI Automation-APoLLo
English | Size: 520.22 MB
Category: Tutorial


The Page Object Model is a popular design pattern for automating web applications. Test automators can be more effective if they have mastered multiples ways of creating page objects and understand their pros and cons. In this course, Alan Richardson shows how to model GUI applications as page objects in Selenium. Discover how to refactor code into abstractions and abstract the details of your infrastructure, dependencies, and even technology elements like buttons and input fields. Explore the different types of page objects, and discover how to abstract navigation and test data. Plus, find out how to model the execution of an application with domain-specific languages. Alan closes with tips on making abstraction design decisions.