Crack Concepts
Crack Concepts
  • 181
  • 12 424 338
Introduction to Python Jupyter Notebooks- ALL IN ONE with many examples
Introduction to Python Jupyter Notebooks- ALL IN ONE with many examples
✨Link to purchase my e-book: imojo.in/rkajq9
This e-book will prove to be one of the best decisions of your life!
✨Join this channel to get access to perks:
czcams.com/channels/43CDA3m7Nwfdj8B9SAZQ4A.htmljoin
✨Work related mails can be sent on work.sadiasiddiqui@gmail.com
✨If you appreciate my work and would like to donate to support our channel, you can do so here : paypal.me/sadia1702
✨Please like, share, subscribe and comment down. It would make my day :)
Thank you, have a nice day!
zhlédnutí: 255

Video

3- Solving Tricky Sql Query - Advance Case and Aggregate Statements #sqlforbeginners
zhlédnutí 556Před dnem
3- Solving Tricky Sql Query - Advance Case and Aggregate Statements #sqlforbeginners
2- How to solve Complex SQL Queries- step by step- LEETCODE MEDIUM SQL
zhlédnutí 541Před 14 dny
Hi, In this video we've solved a SQL leetcode. write a sql query to find employees that earn more than their managers. This is a great example to practice self joins. #sqlforbeginners #sqltips #sqlqueries ✨Link to purchase my e-book: imojo.in/rkajq9 This e-book will prove to be one of the best decisions of your life! ✨Join this channel to get access to perks: czcams.com/channels/43CDA3m7Nwfdj8B...
1- Solving Tricky SQL Leetcode Queries (Medium) | Practice Tricky SQL Interview Queries
zhlédnutí 561Před 14 dny
Hi, In this video we're solving tricky sql queries from Leetcode of medium category ✨Link to purchase my e-book: crackconcepts.myinstamojo.com/ This e-book will prove to be one of the best decisions of your life! ✨Join this channel to get access to perks: czcams.com/channels/43CDA3m7Nwfdj8B9SAZQ4A.htmljoin ✨Work related mails can be sent on work.sadiasiddiqui@gmail.com ✨If you appreciate my wor...
BEST FREE SQL Resources for Beginners | Complete SQL Roadmap for beginners
zhlédnutí 556Před 21 dnem
Hi, In this video we've discussed BEST FREE SQL Resources for Beginners | Complete SQL Roadmap for beginners #sqlforbeginners #sqltips #sqlinterviewquestions ✨Link to purchase my e-book: imojo.in/rkajq9 This e-book will prove to be one of the best decisions of your life! ✨Join this channel to get access to perks: czcams.com/channels/43CDA3m7Nwfdj8B9SAZQ4A.htmljoin ✨Work related mails can be sen...
8 mistakes you are making in SQL as a beginner #sqlforbeginners #sqltips
zhlédnutí 731Před měsícem
Hi, In this video we've discussed 8 mistakes beginners usually make while learning SQL. ✨Link to purchase my e-book: imojo.in/rkajq9 This e-book will prove to be one of the best decisions of your life! ✨Join this channel to get access to perks: czcams.com/channels/43CDA3m7Nwfdj8B9SAZQ4A.htmljoin ✨Work related mails can be sent on work.sadiasiddiqui@gmail.com ✨If you appreciate my work and would...
#3 SQL Tricky Interview questions and answers- Intermediate #sqlforbeginners #sqlinterviewquestions
zhlédnutí 958Před měsícem
Hi, In this video we've solved a complex sql, i have shown step by step how you can divide a complex sql query into smaller parts and make it easier to solve. SQL Interview questions and answers. #sqlforbeginners #sqlinterviewquestions #sql Link to my e-books: ▪️SQL e-book: imojo.in/rkajq9 ▪️'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a complete...
COMPLEX SQL query 2 - Practice complex sql queries - SQL Interview questions and answers
zhlédnutí 903Před měsícem
Hi, In this video we've solved a complex sql, i have shown step by step how you can divide a complex sql query into smaller parts and make it easier to solve. SQL Interview questions and answers. #sqlforbeginners #sqlinterviewquestions #sql Link to my e-books: ▪️SQL e-book: imojo.in/rkajq9 ▪️'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a complete...
How to solve COMPLEX SQL Queries - step by step | SQL Interview queries / questions and answers
zhlédnutí 2KPřed měsícem
Hi, In this video we've solved a complex sql, i have shown step by step how you can divide a complex sql query into smaller parts and make it easier to solve. SQL Interview questions and answers. #sqlforbeginners #sqlinterviewquestions #sql Link to my e-books: ▪️SQL e-book: imojo.in/rkajq9 ▪️'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a complete...
5 SQL Queries in 5 Minutes - Practice SQL Queries for beginners | Master SQL
zhlédnutí 2,1KPřed 2 měsíci
Hi, In this video we've solved 5 sql queries in 5 minutes, watch this video and master SQL. #sqlforbeginners #sqlinterviewquestions #sqltraining ✨Link to purchase my e-book: imojo.in/rkajq9 This e-book will prove to be one of the best decisions of your life! ✨Join this channel to get access to perks: czcams.com/channels/43CDA3m7Nwfdj8B9SAZQ4A.htmljoin ✨Work related mails can be sent on work.sad...
All about Subqueries in SQL - Types of Subqueries
zhlédnutí 1,1KPřed 2 měsíci
Hi, In this video we've discussed All about Subqueries in SQL - Types of Subqueries ✨Link to purchase my e-book: imojo.in/rkajq9 This e-book will prove to be one of the best decisions of your life! ✨Join this channel to get access to perks: czcams.com/channels/43CDA3m7Nwfdj8B9SAZQ4A.htmljoin ✨Work related mails can be sent on work.sadiasiddiqui@gmail.com ✨If you appreciate my work and would lik...
Python DIFFERENCE BETWEEN Interview Questions - Important
zhlédnutí 430Před 3 měsíci
Hi, In this video we've discussed Python DIFFERENCE BETWEEN Interview Questions. ✨Link to purchase my e-book: imojo.in/rkajq9 This e-book will prove to be one of the best decisions of your life! ✨Join this channel to get access to perks: czcams.com/channels/43CDA3m7Nwfdj8B9SAZQ4A.htmljoin ✨Work related mails can be sent on work.sadiasiddiqui@gmail.com ✨If you appreciate my work and would like t...
Python for Beginners | Learn in 15 minutes | Python 101
zhlédnutí 1,4KPřed 3 měsíci
Python for Beginners | Learn in 15 minutes | Python 101
13 Questions related to NULLs in SQL - VERY IMPORTANT SQL INTERVIEW QUESTIONS FOR BEGINNERS
zhlédnutí 1,3KPřed 4 měsíci
13 Questions related to NULLs in SQL - VERY IMPORTANT SQL INTERVIEW QUESTIONS FOR BEGINNERS
5 IMP Topics to REVISE before a SQL Interview
zhlédnutí 2,1KPřed 4 měsíci
5 IMP Topics to REVISE before a SQL Interview
Difference between SQL and NOSQL Databases with REAL WORLD examples | When to use which
zhlédnutí 573Před 4 měsíci
Difference between SQL and NOSQL Databases with REAL WORLD examples | When to use which
CASE statement with AGGREGATE functions | v IMP SQL Interview Question
zhlédnutí 1,4KPřed 4 měsíci
CASE statement with AGGREGATE functions | v IMP SQL Interview Question
7 IMPORTANT concepts in TABLEAU explained under 8 minutes. Tableau Tutorial #tableau
zhlédnutí 496Před 5 měsíci
7 IMPORTANT concepts in TABLEAU explained under 8 minutes. Tableau Tutorial #tableau
Learn SQL in 10 minutes - ALL CONCEPTS | SQL For Beginners #sqlinterviewquestionsandanswers
zhlédnutí 2,8KPřed 5 měsíci
Learn SQL in 10 minutes - ALL CONCEPTS | SQL For Beginners #sqlinterviewquestionsandanswers
Waterfall Chart in Tableau in 3 minutes- How to, uses, many examples, etc. #tableau
zhlédnutí 778Před 6 měsíci
Waterfall Chart in Tableau in 3 minutes- How to, uses, many examples, etc. #tableau
How to convert COLUMNS TO ROWS in SQL without using Pivot table - #sqlinterviewquestionsandanswers
zhlédnutí 2,7KPřed 6 měsíci
How to convert COLUMNS TO ROWS in SQL without using Pivot table - #sqlinterviewquestionsandanswers
How to convert ROWS into COLUMNS in SQL without using Pivot table #sqlinterviewquestionsandanswers
zhlédnutí 3,3KPřed 6 měsíci
How to convert ROWS into COLUMNS in SQL without using Pivot table #sqlinterviewquestionsandanswers
Index Function in tableau | The Index () function in tableau | How to
zhlédnutí 453Před 6 měsíci
Index Function in tableau | The Index () function in tableau | How to
Difference between COALESCE and ISNULL? How are NULLs handled in SQL Server
zhlédnutí 3,7KPřed 7 měsíci
Difference between COALESCE and ISNULL? How are NULLs handled in SQL Server
How to solve complex SQL Queries in Interviews - BONUS VIDEO #sqlinterviewquestions
zhlédnutí 1,6KPřed 8 měsíci
How to solve complex SQL Queries in Interviews - BONUS VIDEO #sqlinterviewquestions
Query5 | Complex SQL Queries- CTE and Subqueries
zhlédnutí 1,5KPřed 8 měsíci
Query5 | Complex SQL Queries- CTE and Subqueries
Query 4: Imp MUST KNOW SQL Query for Interviews | Complex SQL Interview Question #sql
zhlédnutí 1,5KPřed 8 měsíci
Query 4: Imp MUST KNOW SQL Query for Interviews | Complex SQL Interview Question #sql
Query 3: Complex JOINS and SUBQUERIES | Solving TRICKY SQL Interview Queries #sqlinterviewquestions
zhlédnutí 2,3KPřed 9 měsíci
Query 3: Complex JOINS and SUBQUERIES | Solving TRICKY SQL Interview Queries #sqlinterviewquestions
Query 2: Solving TRICKY SQL Interview Queries | SQL Query Interview Questions #sqlinterviewquestions
zhlédnutí 2KPřed 9 měsíci
Query 2: Solving TRICKY SQL Interview Queries | SQL Query Interview Questions #sqlinterviewquestions
Day 1: Solving TRICKY SQL Interview Queries | SQL Query Interview Questions
zhlédnutí 5KPřed 9 měsíci
Day 1: Solving TRICKY SQL Interview Queries | SQL Query Interview Questions

