- 5 Free SQL Courses for Data Science Beginners - Apr 8, 2024.
Are you looking to make a career in data science? Start by learning SQL with these free courses.
SQL
- Boost Your Data Science Skills: The Essential SQL Certifications You Need - Mar 13, 2024.
If you are a data scientist who works with large amounts of data and hasn’t learned SQL yet - now might be the time.
SQL
- 5 Free Courses to Master SQL for Data Science - Mar 6, 2024.
Want to become an SQL expert? Check out these free courses to learn and hone your SQL skills for data science.
SQL
- 5 Free University Courses to Learn Databases and SQL - Mar 5, 2024.
Looking to learn SQL and databases to level up your data science skills? Learn SQL, database internals, and much more with these free university courses.
SQL
- Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts - Feb 6, 2024.
This article introduced you to the world of ranking functions in SQL. We will cover the basics of how they work, how they're used, and how to avoid common pitfalls.
SQL
- The Essential Guide to SQL’s Execution Order - Feb 6, 2024.
Discovering the Hidden Logic Behind SQL's Command Order.
SQL
- A Step by Step Guide to Reading and Understanding SQL Queries - Jan 30, 2024.
Complex queries seem intimidating, but this guide gives you insight into how to work more easily with SQL queries.
SQL
- SQL Simplified: Crafting Modular and Understandable Queries with CTEs - Jan 26, 2024.
Learn how to write SQL queries that are not just code but clear, modular, and reusable work.
SQL
- 5 Super Helpful SQL Cheat Sheets You Can’t Miss! - Jan 19, 2024.
Want to refresh your SQL skills? Bookmark these useful cheat sheets covering SQL basics, joins, window functions, and more.
SQL
- SQL Group By and Partition By Scenarios: When and How to Combine Data in Data Science - Jan 15, 2024.
Learn the generic scenarios and techniques of grouping and aggregating data, partitioning and ranking data in SQL, which will be very helpful in reporting requirements.
SQL
- Data Cleaning in SQL: How To Prepare Messy Data for Analysis - Jan 5, 2024.
Want to clean your messy data so you can start analyzing it with SQL? Learn how to handle missing values, duplicate records, outliers, and much more.
SQL
- SQL for Data Visualization: How to Prepare Data for Charts and Graphs - Nov 2, 2023.
Unlock the Power of SQL in Data Visualization: Master the Art of Preparing Data for Impactful Charts and Graphs.
SQL
- 5 Free Books to Master SQL - Oct 31, 2023.
Use this knowledge to upskill yourselves.
SQL
- Introduction to Databases with SQL: Free Harvard Course - Oct 20, 2023.
Want to learn SQL the Harvard way? Start learning today with CS50 SQL, a free course on databases with SQL from Harvard.
SQL
- Why SQL is THE Language to Learn for Data Science - Oct 12, 2023.
SQL is the essential data science language due to its universal database accessibility, efficient data cleaning capabilities, seamless integration with other languages, and requirement for most data science jobs.
SQL
- SQL in Pandas with Pandasql - Oct 4, 2023.
Want to query your pandas dataframes using SQL? Learn how to do so using the Python library Pandasql.
SQL
- Using SQL to Understand Data Science Career Trends - Sep 25, 2023.
Reveal the Secrets of the Data Science Job Market with SQL.
SQL
- Optimizing Data Storage: Exploring Data Types and Normalization in SQL - Sep 22, 2023.
Learn about the data types and normalization techniques in SQL, which will be very helpful for optimizing your data storage.
SQL
- Data Management Principles for Data Science - Sep 10, 2023.
Back to Basics: Understanding key data management principles that data scientists should know.
SQL
- Getting Started with SQL in 5 Steps - Sep 9, 2023.
This comprehensive SQL tutorial covers everything from setting up your SQL environment to mastering advanced concepts like joins, subqueries, and optimizing query performance. With step-by-step examples, this guide is perfect for beginners looking to enhance their data management skills.
SQL
- Introduction to Databases in Data Science - Sep 8, 2023.
Understand the relevance of databases in data science. Also learn the fundamentals of relational databases, NoSQL database categories, and more.
SQL
- SQL For Data Science: Understanding and Leveraging Joins - Aug 3, 2023.
Learn how to use different joins in SQL and how this helps you in data science.
SQL
- Database Optimization: Exploring Indexes in SQL - Jul 13, 2023.
Learn about Indexing in SQL and how you can increase the retrieval speed of the SELECT queries and WHERE clauses.
SQL
- Why is DuckDB Getting Popular? - Jul 11, 2023.
DuckDB combines the simplicity and ease of use of SQLite with the analytical performance of specialized columnar databases. Learn more with Python examples.
SQL
- In-Database Analytics: Leveraging SQL’s Analytic Functions - Jul 3, 2023.
Learn about various SQL Analytic functions like RANK(), NTILE(), CUME_DIST() and more to leverage your data analysis skills to the next level.
SQL
- How to Optimize SQL Queries for Faster Data Retrieval - Jun 12, 2023.
Today, we’ll talk about why SQL query optimization is important and which techniques can be used to optimize it.
SQL
- Solving 5 Complex SQL Problems: Tricky Queries Explained - May 31, 2023.
The 5 hardest things Josh Berry, a 15 year analytics professional, experienced while switching from Python to SQL. Offering examples, SQL code, and a resource to customize the SQL to your own project.
SQL
- Using ChatGPT to Learn SQL - Apr 25, 2023.
And how to use this amazing tool to enhance our SQL skills.
SQL
- NoSQL Databases and Their Use Cases - Mar 16, 2023.
Learn about NoSQL Databases and their types like key-value, document, graph and column family with their use cases.
SQL
- SQL Query Optimization Techniques - Mar 1, 2023.
Learn how to optimize the queries written in SQL to make them execute faster and more memory efficient.
SQL
- SQL Interviews Preparations Material Resources - Feb 21, 2023.
SQL is a must-known programming language for data people, and many modern jobs have SQL as a prerequisite. Here are material collections to prepare for your SQL interview.
SQL
- 3 More SQL Aggregate Function Interview Questions for Data Science - Jan 30, 2023.
Lacking inspiration on how to prepare SQL aggregate functions for a job interview? Here are three interview question suggestions to get you out of a rut.
SQL
- Top 10 Advanced Data Science SQL Interview Questions You Must Know How to Answer - Jan 27, 2023.
In this article, we will give a list of commonly asked SQL interview questions to help you prepare for your coming technical interview.
SQL
- 7 Best Platforms to Practice SQL
- Jan 13, 2023.
Looking to level up your SQL skills? Here's a list of the best platforms to practice SQL, ace your SQL interviews, and land your dream data role.
SQL
- SQL With CSVs - Jan 5, 2023.
Write SQL query to analyze CSV files using the simple command line tool.
SQL
- 4 Useful Intermediate SQL Queries for Data Science - Dec 6, 2022.
SQL is the essential language for developers, engineers, and data professionals. Intermediate knowledge in SQL gives you an edge in your data science career.
SQL
- 7 SQL Concepts You Should Know For Data Science - Nov 18, 2022.
The post explains all the key elements of SQL that you must know as a data science practitioner.
SQL
- Analyzing Diversity & Inclusion with SQL - Nov 9, 2022.
The most underrated SQL function for analyzing diversity.
SQL
- 10 Essential SQL Commands for Data Science - Oct 20, 2022.
Learn SQL commands for filtering, string operations, alias, joining tables, if-else statements, and grouping.
SQL
- 25 Advanced SQL Interview Questions for Data Scientists - Oct 18, 2022.
Check out this collection of advanced SQL interview questions with answers.
SQL
- How to Get Up and Running with SQL – A List of Free Learning Resources - Oct 7, 2022.
We have compiled a list of the top free resources to help new data practitioners learn SQL. These include free online courses and resources to get the most out of your SQL skills.
SQL
- Key-Value Databases, Explained - Oct 4, 2022.
Among the four big NoSQL database types, key-value stores are probably the most popular ones due to their simplicity and fast performance. Let’s further explore how key-value stores work and what are their practical uses.
SQL
- Handling Missing Values in Time-series with SQL - Sep 30, 2022.
This article is about a specific use-case that comes up often when dealing with time-series data.
SQL
- SQL LIKE Operator Examples - Sep 29, 2022.
Search for the specific patterns in the SQL table using LIKE and wildcards.
SQL
- Free SQL and Database Course - Sep 15, 2022.
Get up to speed on SQL and relational databases with this free video course.
SQL
- SQL vs NoSQL: 7 Key Takeaways - Sep 5, 2022.
People assume that NoSQL is a counterpart to SQL. Instead, it’s a different type of database designed for use-cases where SQL is not ideal. The differences between the two are many, although some are so crucial that they define both databases at their cores.
SQL
- 5 Tricky SQL Queries Solved - Aug 19, 2022.
Explaining the approach to solving a few complex SQL queries.
SQL
- Getting Started with SQL Cheatsheet - Aug 3, 2022.
Want to get started with SQL? Check out the latest cheatsheet from KDnuggets to get up to speed on the basics of one of the most popular, useful, and in-demand languages in the world of data science.
SQL
- Why SQL Will Remain the Data Scientist’s Best Friend - Jul 15, 2022.
Machine learning, big data analytics or AI may steal the headlines, but if you want to hone a smart, strategic skill that can elevate your career, look no further than SQL.
SQL
- 24 SQL Questions You Might See on Your Next Interview - Jun 28, 2022.
Preparing for the SQL job interview can be overwhelming enough. You don’t need someone telling you that you need to know everything on top of that! Be smart and focus on preparing the SQL questions that appear most often at the job interview.
SQL
- Data Preparation with SQL Cheatsheet - Jun 27, 2022.
If your raw data is in a SQL-based data lake, why spend the time and money to export the data into a new platform for data prep?
SQL
- The Definitive Guide to Solving the Phantom Read in MySQL - Jun 14, 2022.
This article will cover how MySQL developers can troubleshoot the "write" skew that phantom reads can cause.
SQL
- SQL Notes for Professionals: The Free eBook Review - May 5, 2022.
The free book is a combination of SQL cheat sheets and practical database examples. It provided bite-size information about every SQL function and attribute with coding samples.
SQL
- High Availability SQL Server Docker Containers in Kubernetes - Apr 28, 2022.
Need high availability for SQL Server Docker containers in Kubernetes? Here’s how to get it.
SQL
- 7 Steps to Mastering SQL for Data Science - Apr 26, 2022.
SQL is a must-know for anyone working in the data industry. Here’s how you can learn it from scratch
SQL
- SQL Window Functions - Apr 5, 2022.
In this article, we’ll go over SQL window functions and how to use them when writing SQL queries.
SQL
- What Is the Difference Between SQL and Object-Relational Mapping (ORM)? - Feb 24, 2022.
Object-relational mapping, or ORM, is a technique that allows you to interact with databases using the object-oriented paradigm of the programming language of your choosing. How is that different from structured query language, though, and when do you use them?
SQL
- The Not-so-Sexy SQL Concepts to Make You Stand Out - Feb 8, 2022.
Databases are the houses of our data and data scientists HAVE TO HAVE A KEY! In this article, I discuss some lesser known concepts of SQL that data scientists do not familiarize themselves with.
SQL
- How to Write SQL in Native Python - Feb 1, 2022.
If the idea of being able to link with SQL databases and define, manipulate, and query using Python sounds appealing, check out the SQLModel library.
SQL
- Top Five SQL Window Functions You Should Know For Data Science Interviews - Jan 13, 2022.
Focusing on the important concepts for data scientists.
SQL
- Query Your Pandas DataFrames with SQL - Jan 13, 2022.
Learn how to query your Pandas DataFrames using the standard SQL SELECT statement, seamlessly from within your Python code.
SQL
- SQL Interview Questions for Experienced Professionals - Jan 7, 2022.
This article will show you what SQL concepts you should know as an experienced professional.
SQL
- KDnuggets™ News 21:n45, Dec 1: Most Common SQL Mistakes on Data Science Interviews; Why Machine Learning Engineers are Replacing Data Scientists - Dec 1, 2021.
Most Common SQL Mistakes on Data Science Interviews; Why Machine Learning Engineers are Replacing Data Scientists; Vote in new KDnuggets Poll: What Percentage of Your Machine Learning Models Have Been Deployed? KDnuggets: Personal History and Nuggets of Experience.
About Gregory Piatetsky, Interview Questions, Machine Learning Engineer, Poll, SQL
Most Common SQL Mistakes on Data Science Interviews - Nov 23, 2021.
Sure, we all make mistakes -- which can be a bit more painful when we are trying to get hired -- so check out these typical errors applicants make while answering SQL questions during data science interviews.
Interview Questions, Mistakes, SQL
How I Redesigned over 100 ETL into ELT Data Pipelines - Nov 15, 2021.
Learn how to level up your Data Pipelines!
ELT, ETL, Pipeline, SQL
- 11 Most Practical Data Science Skills for 2022 - Oct 19, 2021.
While the field of data science continues to evolve with exciting new progress in analytical approaches and machine learning, there remain a core set of skills that are foundational for all general practitioners and specialists, especially those who want to be employable with full-stack capabilities.
Career Advice, Data Science Skills, Explainable AI, Feature Engineering, GitHub, NLP, Regression, SQL
Data science SQL interview questions from top tech firms - Oct 5, 2021.
As a data scientist, there is one thing you really need to understand and know how to handle: data. With SQL being a foundational technical approach for working with data, it should not be surprising that the top tech companies will ask about your SQL skills during an interview. Here, we cover the key concepts tested so you can best prepare for your next data science interview.
Amazon, Data Science, Facebook, Google, Interview Questions, SQL
How To Build A Database Using Python - Sep 28, 2021.
Implement your database without handling the SQL using the Flask-SQLAlchemy library.
Databases, Flask, Python, SQL
- KDnuggets™ News 21:n36, Sep 22: The Machine & Deep Learning Compendium Open Book; Easy SQL in Native Python - Sep 22, 2021.
The Machine & Deep Learning Compendium Open Book; Easy SQL in Native Python; Introduction to Automated Machine Learning; How to be a Data Scientist without a STEM degree; What Is The Real Difference Between Data Engineers and Data Scientists?
Automated Machine Learning, AutoML, Books, Data Engineer, Data Scientist, Machine Learning, Python, SQL
- How to be a Data Scientist without a STEM degree - Sep 20, 2021.
Breaking into data science as a professional does require technical skills, a well-honed knack for problem-solving, and a willingness to swim in oceans of data. Maybe you are coming in as a career change or ready to take a new learning path in life--without having previously earned an advanced degree in a STEM field. Follow these tips to find your way into this high-demand and interesting field.
Career Advice, Data Science Education, Data Scientist, Project, Python, SQL
- Build a synthetic data pipeline using Gretel and Apache Airflow - Sep 2, 2021.
In this blog post, we build an ETL pipeline that generates synthetic data from a PostgreSQL database using Gretel’s Synthetic Data APIs and Apache Airflow.
Airflow, Pipeline, Postgres, SQL, Synthetic Data
- How to solve machine learning problems in the real world - Sep 2, 2021.
Becoming a machine learning engineer pro is your goal? Sure, online ML courses and Kaggle-style competitions are great resources to learn the basics. However, the daily job of a ML engineer requires an additional layer of skills that you won’t master through these approaches.
Advice, Business, Data Quality, Machine Learning, SQL, Tips, XGBoost
Practising SQL without your own database - Aug 10, 2021.
SQL is a very important skill for data analysts and data scientists. However, when you are just starting out learning in the field, how can you practice querying with SQL if you don’t have any data stored in a database?
Beginners, Data.world, SQL
How to Query Your Pandas Dataframe - Aug 9, 2021.
A Data Scientist’s perspective on SQL-like Python functions.
Data Preprocessing, Data Processing, Pandas, Python, SQL
- dbt for Data Transformation – Hands-on Tutorial - Jul 28, 2021.
The data build tool (dbt) is gaining in popularity and use, and this hands-on tutorial covers creating complex models, using variables and functions, running tests, generating docs, and many more features.
Data Engineering, Data Preparation, dbt, ETL, SQL
Top 6 Data Science Online Courses in 2021 - Jul 15, 2021.
As an aspiring data scientist, it is easy to get overwhelmed by the abundance of resources available on the Internet. With these 6 online courses, you can develop yourself from a novice to experienced in less than a year, and prepare you with the skills necessary to land a job in data science.
Data Science Education, Online Education, Programming, Python, SQL
How to Get Practical Data Science Experience to be Career-Ready - Jul 7, 2021.
Becoming a professional in the field of data science takes more than just book-smarts. You need to have experience with real-world data sets, frequently-used tools, and an intuition for solutions that you can only gain from hands-on experience. These resources will jump start developing your practical skills.
Career Advice, Data Science Education, Pandas, Project, SQL
Pandas vs SQL: When Data Scientists Should Use Each Tool - Jun 21, 2021.
Exploring data sets and understanding its structure, content, and relationships is a routine and core process for any Data Scientist. Multiple tools exist for performing such analysis, and we take a deep dive into the benefits and different approaches of two important tools, SQL and Pandas.
Data Scientist, Pandas, SQL
- The Most In Demand Skills for Data Engineers in 2021 - May 18, 2021.
If you are preparing to make a career in data or are looking for opportunities to skill-up in your current data-centric role, then this analysis of in-demand skills for 2021, based on over 17,000 Data Engineer job postings, should offer you a good idea as to which programming languages and software tools are increasing and decreasing in importance.
Apache Spark, AWS, Data Engineer, Data Science Skills, Data Scientist, Python, Skills, SQL
- The NoSQL Know-It-All Compendium - May 13, 2021.
Are you a NoSQL beginner, but want to become a NoSQL Know-It-All? Well, this is the place for you. Get up to speed on NoSQL technologies from a beginner's point of view, with this collection of related progressive posts on the subject. NoSQL? No problem!
Beginners, Databases, NoSQL, SQL
- How to get started managing data quality with SQL and scale - May 4, 2021.
Silent data quality issues are the biggest problem facing data teams today, who are flying blind with no systems or processes in place to monitor and detect bad data before it has a downstream impact.
Data Preparation, Data Quality, Scalability, SQL
- Build an Effective Data Analytics Team and Project Ecosystem for Success - Apr 19, 2021.
Apply these techniques to create a data analytics program that delivers solutions that delight end-users and meet their needs.
Analytics Team, Career Advice, Data Science Team, Excel, Programming, SQL, Success
The Most In-Demand Skills for Data Scientists in 2021 - Apr 15, 2021.
If you are preparing to make a career as a Data Scientist or are looking for opportunities to skill-up in your current role, this analysis of in-demand skills for 2021, based on over 15,000 Data Scientist job postings, should offer you a good idea as to which programming languages and software tools are increasing and decreasing in importance.
AWS, Data Science Skills, Python, PyTorch, R, scikit-learn, SQL, TensorFlow
Working With Time Series Using SQL - Apr 6, 2021.
This article is an overview of using SQL to manipulate time series data.
SQL, Time Series
Data Science Learning Roadmap for 2021 - Feb 26, 2021.
Venturing into the world of Data Science is an exciting, interesting, and rewarding path to consider. There is a great deal to master, and this self-learning recommendation plan will guide you toward establishing a solid understanding of all that is foundational to data science as well as a solid portfolio to showcase your developed expertise.
Data Engineering, Data Preparation, Data Science, Data Science Education, Python, Roadmap, SQL
- Data Observability, Part II: How to Build Your Own Data Quality Monitors Using SQL - Feb 23, 2021.
Using schema and lineage to understand the root cause of your data anomalies.
Data Engineering, Data Quality, Data Science, Data Science Platform, SQL
- Data Observability: Building Data Quality Monitors Using SQL - Feb 16, 2021.
To trigger an alert when data breaks, data teams can leverage a tried and true tactic from our friends in software engineering: monitoring and observability. In this article, we walk through how you can create your own data quality monitors for freshness and distribution from scratch using SQL.
Data Engineering, Data Quality, Data Science, Data Science Platform, SQL
- 7 Most Recommended Skills to Learn to be a Data Scientist - Feb 10, 2021.
The Data Scientist professional has emerged as a true interdisciplinary role that spans a variety of skills, theoretical and practical. For the core, day-to-day activities, many critical requirements that enable the delivery of real business value reach well outside the realm of machine learning, and should be mastered by those aspiring to the field.
Career Advice, Data Science Skills, Data Scientist, Data Visualization, Docker, Pandas, Python, SQL
- How to Deploy a Flask API in Kubernetes and Connect it with Other Micro-services - Feb 9, 2021.
A hands-on tutorial on how to implement your micro-service architecture using the powerful container orchestration tool Kubernetes.
API, Containers, Flask, Kubernetes, MySQL, Python, SQL
- Data Cleaning and Wrangling in SQL - Jan 14, 2021.
SQL is a foundational skill for data analysts but its application is sometimes limited within the data pipeline. However, SQL can be successfully used for many pre-processing tasks, such as data cleaning and wrangling, as demonstrated here by example.
Data Cleaning, Data Preparation, SQL
Crack SQL Interviews - Dec 17, 2020.
SQL is an essential programming language for data analysis and processing. So, SQL questions are always part of the interview process for data science-related jobs, including data analysts, data scientists, and data engineers. Become familiar with these common patterns seen in SQL interview questions and follow our tips on how to neatly handle each with SQL queries.
Interview Questions, SQL
- 6 Things About Data Science that Employers Don’t Want You to Know - Dec 14, 2020.
As is the potential for any "trending hot" career, the reality of a position in the field may not be all that you initially expected. Data Science is no exception, and being still a young field, its evolving definition can offer some surprises that you should know about before accepting that dream offer.
Business, Career Advice, Communication, Data Science, Data Scientist, SQL
- The Ultimate Guide to Data Engineer Interviews - Dec 7, 2020.
If you are preparing for data engineering interviews, then follow these technical recommendations regarding your resume, programming skills, SQL acumen, and system design problem-solving, as well as the non-technical aspects of your upcoming interview session.
Career Advice, Data Engineer, Data Engineering, Interview Questions, Programming, SQL
- Top 6 Data Science Programs for Beginners - Nov 20, 2020.
Udacity has the best industry-leading programs in data science. Here are the top six data science courses for beginners to help you get started.
Beginners, Certificate, Data Engineer, Data Science Education, Data Visualization, Online Education, Python, R, SQL, Udacity
Modern Data Science Skills: 8 Categories, Core Skills, and Hot Skills - Sep 8, 2020.
We analyze the results of the Data Science Skills poll, including 8 categories of skills, 13 core skills that over 50% of respondents have, the emerging/hot skills that data scientists want to learn, and what is the top skill that Data Scientists want to learn.
Communication, Data Preparation, Data Science Skills, Data Visualization, Excel, GitHub, Mathematics, Poll, Python, Reinforcement Learning, scikit-learn, SQL, Statistics
- Working with Spark, Python or SQL on Azure Databricks - Aug 27, 2020.
Here we look at some ways to interchangeably work with Python, PySpark and SQL using Azure Databricks, an Apache Spark-based big data analytics service designed for data science and data engineering offered by Microsoft.
Apache Spark, Databricks, Microsoft Azure, Python, SQL
- Data Science Tools Illustrated Study Guides - Aug 25, 2020.
These data science tools illustrated guides are broken up into four distinct categories: data retrieval, data manipulation, data visualization, and engineering tips. Both online and PDF versions of these guides are available.
Cheat Sheet, Data Preprocessing, Data Processing, Data Science, Data Science Tools, Data Visualization, Python, R, SQL
Feature Engineering in SQL and Python: A Hybrid Approach - Jul 2, 2020.
Set up your workstation, reduce workplace clutter, maintain a clean namespace, and effortlessly keep your dataset up-to-date.
Feature Engineering, Python, SQL
- Top KDnuggets tweets, May 13-19: Linear algebra and optimization and machine learning: A textbook - May 21, 2020.
Also: Everything you need to become a self-taught #MachineLearning Engineer ; SQL Cheat Sheet (2020) - a useful cheat sheet that documents some of the more commonly used elements of SQL;
AutoML, Cheat Sheet, Linear Algebra, Machine Learning Engineer, SQL, Top tweets
- What they do not tell you about machine learning - May 19, 2020.
There's a lot of excitement out there about machine learning jobs. So, it's always good to start off with a healthy dose of reality and proper expectations.
Advice, Career, Machine Learning, Machine Learning Engineer, SQL
- The Benefits & Examples of Using Apache Spark with PySpark - Apr 21, 2020.
Apache Spark runs fast, offers robust, distributed, fault-tolerant data objects, and integrates beautifully with the world of machine learning and graph analytics. Learn more here.
Apache Spark, Data Management, Python, SQL
Python for data analysis… is it really that simple?!? - Apr 2, 2020.
The article addresses a simple data analytics problem, comparing a Python and Pandas solution to an R solution (using plyr, dplyr, and data.table), as well as kdb+ and BigQuery solutions. Performance improvement tricks for these solutions are then covered, as are parallel/cluster computing approaches and their limitations.
Data Analysis, Pandas, Python, R, SQL
- Introduction to Geographical Time Series Prediction with Crime Data in R, SQL, and Tableau - Feb 14, 2020.
When reviewing geographical data, it can be difficult to prepare the data for an analysis. This article helps by covering importing data into a SQL Server database; cleansing and grouping data into a map grid; adding time data points to the set of grid data and filling in the gaps where no crimes occurred; importing the data into R; running XGBoost model to determine where crimes will occur on a specific day
Crime, Geospatial, R, SQL, Tableau, Time Series
Learning SQL the Hard Way - Jan 8, 2020.
Simply put: This post is about installing SQL, explaining SQL and running SQL.
Databases, MySQL, Programming, SQL
7 Resources to Becoming a Data Engineer - Jan 7, 2020.
An estimated 8,650% growth of the volume of Data to 175 zetabytes from 2010 to 2025 has created an enormous need for Data Engineers to build an organization's big data platform to be fast, efficient and scalable.
Advice, Big Data, Cloud Computing, Data Engineering, Data Science, MOOC, SQL
- KDnuggets™ News 19:n38, Oct 9: The Last SQL Guide for Data Analysis; 4 Quadrants of Data Science Skills and 7 steps for Viral Data Visualization - Oct 9, 2019.
Read a comprehensive SQL guide for data analysis; Learn how to choose the right clustering algorithm for your data; Find out how to create a viral DataViz using the data from Data Science Skills poll; Enroll in any of 10 Free Top Notch Natural Language Processing Courses; and more.
Clustering, Data Visualization, Machine Learning Engineer, SQL
The Last SQL Guide for Data Analysis You’ll Ever Need - Oct 4, 2019.
This is it: the last SQL guide for data analysis you'll ever need! OK, maybe it’s actually the first. But it’ll give you a solid head start.
Cheat Sheet, Data Analysis, Data Science, SQL
Top Handy SQL Features for Data Scientists - Aug 23, 2019.
Whenever we hear "data," the first thing that comes to mind is SQL! SQL comes with easy and quick to learn features to organize and retrieve data, as well as perform actions on it in order to gain useful insights.
Data Science, Data Scientist, SQL
- Is SQL needed to be a data scientist? - Jul 25, 2019.
As long as there is ‘data’ in data scientist, Structured Query Language (or see-quel as we call it) will remain an important part of it. In this blog, let us explore data science and its relationship with SQL.
Data Science, Relational Databases, SQL
- Become a Pro at Pandas, Python’s Data Manipulation Library - Jun 13, 2019.
Pandas is one of the most popular Python libraries for cleaning, transforming, manipulating and analyzing data. Learn how to efficiently handle large amounts of data using Pandas.
Matplotlib, numpy, Pandas, Python, SQL
What you need to know: The Modern Open-Source Data Science/Machine Learning Ecosystem - Jun 10, 2019.
We identify the 6 tools in the modern open-source Data Science ecosystem, examine the Python vs R question, and determine which tools are used the most with Deep Learning and Big Data.
Anaconda, Apache Spark, Big Data Software, Deep Learning, Excel, Keras, Poll, Python, R, RapidMiner, scikit-learn, Software, SQL, Tableau, TensorFlow
- A Step-by-Step Guide to Transitioning your Career to Data Science – Part 2 - Jun 7, 2019.
How do you identify the technical skills a hiring manager is looking for? How do you build a data science project that draws the attention of a hiring manager?
Career Advice, Data Science, Skills, SQL, Tableau
- Why physical storage of your database tables might matter - May 31, 2019.
Follow this investigation into why physical storage of your database tables might matter, from problem identification to possible issue resolutions.
Apache Spark, Databases, Postgres, SQL
Python leads the 11 top Data Science, Machine Learning platforms: Trends and Analysis - May 30, 2019.
Python continues to lead the top Data Science platforms, but R and RapidMiner hold their share; Almost 50% have used Deep Learning tools; SQL is steady; Consolidation continues.
Pages: 1 2
Anaconda, Apache Spark, Deep Learning, Excel, Keras, Poll, Python, R, RapidMiner, scikit-learn, Software, SQL, TensorFlow
7 Steps to Mastering SQL for Data Science — 2019 Edition - May 17, 2019.
Follow these updated 7 steps to go from SQL data science newbie to practitioner in a hurry. We consider only the necessary concepts and skills, and provide quality resources for each.
7 Steps, Data Science, Database, Relational Databases, SQL
- Training a Champion: Building Deep Neural Nets for Big Data Analytics - Apr 4, 2019.
Introducing Sisense Hunch, the new way of handling Big Data sets that uses AQP technology to construct Deep Neural Networks (DNNs) which are trained to learn the relationships between queries and their results in these huge datasets.
Big Data Analytics, Deep Learning, Neural Networks, Sisense, SQL
Who is a typical Data Scientist in 2019? - Mar 11, 2019.
We investigate what a typical data scientist looks like and see how this differs from this time last year, looking at skill set, programming languages, industry of employment, country of employment, and more.
Career, Data Science Skills, Data Scientist, Industry, MATLAB, Python, R, SQL
SQL, Python, & R in One Platform - Oct 26, 2018.
No more jumping between applications. Mode Studio combines a SQL editor, Python and R notebooks, and a visualization builder in one platform.
Data Visualization, Mode Analytics, Python, R, SQL
- SQL Case Study: Helping a Startup CEO Manage His Data - Sep 19, 2018.
In this tutorial, you will learn how to create a table, insert values into it, use and understand some data types, use SELECT statements, UPDATE records, use some aggregate functions, and more.
Pages: 1 2
SQL, Startup
- OLAP queries in SQL: A Refresher - Sep 3, 2018.
Based on the recent book - Principles of Database Management - The Practical Guide to Storing, Managing and Analyzing Big and Small Data - this post examines how OLAP queries can be implemented in SQL.
Bart Baesens, OLAP, SQL
- Remote Data Science: How to Send R and Python Execution to SQL Server from Jupyter Notebooks - Jul 27, 2018.
Did you know that you can execute R and Python code remotely in SQL Server from Jupyter Notebooks or any IDE? Machine Learning Services in SQL Server eliminates the need to move data around.
Jupyter, Machine Learning, Microsoft, Python, R, SQL, SQL Server
SQL Cheat Sheet - Jul 2, 2018.
A good programmer or software developer should have a basic knowledge of SQL queries in order to be able retrieve data from a database. This cheat sheet can help you get started in your learning, or provide a useful resource for those working with SQL.
Cheat Sheet, SQL
- Modern Graph Query Language – GSQL - Jun 29, 2018.
This post introduces the prospect of fulfilling the need for a modern graph query language with GSQL
Graph Analytics, Graph Databases, SQL, TigerGraph
- How to Execute R and Python in SQL Server with Machine Learning Services - Jun 25, 2018.
Machine Learning Services in SQL Server eliminates the need for data movement - you can install and run R/Python packages to build Deep Learning and AI applications on data in SQL Server.
Azure ML, Machine Learning, Microsoft, Python, R, SQL, SQL Server
- Simple Tips for PostgreSQL Query Optimization - Jun 22, 2018.
A single query optimization tip can boost your database performance by 100x. Although we usually advise our customers to use these tips to optimize analytic queries (such as aggregation ones), this post is still very helpful for any other type of query.
Optimization, Postgres, SQL, Statsbot
- Event Processing: Three Important Open Problems - May 28, 2018.
This article summarizes the three most important problems to be solved in event processing. The facts in this article are supported by a recent survey and an analysis conducted on the industry trends.
Big Data, Data Analytics, Insights, Real-time, SQL, Streaming Analytics
Python eats away at R: Top Software for Analytics, Data Science, Machine Learning in 2018: Trends and Analysis - May 22, 2018.
Python continues to eat away at R, RapidMiner gains, SQL is steady, Tensorflow advances pulling along Keras, Hadoop drops, Data Science platforms consolidate, and more.
Pages: 1 2
Anaconda, Data Mining Software, Data Science Platform, Hadoop, Keras, Poll, Python, R, RapidMiner, SQL, TensorFlow, Trends
- YouTube videos on database management, SQL, Datawarehousing, Business Intelligence, OLAP, Big Data, NoSQL databases, data quality, data governance and Analytics – free - May 18, 2018.
Watch over 20 hours of YouTube videos on databases and database design, Physical Data Storage, Transaction Management and Database Access, and Data Warehousing, Data Governance and (Big) Data Analytics - all free.
Analytics, Bart Baesens, Big Data, Business Intelligence, Data Governance, Data Quality, Data Warehousing, Databases, NoSQL, SQL, Youtube
- Presto for Data Scientists – SQL on anything - Apr 19, 2018.
Presto enables data scientists to run interactive SQL across multiple data sources. This open source engine supports querying anything, anywhere, and at large scale.
Big Data, Database, Presto, SQL
- Scalable Select of Random Rows in SQL - Apr 5, 2018.
Performance boosts are achieved by selecting random rows or the sampling technique. Let’s learn how to select random rows in SQL.
Sampling, SQL, Statsbot
