DEV Community

Introduction to SQL for Absolute Beginners!

Pavan Belagatti on October 03, 2023

Diving into the world of databases might seem daunting, but with the right guidance, it becomes an intriguing journey. SQL, or Structured Query Lan...
Collapse
 
rickdelpo1 profile image
Rick Delpo

Thanks Pavan for the easy to understand CRUD operations on SQL (create, read, update, delete). To extend this a bit further we also have the javascript equivalents of SQL CRUD operations here
dev.to/rickdelpo1/crud-4-sql-comma...
From a Javascript frontend we can store data in NoSQL using a JSON file. We then call Javascript Array methods on the data. This NoSQL approach is mainly for small use cases that don't involve relational data, such as a simple dashboard.

Collapse
 
michaeltharrington profile image
Michael Tharrington

Great post, Pavan! I hope there's a sequel.

Collapse
 
pavanbelagatti profile image
Pavan Belagatti

Sure, can extend this.

Collapse
 
respect17 profile image
Kudzai Murimi

Perfect Introduction, thanks Pavan.

Collapse
 
pavanbelagatti profile image
Pavan Belagatti

Glad you liked it.

Collapse
 
linuxguist profile image
Nathan S.R.

Thanks for this very useful post. I just wanted to add that, there is a very easy way now, to test all the SQLs described here, using the free & portable tools, mentioned in my latest post here : dev.to/linuxguist/learn-sql-quickl...

Collapse
 
thomasbnt profile image
Thomas Bnt

Very cool post!

Collapse
 
pavanbelagatti profile image
Pavan Belagatti

Thanks:)

Collapse
 
samareshdas profile image
Samaresh Das

SingleStore Notebooks is quite a delight. Many of the tools I used for SQL are always ugly looking and not the best, I loved the modern tool. Thanks.

Collapse
 
pavanbelagatti profile image
Pavan Belagatti

Thanks a lot. Please explore more on SingleStore Notebooks and also we have a discord channel I can add you:)

Collapse
 
teachersfuture profile image
Mark Lew

I need to set up a data base and do joins with another data base, about 100,000 property records. Can I hire someone to help me with this in Nov?