Becoming Human

FEBRUARY 1, 2023

So far this is the 7th blog in the journey of basics to advance SQL. you can refer to previous blogs for learning SQL from scratch, This blog contains good knowledge about views, functions, and stored procedures. VIEWS A view is actually a virtual table-based approach as a result set for SQL statement.

SQL 64

SQL Data Science Artificial Intelligence Artificial Intelligence 64

Becoming Human

JANUARY 23, 2023

Day 5: Advance SQL For Data Science This blog contains Window Ranking function in SQL like (Rank, Dense_Rank, Row_Number , Lead, Lag) . Rank() This RANK() function calculates a rank to each row within a partition of a result set. Reference : [link] [link] Hope you found it helpful! Thanks for reading! Let’s connect on LinkedIn !

Data Science 59

Data Science SQL Artificial Intelligence Artificial Intelligence 59

Becoming Human

JANUARY 23, 2023

Day 6: Advance SQL For Data Science This blog contains type of joins like Inner join, Left join, Right join , Full join, Self join and Cross join. A JOIN clause is used to combine rows from two or more tables, based on a related column between them. Self Join A self-join is a regular join, in which the table joins itself. user_id , T1.name,

Data Science 59

Data Science SQL Artificial Intelligence Artificial Intelligence 59

Smart Data Collective

APRIL 8, 2020

In fact, studies by the Gigabit Magazine depict that the amount of data generated in 2020 will be over 25 times greater than it was 10 years ago. This data is then processed, transformed, and consumed to make it easier for users to access it through SQL clients, spreadsheets and Business Intelligence tools.

Data Warehouse 144

Data Warehouse Big Data Big Data Big Data Analytics 144

Towards AI

JULY 21, 2023

This Week Sentence Transformers txtai: AI-Powered Search Engine Fine-tuning Custom Datasets Data API Endpoint With SQL It’s LIT ? Data API Endpoint With SQL If you like SQL and you like data, Port 5432 is open… Splitgraph allows users to connect to more than 40K datasets via a PostgreSQL client. ? Broadcaster Stream API Fast.ai

Deep Learning 96

Deep Learning Deep Learning SQL Natural Language Processing 96

Becoming Human

MAY 15, 2023

One is a scripting language such as Python, and the other is a Query language like SQL (Structured Query Language) for SQL Databases. There is one Query language known as SQL (Structured Query Language), which works for a type of database. SQL Databases are MySQL , PostgreSQL , MariaDB , etc.

Data Science 75

Data Science Machine Learning Machine Learning Database 75

Pickl AI

SEPTEMBER 25, 2023

Essential Tools for Data Science To get started, you’ll need to familiarize yourself with essential tools like Python, R, and SQL. Subscribing to newsletters and magazines will help you stay up-to-date with relevant information and updates in the world of Data Science. Staying Updated Data Science is a rapidly evolving field.

Data Science 52

Data Science Data Analysis Data Analysis Data Visualization 52