amazon redshift

login user - my gmail / Nidhi@@12345

Cluster admin user/pwd : awsuser / Nidhi--12345

** Best practices to apply in Amazon Redshift:

1. Use separate external schemas for each use case
2. Use query timeouts to limit total runtimes
3. Make sure the Amazon Redshift query plan is efficient - joins, join order etc
4. Make sure predicates are pushed down to the remote query/ subqueries
5. Use materialized views to cache frequently accessed data:
Cache queries that run often, Cache tables that are used by many queries
Balance caching against refresh time and frequency
Limit remote access using materialized views
6. Sync large remote tables to a local copy: Sync newly added remote data,Merge
remote data changes
7. Use a read replica to minimize Aurora or RDS impact
8. Use specific and limited PostgreSQL users for each use case
9. Make sure the PostgreSQL table is correctly indexed
10. Replace restrictive joins with a remote view

**Amazon Redshift best practices for designing tables:

Choose the best sort key
Choose the best distribution style
Let COPY choose compression encodings
Define primary key and foreign key constraints
Use the smallest possible column size
Use date/time data types for date columns

ALTER TABLE products ADD COLUMN ft_description tsvector;

UPDATE products SET ft_description = to_tsvector('english', description);
CREATE INDEX idx_ft_description ON products USING gin (ft_description)

SELECT * FROM products WHERE ft_description @@ to_tsquery('laptop');

-------------------------------

CREATE FUNCTION factorial(integer) RETURNS integer AS $$

BEGIN
IF $1 <= 1 THEN
RETURN 1;
END IF;
RETURN $1 * factorial($1 - 1);
END;
$$ LANGUAGE plpgsql;

SELECT factorial(5);
----------------------------------

CREATE FUNCTION myfunction(arg1 integer, arg2 text)

RETURNS integer AS $$
BEGIN
-- Function logic goes here
RETURN arg1 + 1;
END; $$
LANGUAGE plpgsql;
---------------------------------

CREATE OR REPLACE FUNCTION get_employee_name (p_employee_id INTEGER)

RETURNS TABLE (employee_name TEXT) AS $$
BEGIN
RETURN QUERY SELECT name FROM employees WHERE id = p_employee_id;
END;
$$ LANGUAGE plpgsql;

SELECT * FROM get_employee_name (1); --- proc call

----------------------------------

postrgesql mysql dba and coding test:

MYSQL ORACLE PLSQL TRIGGER NORMALIZATION, BASIC ADMIN, SHRADING, MONGODB
34 QUESTIONS - 226 MARKS 60 MIN TO 90 MIN, MCQS MOSTLY, CODING QUESTIONS MAY
BE 3 TO 4
---------------------------------

https://www.postgresql.fastware.com/postgresql-insider-prt-ove
https://aws.amazon.com/blogs/big-data/amazon-redshift-federated-query-best-
practices-and-performance-considerations/
https://docs.aws.amazon.com/redshift/latest/dg/c_designing-queries-best-
practices.html
https://www.youtube.com/watch?v=KAm8CNWYY-0
https://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial#searchInput
https://www.1keydata.com/sql/sql-create-index.html
https://www.interviewquery.com/p/amazon-sql-interview-questions
https://www.techgeeknext.com/aws/redshift-interview-questions

https://www.interviewquery.com/questions/crossing-bridges?solution=true
https://www.youtube.com/watch?v=oqSqwX333SU
https://www.mysqltutorial.org/mysql-triggers/mysql-after-insert-trigger/

https://www.youtube.com/watch?
v=J7NVBpG33z4&list=PL0hSJrxggIQquOTmUGijMt5aouHfVwFCu&index=1
https://www.youtube.com/watch?v=s8HckCTC6aA
https://www.youtube.com/watch?v=dfo4J5ZhlKI&t=1308s
https://www.naukri.com/learning/articles/top-sql-interview-questions-and-answers/
https://www.gangboard.com/blog/amazon-redshift-interview-questions-and-answers
https://www.edureka.co/blog/interview-questions/sql-interview-questions
https://intellipaat.com/blog/interview-question/sql-interview-questions/
https://dev.mysql.com/doc/workbench/en/
https://www.bestinterviewquestion.com/mysql-interview-questions
https://www.bestinterviewquestion.com/pl-sql-interview-questions
https://www.educba.com/postgresql-describe-table/
https://www.tutorialspoint.com/postgresql/postgresql_using_joins.htm
https://www.devopsschool.com/blog/top-50-interview-questions-and-answers-of-
postgresql/
https://hkrtrainings.com/postgresql-interview-questions
https://www.softwaretesttips.com/mysql-interview-questions/
https://nhlink.net/interview-questions/100-top-postgresql-multiple-choice-
questions-and-answers
https://www.onlineinterviewquestions.com/postgresql-mcq/
https://mcqprof.com/mcq/postgresql/
https://tests4geeks.com/postgresql-online-test
https://www.javatpoint.com/postgresql-interview-questions
https://www.adaface.com/blog/postgresql-interview-questions/
https://engineeringinterviewquestions.com/postgresql-interview-questions-and-
answers/
https://www.acte.in/postgresql-interview-questions-and-answers/
https://ebazhanov.github.io/linkedin-skill-assessments-quizzes/
https://ebazhanov.github.io/linkedin-skill-assessments-quizzes/css/css-quiz.html
https://theglamstreet.com/linkedin-mysql-assessment-answers/
https://seotoptoolz.com/2022/04/17/linkedin-mysql-assessment-test-answers-2022/
https://meshworld.in/mysql-linkedin-skill-assessments-quizzes-with-answers/
https://github.com/Ebazhanov/linkedin-skill-assessments-quizzes/blob/main/mysql/
mysql-quiz.md
https://www.youtube.com/watch?v=i06YDgGEbwk
https://mcqslearn.com/cs/dbms/quizzes/quiz-questions-and-answers.php
https://javarevisited.blogspot.com/2016/01/4-ways-to-find-nth-highest-salary-
in.html#axzz7gQs8WvOa
https://ubiq.co/database-blog/mysql-select-top-n-rows/#:~:text=Sometimes%20you
%20may%20need%20to,or%20purchases%20for%20your%20business.
https://www.youtube.com/watch?v=6v-P6FZnOqQ --- linux and unix mcqs
https://nhlink.net/interview-questions/100-top-postgresql-multiple-choice-
questions-and-answers
https://www.includehelp.com/mcq/oracle-multiple-choice-questions-mcqs-and-
answers.aspx
https://www.includehelp.com/sql/mcq.aspx
https://ebazhanov.github.io/linkedin-skill-assessments-quizzes/
https://www.techbeamers.com/sql-query-questions-answers-for-practice/
https://data-flair.training/blogs/sql-query-interview-questions/
https://www.youtube.com/watch?v=FNYdBLwZ6cE&t=17s
https://www.enterprisedb.com/postgres-tutorials/postgresql-query-introduction-
explanation-and-50-examples
https://www.educba.com/postgresql-describe-table/
https://www.youtube.com/watch?v=sV0swTnWc2I
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/index.html
https://artoftesting.com/sql-queries-for-interview --- mysql queries
https://dev.mysql.com/doc/workbench/en/

