- Видео 91
- Просмотров 65 104
Algometica
Добавлен 1 авг 2016
I create coding videos so that you can crack any Data Engineering and Coding interview in the world.
Caller History - Amazon Interview Question - SQL
Given a phone log table that has information about callers' call history, find out the callers whose first and last calls were to the same person on a given day. Output the caller ID, recipient ID, and the date called.
Companies appeared in: Amazon, Etsy
Difficulty: Medium
Ideas: SQL Window Functions (ROW_NUMBER), Common Table Expressions (CTE)
Problem: t.ly/1aVUO
Companies appeared in: Amazon, Etsy
Difficulty: Medium
Ideas: SQL Window Functions (ROW_NUMBER), Common Table Expressions (CTE)
Problem: t.ly/1aVUO
Просмотров: 50
Видео
Duplicate Training Lessons - Amazon Interview Question - SQL
Просмотров 59День назад
Display a list of users who took the same training lessons more than once on the same day. Output their usernames, training IDs, dates and the number of times they took the same lesson. Companies appeared in: Amazon Difficulty: Medium Ideas: SQL JOINS (INNER JOIN), GROUP BY, HAVING Problem: t.ly/I71IY
Book Sales - Amazon Interview Question - SQL
Просмотров 63День назад
Calculate the total revenue made per book. Output the book ID and total sales per book. In case there is a book that has never been sold, include it in your output with a value of 0. Companies appeared in: Amazon Difficulty: Medium Ideas: SQL JOINS (LEFT JOIN) Problem: t.ly/2bt3c
Salary Less Than Twice The Average - Amazon Interview Question - SQL
Просмотров 602 дня назад
Write a query to get the list of managers whose salary is less than twice the average salary of employees reporting to them. For these managers, output their ID, salary and the average salary of employees reporting to them. Companies appeared in: Amazon, Walmart, BestBuy Difficulty: Medium Ideas: Window Function (AVG), Common Table Expresions Problem: t.ly/gSS34
Responsible for Most Customers - Amazon Interview Question - SQL
Просмотров 8914 дней назад
Each Employee is assigned one territory and is responsible for the Customers from this territory. There may be multiple employees assigned to the same territory. Write a query to get the Employees who are responsible for the maximum number of Customers. Output the Employee ID and the number of Customers. Companies appeared in: Amazon, Asana, WorkDay Difficulty: Medium Ideas: GROUP BY, Window Fu...
At least 3 purchases - Amazon Interview Question - SQL
Просмотров 5914 дней назад
List the IDs of customers who made at least 3 orders in both 2020 and 2021. Companies appeared in: Amazon Difficulty: Medium Ideas: GROUP BY, Intersect 00:00 - First Approach 05:39 - Second Approach
Manager of the Largest Department - Amazon Interview Question - SQL
Просмотров 6114 дней назад
Given a list of a company's employees, find the name of the manager from the largest department. Manager is each employee that contains word "manager" under their position. Output their first and last name. Companies appeared in: Amazon, Ebay, Shopify Difficulty: Medium Ideas: GROUP BY, Window Function
FastAPI Complete Course - CRUD App - Adding Validations using Pydantic Field #fastapi
Просмотров 243Год назад
The same way you can declare additional validation and metadata in path operation function parameters with Query, Path and Body, you can declare validation and metadata inside of Pydantic models using Pydantic's Field. fastapi.tiangolo.com/tutorial/body-fields/
FastAPI Complete Course - CRUD App - POST using Request Body #fastapi
Просмотров 189Год назад
When you need to send data from a client (let's say, a browser) to your API, you send it as a request body. A request body is data sent by the client to your API. A response body is the data your API sends to the client. Your API almost always has to send a response body. But clients don't necessarily need to send request bodies all the time. To declare a request body, you use Pydantic models w...
FastAPI Complete Course - CRUD App - BaseModel Class #fastapi
Просмотров 185Год назад
The primary means of defining objects in pydantic is via models (models are simply classes which inherit from BaseModel). You can think of models as similar to types in strictly typed languages, or as the requirements of a single endpoint in an API. Untrusted data can be passed to a model, and after parsing and validation pydantic guarantees that the fields of the resultant model instance will ...
FastAPI Complete Course - CRUD App - overview and project setup #fastapi
Просмотров 219Год назад
In this lecture, we will create our enhanced CRUD application which will be a huge upgrade on our books project we looked at in our previous section. Watch the video to get the details. 00:49 - Intro to our project. 03:18 - What we will be creating 03:19 - Project Setup
FastAPI Complete Course - Project-1 Deleting an item using DELETE and finishing our CRUD project.
Просмотров 191Год назад
The HTTP DELETE request method deletes the specified resource.
FastAPI Complete Course - Project-1 Updating an item using PUT
Просмотров 137Год назад
The HTTP PUT method is used to update an existing resource on the server, while the POST method creates or adds a resource on the server. The HTTP PUT method is defined as idempotent, which means that multiple identical PUT requests should have the same effect as a single request.
FastAPI Complete Course - Project-1 Creating an item using POST #fastapi
Просмотров 170Год назад
When you need to send data from a client (let's say, a browser) to your API, you send it as a request body. A request body is data sent by the client to your API. A response body is the data your API sends to the client. In this lecture though, we will be looking at POST request using Query parameters instead of request body which we will look in future sections.
FastAPI Complete Course - Project-1 Query Parameters #fastapi
Просмотров 175Год назад
00:00 - What is a Query? 00:50 - Query Parameter with a default value 05:29 - Optional Query Parameter When you declare other function parameters that are not part of the path parameters, they are automatically interpreted as "query" parameters. The query is the set of key-value pairs that go after the ? in a URL, separated by & characters. For example, in the URL: 127.0.0.1:8000/items/?skip=0&...
FastAPI Complete Course - Project-1 Enhancing Our Project #fastapi
Просмотров 188Год назад
FastAPI Complete Course - Project-1 Enhancing Our Project #fastapi
FastAPI Complete Course - Project-1 Predefined Path Parameters using ENUM #fastapi
Просмотров 348Год назад
FastAPI Complete Course - Project-1 Predefined Path Parameters using ENUM #fastapi
FastAPI Complete Course - Project-1 Path Parameters #fastapi
Просмотров 227Год назад
FastAPI Complete Course - Project-1 Path Parameters #fastapi
FastAPI Complete Course - Project-1 GET request #fastapi
Просмотров 244Год назад
FastAPI Complete Course - Project-1 GET request #fastapi
FastAPI Complete Course - Project-1 Overview #fastapi
Просмотров 234Год назад
FastAPI Complete Course - Project-1 Overview #fastapi
FastAPI Complete Course - HTTP Request Methods & Status Codes #fastapi
Просмотров 342Год назад
FastAPI Complete Course - HTTP Request Methods & Status Codes #fastapi
FastAPI Complete Course - Interactive API docs | Swagger VS OpenAPI #fastapi
Просмотров 484Год назад
FastAPI Complete Course - Interactive API docs | Swagger VS OpenAPI #fastapi
FastAPI Complete Course - Creating our first API #fastapi
Просмотров 562Год назад
FastAPI Complete Course - Creating our first API #fastapi
FastAPI Complete Course - Installing FastAPI in virtualenv #fastapi
Просмотров 716Год назад
FastAPI Complete Course - Installing FastAPI in virtualenv #fastapi
FastAPI Complete Course - What is Virtualenv? #fastapi
Просмотров 509Год назад
FastAPI Complete Course - What is Virtualenv? #fastapi
FastAPI Complete Course - Overview #fastapi #python
Просмотров 1,6 тыс.Год назад
FastAPI Complete Course - Overview #fastapi #python
Learn Data Engineering | Dataquest VS Datacamp
Просмотров 2,6 тыс.2 года назад
Learn Data Engineering | Dataquest VS Datacamp
NumPy - #13 - Array Concatenation of Mixed Dimensions
Просмотров 4512 года назад
NumPy - #13 - Array Concatenation of Mixed Dimensions
This video is very helpful and informative for any enterprise 👍
The best use of data science. Its a big tool to analyse professional activities of any enterprise.
Thank you. Stay tuned for more content
Explained in such a easier manner that a computer language illiterate person can easily understand ❤
This video is very helpful in identifying the number of times training sessions done by one user in same day . Seems like making the job of employer a easier one 🙏👍
Very good information about the revenue generated by selling of books on Amazon platform. Nicely explained 👍
Thank you for always supporting
Nice explanation how much one will get 🙏
So nice of you
Good job, useful for job seekers
Thanks a lot
Awesome video, really a great help for getting into a job
Nicely explained and guided for the people who wish to face the interview
Very nice and helpful for aspirants 👍👌
Thanks for the course. Just a small suggestion, Please zoom in a little while recording It might be difficult for the people to read who do not watch in full screen or code along in split screen..
Ok next time :)
Good job👏
It's very important that you must hit the enter key with full force otherwise it may not work for you
Yes those are specifically for you
good job, but the instructor says somewhere after 0:16 that the same things apply for Windows systems as well, but they don't. For bash, use: <virtual_environment_name>\Scripts\activate For Windows PowerShell, point to the working directory and then execute: .\<virtual_environment_name>\Scripts\Activate For Windows, in case of “running files disabled issue”, run below command, and then try above ones: Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass Thanks and good luck !!
I'm the 1000 viewer🥰 i want to say something that please talk in Hindi sometime please we know you are educated but please 💞
For sure, what would you like to hear?
Question, let’s say you Union the same query (that all have the same select) but you want to label one query as a specific name and same with the other to distinguish it. How would you do that?
May be you can look into using CTE (Common table expression)
Excellent tutorial. Explained the basic concepts very nicely
The speaker seems so cautious and nice ☺️ Thank you for the video. I didn't know about dataquest and now I'm going to try it
Appreciate it. I am going to make an updated video on this for 2023
Nicely expressed
Thank you
Hello! Thank you for this video. Could you do a review on the Data science program offered by 365DataScience?
Thanks for your offer to help the up coming D.E. we are in deed grateful
Thank you!!
Good tutorial. Very helpful, thank you 👌👍
👌👌
Great video 👍👍 Very easily understandable, looking forward for your next video 👌
Great video, very useful and helpful. Continue with your job of making this type of good videos 👌
thank you mummy
Very nicely explained. Good job
👌👍
Look forward to your course! Thanks
Awesome, thank you!
Hey can you tell the difference between attributes and methods
hey there, so - A variable stored in an instance OR class is called an attribute. A function stored in an instance OR class is called a method.
Thanks alot sir 🙏
Can you make a calculation out of expanded_price to only show prices that are 34.90 and above?
Another question, do feel like we will be ready to apply for jobs after finishing DataQuest (assuming one actually absorbs the material rather than speeding through just to finish).
Good question! I think so you will be able to get a junior level data-science position for sure.
2:57 how can I access 1,3,4?
Very clear. Good video. Thank you
Glad you liked it
Awesome video man, going through DataQuest now and really really enjoying it. You totally deserve more subs with this amazing content, going through your videos now and they are very helpful
What about the IBM Data Engineer Professional Certification?
I am not sure, as I haven’t enrolled in that one. Is it the one on Coursera?
THANK YOU
can we calculate total price for one order_num ?
Liked and subscribed 👍
Appreciate the love
Your 98th Subscriber :)
appreciate the love! :)
Surprisingly no comments on such a good informative videos. ✨
thanks buddy
Awesome explanation 👌
Good work done
2. Select product_nams from product where products_price = 9.49
1. Select product_nams from product where vent_id = BRSO1
Explained nicely, easy to understand
Good work bro
appreciate it, thanks for watching! :)
Nice explanation. 👍
Thank you for watching
Very clear tutorial, thanks! How would you perform a calculation on the Alias column? For example totalling the column, as normal sum does not appear to work on an alias column.
I also have this question