6.1 Learn SQL - Milancho/CareerPathGuideline GitHub Wiki
๐๐ผ๐ ๐๐ผ ๐น๐ฒ๐ฎ๐ฟ๐ป ๐ฆ๐ค๐?
Structured Query Language (SQL) is a domain-specific language used in programming and designed for managing data held in relational database management systems for many years now. It was developed at IBM in the early 1970s. As relational databases are still very much popular, the need to use them is still present for any developer.
The SQL language has ๐ฐ๐น๐ฎ๐๐๐ฒ๐, which are components of statements and queries, ๐ฒ๐ ๐ฝ๐ฟ๐ฒ๐๐๐ถ๐ผ๐ป๐, that can produce scalar values or tables, ๐ฝ๐ฟ๐ฒ๐ฑ๐ถ๐ฐ๐ฎ๐๐ฒ๐, which specify conditions that can be evaluated to SQL three-valued logic, and ๐พ๐๐ฒ๐ฟ๐ถ๐ฒ๐, which retrieve data based on criteria and some other elements.
So, the question is ๐ต๐ผ๐ ๐๐ผ ๐น๐ฒ๐ฎ๐ฟ๐ป ๐ฆ๐ค๐. Here are some (free) resources that I can recommend:
- Learning Path
- Get Started Querying with Transact-SQL
- Program with Transact-SQL
- Write advanced Transact-SQL queries
- ๐ฆ๐ค๐๐๐ผ๐น๐ - is a completely free fully interactive introductory course. All SQL basics are covered including writing queries, filtering, joins, and aggregations in addition to creating, updating, and deleting tables.
- ๐ฆ๐ค๐๐ญ๐ผ๐ผ - It provides both tutorials and exercises, and thatโs why it is equally useful for someone just starting with SQL and programmers who know SQL but want some good practice to really master it.
- ๐ฆ๐ค๐ ๐ง๐๐๐ผ๐ฟ๐ถ๐ฎ๐น ๐ฎ๐ ๐๐ฟ๐ฒ๐ฒ๐๐ผ๐ฑ๐ฒ๐๐ฎ๐บ๐ฝ - This SQL course has got more than 7 million views and I think it's Youtubeโs most popular free SQL course.
- ๐ฃ๐ผ๐ฝ๐ฆ๐ค๐ - is actually a really interesting tool for collaborative SQL querying. It enables multiple users to share queries, store commonly used queries in a searchable library, and provide a visual interface for analysis.
- ๐๐ฒ๐ฎ๐ฟ๐ป๐ถ๐ป๐ด ๐ฆ๐ค๐ ๐ฏ๐ ๐๐น๐ฎ๐ป ๐๐ฒ๐ฎ๐๐น๐ถ๐ฒ๐ ๐ณ๐ฟ๐ฒ๐ฒ ๐ฏ๐ผ๐ผ๐ธ - This book provides some helpful context regarding the language's history and current usage, offers an overview of query and table architecture, and covers some more complex SQL subjects than the courses mentioned above.
- ๐ฆ๐ค๐๐๐น๐ผ๐ - a nice tool to visualize and analyze SQL.
- ๐๐ฅ๐๐ ๐๐๐ข๐ข๐ - ๐๐ฒ๐ฎ๐ฟ๐ป๐ถ๐ป๐ด ๐ฆ๐ค๐
- This is a free unaffiliated eBook created by Stack Overflow contributors, where you can learn from the basics of SQL, through Clean Code in SQL and Common Table Expressions to some different in different DB engines.