oracle-plsql
https://www.youtube.com/watch?
v=EUYyiFCzU0I&list=PLL_LQvNX4xKyiExzq9GKwORoH6nvaRnOQ&index=52
https://www.youtube.com/watch?v=dG1TIXFpKA8
https://www.youtube.com/watch?v=Qx-mXhkB5b8
https://www.youtube.com/watch?v=2IhuBCGThsQ&t=211s
https://www.youtube.com/watch?v=ObbNGhcxXJA
https://www.youtube.com/watch?v=iuvzjf7nU1I
https://www.youtube.com/watch?v=FNYdBLwZ6cE&t=17s
https://mindmajix.com/oracle-pl-sql-interview-questions
https://www.mysqltutorial.org/mysql-triggers/mysql-after-insert-trigger/
https://www.guru99.com/pl-sql-interview-questions-answers.html
https://riptutorial.com/plsql

IMP SQL PLSQL QUEST MCQ

https://www.youtube.com/watch?v=qU45ids6lsw
https://www.youtube.com/watch?v=N3z_4IbXCt0&t=7s

oracle to postgresql migration

https://www.youtube.com/watch?v=n5K_FfrFjLo
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migration-
pattern-list.html
https://www.youtube.com/watch?v=CnjxgJpPmv4
https://aws.amazon.com/blogs/database/challenges-when-migrating-from-oracle-to-
postgresql-and-how-to-overcome-them/
https://www.youtube.com/watch?v=EcS9PC_TnG0

python
https://app.programiz.pro/course/python-interview-questions/sum-of-every-element-
in-list?page=1
https://app.programiz.pro/course/learn-python-basics/get-started?page=1

-----------------------------------------------------------------------------------
-------------------------------
https://www.linkedin.com/skill-assessments/MySQL/report/?
practiceModal=&practiceMode=
https://www.pythontutorial.net/
https://www.w3schools.com/html/html_responsive.asp
https://www.youtube.com/watch?v=fAU93nmcL7U&list=PLXVQUR5Ul74-
0cDM3ciApZIELr1PT9Cc4&index=3 ---data structures
https://www.youtube.com/watch?v=iEwoo7oEa2U
https://www.youtube.com/watch?v=z9RXGsp2tlQ ---python
https://realpython.com/tutorials/django/
https://www.youtube.com/watch?v=Kk508-pJ0Xg ---html mcqs
https://www.youtube.com/watch?
v=sHyMpdGLiF0&list=PLHGEFDzb9ZJZ2btSDq9wPc2IyB2vPgJAx&index=10 ---html mcqs
https://www.youtube.com/watch?v=3Lm5uFgWsS0 ---java mcq
https://www.javatpoint.com/nodejs-tutorial
https://www.youtube.com/playlist?list=PLGdIbZ-MLtZWuCM3So5tjkuhpDUIyU4jz ----
python trng

-----------------------------------------------------------------------------------
-----------------------------

https://www.linkedin.com/public-profile/settings?
trk=d_flagship3_profile_self_view_public_profile

https://www.postgresqltutorial.com/postgresql-python/connect/
https://www.enterprisedb.com/postgres-tutorials/how-use-postgresql-django
https://www.geeksforgeeks.org/postgresql-insert-data-into-a-table-using-python/?
ref=lbp
https://www.geeksforgeeks.org/postgresql-import-csv-file-into-table/?ref=lbp
https://www.geeksforgeeks.org/postgresql-loading-a-database/?ref=lbp
https://vladmihalcea.com/how-does-mvcc-multi-version-concurrency-control-work/

COMPLEX SQL QUERIES LINKS

https://www.youtube.com/watch?v=VAOpMH_iXMA
https://datalemur.com/questions
https://www.kdnuggets.com/2023/01/7-best-platforms-practice-sql.html
https://www.kdnuggets.com/2018/09/olap-queries-sql-refresher.html
https://leetcode.com/problemset/database/
https://platform.stratascratch.com/coding/2142-third-heaviest-package?code_type=1
https://sqlpad.io/users/dashboard/welcome
https://sqlpad.io/questions/?page=1
https://www.hackerrank.com/domains/sql
https://www.hackerrank.com/challenges/revising-the-select-query/problem?
isFullScreen=true
https://www.sqlshack.com/learn-sql-how-to-write-a-complex-select-query/
https://severalnines.com/blog/basic-administration-comparison-between-oracle-mssql-
mysql-postgresql/
https://www.datacamp.com/blog/sql-server-postgresql-mysql-whats-the-difference-
where-do-i-start
https://www.datacamp.com/blog/category/sql
https://www.datacamp.com/tutorial
https://www.janbasktraining.com/blog/top-oracle-dba-interview-questions-and-
answers/
https://bytescout.com/blog/mysql-vs-postgresql-vs-oracle.html
https://bytescout.com/blog/sql-query-to-select-records-by-multiple-children-
attributes.html?utm_referer=https%3A%2F%2Fbytescout.com%2Fblog
https://bytescout.com/?s=sql+query

complex queries part 2

https://8weeksqlchallenge.com/case-study-1/
https://sqlzoo.net/wiki/SQL_Tutorial
https://sqlzoo.net/wiki/SELECT_within_SELECT_Tutorial
https://www.youtube.com/results?
search_query=top+25+complex+sql+coding+queries+asked+in+interview
https://www.youtube.com/watch?
v=PugrHmixt1k&list=PLKVxK2jv1oA9Ow28rg__JaBWjJQtoPyu6&index=2
https://www.youtube.com/watch?v=UZAqMAzCZss
https://medium.com/analytics-vidhya/8-week-sql-challenge-case-study-week-1-dannys-
diner-2ba026c897ab
https://www.kdnuggets.com/2018/09/olap-queries-sql-refresher.html
https://www.youtube.com/watch?v=AK7_m-aThfw
https://www.youtube.com/watch?v=YJJrVpEVl4Y
https://artoftesting.com/sql-queries-for-interview#sql_minus_operator
https://learnsql.com/cookbook/how-to-add-ranking-positions-to-rows-with-dense_rank-
in-sql/
https://www.edureka.co/blog/interview-questions/sql-query-interview-questions
https://nishantrana.me/2007/10/03/using-left-and-charindex-in-oracle/
https://codingcompiler.com/sql-query-interview-questions-answers/
https://w3resource.com/PostgreSQL/position-function.php
https://www.youtube.com/watch?v=ZwFfiadQB3k

paid trngs:
https://www.udemy.com/home/my-courses/learning/

mongo - alation:
https://www.youtube.com/watch?v=RGfFpQF0NpE&list=PL4RCxklHWZ9v2lcat4oEVGQhZg6r4IQGV
---- mongodb
https://www.youtube.com/@MongoDB/videos ---- mongodb vdo
https://www.youtube.com/watch?v=XJflORjdzug --- data governance alation tool
https://www.youtube.com/watch?v=Grl9qKJ85Ig&list=PL3tm3AUwTko5H4pWO1joD0DiHMz6vCYWU
--- alation
https://www.youtube.com/watch?v=Emmvcwkz4uY --- alation

https://database.guide/category/dbms/ordbms/postgresql/
https://medium.com/scopedev/introduction-to-profiling-and-optimizing-sql-queries-
for-software-engineers-3cf376ecc712
https://www.postgresqltutorial.com/
https://www.softwaretestinghelp.com/oracle-interview-questions-part1/
https://www.youtube.com/watch?v=jS5_hjFgfzA&t=38s --- complex sql query
https://www.youtube.com/watch?v=6UAU79FNBjQ ---- complex query
https://www.youtube.com/watch?v=L7LtmfFYjc4 ---- whatsup system design
https://www.youtube.com/watch?v=6UEWFAtvmsY&t=1s ---- best practices for DWH red
shift
https://engineeringinterviewquestions.com/amazon-redshift-interview-questions-and-
answers/
https://www.analyticsvidhya.com/blog/2022/06/amazon-redshift-basic-introductory-
guide/?utm_source=related_WP
https://www.postgresql.org/about/featurematrix/
https://intellipaat.com/blog/interview-question/postgresql-interview-questions/
https://www.youtube.com/watch?v=7bfOllAyxlg
https://www.youtube.com/watch?v=GoVxorWG0gM
https://www.adaface.com/blog/postgresql-interview-questions/
https://zetcode.com/python/psycopg2/
https://zetcode.com/all/#python
https://www.educba.com/postgresql-database/
https://www.sqlines.com/postgresql/stored_procedures_functions
https://dbaclass.com/postgres-db-scripts/
https://www.postgresqltutorial.com/
https://www.youtube.com/watch?v=2_nDh12K2aM&list=PLownlFUq_rL6iJF0hiSXKT0cnIAtBgHoX
https://www.youtube.com/watch?v=7cBkXKCY4Ew
https://www.youtube.com/watch?v=ezjCft_ldWk
https://dbaclass.com/article/postgres-interview-questions/

