# Path to SQL

## Basics
You need to learn the basics of reading/writing data, filtering over the data, creating tables and all of that.
- https://www.khanacademy.org/computing/computer-programming/sql#sql-basics
- https://www.coursera.org/learn/sql-for-data-science?specialization=learn-sql-basics-data-science
- SQL Operations: https://mode.com/sql-tutorial/introduction-to-sql/
- Summary: https://www.geeksforgeeks.org/sql-concepts-and-queries/

## Data Structures
A more advanced subject that needs to be mastered. Each data structure is useful for a typical problem (think of them as Patterns, you have a specific problem, you solve it with a certain concept). You need to know when to use each type and what problem it solves, more than knowing the exact syntax. The main data structures are:

- Tables and Indexes: https://www.sqlshack.com/sql-server-indexes-series-intro/
- https://docs.oracle.com/en/database/oracle/oracle-database/21/cncpt/oracle-relational-structures.html#GUID-54C48ABE-E589-428A-849F-B8746C9D276A
- More advanced data structures: https://arctype.com/blog/data-structures-in-sql/

## Concepts
These are concepts that you need to know.

- Keys: https://www.analyticsvidhya.com/blog/2020/07/difference-between-sql-keys-primary-key-super-key-candidate-key-foreign-key/
- Transaction processing properties: https://www.ibm.com/docs/en/cics-ts/5.4?topic=overview-transaction-processing
- Query optimization: https://www.analyticsvidhya.com/blog/2021/10/a-detailed-guide-on-sql-query-optimization/

## Tangential Subjects
- Dialects: https://arctype.com/blog/sql-dialects/
- Big Data Concepts: https://www.digitalocean.com/community/tutorials/an-introduction-to-big-data-concepts-and-terminology
- BI list of subjects and tools: https://github.com/thenaturalist/awesome-business-intelligence

## Interview Questions
A list of ressources of typical questions about SQL in an interview.
- https://www.geeksforgeeks.org/sql-interview-questions/
- https://www.mlstack.cafe/interview-questions/sql
- https://www.mlstack.cafe/interview-questions/databases
- https://www.interviewbit.com/sql-interview-questions/
- https://www.guru99.com/sql-interview-questions-answers.html

## Ressources
- Look at the table at the bottom of this wikipedia page: https://en.wikipedia.org/wiki/Database_index
- Specialization: https://www.coursera.org/specializations/learn-sql-basics-data-science
- Oracle's course for the certification: https://learn.oracle.com/ols/learning-path/become-a-oracle-sql-expert/55700/55730
- List of tutorials and courses: https://hackr.io/tutorials/learn-sql