After you finish the course and Practice exercises, you’ll know everything to apply SQL at work and answer any question with data.
Imagine that you’ll be typing 20-30 queries every day, which is 100-150 queries a week or 5000-7000 queries a year.
If we can save a minute on each query by learning keyboard shortcuts we can roughly save 10 days a year on typing SQL. 2-week vacation from typing SQL effectively – not bad, huh?
The most frequent thing you’ll be doing in the course and later at work is clicking on a “Run query”. Hundreds and hundreds of times.
To submit a query (or any form on SQL Habit ) press:
CMD + Enter on Mac
CTRL + Enter on Windows
Rarely you’ll need to type the whole keyword in the SQL Editor – all thanks to autocomplete. It’ll suggest you SQL keywords, table and column names.
Just press the Tab key to complete the suggested word.
This is the shortcut I can’t live without. I use it all the time when moving a query to a subquery. I mean from this:
SELECT * FROM users WHERE status = 'customer'
into this by moving this query one tab to the right and a couple of lines up inside the
WITH ... AS statement:
WITH customers AS ( SELECT * FROM users WHERE status = 'customer' ) SELECT * FROM customers
You’ll find all the details about it in the course later. For now just remember that:
CTRL + [ will move selection one tab to the left
CTRL + ] will move selection one tab to the right
You can also move selected lines one tab to the right by pressing Tab.
To move a number of selected lines up or down press:
To move between words in a line you can use left/right keys – they’ll move the cursor one character at a time.
A more efficient way is to jump between words. All you need to do is to press:
Of course, if you need to move to the beginning or end of the line jumping between words could also become inefficient.
We can jump straight to the beginning or end of the line by pressing:
CMD + or on Mac
CTRL + or on Windows
If you want to roll back the recent changes you made just press:
CMD + z on Mac CTRL + z on Windows
Good news: these shortcuts work in the vast majority of code editors. You can use them to edit SQL queries, code in any other programming language or even plain text for your notes or a blog post.
Try to master these shortcuts as you go through the SQL Habit course and remember – it’s all about a 2-week vacation
Hi, it’s Anatoli, the author of SQL Habit.
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work.