Rubén Romartínez Alonso

Exploring #Excel #Sheet Reading in #cSharp and #Python - Enhance your coding expertise with @ava-patel on @OnlyCoders.net Follow @ava-patel and Read More at https://lnkd.in/eSZfP3J2 #programming  #softwaredeveloper #softwareengineer #100daysofcodechallenge #webdevelopment

5

Crack SQL Interview in 50 Questions - Q47 (தமிழில்):  Second Highest Salary Full Video: https://lnkd.in/gTe2ayvq Video 192: This is the 47th video in our series "Crack SQL Interview in 50 Questions," and in this exercise, we continue with the topic of "Advanced String Functions" We are given a Employee table which has Employee id and salary. We are asked to write a solution to find the second highest salary from the Employee table. If there is no second highest salary, return null In this video, we are discussing four different approaches to finding the second highest salary from the Employee table: *** Approach 1: n00b format using Subquery ***   This approach uses nested subqueries to find the second highest salary. It repeatedly finds the maximum salary that is less than the previous maximum salary until the second highest salary is obtained. *** Approach 2: Correlated subquery ***   In this approach, a correlated subquery is used to count the number of distinct salaries greater than or equal to each salary in the main query. The salary where this count equals 3 represents the second highest salary. *** Approach 3: Windows function with subquery format ***   This approach utilizes a window function DENSE_RANK() to rank the salaries in descending order. The outer query then selects the salary corresponding to the rank of 2, which represents the second highest salary. *** Approach 4: Windows function with CTE table ***   Here, a Common Table Expression (CTE) is used to calculate the dense rank of each salary. The main query then selects the maximum salary where the rank is equal to 2, indicating the second highest salary. For a comprehensive understanding of these SQL methodologies and their application, please refer to this explanatory video. code: https://lnkd.in/g9RRXwTe Follow me on, Website : https://growwithdata.co/ YouTube : https://lnkd.in/gSrqE3Nj TikTok : https://lnkd.in/gqFiMex2 LinkedIn : https://lnkd.in/gdfNNX9a Facebook : https://lnkd.in/gU6JWpFH FB Group : https://lnkd.in/gG4ENcrP twitter : https://lnkd.in/geZ3dqi8 Instagram : https://lnkd.in/gn263_PZ WhatsApp : https://lnkd.in/gBa5eC7y TheWide : https://lnkd.in/gt7htz_8 #sql #dataengineers #tablejoins #ceil #floor #bucket #meta #google #facebook #apple #paypal #netflix #amazon #deinterview #sqlinterview #interviewquestions #leetcode #faang #maanga #mysql #oracle #dbms #query #sqlserver #mysql #coderpad #aggregates #aggregation #nonaggregation #database #placementpreparation #lead #lag #windowsfunction #nullcheck #coalesce #sqlperformance #ifnull #case #lead #lag #windowsfunction #tamil #tamilpython #tamilinterview #tamilinterviewlatest #tamilinterviewquestions #sqlintamil 

1

🐍🔖 Python Video Courses — Our tutorials are created, curated, and vetted by a community of expert Pythonistas. At Real Python you'll get the trusted resources you need on your path to #Python mastery https://lnkd.in/epU2CDm

2

🚀 #Day2 of #SQL Series - Learn with InternForage! 💻 Today, we’re diving into inserting data into a table. Whether new to SQL or just brushing up, this series is designed to make learning simple and engaging. 🎥 Watch Now: https://lnkd.in/g5u7cS-f 👩‍💻 Check out this short video where we walk you through the process step by step 💡 Learn how to: ✅ Insert records efficiently ✅ Understand column and value pairing ✅ Avoid common mistakes when adding data 🔗 Follow our YouTube series for detailed tutorials and practical demos. Perfect for beginners and anyone brushing up their database management skills. Subscribe now to stay updated with more SQL tips and tricks! #SQL #DatabaseManagement #Data #LearningWithInternForage #InternForage #SQLTips #CareerGrowth

