Picture by Creator
The web is brimming with sources for studying SQL. Most of them, after all, require paying for data. These sources additionally primarily educate you primary or, at greatest, intermediate SQL.
The query is, how you can be taught SQL and do it totally free. Are there any sources in any respect that can educate you superior SQL with out paying?
Sure, there are. In actual fact, there are a minimum of 5, as I found.
Earlier than in search of the programs, I needed to outline what superior SQL means.
What’s Superior SQL?
It’s not straightforward to pin this down, as completely different specialists have completely different views (and instructing expertise) on which SQL ideas could be thought-about superior.
Nonetheless, I feel it’s secure to say that these subjects are superior SQL:
- JOINs
- CTEs
- Recursive CTEs
- Subqueries and Correlated Subqueries
- Window Features
- Pivoting and Unpivoting Knowledge
- Hierarchical Queries
- Views
- Saved & Consumer-Outlined Procedures and Features
- Triggers
- Momentary Tables
- Indexes
- Knowledge Normalization
- Efficiency Optimization
The listing is incomplete, nevertheless. Another subjects that additionally belong to superior SQL could be added. How will you say in the event that they’re superior? I’ve a extremely unscientific however environment friendly methodology: in the event you don’t know what a selected subject means, it’s most certainly superior SQL.
Free Assets for Superior SQL
Picture by writer
The sources I listing right here cowl some or a lot of the superior SQL ideas I discussed earlier. When you mix these sources, your superior SQL data can turn into much more healthful. Sure, I do know it requires a bit extra effort, however hey, these are all free. What did you count on?
1. Mode SQL Tutorial
Hyperlink to useful resource: Mode Analytics SQL Tutorial
Description: This tutorial teaches you superior SQL within the Mode BI device. No want to fret that you simply’ll need to be taught yet one more SQL taste; Mode makes use of normal SQL.
All of the ideas are defined theoretically intimately. In every lesson, there are additionally interactive workout routines the place you may follow fixing issues by writing SQL queries and test the solutions.
Talking of ideas, you’ll study subqueries, window features, tuning SQL queries, and pivoting knowledge. As well as, there are classes about knowledge varieties, date codecs, and string features.
When you really feel you’re fighting among the much less superior subjects in these classes, you may all the time revisit them within the Primary SQL and Intermediate SQL sections of the tutorial.
2. StanfordOnline: Databases: Superior Matters in SQL
Hyperlink to useful resource: edX
Description: This course is considered one of 5 programs on databases supplied by Stanford College and hosted by edX.
Of the superior subjects, you can be taught indexing to enhance question efficiency, transactions, database constraints and triggers, and views.
It can take you two weeks to finish the course, with 8-10 hours per week.
As well as, you may take programs on OLAP and recursion, modeling and idea, and semistructured knowledge in the event you’re serious about these subjects.
3. Kaggle Superior SQL
Hyperlink to useful resource: Kaggle Superior SQL
Description: Kaggle’s cute little course will take solely 4 hours to finish. It covers JOINs and UNIONs, analytic (or window) features, nested and repeated knowledge, and recommendations on writing environment friendly queries.
Every lesson gives detailed theoretical explanations complemented by sensible examples. On the finish of every lesson, you’ll find a hyperlink to a bit that exams your understanding by supplying you with a number of workout routines to resolve by writing code.
4. Superior SQL (Summer time 2020)
Hyperlink to useful resource: YouTube
Description: This video course consists of lectures by the Database Analysis Group on the College of Tübingen, Germany.
There are 58 movies, most of them round a half-hour. They cowl subjects equivalent to subqueries, set operations, GROUP BY extensions, knowledge varieties, arrays, window features, user-defined features, recursive CTEs, and plenty of, many extra.
5. SQL for Net Nerds
Hyperlink to useful resource: Philip Greenspun’s private web site
Description: This on-line guide was written by Philip Greenspun, a US laptop scientist and educator.
It combines theoretical and sensible explanations by way of code and real-world examples. Most examples use the information mannequin for net companies and are written in Oracle SQL dialect.
This useful resource will educate you triggers, views, bushes, database tunings, and plenty of extra.
Bonus: Virtually Free Assets
As a bonus, I wished so as to add two virtually free sources: StrataScratch (sure, the platform I based) and LeetCode, two platforms with precise SQL coding interview questions.
Virtually free, as in very low-cost? No, free in a method that they require a paid subscription to entry all questions but additionally have a considerable variety of freemium questions.
Now we have 75 free questions at StrataScratch, most of them of medium or arduous issue. You’ll positively discover a stable variety of them to check your superior SQL data. To make looking simpler for you, there’s an in depth filter the place you may filter by subject, issue, and firm, amongst different issues.
There’s additionally an interactive code editor for writing your answer in a number of SQL flavors (PostgreSQL, SQL Server, MySQL, and Oracle) and validating it. All of the questions have hints and official options with detailed explanations.
LeetCode has the identical variety of questions if I counted accurately. Nonetheless, they’re, normally, categorized as straightforward or medium, which may make in search of superior subjects somewhat trickier. However, I’m certain you’ll be capable of discover some good questions for practising the subjects I discussed at the start of this text. Like StrataScratch, LeetCode additionally has detailed options and an interactive code editor permitting code-writing in a number of SQL dialects.
Conclusion
There it’s – 5 sources that can educate you superior SQL strategies and do it totally free. They’re additionally high quality sources, which makes for higher studying.
Three sources are basic on-line SQL programs that cowl completely different superior subjects. I threw within the combine one thing completely different, too: one YouTube course by a high German college and one on-line guide by a acknowledged knowledgeable and educator.
A number of the subjects lined in these sources overlap, however some are distinctive to every useful resource. When you don’t discover what you’re in search of in a single course, you may all the time mix the sources and fill within the gaps.
As a bonus, there are two interview query platforms, StrataScratch and LeetCode, that provide some questions totally free.
I hope you’ll discover all these a precious useful resource for studying superior SQL. Completely happy studying!
Nate Rosidi is an information scientist and in product technique. He is additionally an adjunct professor instructing analytics, and is the founding father of StrataScratch, a platform serving to knowledge scientists put together for his or her interviews with actual interview questions from high corporations. Nate writes on the most recent traits within the profession market, offers interview recommendation, shares knowledge science tasks, and covers every part SQL.
