Analytics Vidhya

MAY 16, 2024

Introduction You can easily create a simple application that can chat with SQL Database. You can’t make it work seamlessly when it comes to handling and working with large databases. But here’s the problem with that.

SQL 328

SQL Database AI AI 328

Analytics Vidhya

MARCH 8, 2024

Introduction Proficiency with databases and SQL is essential for many job choices in today’s tech-driven world, from ambitious software engineers to fledgling data professionals. These courses offer […] The post Top 5 University Courses to Learn Databases and SQL appeared first on Analytics Vidhya.

SQL 329

SQL Database Analytics Analytics 329

Analytics Vidhya

JULY 18, 2022

Introduction Relational databases are here to stay, regardless of the hype and the rise of newer ones called NoSQL databases. The simple reason is that relational databases enforce basic structure and constraints and provide a friendly, declarative language for querying data (that we […].

Database 306

Database SQL Data Science Analytics 306

Analytics Vidhya

JULY 29, 2022

Introduction SQL?—?A As its name suggests, it is primarily used to query, i.e., fetch the data from the relational database where data is stored in the form of tables. SQL helps […]. The post SQL Commands for Data Science appeared first on Analytics Vidhya.

SQL 397

SQL Data Science Database Analytics 397

Analytics Vidhya

FEBRUARY 27, 2023

The database is the major element of a data science project. To generate actionable insights, the database must be centralized and organized efficiently. If a corrupted, unorganized, or redundant database is used, the results of the analysis may become inconsistent and highly misleading. appeared first on Analytics Vidhya.

Database 319

Database SQL Data Science Analytics 319

Analytics Vidhya

JULY 2, 2024

Introduction Structured Query Language (SQL) is the foundation of managing and manipulating relational databases. One of the most powerful features in SQL is the use of views. They simplify and compress complex queries, making database interactions more efficient and manageable. appeared first on Analytics Vidhya.

SQL 336

SQL Data Analyst Database Analytics 336

Analytics Vidhya

JUNE 25, 2024

Introduction If you are someone who handles databases at work, I’m sure you use SQL a lot. Doesn’t SQL make it a breeze to work with and edit the contents of large databases?

SQL 315

SQL Data Analyst Database Data Scientist 315

Analytics Vidhya

FEBRUARY 5, 2020

Overview Relational databases are ubiquitous, but what happens when you need to scale your infrastructure? We will discuss the role Spark SQL plays in. The post Hands-On Tutorial to Analyze Data using Spark SQL appeared first on Analytics Vidhya.

SQL 400

SQL Database Analytics Analytics 400

Analytics Vidhya

JULY 15, 2024

Introduction Ever had a bunch of text in your database that needed a quick fix? That’s where the SQL REPLACE function comes in handy! Imagine you have a typo scattered throughout your data—REPLACE can handle […] The post 6 Practical Ways to Clean Up Your Database Using SQL REPLACE() appeared first on Analytics Vidhya.

SQL 291

SQL Database Analytics Analytics 291

Analytics Vidhya

FEBRUARY 2, 2023

Introduction SQL injection is an attack in which a malicious user can insert arbitrary SQL code into a web application’s query, allowing them to gain unauthorized access to a database. We can use this to steal sensitive information or make unauthorized changes to the data stored in the database.

SQL 290

SQL Database Analytics Analytics 290

Analytics Vidhya

OCTOBER 12, 2022

This brings up databases, and SQL and PL/SQL stand […]. The post SQL and PL/SQL – An Unmissable Comparison appeared first on Analytics Vidhya. Data is getting significant and gaining more traction by the day. Hence it is required to store such a large amount of data carefully.

SQL 341

SQL Data Science Database Analytics 341

Analytics Vidhya

JANUARY 16, 2024

Introduction Searching for specific patterns within the data is often necessary when working with databases. This is where the SQL LIKE operator comes in handy. The LIKE operator allows you to perform pattern matching on text data, making it a powerful tool for filtering and retrieving information from a database.

SQL 306

SQL Database Analytics Analytics 306

Analytics Vidhya

JUNE 11, 2024

Introduction Stored procedures are a crucial part of SQL databases. They consist of prepared SQL code that you can save and reuse. This article […] The post Stored Procedure in SQL appeared first on Analytics Vidhya. This feature helps avoid writing the same queries repeatedly.

SQL 318

SQL Database Analytics Analytics 318

Analytics Vidhya

JUNE 3, 2024

Introduction In SQL and database management, efficiently querying and retrieving data is paramount. Unlike basic string functions, CONTAINS enables complex queries and patterns, making it a powerful asset for developers and database administrators. […] The post What is CONTAINS in SQL?

SQL 328

SQL Database Administration Database Analytics 328

Analytics Vidhya

APRIL 29, 2022

The post From Blob Storage to SQL Database Using Azure Data Factory appeared first on Analytics Vidhya. The data-driven workflow in ADF orchestrates and automates the data movement and data transformation. In this article, I’ll show […].

Azure 328

Azure SQL Database ETL 328

Analytics Vidhya

JULY 8, 2024

Introduction Managing data transactions is an important skill to have while working with databases. Tools like Structured Query Language (SQL) help you do this efficiently. In this […] The post Difference Between SQL Commit and SQL Rollback appeared first on Analytics Vidhya.

SQL 303

SQL Database Analytics Analytics 303

Analytics Vidhya

JULY 4, 2024

Introduction An index is a unique lookup table in SQL databases that the database search engine can use to expedite data retrieval. When an index is built on a table’s columns, the database can locate rows considerably more quickly than in the absence of an index. appeared first on Analytics Vidhya.

SQL 306

SQL Database Analytics Analytics 306

Analytics Vidhya

NOVEMBER 29, 2021

SQL stands for Structured Query Language which is used to deal with Relational Databases to query from and manipulate databases. The post A Complete Beginner-Friendly Guide to SQL for Data Science appeared first on Analytics Vidhya. This article was published as a part of the Data Science Blogathon.

Data Science 393

Data Science SQL Database Analytics 393

Analytics Vidhya

JULY 3, 2024

Introduction Keys are an important part of SQL, and the primary, foreign, and candidate keys hold a significant value. They are used to design our database, Ensure the integrity of our data, and create an efficient way to retrieve records. Further in […] The post What are the SQL Alternate Keys? Intriguing right?

SQL 335

SQL Database Analytics Analytics 335

Analytics Vidhya

JUNE 21, 2024

Introduction SQL is a go to tool when working with data, and so is important for anybody working with data. SQL has a wide range of functions for creating, manipulating, and managing databases, making it all so easy.

SQL 303

SQL Database Analytics Analytics 303

Analytics Vidhya

JULY 29, 2024

Introduction The CONCAT function in Structured Query Language (SQL) connects or concatenates two or more strings into a single string. This feature is crucial for data formatting and modification, which makes it an indispensable tool for database developers and administrators. The […] The post What is CONCAT in SQL?

SQL 328

SQL Database Analytics Analytics 328

Analytics Vidhya

JUNE 4, 2022

Introduction on SQL Server SQL Server is an RDBMS developed and maintained by Microsoft. Triggers are used in SQL Server to respond to an event in the database server. Trigger automatically gets fired when an event occurs in the database server. A trigger is a […].

SQL 348

SQL Database Data Science Analytics 348

Analytics Vidhya

APRIL 26, 2022

Introduction on Apache Cassandra Apache Cassandra is a scalable database intended to manage massive volumes of data over many commodity computers while maintaining high availability and avoiding a unique failure point. It has high performance, and it is a NO-SQL database. Before understanding […].

SQL 271

SQL Database Data Science Analytics 271

Analytics Vidhya

JUNE 21, 2024

Introduction ALTER command is one of the most important SQL functions to know for database manipulation and management. In addition, ALTER TABLE […] The post SQL ALTER TABLE Statement appeared first on Analytics Vidhya. We’ll look at different ways to use the ALTER command to highlight its flexibility.

SQL 316

SQL Database Analytics Analytics 316

Analytics Vidhya

JULY 3, 2024

Introduction When working with databases, one of the most important things to manage is who can do what within your database. Structured Query Language (SQL) has a function to help you with this. The SQL GRANT command lets you assign specific permissions to different users. appeared first on Analytics Vidhya.

SQL 306

SQL Database Analytics Analytics 306

Analytics Vidhya

MAY 14, 2022

Introduction to SQL SQL stands for the Structure Query Language. And it is the most popular RDBMS (Relational Database Management System) language used to create, access, and manage databases. SQL became a standard of the […]. It was developed in the year 1970 at IBM.

SQL 348

SQL Database Data Science Analytics 348

Analytics Vidhya

JUNE 10, 2024

Introduction In SQL, comparison operators are crucial for querying databases. The SQL Not Equal operator is one of the most used. It excludes specific data from query results, making it vital for database management. Whether […] The post Understanding SQL Not Equal Operator appeared first on Analytics Vidhya.

SQL 306

SQL Database Analytics Analytics 306

Analytics Vidhya

JULY 7, 2024

Introduction TCL (Transaction Control Language) commands are crucial in SQL overseeing changes enacted by DML (Data Manipulation Language) statements. These commands enable users and database administrators to manage transaction processes, maintaining data consistency and integrity. appeared first on Analytics Vidhya.

SQL 328

SQL Database Administration Database Analytics 328

Analytics Vidhya

JUNE 10, 2024

Introduction SQL (Structured Query Language) is an important topic to understand while working with databases. It allows us to interact with databases efficiently. These commands help define and manage the structure of database objects, making them essential for any database system.

SQL 306

SQL Database Analytics Analytics 306

Analytics Vidhya

JULY 30, 2022

Introduction The structured data we generally deal with gets stored in a tabular format in relational databases. And stored data in these databases can be accessed by a query language called “sequel” or SQL. The post A brief introduction to SQL Alchemy appeared first on Analytics Vidhya.

SQL 348

SQL Database Data Science Analytics 348

Analytics Vidhya

MAY 30, 2022

Introduction SQL, Structured Query Language, is a query language. It is used for data manipulation, retrieval, and exploration and is the core data handling tool for relational databases. SQL gets used by data scientists, analysts, web developers, and other tech geeks for data […].

SQL 351

SQL Data Scientist Database Data Science 351

Analytics Vidhya

JULY 5, 2024

Introduction In relational databases, where data is meticulously organized in tables, understanding their structure is essential. SQL’s DESCRIBE (or DESC in some database systems) command gives you to become a data detective, peering into the internal makeup of your tables and extracting valuable information.

SQL 319

SQL Database Analytics Analytics 319

Analytics Vidhya

JUNE 20, 2024

Introduction SQL is an essential tool to know for anybody working with data. It comes with a range of functions that make querying in databases, a breeze. In this article, we are going to see one of the fundamentals of SQL, the SELECT statement.

SQL 317

SQL Database Analytics Analytics 317

Analytics Vidhya

JUNE 21, 2024

Introduction An extensive explanation of SQL Data Manipulation Language (DML) commands is given in this article. DML commands are essential for managing and changing data in databases.

SQL 306

SQL Database Analytics Analytics 306

Analytics Vidhya

MAY 20, 2022

Introduction SQL stands for “Structured Query Language” and is a programming language that is used to query and manipulate relational databases. All this data is stored in databases […]. The post Most Important SQL Queries for Beginners appeared first on Analytics Vidhya.

SQL 335

SQL Database Data Science Analytics 335

Analytics Vidhya

JANUARY 24, 2023

Introduction What kind of database did you use to build your most recent application? According to Scalegrid’s 2019 database trends report, SQL is the most popular database form, with more than 60% of its use. It is followed by NoSQL databases with more than 39% use.

Database 328

Database SQL Analytics Analytics 328

Analytics Vidhya

JANUARY 17, 2024

Introduction Structured Query Language (SQL) is the backbone of relational database management systems, empowering users to interact with and retrieve information from databases. When working with databases, sorting the data in a specific order is often necessary to make it more meaningful and easier to analyze.

SQL 318

SQL Database Analytics Analytics 318