Chai aur SQL — A Beginner's Journey into Databases
The article discusses the basics of SQL and databases for beginners. It explains the role of servers in hosting databases and the importance of understanding raw SQL despite the availability of ORMs like Prisma. Additionally, it covers the Data Definition Language (DDL) commands used to create and manage database structures.
- ▪SQL stands for Structured Query Language and is used to communicate with relational databases.
- ▪A database is software running on a server, which is a powerful computer that operates continuously in a data center.
- ▪Understanding raw SQL is crucial as ORMs can sometimes generate inefficient queries.
Opening excerpt (first ~120 words) tap to expand
try { if(localStorage) { let currentUser = localStorage.getItem('current_user'); if (currentUser) { currentUser = JSON.parse(currentUser); if (currentUser.id === 3886570) { document.getElementById('article-show-container').classList.add('current-user-is-article-author'); } } } } catch (e) { console.error(e); } Abdul Rahman Posted on May 24 • Originally published at blog.abdulrdeveloper.me Chai aur SQL — A Beginner's Journey into Databases #backend #database #postgres #sql SQL stands for Structured Query Language. It is the language we use to talk to relational databases like MySQL, PostgreSQL, and SQLite. What is a Server and Where Does the Database Live? Most beginners think the database is somewhere floating in the "cloud." It is not. A database is software running on a server.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at DEV.to (Top).
Discussion
0 commentsMore from DEV.to (Top)
