ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Amazon Interview Process
2
https://www.amazon.jobs/en/landing_pages/interviewing-at-amazon
3
https://charlesjli.com/2020/12/26/how-i-prepared-for-the-amazon-interview/
4
5
Coding preparation resources
6
Cracking the coding interviewhttps://www.amazon.ca/Cracking-Coding-Interview-Programming-Questions/dp/0984782850
7
Master the coding interviewhttps://www.udemy.com/course/master-the-coding-interview-data-structures-algorithms/
8
9
Coding questions
10
Leetcode (recommend medium difficulty)https://leetcode.com/problemset/all/?difficulty=Medium
11
12
Design patterns
13
File patternhttps://www.tutorialspoint.com/design_pattern/filter_pattern.htm
14
Command patternhttps://www.tutorialspoint.com/design_pattern/command_pattern.htm
15
16
System Design (recommend to start preparing early)
17
Grokking the system design interview (what to consider for different system design questions)https://www.educative.io/courses/grokking-the-system-design-interview
18
Helpful youtube channels for more indepth explanation on specific system designs
19
- System Design Interviewhttps://www.youtube.com/channel/UC9vLsnF6QPYuH51njmIooCQ
20
- Tech Dummies Narendra Lhttps://www.youtube.com/channel/UCn1XnDWhsLS5URXTi5wtFTA
21
- code Karlehttps://www.youtube.com/channel/UCZEfiXy7PmtVTezYUvc4zZw
22
23
SQL Concepts
24
CTEhttps://dev.mysql.com/doc/refman/8.0/en/with.html
25
Window functionshttps://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
26
- PARTITION BYhttps://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
27
- ROWS/RANGE BETWEEN/UNBOUNDED/1 PRECEDING/FOLLOWING/CURRENT_ROWhttps://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html
28
- ROW_NUMBER
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_row-number
29
- RANKhttps://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_rank
30
- DENSE_RANK
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_dense-rank
31
- LEADhttps://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_lead
32
- LAGhttps://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_lag
33
- FIRST_VALUE
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_first-value
34
- LAST_VALUE
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_last-value
35
- NTH_VALUE
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_nth-value
36
Flow controlhttps://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
37
- CASEhttps://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html#operator_case
38
- IFhttps://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html#function_if
39
- IFNULLhttps://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html#function_ifnull
40
- NULLIFhttps://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html#function_nullif
41
Unionhttps://dev.mysql.com/doc/refman/8.0/en/union.html
42
Limithttps://www.mysqltutorial.org/mysql-limit.aspx
43
User-defined variableshttps://dev.mysql.com/doc/refman/8.0/en/user-variables.html
44
Declarehttps://dev.mysql.com/doc/refman/8.0/en/declare-local-variable.html
45
Condition filteringhttps://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
46
47
SQL Questions
48
https://leetcode.com/problemset/database/
49
50
Data Topics (recommend to have a basic understanding)
51
Data warehousehttps://www.youtube.com/watch?v=AHR_7jFCMeY
52
Data marthttps://www.youtube.com/watch?v=l5UcUEt1IzM
53
Data lakehttps://www.datacamp.com/community/blog/data-lakes-vs-data-warehouses
54
Data warehouse vs data lake vs data mart
https://searchdatamanagement.techtarget.com/feature/Beyond-the-RDBMS-Data-warehouse-vs-data-lake-vs-data-mart
55
Data Modelinghttps://www.youtube.com/watch?v=--OJpdPeH80&t=3s
56
Workflow as code
57
- Ooziehttps://www.youtube.com/watch?v=hyq-JsiRdB8
58
- Airflowhttps://www.youtube.com/watch?v=AHMm1wfGuHE
59
Infrastructure as codehttps://www.youtube.com/watch?v=zWw2wuiKd5o
60
Query planshttps://www.youtube.com/watch?v=8BmZ9TaRC9k
61
Indexinghttps://dataschool.com/sql-optimization/how-indexing-works/
62
Multidimensional schemashttps://www.guru99.com/star-snowflake-data-warehousing.html
63
OLAP vs OLTPhttps://www.youtube.com/watch?v=oF_2uDb7DvQ
64
MySQL
65
- Architecturehttps://severalnines.com/blog/overview-mysql-database-high-availability
66
- High Availabilityhttps://www.mysql.com/products/enterprise/high_availability.html
67
NoSQL
68
- Types of NoSQL databaseshttps://www.youtube.com/watch?v=6yp4Za9jBxM
69
- 5 common data storeshttps://shopify.engineering/five-common-data-stores-usage
70
MongoDBhttps://www.youtube.com/watch?v=vPp72R2zZMA
71
Apache Cassandra
72
- Introductionhttps://dzone.com/articles/introduction-apache-cassandras
73
- Architecturehttps://www.instaclustr.com/education/apache-cassandra-database/
74
- Gossip protocolhttps://www.youtube.com/watch?v=1b1mrNB6zjQ
75
Redis
76
- Introductionhttps://www.youtube.com/watch?v=qr4FVhBTq0I
77
- Architecturehttp://qnimate.com/overview-of-redis-architecture/
78
Choosing the right databasehttps://www.youtube.com/watch?v=v5e_PasMdXc&t=12s
79
Database designhttps://www.youtube.com/watch?v=cODCpXtPHbQ
80
Object Storage
81
- Introductionhttps://www.netapp.com/data-storage/storagegrid/what-is-object-storage/
82
- File vs. Block vs. Object Cloud Storagehttps://www.youtube.com/watch?v=3r9RGJ0_Bls
83
CDNhttps://www.youtube.com/watch?v=Bsq5cKkS33I
84
Time series databasehttps://www.youtube.com/watch?v=1mLp6TYjOdA
85
Elastic searchhttps://www.elastic.co/what-is/elasticsearch
86
Map Reducehttps://www.guru99.com/introduction-to-mapreduce.html
87
Performance tuning tips for relational databbaseshttps://www.synametrics.com/SynametricsWebApp/WPTop10Tips.jsp
88
89
* LeetCode and Glassdoor are both great resources for you to see the type of questions you will face in an interview
90
91
Amazon Leadership Principles Questions
92
https://managementconsulted.com/amazon-leadership-principles/
93
94
95
96
97
98
99
100