Duration: 24m 10s | MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Size: 94 MB
Skill Level: Beginner | Genre: eLearning | Language: English + Subtitles
If even a small part of your job entails using Microsoft Excel, there's a good chance that at some point you've received a spreadsheet where the data is unorganized, disconnected, or generally not in great shape. And despite common practice, a long, heavy sigh is not officially part of any recommended Excel workflow. Rather than pull your hair out at the mess of data you see before you, you can use Power Query in Excel to help you import and clean data into something easier to work with. In this course, Excel expert Dave Ludwig takes you through the robust features set of Power Query. Dave shows you how to use Power Query to connect to your data source, filter data, and create conditional columns of data. He also shows off the significant cleansing capabilities of Power Query. Once your data is cleaned up, you can more easily create formulas, PivotTables, charts, and generally get on with your business.

Duration: 2h 19m | MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Size:
Skill Level: Intermediate | Genre: eLearning | Language: English + Subtitles
Ethical hacking-testing to see if an organization's network is vulnerable to outside attacks-is a desired skill for many IT security professionals. In this course, cybersecurity expert Malcolm Shore prepares you to take your first steps into testing client defenses. Malcolm provides you with an overview of firewall technology, detailing how firewalls work in both Windows and Linux, as well as how to set up a firewall simulation in a GNS3 network. Next, he goes over web application firewalls, API gateway threat mitigation solutions, and how to use honeypots to detect intruders. Finally, he covers the main ways to manage a suspected intrusion, including how to use the Security Onion intrusion detection system (IDS).

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Intermediate | Genre: eLearning | Language: English + srt | Duration: 54m 43s | Size: 412.1 MB
In this course, Toni Lowe, a sought-after speaker and senior HR leader specializing in diversity, inclusion, equity, and belonging, teaches you how to identify and address everyday, subtle, intentional and unintentional actions or behaviors that perpetuate bias toward marginalized groups in the workplace. Toni defines microaggression and identifies the three distinct types of microaggressions: microassaults, microinsults, and microinvalidations. While the word "micro" means "small," each instance of microaggression has a big impact on the employee experience, physical health, and psychological well-being. Toni provides actionable steps you can take to create safe spaces in the workplace for coping and developing a support system. She discusses how to effectively address past behaviors directly with the offender or through a third party, then walks you through how to deal with microaggressions in real time. Toni concludes with her three-step framework for dealing with microaggression.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner | Genre: eLearning | Language: English + srt | Duration: 2h 14m | Size: 397.7 MB
In the realm of relational databases, the table is the main event, the showstopper, the lead singer, the king. However, there are several other components of databases that are just as vital to a fully functioning system. In this course-the third part of his Database Foundations series-Adam Wilbert turns the spotlight on the supporting cast of database management characters. He covers topics like view objects, query performance, transactions, and stored procedures, and shows how each is an integral part of database management. Adam also includes challenges designed to test your skills as the course advances. As Adam illustrates, knowledge of these elements of database management can enhance your system performance and lead to a more consistent end-user experience.

Duration: 3h 51m | Video: .MP4 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | Size: 775 MB
Genre: eLearning | Language: English
Data science continues to grow in sophistication and demand at an exponential rate. Data mining is the area of data science that focuses on finding actionable patterns in large and diverse datasets: clusters of similar customers, trends over time that can only be spotted after disentangling seasonal and random effects, and new methods for predicting important outcomes. Instructor Barton Poulson focuses on data mining in R, presents a broad range of algorithms including machine learning methods, and offers important information on laws and policies that affect data mining. Barton gives an overview of dimensionality reduction. He introduces clustering, including hierarchical clustering, then goes into association analysis. He explains time-series mining and decomposition, then concludes with text mining, sentiment analysis, and sentiment scoring.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Intermediate | Genre: eLearning | Language: English + srt | Duration: 1h 3m | Size: 119.3 MB
Data science can be generally defined as the process of making data useful, and data engineering is a key part of how and why. If you think of data science like a race car, the data engineers are the pit crew. They're not driving the car, but they make the car much easier to drive. Data engineers make sure the data flow is running smoothly, monitor systems, anticipate problems, and repair the data pipeline whenever problems arise. They extract and gather data from multiple sources and load it into a single, easy-to-query database. In short, data engineers make data scientists' lives easier.

Duration: 35m 52s | MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Size: 498 MB
Skill Level: Intermediate | Genre: eLearning | Language: English + Subtitles
Join graphic designer and brand strategist Nicte Cuevas as she discusses the impact color has across cultures and how the hues we use in our branding and work can shift perception. Nicte explains how color can hold different meaning across global cultures. She discusses how color psychology can shift or shape purchasing influences or create a divide among cultures. She helps you understand how cultural misappropriation can create a divide in communities and affect the perception of any brand. Nicte points out how gendered marketing through color can shift across the world. She shares the importance of understanding the role color plays when it comes to cultural heritage, and how using the wrong hue can shift the meaning when you market on a global scale. She explains how brands can partner with communities and experts avoid misunderstandings related to color language. In conclusion, Nicte shares her thoughts on how you can use color and culture to truly connect with an audience.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 1h 56m | Size: 371 MB
CSS is a toolkit for image manipulation. Whether you want to create distinctive visual effects or simply make the most of available bandwidth, the options for manipulating images in CSS will let you create reusable graphics solutions. In this course, instructor Morten Rand-Hendriksen shows you how much you can edit images in a browser using pure CSS. Morten explains the importance of proper HTML image markup and how to crop, fit, and position an image. He discusses how to use the clip-path property to create a variety of shapes. Morten shows how you can use and combine filters to edit and add effects to your image. He concludes by walking you through several practical examples of how to use what you learned, as well as some important best practices and caveats.

Duration: 42m 33s | MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Size: 128 MB
Skill Level: Intermediate | Genre: eLearning | Language: English + Subtitles
Every CSS layout relies on the display property to tell it basic rules for how to present content. In this course, instructor Jen Kramer explains why the display property is so important and walks you through basic display values and newer display values that you need to understand to make effective use of this property. Jen discusses inline-level elements and the inline display value. She covers block-level elements, the block display value, and how to nest inline and block elements in HTML. Jen describes how to use "display: none" and "visibility: hidden" to hide content. Then she goes into newer display values, such as inline flex and grid values, the flow-root property, inline-block, tables, and list items. Jen concludes with recommendations on further HTM and CSS learning.

Duration: 1h 41m | MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Size: 256 MB
Skill Level: Advanced | Genre: eLearning | Language: English + Subtitles
Cloud-based services should be secured with common practices such as hardening, disaster recovery planning, periodic security testing, and the use of encryption. Instructor Daniel Lachance goes over software-defined networking (SDN), cloud network infrastructure security, cloud application workload security, and business continuity in the cloud. Daniel begins with an overview of SDN and shows you how to create a virtual private cloud (VPC). He explains how to configure VPC peering, which links cloud-based networks. Daniel describes how to manage access control lists (ACLs) and how to configure a virtual private network (VPN). He reviews ways to manage cloud resources remotely over the Internet. Daniel explains identity and access management (IAM) policies. He discusses how to conduct a business impact analysis and craft disaster recovery policies, then concludes with an explanation of cloud backups and how you can use them to protect workloads and data on-premises.