KDnuggets

JANUARY 18, 2023

7 Best Platforms to Practice SQL • Explainable AI: 10 Python Libraries for Demystifying Your Model's Decisions • ChatGPT: Everything You Need to Know • Data Lakes and SQL: A Match Made in Data Heaven • Google Data Analytics Certification Review for 2023

SQL 213

SQL Data Lakes Python AI 213

Hacker News

JANUARY 4, 2024

From the rise of vector databases to SQL:2023 to MariaDB troubles and the FAA outage, 2023 was an exciting year in database history.

Database 127

Database SQL 127

databricks

JUNE 14, 2023

It's been only 18 months since we announced Databricks SQL general availability - the serverless data warehouse on the Lakehouse - and we.

SQL 130

SQL Data Warehouse AI AI 130

Data Science Dojo

OCTOBER 10, 2023

Top AI conferences and events around the world in 2023 Here are some of the top AI-related virtual events and conferences held around the world in 2023: 1. Generative AI and Data Storytelling (Virtual event | 27th September – 2023) A virtual event on generative AI and data storytelling. Click below 2.

AI 243

AI AI Artificial Intelligence Artificial Intelligence 243

phData

FEBRUARY 29, 2024

it has to be done using custom SQL in Tableau? Hopefully, you don’t run into this scenario because joining and querying multiple tables in Tableau using custom SQL is not recommended due to its impact on performance. Hopefully these tips and examples will give you a kick start in your SQL optimization journey.

Tableau 52

Tableau SQL Database ETL 52

Towards AI

NOVEMBER 3, 2023

Last Updated on November 5, 2023 by Editorial Team Author(s): Pere Martra Originally published on Towards AI. We will use this capability to create a prompt that allows OpenAI Models to generate SQL commands from Natural Language. That is, translating user language requests into SQL commands that will retrieve the requested data.

SQL 118

SQL AI AI Machine Learning 118

Pickl AI

FEBRUARY 6, 2023

Preparing for the SQL interview questions to become more proficient in data science with example questions and a framework for answering them. Amongst the different tools that data scientists must have in their arsenal, SQL holds a special significance. This phase of the interview demands you to address real-world problems using SQL.

SQL 52

SQL Data Analyst Data Science Database 52

Towards AI

JULY 6, 2023

Last Updated on July 12, 2023 by Editorial Team Author(s): Dr. Mandar Karhade, MD. NSQL is a new family of open-source large foundation models (FMs) designed specifically for SQL generation tasks Raise your hand if you have tried to use ChatGPT or any of the other LLMs to generate SQL queries. Originally published on Towards AI.

SQL 84

SQL AI AI Data Science 84

Hacker News

JUNE 1, 2023

Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation)

SQL 61

SQL Database 61

Data Science Dojo

MAY 18, 2023

In March 2023, we had the pleasure of hosting the first edition of the Future of Data and AI conference – an incredible tech extravaganza that drew over 10,000 attendees, featured 30+ industry experts as speakers, and offered 20 engaging panels and tutorials led by the talented team at Data Science Dojo.

Data Science 195

Data Science AI AI SQL 195

Analytics Vidhya

JANUARY 2, 2023

The post Step-by-Step Roadmap to Become a Data Engineer in 2023 appeared first on Analytics Vidhya. While not all of us are tech enthusiasts, we all have a fair knowledge of how Data Science works in our day-to-day lives. All of this is based on Data Science which is […].

Data Engineering 289

Data Engineering Data Engineer Data Engineering Data Engineering 289

ODSC - Open Data Science

APRIL 6, 2023

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 science world can agree on, SQL. But why is SQL, or Structured Query Language , so important to learn? Let’s start with the first clause often learned by new SQL users, the WHERE clause.

SQL 98

SQL Data Scientist Database Data Analysis 98

Analytics Vidhya

MARCH 21, 2023

You will study top 11 azure interview questions in this article which will discuss different data services like Azure Cosmos […] The post Top 11 Azure Data Services Interview Questions in 2023 appeared first on Analytics Vidhya.

Azure 267

Azure Analytics Analytics Data Lakes 267

Analytics Vidhya

FEBRUARY 7, 2023

