This site uses cookies to improve your experience. To help us insure we adhere to various privacy regulations, please select your country/region of residence. If you do not select a country, we will assume you are from the United States. Select your Cookie Settings or view our Privacy Policy and Terms of Use.
Cookies and similar technologies are used on this website for proper function of the website, for tracking performance analytics and for marketing purposes. We and some of our third-party providers may use cookie data for various purposes. Please review the cookie settings below and choose your preference.
Used for the proper function of the website
Used for monitoring website traffic and interactions
Cookies and similar technologies are used on this website for proper function of the website, for tracking performance analytics and for marketing purposes. We and some of our third-party providers may use cookie data for various purposes. Please review the cookie settings below and choose your preference.
Books Database SQL 
Analytics Vidhya
MAY 22, 2021
ArticleVideo Book This article was published as a part of the Data Science Blogathon Introduction Getting complete and high-performance data is not always the case. The post How to Fetch Data using API and SQL databases! appeared first on Analytics Vidhya.
400 
KDnuggets
JUNE 10, 2024
Learn SQL and databases through free courses, tutorials, tools, guides, books, practice exercises, projects, awesome lists, and other resources.
367
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Agent Tooling: Connecting AI to Your Tools, Systems & Data
Automation, Evolved: Your New Playbook for Smarter Knowledge Work
How to Modernize Manufacturing Without Losing Control
Mastering Apache Airflow® 3.0: What’s New (and What’s Next) for Data Orchestration
Analytics Vidhya
DECEMBER 6, 2023
Introduction Structured Query Language (SQL) is the backbone of relational database management systems. It serves as a powerful tool for manipulating and retrieving data from large databases. Whether you […] The post Top 10 Books to Master SQL Concepts in 2024 appeared first on Analytics Vidhya.
306 
KDnuggets
MAY 5, 2022
The free book is a combination of SQL cheat sheets and practical database examples. It provided bite-size information about every SQL function and attribute with coding samples.
399 
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.
306 
Analytics Vidhya
JUNE 10, 2021
ArticleVideo Book This article was published as a part of the Data Science Blogathon Introduction Everyone dealing with data in any capacity has to be. The post How to Access & Use SQL Database with pyodbc in Python appeared first on Analytics Vidhya.
271 
Analytics Vidhya
JUNE 28, 2021
ArticleVideo Book This article was published as a part of the Data Science Blogathon In the age of relational databases, Joining and Merging tables is. The post Join the DataFrames like SQL tables in Python using Pandas appeared first on Analytics Vidhya.
352 
Analytics Vidhya
APRIL 28, 2021
ArticleVideo Book This article was published as a part of the Data Science Blogathon. The post Learn how to get insights from Azure SQL Database: A sample data analytics project using Global Peace Index data appeared first on Analytics Vidhya. Introduction Are you passionate about the empirical investigation to find.
271 
Analytics Vidhya
SEPTEMBER 24, 2024
Introduction Imagine you’re trying to find a specific piece of information from a giant library where some books have other smaller books inside them. To find the right answer, you may need to first look at the smaller books, then use that information to find the larger one.
269 
Analytics Vidhya
AUGUST 14, 2021
ArticleVideo Book This article was published as a part of the Data Science Blogathon Pretty much everything or all sorts of information available online is. The post What is relational about Relational Databases? appeared first on Analytics Vidhya.
329 
Analytics Vidhya
APRIL 12, 2021
ArticleVideo Book This article was published as a part of the Data Science Blogathon. Introduction MongoDB is a free open-source No-SQL document database. The post How To Create An Aggregation Pipeline In MongoDB appeared first on Analytics Vidhya.
319 
Pickl AI
APRIL 11, 2025
Summary: This tutorial guides you through using SQL’s auto increment feature to automatically generate unique identifiers for database records. It covers syntax, examples, and benefits across various SQL databases like MySQL and SQL Server. This is where Auto Increment in SQL becomes invaluable.
52 
Pickl AI
APRIL 4, 2025
Summary: The SQL Cheat Sheet provides a handy reference for mastering SQL commands. It covers database creation, querying data using SELECT and WHERE, joins, data manipulation with INSERT and UPDATE, and advanced operations like transactions and constraints. Let’s dive in! Populating it with data. Modifying existing data.
52 
Analytics Vidhya
JULY 10, 2021
ArticleVideo Book This article was published as a part of the Data Science Blogathon Pre-requisites – Basic knowledge of any database. – Basic understanding of. The post A Beginner’s Guide to MySQL: Part 2 appeared first on Analytics Vidhya.
291 
Analytics Vidhya
JULY 31, 2022
We will build the database, which includes tables. Imagine that you go to the library, take a book, and just enter that book into the computer rather than entering your details […]. This article was published as a part of the Data Science Blogathon.
284 
NOVEMBER 27, 2024
While customers can perform some basic analysis within their operational or transactional databases, many still need to build custom data pipelines that use batch or streaming jobs to extract, transform, and load (ETL) data into their data warehouse for more comprehensive analysis. or a later version) database.
138 
Smart Data Collective
AUGUST 23, 2022
This entails using SQL servers appropriately. One of the things that you need to understand while running a data-driven company is how to use drop tables with SQL servers. This article shows how you can drop tables in SQL Server using a variety of different methods and applications. Creating a Dummy Database.
105 
Pickl AI
APRIL 1, 2025
Summary: A foreign key in SQL links tables, ensuring referential integrity and data consistency. Understanding foreign keys is essential for database management and data science. Learn SQL through Pickl.AIs courses and boost your database expertise. Thats where the foreign key in SQL comes in! Ready to dive in?
52 
Dataconomy
APRIL 27, 2023
What is an online transaction processing database (OLTP)? But the true power of OLTP databases lies beyond the mere execution of transactions, and delving into their inner workings is to unravel a complex tapestry of data management, high-performance computing, and real-time responsiveness.
159 
Pickl AI
FEBRUARY 3, 2023
Structured Query Language, or SQL, is a programming language used to communicate with databases. It means that SQL is the language used for storing, retrieving and manipulating data from relational databases. As a result, you may have a keen interest in finding the best books for SQL.
52 
DECEMBER 6, 2023
In this post, we discuss a Q&A bot use case that Q4 has implemented, the challenges that numerical and structured datasets presented, and how Q4 concluded that using SQL may be a viable solution. RAG with semantic search – Conventional RAG with semantic search was the last step before moving to SQL generation.
168 
Analytics Vidhya
JULY 19, 2021
ArticleVideo Book This article was published as a part of the Data Science Blogathon Introduction Tourism Management System is an integrated software developed for tourism. The post Beginner’s Guide to Cloud based Tourism Management System appeared first on Analytics Vidhya.
289 
AWS Machine Learning Blog
DECEMBER 4, 2024
They have structured data such as sales transactions and revenue metrics stored in databases, alongside unstructured data such as customer reviews and marketing reports collected from various channels. Use Amazon Athena SQL queries to provide insights. Kosti Vasilakakis is a Principal Product Manager at AWS.
108 
Pickl AI
MARCH 6, 2025
Summary: Database normalization is a systematic process that organizes data to reduce redundancy and improve integrity. Normalization in SQL is crucial for maintaining data consistency and scalability in relational databases. This is where normalization in SQL comes into play. What Is Normalization in SQL?
52 
Pickl AI
SEPTEMBER 3, 2024
Summary: The ALTER TABLE command in SQL is used to modify table structures, allowing you to add, delete, or alter columns and constraints. It is essential for adapting your database schema to evolving needs. Introduction The ALTER TABLE command in SQL is essential for modifying the structure of existing database tables.
52 
NOVEMBER 24, 2023
This use case highlights how large language models (LLMs) are able to become a translator between human languages (English, Spanish, Arabic, and more) and machine interpretable languages (Python, Java, Scala, SQL, and so on) along with sophisticated internal reasoning.
158 
Pickl AI
JULY 17, 2024
Summary: The row_number function in SQL assigns unique row numbers within defined partitions, enhancing tasks like ranking and pagination. Its integration as a window function streamlines complex operations, optimising database performance and query readability for SQL developers. SQL Server Error 26 and Methods to Resolve It.
52 
AWS Machine Learning Blog
MAY 30, 2024
In this post, we describe how CBRE partnered with AWS Prototyping to develop a custom query environment allowing natural language query (NLQ) prompts by using Amazon Bedrock, AWS Lambda , Amazon Relational Database Service (Amazon RDS), and Amazon OpenSearch Service. The wrapper function runs the SQL query using psycopg2.
132 
AWS Machine Learning Blog
FEBRUARY 13, 2025
Caching is performed on Amazon CloudFront for certain topics to ease the database load. Amazon Aurora PostgreSQL-Compatible Edition and pgvector Amazon Aurora PostgreSQL-Compatible is used as the database, both for the functionality of the application itself and as a vector store using pgvector. Its hosted on AWS Lambda.
118 
AWS Machine Learning Blog
FEBRUARY 14, 2024
In this post, we discuss how to use the comprehensive capabilities of Amazon Bedrock to perform complex business tasks and improve the customer experience by providing personalization using the data stored in a database like Amazon Redshift. This solution contains two major components. This solution contains two major components.
141 
Pickl AI
SEPTEMBER 19, 2024
Summary: The CASE statement in SQL provides conditional logic within queries, enabling flexible data manipulation. Proper usage and optimisation enhance query performance and adaptability, making it a crucial tool for effective SQL data management. What is a CASE Statement in SQL? Learn the Differences Between SQL and T-SQL.
52 
Pickl AI
JULY 14, 2024
It highlights their unique functionalities and applications, emphasising their roles in maintaining data integrity and facilitating efficient data retrieval in database design and management. Introduction In Database Management Systems (DBMS), keys are pivotal in maintaining data integrity and facilitating efficient data retrieval.
52 
Towards AI
JULY 20, 2023
I tried digging into the work of some of the people I admire to find an answer and I came across Cal Newport’s book “So good that they cannot ignore you” and my mind was literally blown. I am using the directness approach which Scott mentions in his book.
98 
Pickl AI
AUGUST 1, 2023
Aspiring and experienced Data Engineers alike can benefit from a curated list of books covering essential concepts and practical techniques. These 10 Best Data Engineering Books for beginners encompass a range of topics, from foundational principles to advanced data processing methods. Best Data Engineering Books for Beginners 1.
Mlearning.ai
FEBRUARY 13, 2023
Welcome to the wild, wacky world of databases! But with so many types of databases to choose from, how do you know which one is right for you? Databases are like different tools in a toolbox — each designed for a different need Picture a toolbox filled with different tools, each designed for a specific task. and let’s dive in!
52 
Pickl AI
JULY 31, 2024
Summary: MySQL is a widely used open-source relational database management system known for its reliability and performance. Overview of MySQL MySQL is one of the most popular relational database management systems (RDBMS) in the world, widely used for managing and organizing data.
52 
Data Science 101
AUGUST 27, 2023
The database is good old SQL Server and we have a pretty robust CI/CD pipeline that takes care of builds and deployments. Books (I’ll just list these out instead of blab on): The “Pragmatic Programmer” and “Clean Code” are classics. These are like bedrock books for any engineer. It’s a love-hate thing with Ember.
98 
IBM Journey to AI blog
APRIL 8, 2024
The new Amazon Relational Database Service (Amazon RDS) for Db2 offering allows customers to migrate their existing, self-managed Db2 databases to the cloud and accelerate strategic modernization initiatives. Are there any constraints on the number of databases that can be hosted on an instance? Scalability 5.
87 
Pickl AI
APRIL 29, 2024
Whether you’re a beginner or a seasoned pro, you’ll find valuable insights on core concepts like normalization, transactions, and database joins. Top DBMS Interview Questions and Answers (2024 Edition) The world runs on data, and at the heart of data management lies the Database Management System (DBMS).
52 
phData
SEPTEMBER 11, 2024
With Cortex Analyst from the Snowflake AI Data Cloud , business users can transform plain English questions into SQL queries, enabling self-service analytics and making data insights more accessible. This is especially powerful for users who may have pressing questions about their data but might not have the SQL-writing experience to do so.
52 
Dataversity
DECEMBER 20, 2021
However, this post is not a review of Larry’s book. Reading Larry Burns’ “Data Model Storytelling” (TechnicsPub.com, 2021) was a really good experience for a guy like me (i.e., someone who thinks that data models are narratives). I agree with Larry on so many things. Read it for yourself – highly recommended. Reading it triggered […].
98 
Pickl AI
OCTOBER 10, 2024
Introduction A Database Management System (DBMS) is essential for efficiently storing, managing, and retrieving application data. As databases grow, performance optimisation becomes critical to ensure quick access to information. One of the most effective techniques for enhancing database performance is indexing in DBMS.
52 
ODSC - Open Data Science
FEBRUARY 14, 2023
Trained with 570 GB of data from books and all the written text on the internet, ChatGPT is an impressive example of the training that goes into the creation of conversational AI. They are designed to understand and generate human-like language by learning from a large dataset of texts, such as books, articles, and websites.
124 
Pickl AI
FEBRUARY 11, 2025
Although modern databases favour relational and NoSQL models, understanding the hierarchical model remains crucial for database management and structured data applications. Introduction Database models define how data is structured, stored, and accessed. Hence, understanding database models is crucial.
52
Expert insights. Personalized for you.
We have resent the email to
Are you sure you want to cancel your subscriptions?
Let's personalize your content