โ๐๐๐๐๐๐๐ค๐ ๐จโ๐ป เธฃเธตเธเธงเธตเธเนเธฅเนเธง
โ๐๐๐๐๐๐๐ค๐ ๐จโ๐ป
189 posts

โ๐๐๐๐๐๐๐ค๐ ๐จโ๐ป
@technikhilesh
Discover the magic of AI and tech wonders! ๐คโจ Simplifying the future with easy-to-understand updates and cool tech stuff. ๐๐ป #AITechMagic
เนเธเนเธฒเธฃเนเธงเธก Ekim 2014
49 เธเธณเธฅเธฑเธเธเธดเธเธเธฒเธก17 เธเธนเนเธเธดเธเธเธฒเธก
โ๐๐๐๐๐๐๐ค๐ ๐จโ๐ป เธฃเธตเธเธงเธตเธเนเธฅเนเธง

๐ฆ๐ค๐ ๐ค๐๐ฒ๐ฟ๐ถ๐ฒ๐ ๐๐
๐ฒ๐ฐ๐๐๐ถ๐ผ๐ป ๐ข๐ฟ๐ฑ๐ฒ๐ฟ
We utilize SQL queries to access a collection of records stored in our database tables. Clauses are the building blocks of SQL queries. These clauses must be executed to get the proper outcomes. SQL query execution order is the name given to this sequence of operations.
๐ฆ๐ค๐ ๐พ๐๐ฒ๐ฟ๐ ๐ฒ๐
๐ฒ๐ฐ๐๐๐ถ๐ผ๐ป ๐ผ๐ฟ๐ฑ๐ฒ๐ฟ refers to how the requirements evaluate the query clauses or how to optimize database search results. We use clauses in a specific order known as the SQL query execution order, similar to how we plan something step by step and arrive at the result.
Here is the order in which the SQL clauses are executed:
๐ญ. ๐๐ฅ๐ข๐ - tables are joined to get the base data.
๐ฎ. ๐ช๐๐๐ฅ๐ - the base data is filtered.
๐ฏ. ๐๐ฅ๐ข๐จ๐ฃ ๐๐ฌ - the filtered base data is grouped.
๐ฐ. ๐๐๐ฉ๐๐ก๐ - the grouped base data is filtered.
๐ฑ. ๐ฆ๐๐๐๐๐ง - the final data is returned.
๐ฒ. ๐ข๐ฅ๐๐๐ฅ ๐๐ฌ - the final data is sorted.
๐ณ. ๐๐๐ ๐๐ง - the returned data is limited to row count.
#sql

English
โ๐๐๐๐๐๐๐ค๐ ๐จโ๐ป เธฃเธตเธเธงเธตเธเนเธฅเนเธง

