How to Create Your First Database

Taking your design and turning into a live, working database might sound intimidating. But it's really not. CBT Nuggets trainer Garth Schulte demonstrates the process using Microsoft SQL Server.

-----------------
Connect with CBT Nuggets for the latest in IT training:

[tophattommy]

After hours of video trying to find a good This is it!!!!
Thank you!!!

[bilalislam]

Hey how do you define a Boolean variable in SQL. Like the value is either true or false. Is it not BOOL(0, 1)?

[omardesigns]

CBT nuggets this channel i remember watching vids since i was 14 years old now ill start my actual career in database administration

[leonlyan]

This is a Great Guide man. I am using a database for a while but dunno what is SQL means. This is a Perfect example of what "Structured Query Language" means. After watching this, I learned a lot. Thanks, Sir.

[jamessoy]

This is a great video. Thank you for sharing it with us.
Can you please post the SQL scripts you used? It would be very helpful to see the full text of the scripts.

[kevinbarbaira]

Where can I get the data? so I can do it live too! while watching you.

[sweetgema]

How do I get to see the solution explorer solution bar on my database, anyone ps help. Like how do I create the query.sql as it shows on the right hand side of this video

[stuartwill]

Can anyone tell me how many ways there are to create and edit databases?

You have MS SQL Server as shown here, a Ubuntu Linux based instance of SQL I've seen NetworkChuck make a tutorial for - are there any others ?

Trying to put these two different flavours of SQL in context.

[AmericaLIED]

I rather use the SQL which is not showing in the Solution Explore box on the right.

[AmericaLIED]

To right in the solution explore window for me its just showing SQLQuert1.sql

[danielhdezcordobes]

Hi, thanks for the video, it was really helpfull but, how do I create the server (for free) to connect my database?

[salat]

Better get this right at 1:36 "Empty values" are not the same as "missing values" - There's a very important difference between an *empty* string ('') and a *non existing* string (NULL)

[AM-Boluke]

I was following along with video however I don't think the sample data values were provided ?? Otherwise great video and THANK YOU!! #April2024

[chrishenning]

Following along and tried to save the db diagram but I get an error, “Saving changes is not permitted.” Any ideas?

[Gilltrick]

I am still looking for someone who realy make a video on how to create a db from scratch. Everybody is using third party solutions like here with sql. That is using. Not creating. Like most of use drive a car but would never say: "hey lets create (litterly build it) a car and drive it." PS.: Its quite easy and fun. As a benefit you truly understand it and suites best for your work.

[ukelaalred]

I opened “solutions explorer” after creating a new database and it is empty. Any suggestions please?

[jovelynramos]

hi where can I download this microsoft sql?

[AmericaLIED]

Second I finally found the Solution Explore (BUTTON) to the right and of course mine is OPEN but BLANK?!

[naomiezuminelson]

Thank you sir new subscribed here, this is very helpful ♥️

[AmericaLIED]

In my window its showing solution projects soultion1 then under that miscellaneous Files, then under that
SQLQuert1.sq. in the begginig you never showed how to open the Solution explore window you just jump right into it as if everyone has this window OPEN, , NOT!!!