All the data you need.

Tag: SQL

Databricks Announces General Availability of Delta Live Tables
Databricks, the Data and AI company and pioneer of the data lakehouse paradigm, announced the general availability of Delta Live Tables (DLT), the first ETL framework to use a simple declarative approach to build reliable data pipelines and to automatically manage data infrastructure at scale. Turning SQL queries into production …
HEAVY.AI Introduces New Capabilities that Enable Organizations to Gain Faster Access to Rapidly Growing Data Sets and Deliver Decision-Quality Information
HEAVY.AI (previously Omnisci), an innovator in advanced analytics, announced the limited release of HEAVY.AI 6.0, with general availability to follow in April. The new capabilities, such as HeavyConnect, deliver improved analytics performance and faster time to decision-quality information, allowing organizations to immediately extract value from their data. HEAVY.AI 6.0 empowers …
Dremio Announces Open and Forever-Free Lakehouse Platform, Dremio Cloud, In Partnership with AWS
Dremio, the lakehouse company, announced the general availability of Dremio Cloud, the free data lakehouse platform and the addition of two new services: Dremio Sonar, a lakehouse engine built for SQL, and Dremio Arctic, a metadata and data management service for Apache Iceberg that provides a unique Git-like experience for …
How to Put Together an Effective SQL Server Monitoring Strategy
Tracking how your database is performing should be on the top of the to-do list for any administrator. And of course, the only way to make sure you handle this effectively and efficiently is to put a monitoring strategy in place. There are several steps to take, and many considerations …
Learner Spotlight: Rahila Hashim
Meet Rahil Hashim, a zoology graduate with no prior experience in programming who enrolled in Dataquest’s SQL path after winning one of our scholarships. Keep reading to find out how Rahila took advantage of Dataquest’s courses to land a job as a technical data scientist. 1. First, what are your …
Why does SQL Server Consume So Much Memory
According to the company, Microsoft SQL Server is a relational database management system (RDBMS). In relational databases, all SQL Servers use the SQL programming language, which is well-known and widely used. Microsoft created SQL Server's Transact-SQL implementation, also referred to as T-SQL, used by SQL Server. A number of programming …
10 Powerful Features to Simplify Semi-structured Data Management in the Databricks Lakehouse
Ingesting and querying JSON with semi-structured data can be tedious and time-consuming, but Auto Loader and Delta Lake make it easy. JSON data is very flexible, which makes it powerful, but also difficult to ingest and query. The biggest challenges include: It’s a tedious and fragile process to define a …
Learner Spotlight – Viktoria Jorayeva
Meet Viktoria Jorayeva, a Ukrainian student who made the transition from philology to data science in just a few months with Dataquest. As a person from a non-technical, non-mathematical background, breaking into the field of data science was possible thanks to Dataquest’s data science career path. Her story is a …
100 Years of Horror Films: An Analysis Using Databricks SQL
When it comes to the history of film, perhaps no genre says more about us as humans than horror, which taps into our biggest phobias and uncertainties about the world. With such a huge range – from gruesome to symbolic to comedically terrible – we thought it’d be interesting to …
Introducing SQL User-Defined Functions
A user-defined function (UDF) is a means for a user to extend the native capabilities of Apache Spark™ SQL. Spark SQL has supported external user-defined functions written in Scala, Java, Python and R programming languages since 1.3.0. While external UDFs are very powerful, they also come with a few caveats: …
Learn SQL for Data Analysis – from scratch
Learning SQL is very useful for anyone in the online world. And it’s a definite must for Data Analysts/Scientists! Here are 8 articles to start with… The post Learn SQL for Data Analysis – from scratch appeared first on Data36.
Accelerated Integration of Eventador with Cloudera – SQL Stream Builder
Today, within 5 months after the acquisition of Eventador, Cloudera announced that SQL Stream Builder is now being re-launched as Cloudera SQL Stream Builder. This is being done after it was fully integrated with Cloudera Data Platform’s (CDP) Shared Data Experience (SDX). This means that SQL Stream Builder can take …
Understanding NoSQL Databases: Document Stores
In this contributed article, Alex Williams, Writer/Researcher at Hosting Data UK, discusses document-oriented databases (also called: aggregate databases, document databases or document stores) and how they place each record, and its associative data, inside single documents. This database type is a subset of the NoSQL umbrella, which refers to the …
SQL Operators: 6 Different Types (w/ Examples)
We have previously covered why you need to learn SQL to get a data job in 2021, as well as publishing a full list of SQL commands to help you get started. Next, we’re going to be looking at SQL operators.We’re going to cover what exactly SQL operators are, before …
How Long Does It Take to Learn SQL?
How long does it take to learn SQL? It depends on your goals and your background, so we've broken down a variety of scenarios for you. The post How Long Does It Take to Learn SQL? appeared first on Dataquest.
SQL vs T-SQL: Understanding the Differences
SQL or T-SQL — which one do you need to learn? SQL and T-SQL both see heavy use in the database and data science industries. But what exactly are they? These two query languages are very similar, both in name and in what they can do, so the distinction between …
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.