Tag: Queries

learning path – Unlocking Hierarchical Queries in SQL Server


Free Download learning path – Unlocking Hierarchical Queries in SQL Server
Published 2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 48 KHz
Language: English | Size: 415.51 MB | Duration: 3h 00m
This learning path offers in-depth training on managing and querying hierarchical data. Starting with foundational concepts of hierarchical data in SQL Server, learners progress to mastering recursive queries and advanced data management techniques. The path culminates in integrating and visualizing hierarchical data, along with exploring its real-world applications.

(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…)