Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
SQL Articles
Found 115 articles
How to Convert SQL Query Results to Pandas Dataframe Using Pypyodbc?
Python's pypyodbc library provides a simple way to connect to SQL databases and convert query results into Pandas DataFrames. This approach is essential for data analysis workflows where you need to extract data from databases and manipulate it using Python's powerful data science tools. Installation and Setup First, install the required libraries using pip: pip install pypyodbc pandas Import the necessary libraries in your Python script: import pypyodbc import pandas as pd Establishing Database Connection Create a connection string with your database credentials. Here's an example for SQL Server: ...
Read MoreWhat Tools Besides Python, R, and SQL are all Data Scientists Expected to Know?
Data science is a rapidly evolving field that requires a diverse set of skills and tools to keep up with the ever-changing data landscape. While Python, R, and SQL are undoubtedly the most commonly used tools in the data science industry, there are several other essential tools and technologies that data scientists are expected to be proficient with. In this article, we'll explore some of the key additional tools that every data scientist should be familiar with. Excel Excel remains a powerful tool for data analysis and is widely used in the business world. It is particularly valuable ...
Read MoreWhich is Easier to Learn, SQL or Python?
Both SQL and Python are essential skills in today's data-driven world. While SQL is designed specifically for database management, Python offers broader programming capabilities. Understanding their differences helps you choose the right starting point for your learning journey. What is SQL? SQL (Structured Query Language) is a specialized language for managing relational databases. It uses a declarative approach — you specify what you want, and the database handles how to get it. Example A simple SQL query to retrieve customer data ? SELECT name, email FROM customers WHERE age > 25; ...
Read MoreJavaScript - Find keys for the matched values as like query in SQL
In JavaScript, you can filter object properties based on value matching, similar to SQL's WHERE clause with LIKE operator. This is useful for searching through data structures and finding keys that match specific criteria. Problem Statement Given an object with key-value pairs, we need to find all keys whose values contain a specific search term (case-insensitive). const obj = { "100": "Jaipur", "101": "Delhi", "102": "Raipur", "104": "Goa" }; We want to create a function that returns ...
Read MoreOperations on Files
When working with files in a DBMS, two fundamental types of operations are performed: retrieval (finding and reading records) and update (inserting, deleting, or modifying records). Both use selection conditions to identify target records. Selection Conditions A selection condition specifies criteria that records must meet. Conditions can be − Simple − Uses one field (e.g., Ssn = '123-45-6789') Complex − Combines multiple fields with comparison operators (e.g., Department = 'Sales' AND Salary ≥ 30000) File Operations The typical sequence of file operations − 1. Open file 2. Find first record matching ...
Read MoreObject-Relational Features_ Object Database Extensions to SQL
The object-relational model combines relational databases with object database features. SQL (starting from SQL:1999 and refined in SQL:2008) incorporates object extensions including user-defined types, object identity, encapsulation, and inheritance. Key Object Features in SQL Feature Description Type Constructors ROW type (struct), ARRAY, SET, LIST, BAG for complex objects Object Identity REF types provide unique object identifiers (OIDs) Encapsulation Methods defined within UDTs (User-Defined Types) Inheritance UNDER keyword for type and table inheritance User-Defined Types (UDTs) UDTs allow creating complex-structured objects with custom attributes and ...
Read MoreNested Queries in SQL
A nested query (subquery) is a query placed inside another query. The inner query executes first and its result is used by the outer query for more complex data retrieval. Syntax SELECT column1, column2 FROM table1 WHERE column1 IN ( SELECT column1 FROM table2 WHERE condition ); Types of Nested Queries Non-Correlated Inner runs independently Result passed to outer Operators: IN, NOT IN, ALL, ANY ...
Read MoreDifference between NoSQL and RDBMS
RDBMS stores data in structured tables with fixed schemas using SQL. NoSQL is a non-relational approach with flexible schemas, designed for large-scale distributed data. Companies like Amazon, Facebook, and Google pioneered NoSQL to handle massive data volumes that traditional RDBMS struggled with. RDBMS ID Name Age Fixed Schema | Vertical Scaling vs NoSQL ...
Read MoreWhat is NoSQL and is it the next big trend in databases?
A NoSQL ("non SQL" or "non relational") database stores and retrieves data using models other than relational tables. NoSQL databases are structured as key-value pairs, documents, columns, or graphs − designed for large-scale data, high performance, and flexible schemas. Why NoSQL? Applications like Facebook, Google, and Amazon need to handle massive data volumes that traditional RDBMS struggles with. NoSQL allows adding new data fields without redesigning the entire schema − ideal for agile development. SQL vs NoSQL Example SQL requires predefined tables and schema changes for new features ? CREATE TABLE users (id INT ...
Read MoreDifference between Function and Procedure
SQL (Structured Query Language) is a computer language which is used to interact with an RDBMS (Relational Database Management System). It is basically a method of managing, organizing, and retrieving data from a relational database. In SQL, two important concepts are used namely, function and procedure. A function calculates the results of a program based on the inputs provided, whereas a procedure is used to perform some tasks in a specific order. There are many other differences between functions and procedures, which we will discuss in this article. What is Function? A function, in the context of ...
Read More