Tag: Practice

SQL Practice – Window Functions


Free Download SQL Practice – Window Functions
Released 9/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner | Genre: eLearning | Language: English + srt | Duration: 12m | Size: 23 MB
Test your knowledge of Window Functions in SQL in this edition of Code Challenges. Instructor Scott Simpson provides five challenges-and his solutions-that reflect real-world data analysis use cases, including calculating a running total, ranking employees of a company by pay, and comparing order totals over time. It’s a data-driven world, and SQL is the language often used to work with that data. Try out Scott’s challenges to see how your skills match up, learn new methods, and gain confidence in working with the various data analysis and reporting tools that many SQL-compatible relational database management systems provide.

(more…)

SQL Practice – Intermediate Queries


Free Download SQL Practice – Intermediate Queries
Released: 09/2023
Duration: 11m | .MP4 1280×720, 30 fps(r) | AAC, 48000 Hz, 2ch | 20 MB
Level: Intermediate | Genre: eLearning | Language: English
Looking to boost your skills writing queries in SQL? This course was made for you. Join senior LinkedIn Learning staff instructor Scott Simpson in this hands-on, interactive, skills-first coding course designed uniquely for intermediate SQL developers. Explore techniques for writing queries in SQL to boost your technical know-how or prepare for an interview to land a new role. This course includes Code Challenges powered by CoderPad: interactive coding exercises with real-time feedback, so you can get hands-on coding practice to advance your coding skills. Scott helps you develop your skills as a SQL programmer with five specific, query-focused coding challenges. Practice finding your top customers, listing items in each order, sorting orders by day, seasonal sales, and vendor integration.

(more…)

SQL Practice – Basic Queries


Free Download SQL Practice – Basic Queries
Released 9/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner | Genre: eLearning | Language: English + srt | Duration: 17m | Size: 35m MB
In this hands-on, interactive course, join instructor David Gassner to practice writing basic queries in SQL, the popular programming language that’s widely used for relational databases. This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice to advance your coding skills. David helps you boost your skills as a SQL programmer with seven specific, query-focused coding challenges. Practice retrieving sorted data from a specific table or multiple tables, retrieving data filtered on a range of values, retrieving aggregated data with SQL functions, retrieving data filtered with a string pattern, and more.

(more…)

Python Practice – Operations


Free Download Python Practice – Operations
Released 9/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner | Genre: eLearning | Language: English + srt | Duration: 17m | Size: 32 MB
If you’re looking to practice basic operations in Python, this course was designed just for you. Join LinkedIn Learning staff instructor Scott Simpson as he leads you through a series of automated coding challenges hosted by CoderPad, the skills-first, technical assessment platform that lets you write live code in a realistic coding environment. Each challenge in the course includes a set of instructions and a couple of code editors you can use to create and test your own solution. Scott shows you get started testing your skills as a Python programmer with seven operations-focused challenges. Learn how to determine if two strings are equal, replace a string, reverse a string, format a string, insert a string, determine whether a string contains certain letters, and check to validate if multiple strings are anagrams.

(more…)

Python Practice – Object-Oriented Programming


Free Download Python Practice – Object-Oriented Programming
Released 9/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 12m | Size: 25 MB
Python is a popular programming language that can be used to work with data, build applications, and solve problems, on many types of devices. This code challenge with Scott Simpson, Senior Staff Instructor at LinkedIn Learning, is designed to help you test your knowledge of object-oriented programming in Python. The course includes five code challenges that cover the concepts around object-oriented programming. You can build and test your solutions to these challenges in the built-in interactive coding environment without needing any special software. When you finish each challenge, you can watch solution videos to see how they were solved. Are you ready to try out your Python object-oriented programming skills?

(more…)

Python Practice – Collections


Free Download Python Practice – Collections
Released 9/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Intermediate | Genre: eLearning | Language: English + srt | Duration: 11m | Size: 23 MB
Want to get up to speed with Python collections, but not sure where to begin? In this course, designed for developers with intermediate-level Python experience, LinkedIn Learning staff instructor Scott Simpson gives you a hands-on overview of the different available data types in the Python collections module and shows you how to use each of them to write more efficient and more reliable code. Join Scott as he takes you through a series of automated coding challenges hosted by CoderPad, the skills-first, technical assessment platform that lets you write live code in a realistic coding environment. Each challenge in the course includes a set of instructions and a couple of code editors that you can use to create and test your own solution on the go. Scott helps you boost your skills as a Python programmer with five specific, collections-focused coding challenges. Learn how to deduplicate and sort a list, work with and transform a tuple, build a set, create a dictionary, and more.

(more…)

JavaScript Practice – Object-Oriented Programming


Free Download JavaScript Practice – Object-Oriented Programming
Released 9/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 15m | Size: 33 MB
Unlike class-based programming languages like Java, JavaScript is a prototype-based procedural language. This means it supports functional and object-oriented programming-with less rigid syntax, greater extensibility, and fewer rules. In this hands-on, interactive course, join instructor Emma Bostian to practice performing basic object-oriented programming tasks in JavaScript to boost your technical know-how, prepare for an interview, or land a new role. This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice to advance your coding skills. Emma helps you boost your skills as a JavaScript programmer with five specific, query-focused coding challenges. Practice creating a course roster with functions, a book function with Object.create(), a country with classes, a food ordering class with getters and setters, and a user/admin class with private properties.

(more…)

JavaScript Practice – Events


Free Download JavaScript Practice – Events
Released 9/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Intermediate | Genre: eLearning | Language: English + srt | Duration: 22m | Size: 47 MB
As a JavaScript developer, much of the code you write centers on events triggered by users. Improving your understanding of how these events can be utilized will help you sharpen your skill set and help you work more efficiently. In this course, Jamie Pittman provides challenges that test your knowledge of five common JavaScript events. Check out these code challenges to gain a deeper understanding about JavaScript events and how these events can be incorporated into additional learnings and into your own JavaScript work.

(more…)