How to setup a database & write your first SQL query?

📚 Learn how to solve problems and build projects with these Free E-Books ⬇️

Experience the power of practical learning, gain career-ready skills, and start building real applications!
This is a step-by-step course designed to take you from beginner to expert in no time!
💰 Here is a coupon to save 10% on your first payment (CODEBEAUTY_YT10).
Use it quickly, because it will be available for a limited time.

I use it to enhance the performance, features, and support for C, C#, and C++ development in Visual Studio.
It is a powerful, secure text editor designed specifically for programmers.

However, please don't feel obligated to do so. I appreciate every one of you, and I will continue to share valuable content with you regardless of whether you choose to support me in this way. Thank you for being part of the Code Beauty community! ❤️😇

A database is an organized collection of data, stored in electronic format on your computer. A database is usually controlled by a database management system (DBMS).
We can use it to add, remove, update and retrieve data that match certain criteria, perform queries, complex aggregate calculations, etc.
⠀⠀⠀⠀⠀⠀⠀⠀⠀
Structured Query Language (SQL) is a language that is used to communicate with databases.⠀⠀⠀⠀⠀⠀⠀⠀⠀
In this video, I explained the easiest way to install and set up a database and write SQL queries.

Contents:
00:00 - Database download and installation
02:27 - Setup server and create a database
04:55 - Introduction to writing SQL queries
05:40 - SQL Create table command
09:29 - How to insert data into DB table (2 ways)
11:44 - SQL Insert into table command
12:45 - Common errors

Follow me on other platforms:

[CodeBeauty]

📚 Learn how to solve problems and build projects with these Free E-Books ⬇
Experience the power of practical learning, gain career-ready skills, and start building real applications!
This is a step-by-step course designed to take you from beginner to expert in no time!
💰 Here is a coupon to save 10% on your first payment (CODEBEAUTY_YT10).
Use it quickly, because it will be available for a limited time.

Code from this video:

create table Users (
Id int not null,
Name varchar(30) not null,
Age int not null,
primary key (Id)
);

insert into Users(Id, Name, Age)
values (2, 'Saldina Nurak', 27)

select * from Users

[qudratullahkhan]

Yes it was absolutely helpful video for SQL beginners. Thank you.
And yes we want you to please make a full length video about SQL.
Beautiful video ☺️

[nvusb]

Soo simple and easy. Wish I had seen this video earlier, because I tried to d this multiple times and it was so hard and there were many more steps in order to set this all up. Thanks Saldy 😍

[phoebewell]

Saldina, you're changing my life with your videos! I have much better grades now, and I feel so motivated to work. After I finish all your videos I'll apply for a job!

[birr]

Thankyou Saldina this is what i was waiting for, please make more videos on sql basics

[georgebentley-ricardo]

Thanks very much for sharing this informative lesson. A lesson on SQL would be awesome thank you very much 🤓👍

[deneristargerian]

This is the best video that I've watched so far!! Great <3<3<3

[marym]

I love the way you teach. I always leave with exactly what I wanted to learn after watching your videos. :*

[MichaelAbendrothPerez]

SQL course would definitely be appreciated. Thanks for the extremely helpful and thorough instruction Saldina!

[greatplays]

Saldina you were the very first teacher i had at programming I watched your entired 9 hour c++ video, and 5 months later I'm now accepted in gsoc, thanks for everything god bless you.

[anuragriswadkar]

This video couldn't have come at a better time. I have a test tomorrow on basic sql

[tarunkumar]

Yes, i definitely need a SQL course. Please make it happen

[dundyd]

OMG, this is exactly what I needed. You helped me so much! <3

[shazeenthowfeek]

Yes saldina,
Plz create a full lengthy SQL video 📹 lesson which will cover overall SQL methods...

[stevemulwa]

Thank you for the helpful video. Please make a full SQL tutorial for beginners.

[nataliabloom]

Thank you so much for making a series about SQL!! 🙏

[hilgicamala]

Just what I was looking for. All done, thanks! ;)

[abdelrahmanshaheen]

great! please make a course, your way of discussion is really awesome.

[kristopherdurham]

SQL course would be amazing! thanks for the content!

[imtplugs]

Hi Saldina. Lost of love all the way from Africa. Please do a full SQL series for us.