8

𝐇𝐚𝐯𝐞 𝐲𝐨𝐮 𝐞𝐯𝐞𝐫 𝐛𝐞𝐞𝐧 𝐢𝐧 𝐭𝐡𝐞 𝐬𝐚𝐦𝐞 𝐛𝐨𝐚𝐭? You took courses, attended workshops, talked to experts, but still get nervous about an upcoming SQL coding test? If this sounds like you, keep reading. Success stories are inspiring, but relying on others' methods won't get you far. Tutorials alone won't make you an SQL expert. True success comes from consistent practice and developing your own approach. To bridge this gap, Data Sense is launching the 𝐒𝐮𝐩𝐞𝐫 𝟑𝟎 𝐒𝐐𝐋 𝐁𝐚𝐭𝐜𝐡 from 𝐉𝐮𝐧𝐞 𝟏 𝐭𝐨 𝐉𝐮𝐧𝐞 𝟑𝟎—𝐜𝐨𝐦𝐩𝐥𝐞𝐭𝐞𝐥𝐲 𝐟𝐫𝐞𝐞! 𝐖𝐡𝐚𝐭'𝐬 𝐢𝐧 𝐢𝐭 𝐟𝐨𝐫 𝐲𝐨𝐮? 1. Commit 60 minutes daily for 30 days. 𝟐. 𝐒𝐨𝐥𝐯𝐞 𝟐 𝐒𝐐𝐋 𝐪𝐮𝐞𝐬𝐭𝐢𝐨𝐧𝐬 𝐞𝐚𝐜𝐡 𝐝𝐚𝐲 and post your logic and solutions without using Google or ChatGPT. 𝟑. 𝐂𝐨𝐧𝐬𝐢𝐬𝐭𝐞𝐧𝐜𝐲 𝐢𝐬 𝐤𝐞𝐲:Inactive participants will be removed. 𝟒. 𝐒𝐭𝐚𝐲 𝐚𝐜𝐭𝐢𝐯𝐞:Only those who solve and post answers daily will remain. 𝟓. 𝐖𝐞𝐞𝐤𝐥𝐲 𝐒𝐐𝐋 𝐭𝐞𝐬𝐭𝐬(10 questions every weekend) with a final test at the end—targeting 100-120 questions in 30 days. 𝟔. 𝐉𝐨𝐛-𝐫𝐞𝐚𝐝𝐲 𝐚𝐬𝐬𝐮𝐫𝐚𝐧𝐜𝐞: Complete this challenge, and you’ll be prepared for any SQL interview. 𝐈𝐧𝐯𝐞𝐬𝐭𝐦𝐞𝐧𝐭: 60 minutes per day Ready to commit and transform your SQL skills in just 30 days? 𝐉𝐨𝐢𝐧 𝐭𝐡𝐞 𝐒𝐐𝐋 𝐒𝐮𝐩𝐞𝐫 𝟑𝟎 𝐁𝐚𝐭𝐜𝐡 𝐛𝐲 𝐜𝐥𝐢𝐜𝐤𝐢𝐧𝐠 𝐭𝐡𝐞 𝐥𝐢𝐧𝐤 𝐛𝐞𝐥𝐨𝐰 and watch your career and confidence soar! SQL Super 30 Batch- https://lnkd.in/gyz-CvQP #SQL #DataSense #Super30SQL #DataScience #DataAnalysis #SQLTraining #CareerGrowth #JobReady #SQLInterview #TechSkills #ContinuousLearning #PracticeMakesPerfect #JoinNow

17

2 commentaires

Feeling stuck in a loop? 🔄 . . . Our Python while loop tutorial can help! 💡 Learn how to use this powerful tool to automate tasks and create dynamic programs. 🔗 Watch Now: https://buff.ly/3zOiui9 #python #programming #whileloop #learnpython #coding #tutorial #pythonprogramming #pythontips #pythoncode #pythondeveloper

2