Algometica
Algometica
  • Видео 91
  • Просмотров 65 104
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
Просмотров: 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 - #14 - Array Splitting
Просмотров 2852 года назад
NumPy - #14 - Array Splitting
NumPy - #13 - Array Concatenation of Mixed Dimensions
Просмотров 4512 года назад
NumPy - #13 - Array Concatenation of Mixed Dimensions
NumPy - #12 - Array Concatenation
Просмотров 3133 года назад
NumPy - #12 - Array Concatenation

Комментарии

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 3 дня назад

    This video is very helpful and informative for any enterprise 👍

  • @krishnayadav-yj6ph
    @krishnayadav-yj6ph 5 дней назад

    The best use of data science. Its a big tool to analyse professional activities of any enterprise.

    • @algometica8564
      @algometica8564 5 дней назад

      Thank you. Stay tuned for more content

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 10 дней назад

    Explained in such a easier manner that a computer language illiterate person can easily understand ❤

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 10 дней назад

    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 🙏👍

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 10 дней назад

    Very good information about the revenue generated by selling of books on Amazon platform. Nicely explained 👍

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 13 дней назад

    Nice explanation how much one will get 🙏

  • @krishnayadav-yj6ph
    @krishnayadav-yj6ph 13 дней назад

    Good job, useful for job seekers

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 14 дней назад

    Awesome video, really a great help for getting into a job

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 14 дней назад

    Nicely explained and guided for the people who wish to face the interview

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 14 дней назад

    Very nice and helpful for aspirants 👍👌

  • @abhishekmaheshwari1638
    @abhishekmaheshwari1638 4 месяца назад

    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..

  • @larrykorli8730
    @larrykorli8730 5 месяцев назад

    Good job👏

  • @cs-yk9qh
    @cs-yk9qh 6 месяцев назад

    It's very important that you must hit the enter key with full force otherwise it may not work for you

  • @jitendrakumarnayak8857
    @jitendrakumarnayak8857 7 месяцев назад

    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 !!

  • @Nishant_1984
    @Nishant_1984 Год назад

    I'm the 1000 viewer🥰 i want to say something that please talk in Hindi sometime please we know you are educated but please 💞

  • @ishmaelgamer8198
    @ishmaelgamer8198 Год назад

    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?

    • @algometica8564
      @algometica8564 Год назад

      May be you can look into using CTE (Common table expression)

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei Год назад

    Excellent tutorial. Explained the basic concepts very nicely

  • @user-gc5ih9fm5y
    @user-gc5ih9fm5y Год назад

    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

    • @algometica8564
      @algometica8564 Год назад

      Appreciate it. I am going to make an updated video on this for 2023

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei Год назад

    Nicely expressed

  • @vesahlberg
    @vesahlberg Год назад

    Thank you

  • @aliciacantaro
    @aliciacantaro Год назад

    Hello! Thank you for this video. Could you do a review on the Data science program offered by 365DataScience?

  • @israelkolly8565
    @israelkolly8565 Год назад

    Thanks for your offer to help the up coming D.E. we are in deed grateful

  • @modyemam2466
    @modyemam2466 Год назад

    Thank you!!

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei Год назад

    Good tutorial. Very helpful, thank you 👌👍

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei Год назад

    👌👌

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei Год назад

    Great video 👍👍 Very easily understandable, looking forward for your next video 👌

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei Год назад

    Great video, very useful and helpful. Continue with your job of making this type of good videos 👌

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei Год назад

    Very nicely explained. Good job

  • @philipwong8388
    @philipwong8388 Год назад

    Look forward to your course! Thanks

  • @nivviyer_
    @nivviyer_ Год назад

    Hey can you tell the difference between attributes and methods

    • @algometica8564
      @algometica8564 Год назад

      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.

  • @gajendrasinghkushwah4574
    @gajendrasinghkushwah4574 Год назад

    Thanks alot sir 🙏

  • @saineyjammeh8194
    @saineyjammeh8194 Год назад

    Can you make a calculation out of expanded_price to only show prices that are 34.90 and above?

  • @ItsPureLuck27
    @ItsPureLuck27 2 года назад

    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).

    • @algometica8564
      @algometica8564 Год назад

      Good question! I think so you will be able to get a junior level data-science position for sure.

  • @Kig_Ama
    @Kig_Ama 2 года назад

    2:57 how can I access 1,3,4?

  • @anurasenarathna1703
    @anurasenarathna1703 2 года назад

    Very clear. Good video. Thank you

  • @ItsPureLuck27
    @ItsPureLuck27 2 года назад

    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

  • @priscillaoduro4865
    @priscillaoduro4865 2 года назад

    What about the IBM Data Engineer Professional Certification?

    • @algometica8564
      @algometica8564 2 года назад

      I am not sure, as I haven’t enrolled in that one. Is it the one on Coursera?

  • @partabparmar5537
    @partabparmar5537 2 года назад

    THANK YOU

  • @leery_swan
    @leery_swan 2 года назад

    can we calculate total price for one order_num ?

  • @shanmukhv1006
    @shanmukhv1006 2 года назад

    Liked and subscribed 👍

  • @patrickbateman7665
    @patrickbateman7665 2 года назад

    Your 98th Subscriber :)

  • @MrinalDasListenToMe
    @MrinalDasListenToMe 2 года назад

    Surprisingly no comments on such a good informative videos. ✨

  • @armaanjotsandhu5337
    @armaanjotsandhu5337 2 года назад

    Awesome explanation 👌

  • @krishnayadav-yj6ph
    @krishnayadav-yj6ph 2 года назад

    Good work done

  • @davidrajajames6898
    @davidrajajames6898 2 года назад

    2. Select product_nams from product where products_price = 9.49

  • @davidrajajames6898
    @davidrajajames6898 2 года назад

    1. Select product_nams from product where vent_id = BRSO1

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei 3 года назад

    Explained nicely, easy to understand

  • @rambaijamra5939
    @rambaijamra5939 3 года назад

    Good work bro

    • @algometica8564
      @algometica8564 3 года назад

      appreciate it, thanks for watching! :)

  • @renutripathi9531
    @renutripathi9531 3 года назад

    Nice explanation. 👍

  • @photoinshot1355
    @photoinshot1355 3 года назад

    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.

    • @pandraus
      @pandraus Год назад

      I also have this question