This includes designing and implementing […] The post Most Essential 2023 Interview Questions on Data Engineering appeared first on Analytics Vidhya. The goal of this domain is to collect, store, and process data efficiently and efficiently so that it can be used to support business decisions and power data-driven applications.

Data Engineering 266

Data Engineering Data Engineer Data Engineering Data Engineering 266

Flipboard

DECEMBER 18, 2023

Learn more about these new generative AI features to increase productivity including Amazon Q generative SQL in Amazon Redshift. Easily build and train machine learning models using SQL within Amazon Redshift to generate predictive analytics and propel data-driven decision-making.

AWS 112

AWS Data Warehouse ETL SQL 112

Analytics Vidhya

JANUARY 17, 2023

The post Step-by-Step Guide to Becoming a Data Analyst in 2023 appeared first on Analytics Vidhya. That growth is projected to continue in the future since industries that have been slow to adopt big data analytics, such as education, […].

Data Analyst 244

Data Analyst Big Data Analytics Big Data Analytics Big Data 244

Data Science Dojo

APRIL 18, 2023

In 2023, data analysts will be expected to have a wide range of skills and knowledge to be effective in their roles. Skills for data analysts 2023 10 essential skills for data analysts to have in 2023 Here are 10 essential skills for data analysts to have in 2023: 1. Are you ready to level up your skillset?

Data Analyst 195

Data Analyst Data Visualization Data Analysis Data Analysis 195

Flipboard

MARCH 8, 2023

ChatGPT for Data Science Cheat Sheet • Top Free Data Science Online Courses for 2023 • SQL Query Optimization Techniques • 3 Hard Python Coding Interview Questions For Data Science • A List of 7 Best Data Modeling Tools for 2023

Data Science 82

Data Science SQL Data Modeling Data Models 82

Data Science Dojo

JULY 6, 2023

Essential data engineering tools for 2023 Top 10 data engineering tools to watch out for in 2023 1. dbt focuses on transforming raw data into analytics-ready tables using SQL-based transformations. Snowflake: Snowflake is a cloud-based data warehouse platform that provides high scalability, performance, and ease of use.

Data Engineering 195

Data Engineering Data Engineer Data Engineering Data Engineering 195

phData

JANUARY 10, 2024

Over the last month, we’ve added new functionality to our SQL translation tool and modified our Access Tool. SQL Translation Our SQL Translation tool, known as SQLMorph, supports translating SQL dialects between different platforms. Let’s dive in and take a look at the changes! In Snowflake this specifies NUMBER(38, 0).

SQL 52

SQL Database 52

phData

SEPTEMBER 7, 2023

Over the last month, we’ve been heavily focused on adding additional support for SQL translations to our SQL Translations tool. Specifically, we’ve been introducing fixes and features for our Microsoft SQL Server to Snowflake translation. This is where the SQL Translation tool can be a massive accelerator for your migration.

SQL 52

SQL Data Profiling Data Pipeline Database 52

phData

NOVEMBER 3, 2023

SQL Translation Updates Are you tired of spending endless hours manually converting SQL queries between different dialects? Our SQL translation application is your answer. This revolutionary tool acts like a “Google Translate” for SQL dialects, making it a game-changer for database professionals and learners alike.

SQL 52

SQL Database 52

Data Science Dojo

MARCH 7, 2023

These skills include non-technical skills and technical skills. 10 essential skills to excel as a data scientist in 2023 – Data Science Dojo Technical skills Data science is a rapidly growing field, and as such, the skills required for a data scientist are constantly evolving.

Data Scientist 221

Data Scientist Exploratory Data Analysis Data Visualization Machine Learning 221

phData

MARCH 31, 2023

You have tons of data and SQL to migrate, and you need to ensure that it’s done right, or it’s your job on the line! Whether it’s translating SQL, ensuring parity between platforms, allowing for programmatic and consistent platform administration, or auditing your system for best practices and organizational policies, we’ve got you covered.

SQL 52

SQL Data Profiling Data Pipeline Database 52

phData

OCTOBER 5, 2023

Over the last month, we’ve been continuing to focus heavily on adding additional support for our Microsoft SQL Server to Snowflake SQL translations. SQL Server to Snowflake Translations Over the course of the last month, we’ve been heavily focused on adding additional support for this SQL translation pairing.

SQL 52

SQL 52

phData