https://engineeringinterviewquestions.com/amazon-redshift-interview-questions-and-
answers/

https://engineeringinterviewquestions.com/postgresql-interview-questions-and-
answers/

scribd:
https://www.slideshare.net/Hadoop_Summit/analytical-queries-with-hive?
from_search=108
https://www.slideshare.net/hamcdc/the-sql-model-clause?from_search=106
https://www.slideshare.net/MariaDB/beyond-the-basics-advanced-sql-with-mariadb?
from_search=100
https://www.slideshare.net/hamcdc/sep13-sql-tuning101
https://www.slideshare.net/hamcdc/sep13-analytics
https://www.slideshare.net/hamcdc/using-sql-to-process-hierarchies
https://www.slideshare.net/hamcdc/sep13-analytics
https://www.slideshare.net/hamcdc/sep13-sql-tuning101
https://www.slideshare.net/EdurekaIN/postgresql-tutorial-for-beginners-edureka?
from_search=15
https://www.slideshare.net/search?searchfrom=header&q=postgresql+queries

https://www.edureka.co/blog/interview-questions/python-interview-questions/
https://intellipaat.com/blog/interview-question/amazon-aws-interview-questions/
https://www.techgeeknext.com/aws/redshift-interview-questions
https://climbtheladder.com/aws-redshift-interview-questions/
https://www.techgeeknext.com/python/python-interview-questions
https://medium.com/scopedev/introduction-to-profiling-and-optimizing-sql-queries-
for-software-engineers-3cf376ecc712
https://engineeringinterviewquestions.com/amazon-redshift-interview-questions-and-
answers/

https://www.youtube.com/watch?v=kUJPZbUPqro ---- html css js tailwind

An Introduction to Assessing Normal Distribution with Python

https://www.mssqltips.com/sqlservertip/7543/python-normal-distribution-example/
--------------------------------------

https://www.sqlservercentral.com/articles/postgresql-temporary-table
https://www.sqlservercentral.com/articles/how-to-avoid-merge-in-sql-server
https://www.sqlservercentral.com/articles
https://www.sqlservercentral.com/search/COMPLEX+/section/scripts/
https://www.sqlservercentral.com/search/COMPLEX+/section/articles/page/3

SSIS LINKS:
https://www.youtube.com/watch?v=G_wG-bzTCZY
https://www.youtube.com/watch?v=0ikNnenDyNw
https://www.youtube.com/watch?v=Ugbadoa8nq0

SSIA--> SSAS--> SSRS LINKS

https://www.youtube.com/watch?v=I_Ae3suaL-U
https://www.youtube.com/watch?v=kgSKzkdr2RI

https://www.javatpoint.com/postgresql-tutorial
https://www.javatpoint.com/postgresql-interview-questions
https://dbaclass.com/postgres-db-scripts/
https://www.codingninjas.com/blog/2021/09/16/33-python-interview-questions-for-
beginner-in-2021-part-1/
https://www.dataquest.io/blog/tutorial-connect-install-and-query-postgresql-in-
python/
https://www.datacamp.com/tutorial/tutorial-postgresql-python
https://www.tutorialspoint.com/python_data_access/
python_postgresql_introduction.htm
https://help.lever.co/hc/en-us/articles/360043698832-How-do-I-extract-and-load-
data-into-a-Postgres-database-using-a-Python-script-

https://www.sanfoundry.com/python-problems-solutions/
https://www.youtube.com/watch?v=O61gbmYZJmE ---- aws quest
https://www.youtube.com/watch?v=yUXh6pp85Lc ---- aws question
https://www.youtube.com/watch?v=yUXh6pp85Lc ---- cloud quest
https://www.youtube.com/watch?v=lHC7xpFack8 ---- kubernetes quest
https://www.youtube.com/watch?v=8zsdpwvTxos&list=PL5aURjJ6mdUc7O6xrwnv96SrZ4DxF-8tZ
--- soln architect and other quest
https://www.youtube.com/@cloudwithraj/playlists ---- cloud and other tech
playlist
https://www.youtube.com/watch?v=ALrOcDPimWE --- rest api in hindi
https://www.youtube.com/@ThapaTechnical/playlists --- all tech vdos playlist
https://www.interviewbit.com/sql-interview-questions/
https://www.enterprisedb.com/postgres-tutorials/how-use-postgresql-django

https://protechstack.com/interview/python-interview-questions
https://www.youtube.com/watch?v=4YhUpB3PeSw&list=PLw945x_O7SHqlFQUCm-K1HrcwwmQ1XUq8
---python coding quest
https://www.youtube.com/watch?v=s3nW1kdTT7w&t=1s ---- python coding interview
quest
https://www.sanfoundry.com/python-problems-solutions/
https://www.geeksforgeeks.org/python-programming-examples/?ref=lbp
https://www.geeksforgeeks.org/python-oops-concepts/
https://www.sanfoundry.com/python-problems-solutions/
https://data-flair.training/blogs/top-python-interview-questions-answer/
https://www.youtube.com/watch?v=UFAwAw-7Zpw&t=67s ---- python quest
https://www.youtube.com/watch?v=EJUsnCMzXfI ---- django mock interview
https://medium.com/coders-camp/100-python-projects-with-source-code-4a60d7d7cd08
https://codedamn.com/news/python/100-python-projects-for-practice
https://www.geeksforgeeks.org/python-oops-concepts/
https://www.geeksforgeeks.org/python-programming-examples/?ref=lbp
https://www.geeksforgeeks.org/python-exercises-practice-questions-and-solutions/?
ref=lbp
https://www.youtube.com/watch?v=u9ZqynGOXl8&t=252s
https://www.javatpoint.com/python-tutorial
https://www.javatpoint.com/python-programs
https://www.programiz.com/python-programming/examples
https://mindmajix.com/django-interview-questions
https://hackr.io/blog/python-interview-questions
https://svrtechnologies.com/top-54-python-interview-questions-and-answers-for-
experienced/
https://www.analyticsvidhya.com/blog/2022/07/python-coding-interview-questions-for-
freshers/
https://www.javatpoint.com/python-coding-interview-questions
https://www.analyticsvidhya.com/blog/2022/07/python-coding-interview-questions-for-
freshers/
https://quescol.com/interview-preparation/python-coding-question
https://mindmajix.com/python-interview-questions
https://mindmajix.com/oops-interview-questions
https://www.w3schools.com/python/python_examples.asp
https://www.youtube.com/watch?v=bQ9WTpVVrdA&list=PLxQ8cCJ6LyOatT6D7NASBz6dcHgdPCfgF

coder byte python coding examples:

