All the data you need.

Tag: SQL

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.
Cloud Data Science 9
Lots of announcements this week, so without delay, let’s get right to Cloud Data Science 9. News Google Announces Cloud SQL for Microsoft SQL ServerGoogle’s Cloud SQL now supports SQL … The post Cloud Data Science 9 appeared first on Data Science 101.
SQL Fundamentals Tutorial: Start Learning SQL Today!
Learn the fundamentals of SQL and start writing SQL queries to answer business questions in this free SQL fundamentals tutorial and interactive course. The post SQL Fundamentals Tutorial: Start Learning SQL Today! appeared first on Dataquest.
Beginner SQL Tutorial: Learn SQL Basics While Analyzing Bike-Sharing
Learn the basics of SQL and databases while analyzing a data set on bike rentals in this free beginner SQL tutorial. Then try our interactive courses! The post Beginner SQL Tutorial: Learn SQL Basics While Analyzing Bike-Sharing appeared first on Dataquest.
SQL Joins Tutorial: Working with Databases
When first learning SQL, it’s common to work with data in a single table. In the real world, databases generally have data in more than one table. If we want to be able to work with that data, we’ll have to combine multiple tables within a query. In this SQL …
Why You should Attend SQLSaturday – An Interview with John Byrnes
An interview with John Byrnes. Where has SQL taken his career? What does the SQLSaturday community mean to him? Why should someone attend a SQLSaturday event?
SQL Insert Tutorial: Inserting Records and DataFrames Into a Database
Master the art of the SQL Insert to add data to SQL and MySQL databases using SQL queries, as well as from within Python, and when using pandas. The post SQL Insert Tutorial: Inserting Records and DataFrames Into a Database appeared first on Dataquest.
NuoDB 4.0 Expands Cloud-native and Cloud-agnostic Capabilities of Distributed SQL Database
NuoDB, the distributed SQL database company, unveiled NuoDB 4.0, featuring expanded cloud-native and cloud-agnostic capabilities with support for Kubernetes Operators and Google Cloud and Azure public clouds. This includes the recently announced Kubernetes Operator to simplify and automate database deployments in Red Hat OpenShift.