SQL Archives

5 Reasons Why SQL is Still the Most Accessible Language for New Data Scientists

Modeling SQLposted by ODSC Team March 7, 2023

For budding data scientists and data analysts, there are mountains of information about why you should learn R over Python and the other way around. Though both are great to learn, what gets left out of the conversation is a simple yet powerful programming language that... Read more

Don’t Sleep on SQL – 5 Reasons Why it’s a Must-Have Skill in 2022

Modeling Tools & Languages SQLposted by ODSC Team July 21, 2022

While we mostly hear about Python, R, and Julia in regards to coding for data science, SQL (Structured Query Language) still has its place as a fundamental skill that supplements more popular languages. Given its ease of use and ability to quickly get started, its versatile... Read more

5 SQL Data Wrangling Techniques Every Expert Should Know

Data Wrangling Modeling SQLposted by Sheamus McGovern July 13, 2022

Data wrangling is an essential job function for data engineering, data science, or machine learning roles. As knowledgable coders, many of these professionals can rely on their programming skills and help from libraries like Pandas to wrangle data. However, it can often be optimal to manipulate... Read more

Best Practices: SQL Formatting

Tools & Languages SQLposted by ODSC Community May 19, 2021

We take a holistic approach towards best practices at 173Tech. Data and analytics are here to guide us in our daily decisions. It needs to be clearly defined, trusted, and easily digestible for everyone. We build quality and thoughtfulness into all aspects of our processes. It is... Read more

To Learn SQL or Not is the Question

Blogs from ODSC Speakers Conferences Modeling APAC 2020 SQLposted by ODSC Community November 30, 2020

It is generally a major debate amongst many data analysts and data scientists if they should learn SQL to be able to do their job, especially when you have great packages and libraries to ingest data in R/Python directly. In today’s day and age with the... Read more

A Sneak Peek at SQL Bootcamp for Data Science

Featured Post AI Plus SQLposted by ODSC Community September 2, 2020

For years now, ODSC has served as a resource for data professionals to connect, learn from each other, and contribute back to the community as our field moves forward at a lightning pace. Their commitment to data science has extended into the current pandemic, resulting in... Read more

Complex Queries in SQL

Tools & Languages SQLposted by Robert de Graaf March 5, 2020

Hopefully, your SQL queries aren’t tangled like this. (Photo: Author) Texts on SQL are good at providing the basic templates of SQL syntax, but sometimes the queries in those books are a little idealized compared to real life, with no more than two or three tables... Read more

How to Get Started with SQL

Featured Post Tools & Languages SQLposted by Kailen Santos June 19, 2019

Just about every popular app and social media platform has an engine under the hood that powers the information and data we absorb. With hundreds of millions of data points to keep track of, there has to be a well-oiled machine to maintain that database. Every... Read more

3 Sought-After Data Science Skills to Get Hired in 2019

Career Insights Featured Post Modeling Career insight SQL XAIposted by Elizabeth Wallace, ODSC January 8, 2019

Getting a job in data science is a wide-open prospect. Standing out and being successful is another story. Don’t languish in mediocre data science hell. Get to work on these essential skills to stand out in the data science field, get hired, and thrive, and find... Read more

The Five Best Frameworks for Data Scientists

Modeling apache kafka frameworks jupyter Scikit-Learn SQL TensorFlowposted by Alex Landa, ODSC October 25, 2018

There are many tools that can help you when you start your data science career. Some of these tools you will be using them almost in every new project. In this post, we aim to highlight the five best frameworks for data scientists so that you... Read more