https://www.youtube.com/watch?v=bQ9WTpVVrdA&list=PLxQ8cCJ6LyOatT6D7NASBz6dcHgdPCfgF
https://coderbyte.com/video/how-to-code-combinations-using-recursion
https://www.youtube.com/watch?v=PgKbrHcVhZs
https://www.youtube.com/watch?v=a6DPueTvN50&t=213s
https://www.youtube.com/watch?v=ID3a2-ByYM4
https://www.youtube.com/watch?v=EiBU4ykTlGw&t=8146s
https://www.youtube.com/watch?v=G6C9Q_oP5Ic
https://www.codingninjas.com/codestudio/library/coderbyte-interview-questions
https://www.youtube.com/watch?v=lLeZ8Cr2YVM ---- master react.js
https://www.youtube.com/watch?v=yju4zwKSriI ----- javascript mock interview

Paid courses and other KT interview links

https://www.dotnettricks.com/member
https://log2base2.com/courses/python/dynamic-nature-in-python
https://hkrtrainings.com/postgresql-interview-questions
https://www.devopsschool.com/blog/top-50-interview-questions-and-answers-of-
postgresql/
https://www.interviewbit.com/sql-interview-questions/
https://dbaclass.com/postgres-database-articles/
https://dbaclass.com/postgres-db-scripts/
https://blog.insightdatascience.com/from-postgresql-to-redshift-with-kafka-connect-
111c44954a6a
https://auth.geeksforgeeks.org/roadBlock_v2.php
https://dbaclass.com/
https://openclassrooms.com/en/courses/6902811-learn-python-basics/7091156-extract-
and-transform-data-with-web-scraping
https://support.etlworks.com/hc/en-us/articles/360013612534-Transform-dataset-
using-JavaScript-or-Python
https://github.com/markwsutton/ETL-using-Python-SQL

https://www.alphacodingskills.com/python/python-strings.php ---- python alph

coding
https://www.programiz.com/python-programming/examples ---- python examples
https://blog.insightdatascience.com/from-postgresql-to-redshift-with-kafka-connect-
111c44954a6a ---- redshoft and postgre
https://www.dataquest.io/blog/tutorial-connect-install-and-query-postgresql-in-
python/

https://www.youtube.com/watch?v=ocGtwjEuUA4 ----- top 20 aws quest

https://www.youtube.com/watch?v=uQ_8is1K_Jg ---- aws quest
https://www.youtube.com/watch?
v=NzgFdEGI8sI&list=PLBBog2r6uMCRhh5U6TAHeKedy_BV7OtnK&index=10 --- rest api
and web serv
https://www.youtube.com/watch?v=ysoC8S96pZU&list=PLBBog2r6uMCResrR48HziFtNx4-
BDOmU0&index=2 ---- microserv docker, kubernetes etc
https://www.youtube.com/user/rithustutorials/playlists ---- cloud and other
tutorials
https://www.youtube.com/watch?v=-7JSF_aATJg ----- html css js projects

my details:

[email protected]

Name : Prasanna Ghare

Contact : +91 8007988904
Alternate Contact : +91 8007988905
Email : [email protected]
Current Location : Pune
Total Exp : 18 yrs
Rel Exp : 5+ yrs
Current CTC : 30 Lacs/pa
Exp CTC : 31 to 32 Lacs/pa
Notice Period : 15 days only
NAME AS PER PAN CARD: Prasanna Prabhakar Ghare
DOB: 22/02/1974
HIGHEST QUALIFICATION: MCA
PASSING YEAR: 1997
PERCENTAGE: 64.35%
UNIVERSITY: Shivaji University
PANCARD: ABDPG8204E

HIGH DIVIDEND STOCKS

RECLTD, PFC, IOC, COAL,
DIVIDEND PLUS GROWTH STOCKS
HCLTECH, ITC

ASHOK LEYLAND, JUBLFOOD, SAMVARDHANA MOTHERSON SUMI, WIPRO

1 lakh Portfolio stocks

PIDILITE, ICICIBANK, BAJAJFINSV, HCLTECH, UNOMINDA, ASTRAL, POLYCAB, SRF , KPITTECH

STKS: IRCTC, ITC, VBL, KPIT, KOTAK, BERGER, HAL, RELIANCE, DIVISLAB, DMART/TRENT,
JUBLFOOD, SRF, TUBE, MOLDTEK
MTAR, RADICO, LT FOODS, DELTA CORP, APOLLO PIPES, HINDWARE HOME, ALLCARGO,
KINGFA SCIENCE & TECH, ETHOS

Cholestrol reduce using below items:

1) one to two spoon Methi dana mix in glass of water at night, next day norning
drint it early morning
2) Use green tea, Dalchini, Lasun, adrak, limbu, lasun 2 paklya jevtana ani javas
chatani jevtana
3) Dhane, jire, badishep, khadisakhar, kale mire mixture churn ghene
4) Srilankan Dalchini, lavang jevan zale ki khane
5) Isab Gol 1 to 2 spoon in warm water, jwari chi bhakri jast khane poli aivaji
6) Fruits(apple, santri, mosumbi, dalimb, banana, peru, limbu) green vegetables
( Vang, bhendi, dudhi, bhopla, tomato, onion)
all types of nuts,kadadhanye, dark choclate

CDSL Consolidated Account Statement (CAS) across Mutual Funds and Depositories

Login and pwd for income tax site:

link: https://www.incometax.gov.in/iec/foportal/

login - ABDPG8204E
pwd: Tata@@1234

lasun, amla, ( mix of dhane, jire, badishep, khadisakhar), isabgol, limbu, ale,
dudhi bhopla, methi dana, green tea
pranayam,anulom-vilom, kapalbhati, yoga, exercise, walking, eyes exercise

1 8 - mangal, 2,7- shukra, 3,6-budh, 9,12-guru, 10,11-shani, 4-chandra, 5- surya

1 - MESH - MANGAL
2 - VRUSHABH- SHUKRA
3 - MITHUN- BUDH
4 - KARK - CHANDRAMA
5 - SINHA - SURYA
6 - KANYA - BUDH
7 - TULA - SHUKRA
8 - VRUSHIK - MANGAL
9 - DHANU - GURU
10- MAKAR - SHANI
11- KUMBH - SHANI
12- MEEN - GURU

GRAHON KI DRUSHTI
SURYA - 7
CHANDRAMA - 7
MANGAL - 4,7,8
BUDH - 7
GURU - 5,7,9
SHUKRA - 7
SHANI - 3,7,10
RAHU - 5,7,9
KETU - 5,7,9

PAID TRNG COURSES LINKS

https://log2base2.com/courses/python/dynamic-nature-in-python

INTELLIPAT PAID TRNG COURSES

https://lms.intellipaat.com/members/prasannaghare/course/

DOTNETRICS PAID COURSES

https://www.dotnettricks.com/member
UDEMI FULL STACK AND OTHER PAID COURSES
https://www.udemy.com/home/my-courses/learning/

HTML CSS TRNG

https://www.youtube.com/watch?v=aZa1t2pTqJA&list=PLYxzS__5yYQk3V3b8yJZfyH-
cX4LbgyYj&index=36

SIMPLILEARN FREE TRNG COURSE

https://lms.simplilearn.com/dashboard

CLOUD SKILLS TRNG

https://www.cloudskillsboost.google/

1. Total Experience - 18 yrs , 2. Relevant Experience in Mysql: 6 yrs

3. Current CTC - 29 Lacs/pa 4. Expected CTC - 32 to 34 Lacs
5. Earliest date of joining - 24th Oct (join within 15 days only)
6. Notice Period - 15 days, 7. Current Location - Pune, Preferred Location -
Remote/WFH only
8. SSC, HSC and Graduation Grades - SSC: 82%, HSC: 72.33%, Bsc(electr): 70%
(distinction), MCA - 64.35% (First class)
9. Availability for tel/video call interview: Next week, pls call before scheduling
it if my CV is shortlisted

