What You’ll Learn
We’ve divided our SQL Fundamentals course into two parts — this is the second part. If you missed the first part or would like a refresher, check out the lessons from the previous course! In this second part of our SQL Fundamentals course, you’ll learn intermediate concepts and techniques that will prove invaluable to your data science workflow, no matter what specific role you assume in data science.
Working in data science requires that you work with databases, and sometimes databases can be immense and disorganized. That’s why SQL is such a valuable asset for data professionals. In this course, you’ll learn how to precisely identify, filter, and extract the data you need using SQL functions, operations, expressions, and more.
Enroll in this course if you want to do the following:
- Identify different data types
- Execute operations between columns
- Define aliases and functions
- Employ nested functions
- Resolve missing values
- Define expressions and conditions
- Identify the order of execution
- Employ the `BETWEEN` and `LIKE` operator
- Filter based on patterns
- Check if an expression is `NULL`
- Program if/then rules
How Our SQL Fundamentals Part II Course Works
Even though SQL is half a century old, it’s one of the most important skills to learn if you want a data career. Big companies like Uber, Netflix, and Airbnb all use SQL. Also, it’s more in-demand now than ever. Currently, over 50% of data job postings on Indeed list SQL as a required skill.
At Dataquest, it’s our job to help you develop these in-demand data science skills so that you excel in your data science career. Since SQL is such a prominent part of data science, we’ve created our SQL Fundamentals skill path, including this course. We’ve carefully designed our lessons to give you the structure you need as well as the freedom to explore and maximize learning.
Here at Dataquest, we believe in learning by doing. That’s why we’ll never ask you to sit through boring training videos or ineffective “fill-in-the-blank” questions. Instead, we believe the best way to learn data science skills is by solving real problems with actual code.
Additionally, with Dataquest, you’ll never learn alone. By signing up with us, you’ll become a part of our supportive community of data learners and professionals who are eager to help you overcome any obstacle. And if you ever need a little extra help, our powerful and responsive support tools are just a click away.
Here’s a glance at our SQL Fundamentals course:
- This course is the second course in the SQL Fundamentals skill Path. It consists of the seven lessons listed below, which cover intermediate coding concepts in SQL.
- You’ll write real code with dozens of practice problems so you can apply your skills.
- When you complete this course, you’ll receive a certificate that you can share with your professional network.
- Once you complete this course, you’ll be ready for more advanced SQL courses.
- Engage with our friendly community of data professionals, get feedback on your projects, and keep building your skills.
Enroll in this course to learn SQL Fundamentals Part II!
Filtering and Sorting Data in SQL Lessons List
Datatypes and Column Operations
In this lesson, learn all about datatypes, string operations, and column operations. Learn to use documentation and how to define aliases.
Control Flow
In this lesson, learn how to code if/then/else rules in SQL and how to use the “CASE” expression.
Ordering Results
Learn how to order results in this lesson using the Chinook Music Store Database.
Who Is this SQL Fundamentals Course for?
We created this SQL course for beginners, but it does require prerequisite knowledge of basic SQL concepts and techniques from our previous course. If you haven’t completed Part I of our SQL fundamentals course, we strongly recommend you return to our previous lessons before starting this course.
This SQL beginners course has a broad application — we didn’t design it for any one kind of person. Here are a few examples of people who could benefit from these lessons in SQL:
- Data science beginners looking for fundamental SQL knowledge for data science
- SQL beginners seeking proficiency with basic operations in SQL
- People who want a career as a data analyst, data engineer, or data scientist
- People seeking remote work in data science
- Anyone who works with data in telecommunication, finance, education, and healthcare
- Junior data analysts or data scientists who want to advance in their current positions
- Anyone who wants to be able to capture, process, and interpret data
- Students who wish to develop a competitive portfolio
- Experienced SQL users who want to brush up on the basics
Students Who Enrolled in this Course Also Enrolled in these:
If you’re one of the many thousands learning SQL for a data science career, we encourage you to enroll in any of the following. We’ve crafted these paths specifically to help you develop the in-demand skills you need to jump-start your data science career:
Or perhaps you already have a data science background. If you simply want to expand your knowledge base and broaden your skill set, we’re happy to recommend the following courses to enhance your job performance:
Qualify for In-demand Jobs in Data Science With SQL
SQL has stood the test of time and remains the universal language for databases — and one of the most necessary skills for any career in data science. Consequently, proficiency in SQL is in very high demand across a variety of industries and data positions.
With the skills you’ll learn in this course, you’ll be ready for success in any of the following in-demand data specializations:
- Data analyst
- Business analyst
- Financial analyst
- Data scientist
- GIS analyst
- Data engineer
- Software engineer
- Biotech analyst
- Data architect
- ML engineer
- Technical Data Analyst
- Research data analyst
- Data Warehouse Engineer
- Technical Architect
