- 181
- 12 424 338
Crack Concepts
Registrace 6. 11. 2018
Hi, this is Sadia and I post videos on Computer Science related concepts.
The videos will help you in interviews as well as in clearing your theory papers. If this channel helped you even a bit, please consider subscribing to the channel.
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 completely new field or to a different company in the Tech World)
If you need personal help in SQL/ Mock interviews, You can contact us on work.sadiasiddiqui@gmail.com, Please note it will be paid.
Thank you :)
✨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
✨Follow us on Linkedin: www.linkedin.com/company/crack-concepts/
The videos will help you in interviews as well as in clearing your theory papers. If this channel helped you even a bit, please consider subscribing to the channel.
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 completely new field or to a different company in the Tech World)
If you need personal help in SQL/ Mock interviews, You can contact us on work.sadiasiddiqui@gmail.com, Please note it will be paid.
Thank you :)
✨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
✨Follow us on Linkedin: www.linkedin.com/company/crack-concepts/
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!
✨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
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". 🚫🚫
AM l the only one who felt the information is not fully describe
Yes. You’re the only one
I UNDERSTOOD 3NF. THANKYOU !
Akka char bage heli
I am full understand ❤
Your are great ❤
I have exam in 15 min 😅😅😅😅 thank
Very good explanation
You explained it in very simple and understandable way. I appreciate! Thank You..
How to run a program, I am having a problem "kernel" again and again
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
Nice note
Awesome simple explanation🎉
you are best ❤
Learn anything in 2 easy steps: Step 1: Learn Basics Step 2: Practice
Thank you
good explanation tq!!!!
Your IG ?
Do a video on the difference between group by and partation by
best explaination i've seen , thank you and subscribed
Very well done, Thank you!
Perfect!
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
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
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
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
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
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
Please explain the difference between partition by and group by
nice explanation
Thank you, it helped a lot!
select * from employees where salary < (select max(salary) from employees) order by salary desc limit 1;
Good job - I also 'preciate it - informative explanation.
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?
Hey, yes. That would give a different output
Hi, the content was good. I would like you to explain each type with an example, so it will be more understandable.
Noted
Execution order of clauses--- 1.From 2.Where 3.Group By 4.Having 5.Order by 6.Select.
✅✅✅✅✅
Very simple 👌 thanks
after all these ops what is the max value at the top?
Mam can you tell us that is there need to find the Max value at the top or not which is 11 ?
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
Multiple tables using right join and left join
Thanks for the valuable info.
Scientific insights: the significance of refund information
Hello can you help me with regex of phone numbers of different countries please. Anyone can you help
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