How to use Big O to ace your technical interviews:
Firstly, what is Big O Notation?
Big O describes an algorithm's runtime or memory consumption without the interference of contextual variables like RAM and CPU. It gives programmers a way to compare algorithms and identify the most efficient solution.
๐๐ถ๐ด ๐ข ๐ฎ๐ป๐๐๐ฒ๐ฟ๐ ๐ผ๐ป๐ฒ ๐๐๐ฟ๐ฎ๐ถ๐ด๐ต๐๐ณ๐ผ๐ฟ๐๐ฎ๐ฟ๐ฑ ๐พ๐๐ฒ๐๐๐ถ๐ผ๐ป:
"How much does runtime or memory consumption grow as the size of the input increases, in the worst-case scenario?".
๐ง๐ผ ๐๐๐ถ๐น๐ถ๐๐ฒ ๐๐ถ๐ด ๐ข, you'll need to know the possible values and how they compare with each other. Use the attached photo for a quick reference.
๐ฆ๐ผ, ๐ต๐ผ๐ ๐ฑ๐ผ ๐๐ผ๐ ๐ฎ๐ฝ๐ฝ๐น๐ ๐๐ถ๐ด ๐ข ๐ถ๐ป ๐๐ผ๐๐ฟ ๐๐ฒ๐ฐ๐ต๐ป๐ถ๐ฐ๐ฎ๐น ๐ถ๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐?
Here are a few scenarios where Big O can be used:
๐ธ Live coding challenges
๐ธ Code walk-throughs
๐ธ Discussions about projects/solutions you've built
๐ธ Discussions about your approach to programming & problem-solving
When any of these scenarios come up, be sure to mention the Big O of your solution and how it compares to alternative approaches. This is especially useful in live coding challenges where you have to compare solutions on the spot โ remember to think out loud!
๐ง๐ถ๐ฝ: ๐ช๐ต๐ฒ๐ป ๐ฐ๐ผ๐บ๐ฝ๐ฎ๐ฟ๐ถ๐ป๐ด ๐๐ผ๐น๐๐๐ถ๐ผ๐ป๐, ๐ฝ๐ฎ๐ ๐ฎ๐๐๐ฒ๐ป๐๐ถ๐ผ๐ป ๐๐ผ ๐๐ต๐ฒ ๐ฝ๐ฟ๐ผ๐ฏ๐น๐ฒ๐บ'๐ ๐ฟ๐ฒ๐พ๐๐ถ๐ฟ๐ฒ๐บ๐ฒ๐ป๐๐.
For example, linear time complexity may be completely fine when the input can never be too large. But if youโre dealing with big data, youโll want to opt for something more efficient.
Of course, the goal is to get the correct Big O notation that applies to your solution. But don't worry about getting it wrong! Your interviewer will probably correct you when you do. The point is to show that you are thinking about the efficiency and performance of your solution.
๐๐ผ ๐๐ต๐ถ๐ ๐ฎ๐ป๐ฑ ๐๐ผ๐'๐น๐น ๐ฏ๐ฒ ๐ฎ๐ฏ๐น๐ฒ ๐๐ผ ๐๐ต๐ผ๐๐ฐ๐ฎ๐๐ฒ ๐ฎ๐ป ๐ถ๐บ๐ฝ๐ผ๐ฟ๐๐ฎ๐ป๐ ๐๐ฟ๐ฎ๐ถ๐ ๐๐ต๐ฎ๐ ๐๐ฒ๐ฐ๐ต๐ป๐ถ๐ฐ๐ฎ๐น ๐ต๐ถ๐ฟ๐ถ๐ป๐ด ๐บ๐ฎ๐ป๐ฎ๐ด๐ฒ๐ฟ๐ ๐น๐ผ๐ผ๐ธ ๐ณ๐ผ๐ฟ:
The ability to consider a solution's viability beyond whether it works or not. This shows maturity in your decision-making and approach to programming.

English
โ๐๐๐๐๐๐๐ค๐ ๐จโ๐ป เธฃเธตเธเธงเธตเธเนเธฅเนเธง
โ๐๐๐๐๐๐๐ค๐ ๐จโ๐ป เธฃเธตเธเธงเธตเธเนเธฅเนเธง

9 AI tools you don't want to miss in 2024 ๐ฅ๐ฅ
Code: @tabnine
Images: @midjourney
Video: @runwayml
Design: @DesignsdotAI
Writing: @rytr_me
Speech: @DeepgramAI
Marketing: @copysmith_ai
Sales: @lavenderhq
Support: @CohereAI
English

Hey @Apple, not thrilled with my iPhone 14 Pro Max โ battery drains like it's on a race and heating up faster than a microwave. Seriously, not expected this from apple, this will be the first and last apple product for me. ๐ค๐ฅ #iPhoneProblems #NotHappy #Apple
English

๐ Hyperparameter Tuning ๐
Algorithms have settings called hyperparameters that affect performance. Tuning them optimizes the model. Think of it as adjusting knobs for better sound on a stereo. ๐๏ธ๐ถ #HyperparameterTuning
English

๐ Cross-Validation ๐
To ensure our modelโs reliability, we use techniques like cross-validation. This divides data into multiple sets for training and testing, reducing the risk of overfitting. Itโs like having multiple quizzes! ๐๐งช #CrossValidation
English

๐ค๐ #MachineLearning Series ๐๐ค
Welcome aboard! This series is your ticket to understanding machine learning with real examples and hands-on coding. Letโs begin our journey! ๐
English



