AI-powered search & chat for Data / Computer Science Students

Database 101: What Are They and How Are They Different

 Towards Data Science

We all have that love and hate relationship with the database, more specifically the data management system (DBMS). It’s an integral part that defines how to access one of the most valuable assets of…...

Read more at Towards Data Science

7 Database Concepts You Should Know About

 Better Programming

There’s a lot to know about databases. They’re complex mission-critical applications that sometimes require specialized subject matter experts to maintain them, but that doesn’t mean that they’re…

Read more at Better Programming

How Databases Work and Why They Are So Cool

 Javarevisited

At first glance databases seem like a pain to learn.It doesn’t seem that important or “cool” to learn as you would a programming language.But, you will find there are some important use cases for data...

Read more at Javarevisited

Database

 Codecademy

A database is a collection of structured information stored so it can be easily accessed and updated. In a computer system, databases are commonly accessed through a database management system, referr...

Read more at Codecademy

Database, SQL and NoSQL

 Analytics Vidhya

Database is a collection of information that is organized so that it can be easily accessed, managed and updated. Databases typically contain aggregations of data records or files, containing…

Read more at Analytics Vidhya

Getting Hands-On with Databases

 Towards Data Science

Data science is a field that has been experiencing explosive growth in the last few years and was deemed the “sexiest job of the 21st century” by Harvard Business Review in 2012. With high salaries…

Read more at Towards Data Science

An Introduction to Databases for Data Scientists

 Towards Data Science

Everything you need to know on databases in one article Continue reading on Towards Data Science

Read more at Towards Data Science

4 Must-Know Properties of Databases

 Towards Data Science

Everything about data science starts with data. Without proper and accurate data, data science is like a luxury car with no gas. A well-maintained, easily accessible, scalable, and hard-to-fail…

Read more at Towards Data Science

Databases: Fundamentals of SQL

 Towards Data Science

This post by no means can completely cover every aspect of SQL functionality, however, I’m attempting to create a quick reference guide that provides the practical aspect of SQL and shows important…

Read more at Towards Data Science

Understanding Database Types

 ByteByteGo Newsletter

The success of a software application often hinges on the choice of the right databases. As developers, we're faced with a vast array of database options. It is crucial for us to understand the differ...

Read more at ByteByteGo Newsletter

SQL BASICS

 Analytics Vidhya

Structured Query Language (SQL) is one of the essential languages used by data scientists. It is designed to manage and query data in relational databases like MySQL and PostgreSQL. It’s also one of…

Read more at Analytics Vidhya

Querying Databases

 Towards Data Science

In the quest of every aspiring data scientist to get a job, there comes a point where they must master database querying. If you begin your journey with SQL instead of a programming language like…

Read more at Towards Data Science

DB 101: Databases for Developers

 Better Programming

Over the past few weeks, I’ve been doing some deep-diving into databases as part of my day-job effort to migrate our existing Postgres 9x databases to something more recent, like Postgres 13. As an…

Read more at Better Programming

System Design Interview: Mastering Databases

 Level Up Coding

When it comes to system design interviews, understanding the intricacies of databases is paramount. If you’re gearing up for such an interview and you’re scratching your head over databases, you’ve co...

Read more at Level Up Coding

SQL Database Design Basics with Example

 Towards Data Science

It is a common practice that a DB architect has to design a relational database tailored to a particular solution. One Friday evening, I was coming home from work on a commuter train, and I was…

Read more at Towards Data Science

4 Must Know Database Paradigms

 Level Up Coding

What The Most Common Database Paradigms Look Like Continue reading on Level Up Coding

Read more at Level Up Coding

Categories of Databases — A Primer

 Analytics Vidhya

This is not a guide for choosing which Database you need. This is a guide for you to choose which Category of Database you need. Before choosing a Database you should know which category of Database…

Read more at Analytics Vidhya

Mastering SQL Fundamentals

 Level Up Coding

A Comprehensive Guide Photo by Leif Christoph Gottwald on Unsplash This article is designed for beginners in the SQL language, offering a step-by-step guide starting from the most fundamental concept...

Read more at Level Up Coding

First steps to SQL!

 Analytics Vidhya

When we think about the amount of data we are storing and using, it looks like SQL is going to be around for a long time. Let’s assume that we have a database on a server. This server can be on a…

Read more at Analytics Vidhya

How To Choose the Right Database

 Towards AI

A blog around how companies decided which databases are right for them Photo by Caspar Camille Rubin on Unsplash Choosing the right database can be a challenge for businesses. You need to understand ...

Read more at Towards AI

A Simple Database

 Object-oriented Programming in Java

The document provides information about implementing a simple database of employee records using an array. It includes a template for creating employee record objects, along with details about the Emp...

Read more at Object-oriented Programming in Java

4 Important SQL Concepts for Beginners

 Towards Data Science

Let’s learn some important SQL concepts for beginners to power up your queries Continue reading on Towards Data Science

Read more at Towards Data Science

SQL: Tables and Basic Structure

 Renan Moura – Software Engineering

This is a direct continuation of my previous article Introduction to SQL. SQL works on a structure with four components: Table, Field, Row, and Column. You can think of those components exactly like t...

Read more at Renan Moura – Software Engineering

Practical SQL: Designing and Creating a Relational Database

 Towards Data Science

SQL is a programming language that is used by most relational database management systems (RDBMS) to manage data stored in tabular form (i.e. tables). A relational database consists of multiple…

Read more at Towards Data Science