https://cutshort.io/profile/matches/c/637891cf7efcb800259db6e3?view=take_tests
----- mcq tests

https://www.youtube.com/watch?v=PtQiiknWUcI ----- Python Django 7 Hour Course

https://www.geeksforgeeks.org/introduction-to-python/?ref=lbp ---- python
tutorial from geeks
https://www.geeksforgeeks.org/python-programming-examples/
https://www.w3schools.com/python/default.asp ----- python tutorial from
w3schools

https://scrimba.com/learn/introhtmlcss ----- scrimba html css

https://scrimba.com/learn/responsive ----- scrimba responsive web design
https://scrimba.com/learn/learnjavascript ---- scrimba javascript
https://scrimba.com/learn/python ----- scrimba python
https://scrimba.com/learn/learnreact ------ scrimba react
https://scrimba.com/learn/react ------ scrimba adv react
https://scrimba.com/learn/reactinterview ----- scrimba react quest
https://scrimba.com/learn/frontend ----- scrimba frontend with react
https://scrimba.com/learn/design ------ scrimba UI design
https://scrimba.com/learn/regularexpressions ---- scrimba reg expre
https://scrimba.com/learn/bootstrap4 ----- scrimba bootstrap4

Django Rest API + React JS (Hooks) Complete Full Stack Series Introduction & Demo
Project
https://www.youtube.com/watch?
v=t7SdmogImh4&list=PLPip5lOh2Z5Cms1C6g0GHgHiaXnXCmYm1&index=1

https://www.alphacodingskills.com/python/python-tutorial.php ----- python

tutorial
https://docs.python.org/3/library/index.html
https://cutshort.io/profile/matches/c/637891cf7efcb800259db6e3?view=take_tests
https://github.com/brennerm/PyTricks
https://masterprograming.com/category/programming-blog/

https://www.alphacodingskills.com/interview/python-interview-questions.php

https://www.youtube.com/watch?v=vlxIjXLlmxQ --- Complete API Development --

Django Rest Framework + MySQL For Beginners ||
https://www.youtube.com/watch?v=cbx6eS7crto --- Deploy DJANGO APP on AWS EC2
Instance | DJANGO on EC2
https://www.youtube.com/playlist?list=PLtGXgNsNHqPRIREAxyE47turTLeJMgXf2 -----
django deployment on aws
https://www.youtube.com/watch?v=ybxv-2j0V5U ---- Complete build pipeline:Auto
deploy changes to server as soon as dev commits to git repo
https://www.youtube.com/channel/UCH_YSj45mWthhPi1S22HpAw/videos ---- build deploy
django app
https://www.youtube.com/watch?v=9YGZL9hdsaw ----- Deploy Django project in
Kubernetes | zero downtime deployment
https://www.youtube.com/watch?v=JVFH8fuR4l0 --- Deploy Django Web App In AWS
Ubuntu Instance With Nginx,MySQL,Gunicorn,Supervisor
https://www.youtube.com/watch?v=awFLzy0XwXo --- Learn to Deploy your Docker
Container on EC2 in 15 Minutes
https://www.youtube.com/watch?v=Qlwv7FzHADM ---- How to deploy your Django app
with PostgreSQL on AWS, quovery
https://www.youtube.com/watch?v=SdTzwYmsgoU --- Microservices in Python using
Flask Framework|Dockerize and Deploy to Kubernetes with Helm
https://www.youtube.com/watch?v=d7PTjQiahOQ --- CI/CD With AWS ECS + CodePipeline
+ CodeDeploy + CodeCommit + CodeBuild + Docker
https://www.youtube.com/watch?v=k20OHJPSc38 --- Deploy Django API on AWS Lambda
and Load Balancer
https://www.youtube.com/watch?v=kwZNpieUreA --- Python for DevOps Master Class
2022: CI/CD, Github Actions, Containers and Microservices
https://www.youtube.com/watch?v=DNS6OcwcxV8 --- Setting up a Django + MySQL
Development Environment on AWS EC2 Linux 2
https://www.youtube.com/watch?v=Qlwv7FzHADM&t=26s --- How to deploy your Django app
with PostgreSQL on AWS
https://www.youtube.com/watch?v=Gf0vpJQZeBI --- Serverless Deployment of a Django
Project with AWS Lambda, Zappa, S3 and PostgreSQL
https://www.youtube.com/watch?v=51YwXvJ9LOE --- Deploy Django Website to Amazon
Web Services (Elastic Beanstalk)
https://www.youtube.com/watch?v=nIKhrWTtkKs --- DevOps RestAPI - AWS RDS, EC2, S3,
React and Django Rest Framework
https://www.youtube.com/watch?v=pkeuHEsuXXY --- How to deploy Django project on
AWS for FREE 2020
https://www.youtube.com/watch?v=3uTVVoOOPO8 --- django project with source code |
School LMS zero to deployment
https://www.youtube.com/watch?v=ftpepZo9GSI --- How to setup a Django 4.0 project
with Heroku and AWS S3
https://www.youtube.com/watch?v=4nBlCQ2SBNw --- Django python: How to launch
django project in public internet using aws

https://www.youtube.com/watch?v=i5JykvxUk_A --- Django REST Framework - Build an

API from Scratch
https://www.youtube.com/@codebreakthrough/playlists

https://www.youtube.com/watch?v=9LLtssFchbw&list=PLsDu33Q_p-uR_9EFvR-zEmdJ35V9SJNL-
&index=57
-- Host Django Project On Amazon AWS + Connect Domain With SSL

Python basic programming

https://www.youtube.com/watch?v=0OV2hzlxreM&list=PLsDu33Q_p-uRD1yDKrnSDxb0PxeUbbQvN

https://www.youtube.com/watch?v=HHndy_etgzU
AWS Lambda - How to do serverless deployments - Free Full Tutorial - SCALER

https://www.youtube.com/watch?v=GyHaF1Ufdwc
#1 DEPLOY YOUR DJANGO PROJECT ON AWS DJANGO | AWS FROM SCRATCH |

https://www.youtube.com/watch?v=q4vE5NSmjuc
#2 DEPLOY YOUR DJANGO PROJECT ON AWS DJANGO | AWS FROM SCRATCH |

https://www.w3resource.com/
https://www.interviewkickstart.com/interview-questions/python-data-structures-
interview-questions
https://www.javatpoint.com/python-interview-questions
https://www.javatpoint.com/python-coding-interview-questions
https://mindmajix.com/linux-interview-questions
https://climbtheladder.com/cron-job-interview-questions/
https://www.sqlalchemy.org/
https://www.javatpoint.com/logging-in-python
https://www.edureka.co/blog/interview-questions/top-hadoop-interview-questions

https://scrimba.com/learn/python ---- PYTHON

https://scrimba.com/learn/introhtmlcss ---- HTML CSS
https://scrimba.com/playlist/p7v3gCd ----- JS
https://scrimba.com/learn/learnreact ----- REACT
https://scrimba.com/learn/frontend
https://www.youtube.com/watch?v=NaEk2zAmDE8 ---- springboot
https://www.youtube.com/watch?v=qof9A8k64rA&list=PLVz2XdJiJQxybsyOxK7WFtteH42ayn5i9
---- kubernetes
https://www.youtube.com/watch?
v=aOen1-pQLZg&list=PLVz2XdJiJQxw1H3JVhclHc__WYDaiS1uL ---- microservice
https://www.youtube.com/watch?v=k5PeywcbVYc&list=PLVz2XdJiJQxzEDYrjG-31qrRYrKymm1Ab
---- mongodb
https://www.youtube.com/watch?v=0zJUK-SwPqQ&list=PLVz2XdJiJQxw65gPKDfv2w3voXH4CruCk
---- cloud deployment

