YT_AIGamer

  Description Learn intermediate SQL Server coding concepts. Commands taught: Outer Join (Left Outer Join / Right Outer Join / Full Outer Join), Inner Join, Cross Join, Aggregates (Count, Sum, Avg / Average), Windowed Functions (Row_Number OVER), Group By, Having, Partition By, SubQueries (Common Table Expression, CTE), Declare Variables, Filters (WHERE ON),  cast Transcript This is part two of my series on learning the SQL database language we'll be completing the practice exercises on the hackerearth.com website once you navigate to the site you can click on the search icon at the top and type SQL then you want to filter for problems or challenges and as you scroll through the challenges and click on each one you'll notice that they've already been completed so for example this particular challenge was done in 2016. that was for people that wanted to compete live even though it has ended we can still complete the problems we just won't be able to compete intition so i...

Description Learn basic SQL Server coding concepts. Commands taught: SELECT FROM WHERE. Transcript Today we're going to be practicing our SQL skills with the hacker rank website SQL stands for structured query language and it's used for getting data out of a database when you first go to the hackerrank.com website hackerrank.com you'll notice that it has a section for candidates the rest of it is for companies because companies use this for hiring people we're just going to use the candidate section so first you'll want to create an account or log in and it's totally free so don't worry about that okay I'm logged in and you can see I have a list of topics I can practice today we're just going to be doing SQL but if you're interested in other programming Technologies you can practice those here as well once I click on SQL I have a list of challenges the first ones on the list just say easy if I scroll down eventually I'll get to medium and har...