NOVEMBER 2, 2023

Going one step deeper, Cortex powers LLM (and traditional ML) functionality that can be called using Snowflake SQL. Copilot outputs SQL queries and provides buttons to add that SQL to your Snowflake worksheet and run the query. We talked a lot about it after Summit 2023, but the demos from Snowday made us even more excited.

ML 52

ML ML AI AI 52

phData

JULY 29, 2023

We’ve been focusing on two key areas: Microsoft SQL Server to Snowflake Data Cloud SQL translations and our new Advisor tool within the phData Toolkit. SQL Translation Updates When customers are looking to migrate between platforms, there’s always a challenge in migrating existing code. Let’s dive in.

SQL 52

SQL Database Data Pipeline 52

Hacker News

MARCH 6, 2024

PostgreSQL became a go-to SQL database for many developers over the past couple of years. While being an SQL database, Postgres also includes a lot of.

SQL 63

SQL Database 63

phData

MARCH 1, 2023

The first one we want to talk about is the Toolkit SQL analyze command. This command will take in the source and target dialects, a directory of SQL to analyze (along with some other inputs), and generate a coverage report. The other major new feature we want to talk about is the Toolkit SQL translate command.

SQL 52

SQL Data Pipeline Data Quality Database 52

ODSC - Open Data Science

MARCH 20, 2023

ODSC East 2023 is still a bit over a month away, but we’re excited to be able to share our Preliminary Schedule with you! Day 0: Monday, May 8th Day 0 of ODSC East 2023 will be exclusive to Mini-Bootcamp and VIP pass holders, and will be a virtual-only day comprising the first bootcamp sessions of the week.

Data Science 98

Data Science Data Wrangling Python Deep Learning 98

phData

JULY 12, 2023

Unlike traditional methods that rely on complex SQL queries for orchestration, Matillion Jobs provides a more streamlined approach. By converting SQL scripts into Matillion Jobs , users can take advantage of the platform’s advanced features for job orchestration, scheduling, and sharing. In our case, this table is “orders.”

SQL 52

SQL ETL Database Data Pipeline 52

IBM Journey to AI blog

OCTOBER 18, 2023

On December 5–6, 2023 at the Computer History Museum in Mountain View, CA, hundreds of developers and software engineers will come together at PrestoCon 2023 to support and learn more about Presto, the open-source SQL query engine for data analytics and the Open Data Lakehouse.

SQL 84

SQL Database Analytics Analytics 84

Data Science Dojo

MAY 10, 2023

Here, we outline the essential skills and qualifications that pave way for data science careers: Proficiency in Programming Languages – Mastery of programming languages such as Python, R, and SQL forms the foundation of a data scientist’s toolkit.

Data Science 368

Data Science Database Administration Data Scientist Machine Learning 368

KDnuggets

NOVEMBER 30, 2022

Linux for Data Science Cheatsheet • The Complete Data Engineering Study Roadmap • 10 Amazing Machine Learning Visualizations You Should Know in 2023 • 7 SQL Concepts Needed for Data Science. What is Chebychev's Theorem and How Does it Apply to Data Science?

Data Science 133

Data Science SQL Data Engineering Data Engineer 133

phData

MAY 1, 2023

Welcome to the April 2023 update of the phData Toolkit blog series! We’ve also spent a good amount of time upgrading our Netezza to Snowflake SQL translations. The tool converts the templated configuration into a set of SQL commands that are executed against the target Snowflake environment. Let’s take a deeper dive!

SQL 52

SQL 52

phData

JUNE 6, 2023

Toolkit CLI Updates The Toolkit CLI is an extension of our Toolkit UI and aims to provide a programmatic interface for a variety of tasks such as SQL translation, profiling of source/target databases, and generating scripts using those profiles. Explore phData Toolkit The post phData Toolkit May 2023 Update appeared first on phData.

SQL 52

SQL Data Governance AWS Database 52

phData

JUNE 26, 2023

While many of our customers leverage our UI for tools like our SQL Translation or Privilege Audit tooling, there are limitations when it comes to using a UI. You wouldn’t want to pay someone (or perform yourself) to manually copy/paste each file into a browser window and copy/paste the translated SQL back.

SQL 52

SQL Data Profiling Data Pipeline Data Governance 52