AI-powered search & chat for Data / Computer Science Students
Database 101: What Are They and How Are They Different
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 Science7 Database Concepts You Should Know About
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 ProgrammingHow Databases Work and Why They Are So Cool
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 JavarevisitedDatabase
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 CodecademyDatabase, SQL and NoSQL
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 VidhyaGetting Hands-On with Databases
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 ScienceAn Introduction to Databases for Data Scientists
Everything you need to know on databases in one article Continue reading on Towards Data Science
Read more at Towards Data Science4 Must-Know Properties of Databases
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 ScienceDatabases: Fundamentals of SQL
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 ScienceUnderstanding Database Types
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 NewsletterSQL BASICS
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 VidhyaQuerying Databases
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 ScienceDB 101: Databases for Developers
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 ProgrammingSystem Design Interview: Mastering Databases
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 CodingSQL Database Design Basics with Example
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 Science4 Must Know Database Paradigms
What The Most Common Database Paradigms Look Like Continue reading on Level Up Coding
Read more at Level Up CodingCategories of Databases — A Primer
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 VidhyaMastering SQL Fundamentals
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 CodingFirst steps to SQL!
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 VidhyaHow To Choose the Right Database
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 AIA Simple Database
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 Java4 Important SQL Concepts for Beginners
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 ScienceSQL: Tables and Basic Structure
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 EngineeringPractical SQL: Designing and Creating a Relational Database
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- «
- ‹
- …