Searched for
252 results found SQL
5 Things I Learned Writing SQL with Gen AI
Uncategorizedposted by ODSC Community April 10, 2023
ChatGPT has been all over the news for the last few months and again with the release of GPT-4. At DataDistillr, we added a query assistant using this technology which allows a user to simply ask a question and DataDistillr will generate a query that answers that question. I decided... Read more
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 everyone in the data... Read more
5 Easy SQL Tricks to Clean Dirty Data
PythonTools & Languagesposted by ODSC Community November 10, 2022
Real-world data is almost always messy. And as a data scientist or analyst, you need to discover the facts about the data. To do so, the data must be tidy and free from errors. Hence, the very first step is to clean the data. Therefore, I summarized 5 tips that... Read more
Don’t Sleep on SQL – 5 Reasons Why it’s a Must-Have Skill in 2022
ModelingTools & LanguagesSQLposted 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 use in data analysis,... Read more
5 SQL Data Wrangling Techniques Every Expert Should Know
Data WranglingModelingSQLposted 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 data directly at the... Read more
When SQL is Not the Best Answer: Identifying “Graph-y” Problems and When Graphs Can Help
Data VisualizationModelingEast 2022posted by ODSC Community March 18, 2022
Data scientists work with columns and rows. This is at the core of our training and we are very good at it! From SQL tables to Pandas dataframes and everything in between, we like our columnar data. We thrive best in the assumption that each of our rows is an... Read more
Best Practices: SQL Formatting
Tools & LanguagesSQLposted 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 the key to a... Read more
To Learn SQL or Not is the Question
Blogs from ODSC SpeakersConferencesModelingAPAC 2020SQLposted 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 rise of data lakes,... Read more
Getting Started with Dask and SQL
ModelingAzureCoileddaskposted by ODSC Community November 9, 2020
Lots of people talk about “democratizing” data science and machine learning. What could be more democratic — in the sense of widely accessible — than SQL, PyData, and scaling data science to larger datasets and models? Dask is rapidly becoming a go-to technology for scalable computing. Despite a strong and... Read more
A Sneak Peek at SQL Bootcamp for Data Science
Featured PostAI PlusSQLposted 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 their first virtual conference... Read more