Neil Sainsbury

Popular pages

• Mathematics for the adventurous self-learner | Neil Sainsbury

  Neil Sainsbury Mathematics for the adventurous self-learner For over six years now, I've been studying mathematics on my own in my spare time - working my way through books, exercises, and online cour...

• Advanced SQL and database books and resources | Neil Sainsbury

  Neil Sainsbury Advanced SQL and database books and resources For people who've worked through Mastery with SQL, a common question I get is "What's next?" If you completed the course and all 150+ exerc...

• Joins: USING vs ON for join conditions | Neil Sainsbury

  select * from departments; select * from employees; dept_id|description | -------|------------------------| 1|Accounting | 2|Finance | ...

• Logging raw SQL to the console in Django | Neil Sainsbury

  Neil Sainsbury Logging raw SQL to the console in Django When working on a Django project it can be useful to see the raw SQL queries being made to your database - you can quickly and easily identify w...

• Implementing SQL Server's WITH TIES in PostgreSQL | Neil Sainsbury

  Neil Sainsbury Implementing SQL Server's WITH TIES in PostgreSQL SQL Server supports a TOP (N) WITH TIES clause which can be used to return the top N rows from a query along with any additional rows t...

• Mastery with SQL is out now! | Neil Sainsbury

  I'm so thrilled with how it's turned out. My goal when I set out was to build a course that's exercise-centric. I'm an avid learner who loves studying new domains, and in my experience one of the best...