https://www.youtube.com/@talkpython/videos ---- talk python

https://www.youtube.com/watch?v=fgXW3RF7dMw ---- Running Python Applications in
Production
https://www.youtube.com/watch?v=S4fHuASb_vY ---- How to Deploy Django Project
- AWS EC2 + Nginx + uWSGI
https://www.youtube.com/watch?v=3sQhVKO5xAA ---- AWS Tutorials: Deploy Python
Application on AWS EC2 (Permanent Running)
https://www.alphacodingskills.com/interview/python-interview-questions.php
https://www.alphacodingskills.com/numpy/numpy-tutorial.php
https://developer.mozilla.org/en-US/docs/Glossary/Python

https://www.scaler.com/topics/mutable-data-types-in-python/
https://www.youtube.com/watch?v=Ri-URt8gPCk ----- Jenkins CI CD By Mr. Ashok |
DevOps Tools | Ashok IT
https://www.djangoproject.com/start/ ----- django documentation
https://developer.mozilla.org/en-US/docs/Learn/Server-side/Django/
Tutorial_local_library_website
https://developer.mozilla.org/en-US/docs/Learn/Server-side
https://developer.mozilla.org/en-US/docs/Web/HTML
https://developer.mozilla.org/en-US/docs/Web/CSS
https://developer.mozilla.org/en-US/docs/Web/JavaScript
https://developer.mozilla.org/en-US/docs/Web/HTTP
https://developer.mozilla.org/en-US/docs/Web/API
https://developer.mozilla.org/en-US/docs/Mozilla/Add-ons/WebExtensions

https://www.tutorialspoint.com/python/index.htm

https://www.youtube.com/watch?v=psr7TvtLOxA ----- PYTHON FULL COURSE

https://www.youtube.com/watch?
v=E7meeDklryA&list=PLUDwpEzHYYLsL84A2pK3Ayzfyt610bxaT&index=1 ---- PYTHON
SERIES
https://www.youtube.com/watch?v=ta9kgf15i20 ----- DJANGO FULL COURSE
https://www.youtube.com/watch?v=svs7mCtDvzs&list=PLjC8JXsSUrrgmuAZxPeNLdPoBNzbc2BBV
--- REST API SERIES
https://www.youtube.com/watch?v=rg6LWuXkNDk ----- HTML FULL COURSE
https://www.youtube.com/watch?
v=FD8yFnncPTc&list=PLH9iLcrNpXtRQ809q6AeIDMMSYYoToB8T&index=11 ---- CSS TUTORIAL
FULL
https://www.youtube.com/watch?v=D9NNOHiEnkw&list=PLUDwpEzHYYLvwue9lrn2f-khukGDl-Nuh
----- JS FULL SERIES
https://www.youtube.com/watch?v=DMBtRCvords&list=PLUDwpEzHYYLu1Sxfwtvbr8kzd7uNd8jIS
---- SQL QUERIES SERIES
https://www.youtube.com/watch?v=9_lkSgqBOwc&list=PLUDwpEzHYYLvWEwDxZViN1shP-
pGyZdtT&index=3 ---- MYSQL SERIES
https://www.youtube.com/watch?v=yy-RPsffuKk&list=PLUDwpEzHYYLs6I6jA_USsP3UWfS7EKCf2
----- JSON SERIES
https://www.youtube.com/watch?v=BZi44GOD8kY ----- rest api course
https://www.youtube.com/watch?v=sZKzpHkJ-xw&list=PLUDwpEzHYYLtg-RO06RVFsauoAv241TNE
----- REST API, MICROSERVICES, BOOTSTRAP
https://www.youtube.com/watch?v=n3UITFRJ9KU&list=PLUDwpEzHYYLskkglxoXd0L6DKu4uOfh-m
------ REST ASSURED WITH BDD APROACH
https://www.youtube.com/watch?v=YRYsXnfhfuc&list=PLUDwpEzHYYLtrdDyf3z-
0fybtHNcqAdj5&index=1 ---- GIT GITHUB, CI-CD, JENKINS
https://www.youtube.com/watch?v=AQbSmki24Xw&list=PLUDwpEzHYYLtpm24ojHwubwmMNQildHBc
------ DOCKER SERIES
https://www.youtube.com/watch?v=95NBave0W_k&list=PLUDwpEzHYYLt3kLIHDLVjdnmJw7BDvVdE
----- postman full course
https://www.youtube.com/watch?v=2DD-ynCIZ4w&list=PLUDwpEzHYYLsuUBvuoYTlN0KsBB5t-BDa
----- SELENIUM WITH PYTHON
https://www.youtube.com/watch?v=-25Q76lnB50&list=PLUDwpEzHYYLs86hEjzJGWmrHjONOQJWJY
----- APACHE MAVEN

https://www.youtube.com/watch?v=0Lta-YbuIQY&list=PLUDwpEzHYYLu2Q7VazSGfdLW-W0B8xv-N
----- LINUX SHELL SCRIPT SERIES
https://www.youtube.com/watch?v=2qWPpgALJyw ----- CORE JAVA FULL COURSE
https://www.youtube.com/watch?v=7E6-
rMlOZ3k&list=PLH9iLcrNpXtRQ809q6AeIDMMSYYoToB8T&index=7 ---- JDBC COURSE
https://www.youtube.com/watch?v=8C_gxjuME-8 ----- JAVA FX (GUI) COURSE
https://www.youtube.com/watch?v=1S0A7fh4l_E ----- BOOTSTRAP PART-1
https://www.youtube.com/watch?v=hl3JNowNPKA ----- BOOTSTRAP PART-2
https://www.youtube.com/watch?v=Iqq7Yel4xOA&list=PLtbUiCH_oPJjs0pKodMDHGszgYOVH81Xe
---- JAVASCRIPT
Python django, sql, JS programs/code, tutorials and interview stuff:
https://www.youtube.com/watch?v=fdn9oKAqzmI&list=PLUDwpEzHYYLv0iZsTx4dm-v-
icoVXRqrz&index=1 ----- python prog examples
https://www.geeksforgeeks.org/python-programming-examples/
https://www.w3schools.com/python/python_examples.asp
https://www.geeksforgeeks.org/introduction-to-python/?ref=lbp
https://www.javatpoint.com/python-interview-questions
https://www.linkedin.com/pulse/top-100-python-interview-questions-answers-credo-
systemz-1e/
https://www.geeksforgeeks.org/django-interview-questions-answers-with-practical-
tips-for-junior-developers/
https://www.geeksforgeeks.org/python-web-development-django-tutorial/
https://www.techtutorial.in/python-interview-questions-and-answers-set-1/