Komentáře

  • @srabanibanerjee1148
    @srabanibanerjee1148 Před 15 hodinami

    I am facing an issue. 🤔 Suppose I just declared a DataFrame in a cell, and it is working perfectly. But suddenly, in the next cell when I am calling the same DataFrame, it gives me an error "not recognized". 🚫🚫

  • @MayaBhandari-ob5ho

    AM l the only one who felt the information is not fully describe

  • @AshishKumar-c4w2k
    @AshishKumar-c4w2k Před dnem

    I UNDERSTOOD 3NF. THANKYOU !

  • @PriyankaKumarHk
    @PriyankaKumarHk Před dnem

    Akka char bage heli

  • @ZidiZidi-bq9sg
    @ZidiZidi-bq9sg Před dnem

    I am full understand ❤

  • @ZidiZidi-bq9sg
    @ZidiZidi-bq9sg Před dnem

    Your are great ❤

  • @muruganMurugan-zr5ur

    I have exam in 15 min 😅😅😅😅 thank

  • @AishwaryaPatil-n2o
    @AishwaryaPatil-n2o Před 2 dny

    Very good explanation

  • @surajmane5481
    @surajmane5481 Před 2 dny

    You explained it in very simple and understandable way. I appreciate! Thank You..

  • @ManishBahubaliJain
    @ManishBahubaliJain Před 2 dny

    How to run a program, I am having a problem "kernel" again and again

  • @deepanshusingh9943
    @deepanshusingh9943 Před 3 dny

    In example 2, i think it should be " [A-Z][a-z]*[0-9][a-z]+ " as it is written that the digits should be in between of these

  • @th1nk3r32
    @th1nk3r32 Před 3 dny

    Nice note

  • @7smessi803
    @7smessi803 Před 3 dny

    Awesome simple explanation🎉

  • @Milan-mw7gz
    @Milan-mw7gz Před 3 dny

    you are best ❤

  • @bharathms5560
    @bharathms5560 Před 3 dny

    Learn anything in 2 easy steps: Step 1: Learn Basics Step 2: Practice

  • @kirubajemi5771
    @kirubajemi5771 Před 4 dny

    Thank you

  • @anupam5886
    @anupam5886 Před 4 dny

    good explanation tq!!!!

  • @Haha1234-z7f
    @Haha1234-z7f Před 5 dny

    Your IG ?

  • @user-cr9yw9yg5v
    @user-cr9yw9yg5v Před 6 dny

    Do a video on the difference between group by and partation by

  • @usharaninalla5786
    @usharaninalla5786 Před 7 dny

    best explaination i've seen , thank you and subscribed

  • @arindambanerjee515
    @arindambanerjee515 Před 7 dny

    Very well done, Thank you!

  • @gidiyup
    @gidiyup Před 7 dny

    Perfect!

  • @yaserarafath6581
    @yaserarafath6581 Před 7 dny

    Assalamu alaikum jumma mubarak madam pls send me your account number to pay amount for crack interview sql book. I don't have net banking account and mobilekiwi account

  • @yaserarafath6581
    @yaserarafath6581 Před 7 dny

    Assalamu alaikum jumma mubarak madam pls send me your account number to pay amount for crack interview sql book. I don't have net banking account and mobilekiwi account

  • @yaserarafath6581
    @yaserarafath6581 Před 7 dny

    Assalamu alaikum jumma mubarak madam pls send me your account number to pay amount for crack interview sql book. I don't have net banking account and mobilekiwi account

  • @yaserarafath6581
    @yaserarafath6581 Před 7 dny

    Assalamu alaikum jumma mubarak madam pls send me your account number to pay amount for crack interview sql book. I don't have net banking account and mobilekiwi account

  • @yaserarafath6581
    @yaserarafath6581 Před 7 dny

    Assalamu alaikum jumma mubarak madam pls send me your account number to pay amount for crack interview sql book. I don't have net banking account and mobilekiwi account

  • @yaserarafath6581
    @yaserarafath6581 Před 7 dny

    Assalamu alaikum jumma mubarak madam pls send me your account number to pay amount for crack interview sql book. I don't have net banking account and mobilekiwi account

  • @user-cr9yw9yg5v
    @user-cr9yw9yg5v Před 8 dny

    Please explain the difference between partition by and group by

  • @achyutkulkarni2047
    @achyutkulkarni2047 Před 8 dny

    nice explanation

  • @miss.ankats
    @miss.ankats Před 8 dny

    Thank you, it helped a lot!

  • @AdithyaP.Kashyap
    @AdithyaP.Kashyap Před 8 dny

  • @shirdilalmutyala166

    select * from employees where salary < (select max(salary) from employees) order by salary desc limit 1;

  • @gudguy1a
    @gudguy1a Před 10 dny

    Good job - I also 'preciate it - informative explanation.

  • @prathameshkavathekar6271

    Hey it was a nice explaination , but i do have a doubt in the query . What if we swap the conditions that we have used in 'ON' Clause ,i.e(e.id = m.manager_id ) And also in the where clause we use e.salary > m.salary . Will output be the same?

    • @crackconcepts
      @crackconcepts Před 10 dny

      Hey, yes. That would give a different output

  • @asrithagudla4865
    @asrithagudla4865 Před 10 dny

    Hi, the content was good. I would like you to explain each type with an example, so it will be more understandable.

  • @suhailsavo9291
    @suhailsavo9291 Před 11 dny

    Execution order of clauses--- 1.From 2.Where 3.Group By 4.Having 5.Order by 6.Select.

  • @jagadeeshrayapureddy8930

    ✅✅✅✅✅

  • @muhamadfaiyaz6523
    @muhamadfaiyaz6523 Před 12 dny

    Very simple 👌 thanks

  • @jsTsRust
    @jsTsRust Před 14 dny

    after all these ops what is the max value at the top?

  • @jsTsRust
    @jsTsRust Před 14 dny

    Mam can you tell us that is there need to find the Max value at the top or not which is 11 ?

  • @yaserarafath6581
    @yaserarafath6581 Před 14 dny

    Within specific scenario: we used complex scenario (i.e. combination of union, joins, left join, right join, sub query within specific scenario) in SQL screnaios

  • @yaserarafath6581
    @yaserarafath6581 Před 14 dny

    Multiple tables using right join and left join

  • @vaddimurthyram3364
    @vaddimurthyram3364 Před 14 dny

    Thanks for the valuable info.

  • @Betty___1056
    @Betty___1056 Před 14 dny

    Scientific insights: the significance of refund information

  • @durdonaholmurodova7723

    Hello can you help me with regex of phone numbers of different countries please. Anyone can you help

  • @maheshvadige2864
    @maheshvadige2864 Před 15 dny

    Same Filters are used Multiple worksheets. One option there Apply Worksheet. There U can apply entire whole related data base and all worksheets. If I wrong please explain Clearly