All the data you need.

Tag: SQL

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 …
Winning the Kevin Bacon Game with SQL: Data Science Hobby Project Example
James Rice was a participant in my 6-week data science course (The Junior Data Scientist’s First Month). After finishing the course, he started a cool hobby project and... The post Winning the Kevin Bacon Game with SQL: Data Science Hobby Project Example appeared first on Data36.
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. The post SQL vs MySQL: A Simple Guide to the Differences appeared first on Dataquest.
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. The post SQL Interview Questions — Real Questions to Prep for Your Job Interview appeared first on Dataquest.
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!Don't …
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. Table Of Contents (click to expand) 1Do you need to learn SQL? Yes.2Do …
SQL Tutorial: Selecting Ungrouped Columns Without Aggregate Functions
When is a SQL query that returns the correct answer actually wrong? In this tutorial, we're going to take a close look at a very common mistake. It's one that will actually return the right answer, but it's still a mistake that's important to avoid.That probably sounds rather mysterious, so …
Databricks and Coursera Launch Data Science Specialization for Data Analysts
Earlier this year, Databricks made a massive investment in training by providing free self-paced courses to all of our customers. Databricks furthers this investment by partnering with Coursera to provide Massive Open Online Courses (MOOC) training to the larger data community. Together we launched a new three-course specialization, Data Science …
Databricks Launches SQL Analytics to Enable Cloud Data Warehousing on Data Lakes
Databricks, the data and AI company, announced the launch of SQL Analytics, which for the first time enables data analysts to perform workloads previously meant only for a data warehouse on a data lake. This expands the traditional scope of the data lake from data science and machine learning to …
Announcing Azure Databricks Power BI Connector (Public Preview)
Databricks and Microsoft Power BI customers will be delighted to know that an enhanced Azure Databricks PowerBI connector is now... The post Announcing Azure Databricks Power BI Connector (Public Preview) appeared first on Databricks.
Analyzing Algorand Blockchain Data with Databricks Delta
Algorand is a public, decentralized blockchain system that uses a proof of stake consensus protocol. It is fast and energy-efficient,... The post Analyzing Algorand Blockchain Data with Databricks Delta appeared first on Databricks.
How to Become a Data Analyst
The demand for data professionals like Data Analysts is booming. This is a direct result of more and more organizations becoming data driven and leveraging data to streamline their operations, compete better, and improve customer experiences. According to the US Bureau of Labor Statistics, the thriving job market for data …
Welcoming Redash to Databricks
This morning at Spark and AI Summit, we announced that Databricks has acquired Redash, the company behind the popular open source project of the same name. With this acquisition, Redash joins Apache Spark, Delta Lake, and MLflow to create a larger and more thriving open source system to give data …
Schema Evolution in Merge Operations and Operational Metrics in Delta Lake
Try this notebook to reproduce the steps outlined below We recently announced the release of Delta Lake 0.6.0, which introduces schema evolution and performance improvements in merge and operational metrics in table history. The key features in this release are: Support for schema evolution in merge operations (#170) – You …
Faster SQL Queries on Delta Lake with Dynamic File Pruning
There are two time-honored optimization techniques for making queries run faster in data systems: process data at a faster rate or simply process less data by skipping non-relevant data. This blog post introduces Dynamic File Pruning (DFP), a new data-skipping technique enabled by default in Databricks Runtime 6.1, which can …
Glow 0.3.0 Introduces New Large-Scale Genomic Analysis Features
In October of last year, Databricks and the Regeneron Genetics Center® partnered together to introduce Project Glow, an open-source analysis tool aimed at empowering genetics researchers to work on genomics projects at the scale of millions of samples. Since we introduced Glow, we have been busy at work adding new …
SQL current date — How to get the current date, time, month or year in postgreSQL?
Working with current dates and times in data science projects is quite common. In this episode of my SQL tutorial series I’ll show you the best functions that... The post SQL current date — How to get the current date, time, month or year in postgreSQL? appeared first on Data36.
SQL TRUNCATE TABLE and DROP TABLE (tutorial)
In this episode of the SQL tutorial series you’ll learn two simple but important commands that you’ll use frequently when working in SQL: TRUNCATE TABLE and DROP TABLE.... The post SQL TRUNCATE TABLE and DROP TABLE (tutorial) appeared first on Data36.