https://www.w3resource.com/python-exercises/
https://www.w3resource.com/python-exercises/python-basic-exercises.php
https://www.w3resource.com/python-exercises/python-basic-exercise-3.php
https://quescol.com/interview-preparation/python-coding-question
https://www.geeksforgeeks.org/python-programming-examples/
https://www.w3schools.com/python/python_examples.asp
https://www.youtube.com/playlist?list=PL2_UVwGGi2BFhPsRlaQ4bzuOoTMRdXKgP
https://www.youtube.com/watch?v=fdxtmMOfdrc&list=PLzgPDYo_3xulOYHoVsg7uASoF-OE3GE-S
https://www.youtube.com/watch?v=fdn9oKAqzmI&list=PLUDwpEzHYYLv0iZsTx4dm-v-icoVXRqrz
https://www.youtube.com/watch?v=bqeRqFVmEuI&list=PLI4OVrCFuY54S0RMuEYAgF2WguzROM1w3
https://www.youtube.com/watch?v=O3i-145ATog&t=7s
https://www.youtube.com/watch?v=x75bsVZNLeE&t=15s
https://www.youtube.com/watch?v=2mtEE4rN4Wk
https://www.youtube.com/watch?v=b0nwTZY4dzM&list=PLtbUiCH_oPJjq3Khw0fP4sJIvpCG3gaYZ
https://www.youtube.com/watch?v=7hST93yHfGI&list=PLtbUiCH_oPJhyuZINbbkyGrUFRXkRGD6A
https://www.youtube.com/watch?v=x6YWVihgdoM&list=PLtbUiCH_oPJi9Tju3ImeZ6CNGmXBM_Pg7
https://www.youtube.com/watch?v=Iqq7Yel4xOA&list=PLtbUiCH_oPJjs0pKodMDHGszgYOVH81Xe
https://www.youtube.com/watch?v=clAbJwFl8_I&list=PLtbUiCH_oPJi7UW50kM9WdNDV4FX24g5c

https://www.youtube.com/watch?v=PkZNo7MFNFg&t=34s ----- JAVASCRIPT COURSE

https://www.youtube.com/watch?v=qEw-W1q1TKs
https://www.youtube.com/watch?v=IUdatwSItnU
https://www.youtube.com/watch?v=HZ_5e9rZNb0
https://www.youtube.com/watch?v=f3jgbM5_45s
https://www.youtube.com/watch?v=oetfjiL45NI

https://www.youtube.com/watch?v=WYEAbjwUnDY
https://www.youtube.com/watch?v=3Xza9K2A04U
https://www.youtube.com/watch?v=KLsQz_BtT24
https://www.youtube.com/watch?v=CYbnJHLu8Lc
https://www.youtube.com/watch?v=Nd16NfzuxII

About the job- Postgresql Developer - HTC global

1. The person should have experience in either RedShift Cluster or PostgreSQL

2. Some data is available in S3 which is also query the data
3. The person should be able to discuss with customers (internal), identify the
data point required, work backwards
to the design the data points, figure out what to do in order to provide the
data to the customers
4. Minimum Knowledge on Python Script (nothing on Pandas, NumPy etc.) . Plain
Python Scripting. If the person does not have
knowledge and if the candidate is good, we HTC can provide training on Python
scripting during the Boot camp period of Amazon
5. Should work on documenting the current ERD, Data Dictionary etc as we go along

-bhoj
https://www.youtube.com/watch?v=KipSZ2bYHfI
https://www.youtube.com/watch?v=RsAh4Z8fAfU&list=PLLri4Tn5jAjGB-
5eRVO8vqtPfTyaYQajy&index=8
https://www.youtube.com/watch?v=lcX2qEFCPyQ
https://www.youtube.com/watch?v=G1Ur5LEsHc0

postgre

Profiling and Optimizing SQL Queries

Coordinate with the developers, managers and leadership teams to build effective
databases
Collaborate with product managers,leadership teams, developers to make sure
database code meets demand and to build effective databases
Communicate with front-end developers to define plain yet dynamic APIs
Keep a check on data structures and quality of data with DBAs
Integrate and maintain database code in procedures, scripts, queries, and views

Expertise in time-series databases

Knowledge of message queuing, indexing, and high-performance data concepts
Familiarity with data structure and algorithms
Ability to profile databases
Ability to write database queries and code while maintaining data quality, privacy,
and security

oracle

Develop high-quality database solutions

Develop, implement and optimize functions and procedures using T-SQL
Review and analyze ongoing business requirements
Build useful and efficient reporting for deliverables
Analyze existing SQL queries and suggest new ones for performance improvements
Create scripts and procedures for data migration and offer timely scheduled
reporting
https://www.youtube.com/watch?v=Ps9fm8PFanw&list=PLaQDAUiZcql0AQupouJGXQFP0tuwFxgdA

redshift
Designing Table Models to Represent Information
Designing Sort and Distribution Keys
Processing Data Using Redshift
Debugging Queries
Exporting Data from Redshift
Serving Redshift Data to Other Sources

Implement Python code to build scalable application architectures

Develop efficient solutions for systems, databases, UI, and web services
Analyze existing software solutions to identify areas for improvement
Conduct multiple unit tests to ensure improved functionality of the applications
Design and deliver reliable, low-latency, and highly performant applications
Implement the best security practices throughout the development process
Discover, learn and apply new technologies, best design practices and usability
patterns to development processes
Implement and support technical solutions to deliver business requirements
Collaborate with product managers, data analysts, and developers to meet database
code requirements
Take care of the efficiency, integrity, and quality of database code and structures
-----------------------------------------------------------------------------------
-------------------------

https://www.linkedin.com/public-profile/settings?
trk=d_flagship3_profile_self_view_public_profile

https://database.guide/basic-sql-queries/
https://database.guide/category/sql/
https://www.w3resource.com/sql-exercises/

https://database.guide/category/dbms/ordbms/postgresql/
https://www.interviewquery.com/questions/average-commute-time
https://www.interviewquery.com/p/amazon-sql-interview-questions
https://www.w3resource.com/sql-exercises/sql-retrieve-from-table.php
https://pub.towardsai.net/5-tricky-sql-queries-solved-part-ii-8acceec170b0

https://www.geeksforgeeks.org/difference-between-natural-join-and-inner-join-in-
sql/
https://oracle-base.com/articles/misc/dml-returning-into-clause
https://mindmajix.com/postgresql-interview-questions
https://www.javatpoint.com/postgresql-interview-questions
https://www.postgresql.org/docs/current/xfunc-volatility.html
https://www.guru99.com/data-engineer-interview-questions.html
https://www.guru99.com/sql-interview-questions-answers.html
https://www.guru99.com/postgresql-tutorial.html
https://www.guru99.com/postgresql-tutorial.html
https://www.headway.io/blog/advantages-of-sql-views
https://www.geeksforgeeks.org/difference-between-grant-and-revoke/

https://www.educba.com/postgresql-features/
https://www.pgadmin.org/docs/pgadmin4/6.19/index.html
https://www.educba.com/postgresql-interview-questions/
https://www.tutorialspoint.com/python_data_access/python_mongodb_query.htm

https://pynative.com/python-database-programming-exercise-with-solution/
https://pynative.com/python-exercises-with-solutions/

https://towardsdatascience.com/crack-sql-interview-question-window-functions-with-
partition-by-599d792c07c3
https://www.kdnuggets.com/2022/06/24-sql-questions-might-see-next-interview.html
https://www.kdnuggets.com/tag/sql
https://www.kdnuggets.com/2020/12/crack-sql-interviews.html
https://medium.com/search?q=crack+sql+interview
https://medium.com/geekculture/comprehensive-sql-cheat-sheet-f821c5abf85a
https://towardsdatascience.com/sql-for-data-analysis-subquery-vs-cte-699ef629d9eb
https://www.postgresqltutorial.com/postgresql-administration/postgresql-show-
tables/
https://razorsql.com/articles/postgresql_system_queries.html
https://www.postgresql.org/docs/current/information-schema.html
https://www.geeksforgeeks.org/postgresql-data-types/
https://www.techonthenet.com/postgresql/index.php
https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-alter-table/
https://www.educba.com/postgresql-describe-table/
https://pynative.com/python-exercises-with-solutions/
https://database.guide/how-to-insert-multiple-rows-in-sql/
https://database.guide/category/dbms/ordbms/postgresql/
https://www.youtube.com/watch?v=4p-G7fGhqRk
https://www.youtube.com/watch?v=ZwFfiadQB3k

