Back To SQL

Junji Zhiprogramming$0

SQL is useful, universal, and an evergreen skill that wins you respect.

We offer this course for engineers and data analysts to gain SQL fluency. After taking the course, you would be able to read and write SQL like a second nature.

Why should you care?

The ability to compose queries and extract insights from production data is an invaluable skill.

Knowing SQL is powerful.

Being able to quickly write queries, glean insights from production and generate organized CSVs make you helpful. SQL gets the job done and others can depend on you.

SQL is a core developer skill.

Regardless of databases or SQL flavours or database your company uses, it's an incredible skill to be able to write queries and get results back within seconds.

SQL as a career booster.

At some point, you need to get data out of relational databases. You don't want to always talk to senior engineer or DBA to troubleshoot data issues, or filter error logs. Once you gain SQL fluency, it follows you from job to job.

It's a technology that lasts

SQL isn's the trendiest, and is often overlooked. Over the last decades, it has outlasted VBScript, VBA, Java, C#, Javascript, Typescript and Python, and will do many more in the foreseeable future.

Who is the course for?

Developers and analysts. We expect you to have basic knowledge about software development. This course will not cover the fundamentals about databases and SQLs. Instead, we focus on the hands-on part of SQL. After going through the materials, you can immediately apply to your work.

How does the course content look?

We believe that, a big part of software craftsmanship is acquired by watching how experienced engineers think and use the language and tools. The course will be mainly delivered in videos and exercises. You can gain enough exposure and hone the skills along the way. We cover the following aspects about SQL.

Comfort with SQL

  • Join tables
  • Filter results
  • Group by
  • Nested queries

Think in SQL

  • Convert problems into SQL queries
  • Query performance
  • Troubleshoot data issues

Good SQL Habits

  • Good indentation
  • SQL Linting