Tag: SQL

Learner Spotlight – Ashray Adappa

Ashray started his professional journey in chemical engineering, but when he felt like he had lost his way, he discovered data science, taught himself on the Dataquest platform, and landed a job as a data analysis consultant. This is the story of how he decided to change his life, step by step. 1. First, what […]

Read More

Learner Spotlight – Otavio Silveira

Meet Otavio Silveira, an economics graduate who discovered Python and data science when trying to learn Python and SQL on YouTube to improve his chances of landing his first job in data. He joined Dataquest and later won a scholarship which he used to complete his learning path. Here’s his story… 1. First, what are […]

Read More

Learner Spotlight – Rahila Hashim

Meet Rahil Hashim, a zoology graduate with no prior experience in programming who enrolled in Dataquest’s SQL path after winning one of our scholarships. Keep reading to find out how Rahila took advantage of Dataquest’s courses to land a job as a technical data scientist. 1. First, what are your preferred pronouns? She/her 2. All […]

Read More

Why does SQL Server Consume So Much Memory

According to the company, Microsoft SQL Server is a relational database management system (RDBMS). In relational databases, all SQL Servers use the SQL programming language, which is well-known and widely used. Microsoft created SQL Server’s Transact-SQL implementation, also referred to as T-SQL, used by SQL Server. A number of programming constructs not found in SQL […]

Read More

Learner Spotlight – Viktoria Jorayeva

Meet Viktoria Jorayeva, a Ukrainian student who made the transition from philology to data science in just a few months with Dataquest. As a person from a non-technical, non-mathematical background, breaking into the field of data science was possible thanks to Dataquest’s data science career path. Her story is a true inspiration to learners around […]

Read More

SQL Operators: 6 Different Types (w/ Examples)

We have previously covered why you need to learn SQL to get a data job in 2021, as well as publishing a full list of SQL commands to help you get started. Next, we’re going to be looking at SQL operators. We’re going to cover what exactly SQL operators are, before providing a comprehensive list […]

Read More

How Long Does It Take to Learn SQL?

How long does it take to learn SQL? It depends on your goals and your background, so we’ve broken down a variety of scenarios for you.

Read More

SQL vs T-SQL: Understanding the Differences

SQL or T-SQL — which one do you need to learn? SQL ​and T-SQL both see heavy use in the database and data science industries. But what exactly are they? These two query languages are very similar, both in name and in what they can do, so the distinction between them can be difficult to […]

Read More

The Best Way to Learn SQL (According to Seasoned Devs)

What’s the best way to learn SQL? With all of the resources available, learning SQL the “right way” can be difficult. Finding the best way to learn SQL is tricky because everyone learns things differently. But, after training tens of thousands of students — seeing what works and what doesn’t — we’ve come up with […]

Read More

SQL vs MySQL: A Simple Guide to the Differences

SQL and MySQL are important tools for working with data. But what are they, exactly, and how are they different? Let’s clear that up.

Read More

SQL Interview Questions — Real Questions to Prep for Your Job Interview

A lot of the SQL interview questions you’ll find on the web are generic: “What is SQL?” You’ll never be asked that. We’ve got real questions to help you prep.

Read More

SQL Basics — Hands-On Beginner SQL Tutorial Analyzing Bike-Sharing

Learn the SQL basics and go hands-on querying databases as you analyze bike rental data in this free beginner SQL tutorial.

Read More

Want a job in data? Learn SQL.

Learning SQL might not be as “sexy” as learning Python or R, but it’s a fundamental skill for almost every data scientist and data analyst job. Here’s why.

Read More

SQL Cheat Sheet — SQL Reference Guide for Data Analysis

Whether you’re learning SQL through one of our interactive SQL courses or by some other means, it can be really helpful to have a SQL cheat sheet. Bookmark this article, or download and print the PDF, and keep it handy for quick reference the next time you’re writing an SQL query!   Our SQL cheat […]

Read More

Do You Need a SQL Certification to Get a Data Job in 2021?

If you want to work in data, do you need a SQL certification? That’s a question that can be difficult to answer, especially with different organizations pushing to get you to spend money on their certificate programs. Will getting a SQL certification actually help you get a job? Do you need to learn SQL? Yes. […]

Read More