https://www.edureka.co/blog/interview-questions/sql-query-interview-questions
https://learnsql.com/cookbook/
https://www.w3resource.com/sql-exercises/adventureworks/adventureworks-
exercises.php#SQLEDITOR

https://artoftesting.com/sql-queries-for-interview#sql_minus_operator
https://techtfq.com/blog/top-20-sql-interview-questions
https://www.youtube.com/watch?v=AK7_m-aThfw
https://www.youtube.com/watch?v=Ngga7nEi1JE
https://www.youtube.com/results?
search_query=amazon+learning+management+system+olap+sql+interview+questions+and+ans
wers

Python Full Course for Beginners

https://www.youtube.com/watch?v=dFIutdyjhKg
https://www.youtube.com/watch?v=9D8XTUD7ATE&list=PLH-
JOUOB13K_mbOxAk171OPhxkVwaD1nO&index=6
https://www.youtube.com/watch?v=hEgO047GxaQ&list=PLsyeobzWxl7poL9JTVyndKe62ieoN-
MZ3&index=2&t=0s
https://www.python.org/jobs/6892/
https://www.enterprisedb.com/postgres-tutorials
https://www.javatpoint.com/python-multiprocessing
https://www.javatpoint.com/aws-devops
https://www.pythontutorial.net/
https://www.scaler.com/topics/python/what-is-python/
https://medium.com/analytics-vidhya/building-a-etl-pipeline-226656a22f6d
https://www.youtube.com/watch?v=m4RtVdluNPM
https://www.youtube.com/watch?v=kgSKzkdr2RI
https://www.edureka.co/blog/interview-questions/top-node-js-interview-questions-
2016/

databases mcq tests ( mysql, postgre)

https://www.youtube.com/watch?v=isyRlcv-TkE

https://www.youtube.com/watch?v=_uQrJ0TkZlc&t=18834s
https://www.youtube.com/watch?v=eWRfhZUzrAc
https://www.youtube.com/c/DurgaSoftwareSolutions
https://www.youtube.com/watch?v=aqvDTCpNRek&list=PLu0W_9lII9agICnT8t4iYVSZ3eykIAOME
https://www.youtube.com/watch?v=gfDE2a7MKjA&t=41876s
https://www.youtube.com/watch?v=qn0VbSFeTyY&list=PLLOxZwkBK52DmuHRO3UNpqAzDF57FtIxk
https://www.youtube.com/watch?v=k_5Q_dHSMCw
https://github.com/topics/paytm-payment-gateway
https://www.w3schools.com/python/default.asp
https://www.youtube.com/results?search_query=payment+gateway+integration+in+django

Top 10 Python Coding Interview Questions & Solutions for FAANG

https://www.youtube.com/watch?v=3AHzWOWRWvQ

Django Razorpay Payment Gateway Integration

https://www.youtube.com/watch?v=oXmBpkM2b8U

Integrating Payment Gateway: PayTM, UPI, Cards & NetBanking

https://www.youtube.com/watch?v=cdtPcTIuazI

Mastering django
https://www.youtube.com/playlist?list=PLLz6Bi1mIXhEXEnfAgUJXB0vLjHkyee6q

Python for Beginners

https://www.youtube.com/watch?
v=y_bPVnrM_eA&list=PLFV6T8f5WU2Gl1dhOn8xNgRvY6V5v39NP&index=1
https://www.programiz.com/python-programming/operators
https://www.scaler.com/topics/python/what-is-python/

E-Commerce Payment With Django

https://www.youtube.com/watch?v=tbYaQ5ALcN8

linkedin python assignment

https://www.youtube.com/watch?v=mf8J0F9mk_w

Python Coding Interview Practice - Difficulty: Hard

https://www.youtube.com/watch?v=TgCKJU3JvO4

20 Mostly Asked Python Question |

https://www.youtube.com/watch?v=s3nW1kdTT7w

Learnings paths
https://www.w3schools.com/java/default.asp
https://www.udemy.com/course/azure-devops-fundamental/learn/lecture/22337856?
start=0#overview
https://www.javatpoint.com/net-framework
https://log2base2.com/courses/python/escape-sequence-in-python
https://www.youtube.com/watch?v=SIDdbnT7lQI

https://www.youtube.com/watch?v=zPFZy6wKhVA
https://www.w3schools.com/python/python_comments.asp

How to Explain Project in Interview

https://www.youtube.com/watch?v=_ZfsMYidl-8

Top 100 Python Interview Questions |

https://www.youtube.com/watch?v=y0VpJZusBtg
https://www.youtube.com/watch?v=KwUY2fZ04Bg
Django Tutorial || Django Online Training by Durga Sir
https://www.youtube.com/watch?v=tLpcxBmGJW8&list=PLd3UqWTnYXOkm_MTKVZ8CJmgJ6sfLUIWK

Python Tutorilas | Python Interview Questions | Session - 1, 2 3|

https://www.youtube.com/watch?v=XqAHhnXTtIE
https://www.youtube.com/watch?v=EiTh_nLv-uY
https://www.youtube.com/watch?v=AI6omceuZUY

django- python interview quest

https://github.com/PragatiVerma18/DRF-Interview-Prep
https://www.youtube.com/watch?v=Yb5gkJiWn4w&t=5s
https://www.youtube.com/watch?v=ERHTOvQCOBs
https://mindmajix.com/django-interview-questions
https://www.javatpoint.com/django-interview-questions-and-answers
https://www.adaface.com/blog/top-django-interview-questions-with-answers/
https://www.kausalvikash.in/python-django-interview-questions-and-answers-for-
freshers/
https://hackr.io/blog/top-django-interview-questions-and-answers
https://www.simplilearn.com/django-interview-questions-article
https://www.youtube.com/watch?v=uyaGIvTQBSY
https://www.youtube.com/watch?v=KwUY2fZ04Bg
https://www.youtube.com/watch?v=9ai0b1LRMQM
https://career.guru99.com/top-16-django-interview-questions/
https://hackr.io/blog/top-django-interview-questions-and-answers
https://mindmajix.com/django-interview-questions
https://www.kausalvikash.in/python-django-interview-questions-and-answers-for-
freshers/
https://www.youtube.com/watch?v=F8Ow2tdle9A
https://www.adaface.com/blog/top-django-interview-questions-with-answers/
https://github.com/PragatiVerma18/DRF-Interview-Prep
https://www.youtube.com/results?
search_query=django+cms+interview+questions+and+answers
https://www.youtube.com/watch?v=Yb5gkJiWn4w&t=5s
https://www.youtube.com/watch?v=ERHTOvQCOBs

https://www.simplilearn.com/django-interview-questions-article
https://career.guru99.com/top-16-django-interview-questions/
https://morioh.com/p/bb5647450cbe

https://www.youtube.com/results?
search_query=django+oscar+and+wagtail+interview+questions+and+answers
https://www.youtube.com/results?
search_query=django+oscar+interview+questions+and+answers

https://www.youtube.com/watch?v=9ai0b1LRMQM

https://www.youtube.com/watch?v=uyaGIvTQBSY

https://www.youtube.com/watch?v=iuUxoudgOhU

https://www.youtube.com/watch?v=cWPsXFAPF_4 --- CHETAN

-----------------------------------------------------------------------------------
----------