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)
As I wrote - *NULL* means the absence of a value while an *empty string* '' means that we know the value is zero-length (e.g. we know there's no middle name). Also, if you concaternate strings and one of them is NULL, the result will be also NULL (not matter what was in the other strings). You also have to be careful with joins when there are possible NULL columns. A few good links: joshuapaling.com/blog/2015/05/05/nulls-in-database.html www.sqlservercentral.com/articles/database-design-follies-null-vs-not-null
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.
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
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.
You misunderstand. This is creating a database not “using one” what is being used here is a database engine like SQL. You’re looking for “how to create a database engine” Good luck.
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.
I'm surely late, but i had same problem and found a solution. It might help someone else. All you need to do is go: Tools -> Options... -> Designers -> Table and Database Designers -> Prevent saving changes that require table re-creation -> uncheck it -> OK and try to save your changes. Same thing with photos: blog.sandro-pereira.com/2018/12/03/a-fish-out-of-water-saving-changes-is-not-permitted-the-changes-that-you-have-made-require-the-following-tables-to-be-dropped-and-re-created/
Save (Not Permitted) Dialog Box The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created. The following actions might require a table to be re-created: Adding a new column to the middle of the table Dropping a column Changing column nullability Changing the order of the columns Changing the data type of a column To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.
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.
Hi Daniel, thank you for your question. Linux has been a great option for decades. They are extremely efficient and customizable. The bonus is that it's open source, so it's free. We have training on CBT Nuggets for Linux and some of the many uses for it. There are many follow up questions to your initial question for a server to connect to a database. It can depend on the database, and its dependencies. If there is a connection manager and the use cases you have for the database, and so on. We hope this is helpful! Thank you for learning with us.
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!!!
I wonder where you get your information from. As stated on DPpedia itself: "SQL (/ˌɛsˌkjuːˈɛl/ S-Q-L, /ˈsiːkwəl/ "sequel"; Structured Query Language) is a domain-specific language used in programming ..." So people agree that you SQL can be pronounced sequel, whether you like it or not.
After hours of video trying to find a good overview..... This is it!!!!
Thank you!!!
CBT nuggets this channel i remember watching vids since i was 14 years old now ill start my actual career in database administration
sameee, now im 14 😁
@@muhammadattaurahman4684 congratulations and happy birthday, bro if you like tech this channel shall teach you a lot 😊
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)
DB newbie here, care to explain the important difference? thanks.
As I wrote - *NULL* means the absence of a value while an *empty string* '' means that we know the value is zero-length (e.g. we know there's no middle name).
Also, if you concaternate strings and one of them is NULL, the result will be also NULL (not matter what was in the other strings).
You also have to be careful with joins when there are possible NULL columns.
A few good links:
joshuapaling.com/blog/2015/05/05/nulls-in-database.html
www.sqlservercentral.com/articles/database-design-follies-null-vs-not-null
@@salat Thanks for the clarification!
Where can I get the data? so I can do it live too! while watching you.
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.
Great to hear, Leon, thank you for the kind words!
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
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.
Did you ever find a video showing how to make one from scratch?
You misunderstand. This is creating a database not “using one” what is being used here is a database engine like SQL.
You’re looking for “how to create a database engine”
Good luck.
Hey how do you define a Boolean variable in SQL. Like the value is either true or false. Is it not BOOL(0,1)?
hello could you help me understand if the ideas I had are good and feasible, I would like to do automation with code tools in my WordPress databasea
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.
Following along and tried to save the db diagram but I get an error, “Saving changes is not permitted.” Any ideas?
I'm surely late, but i had same problem and found a solution. It might help someone else.
All you need to do is go: Tools -> Options... -> Designers -> Table and Database Designers -> Prevent saving changes that require table re-creation -> uncheck it -> OK and try to save your changes.
Same thing with photos: blog.sandro-pereira.com/2018/12/03/a-fish-out-of-water-saving-changes-is-not-permitted-the-changes-that-you-have-made-require-the-following-tables-to-be-dropped-and-re-created/
@@Ciemny GG mate ❤
Save (Not Permitted) Dialog Box
The Save (Not Permitted) dialog box warns you that saving changes is not permitted
because the changes you have made require the listed tables to be dropped and re-created.
The following actions might require a table to be re-created:
Adding a new column to the middle of the table
Dropping a column
Changing column nullability
Changing the order of the columns
Changing the data type of a column
To change this option, on the Tools menu, click Options, expand Designers, and then click
Table and Database Designers. Select or clear the Prevent saving changes that require the
table to be re-created check box.
To right in the solution explore window for me its just showing SQLQuert1.sql
I opened “solutions explorer” after creating a new database and it is empty. Any suggestions please?
Did you have to create those scripts beforehand?
@@ukelaalred2575 Hi, you'll have to enter them.
--create customers table
CREATE TABLE Customers (
CustomerID INT PRIMARY KEY,
FirstName NVARCHAR(255),
LastName NVARCHAR(255),
Adddress NVARCHAR(255),
City NVARCHAR(100),
State NVARCHAR(50),
ZipCode NVARCHAR(10)
)
--create products table
CREATE TABLE Products (
ProductID INT PRIMARY KEY,
Name NVARCHAR(255),
Color NVARCHAR(25),
Cost DECIMAL(18,2),
Price DECIMAL(18,2)
)
--create orders table
CREATE TABLE Orders (
OrderID INT PRIMARY KEY,
CustomerID INT,
OrderDate DATETIME,
ShippedDate DATETIME
)
--create orderdetails table
CREATE TABLE OrderDetails (
OrderID INT,
ProductID INT,
Quantity INT
)
Justin Mellott Thank you!
@@justinmellott5679 thanks alot
@@justinmellott5679 Hi. What about the LoadData query? Where I can find it , please? Thanks
I rather use the SQL which is not showing in the Solution Explore box on the right.
I was following along with video however I don't think the sample data values were provided ?? Otherwise great video and THANK YOU!! #April2024
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.
hi where can I download this microsoft sql?
Thanks for your question, Jovelyn! You can download Microsoft SQL at www.microsoft.com/en-us/download/details.aspx?id=56128
"first server"
You are already connected to your own server ("SQL NUG")
what video show you how to create your own server ? Just downloaded azure studio today and wanting to learn this.
Hi, thanks for the video, it was really helpfull but, how do I create the server (for free) to connect my database?
Hi Daniel, thank you for your question.
Linux has been a great option for decades. They are extremely efficient and customizable. The bonus is that it's open source, so it's free. We have training on CBT Nuggets for Linux and some of the many uses for it.
There are many follow up questions to your initial question for a server to connect to a database. It can depend on the database, and its dependencies. If there is a connection manager and the use cases you have for the database, and so on.
We hope this is helpful! Thank you for learning with us.
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!!!
Thanks fir the video.
Second I finally found the Solution Explore (BUTTON) to the right and of course mine is OPEN but BLANK?!
so touching for an excellent video
Thank you!
Thank you sir new subscribed here , this is very helpful ♥️
Remove this fake site , a bunch of hackers ,risk theft
Disable this database, this is fake administration, remove this premium
Disable this one for fraudulently minutes
thanks
Sequal (Standerd English Query Language) or SQL (Structured Querie language)? Call it by the right name please
I wonder where you get your information from.
As stated on DPpedia itself: "SQL (/ˌɛsˌkjuːˈɛl/ S-Q-L, /ˈsiːkwəl/ "sequel"; Structured Query Language) is a domain-specific language used in programming ..."
So people agree that you SQL can be pronounced sequel, whether you like it or not.
😎😎
Just a comment!
You know what you MOVE and TALK way to fast as a person is trying to step by step to keep up with you.
Slow the video down then
This gets so DARN frustrated!
Just a comment!