To anyone unable to see the Northwind Database on the left side of the screen: (i) Rigth click on the folder "Databases" -> "New Database..." (ii) On "Database name" write Northwind and click OK (iii) Click "New Query", paste and execute the script Thanks lolo for the great tip! If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
This instructor is probably the best I've seen so far. This course was at the right pace, and the right subject matter and has been such a great help. Thanks so much
@@LearnitTraining Hi, you are wonderful teaching, I am having some trouble getting the Northwind.sql file. would you assist me on how to download it. Thank You
@@kolvis78 I was facing the same, in the end, I made a new database in Management studio. I did it using the right click in the database tree on the left column, named it "Northwind". Opened a query in the database and then pasted the syntax from the file in the description adn saved it. It worked. After it, I was able to perform all the queries as taught in the lesson.
OMG - perfect diction! Thank you Christina!! Some of the folks on here I cannot understand for they speak about 10,000 mph! Best and thank you for your time! Mort
Guys, the instructor here is awesome. Her explanations on sql concepts are excellent. She made me develop a strong desire for sql. Its often been confusing all along in years past. For the first time i saw there is a fine line separating sql from php though they both go together in my choice of programming. For the first time i wrote sql statements and ran them on the phpmyadmin environment and also saw a button that can help me generate the php code of sql. Madam, i can't thank you enough. You are a 5 star GENERAL in the teaching of sql. You made it less frustrating and less intimidating. This is what a teacher looks like. Thank you again ma, i had to come back here after a week to give you this feedback, review and to subscribe to your channel. God bless you richly with more wisdom.
Excellent instructor. Crystal clear explanation! Please add SQL queries intermediate, advanced, expert and database design with her. Dan McAllister also was an amazing instructor. Keep up the good work.
We can't wait for more advanced tutorials by your state-of-the-art tutors like captain Dan McAllister ( the man with a gorgeously coarse voice),Sean Bugler (eloquent man), ma'am Chelsea Dohman (a sweetheart s voice), etc. They made me a programmer. God bless learnit
Very good video for a refresher! I was able to quickly pick up from where I left when I began learning SQL. Thank you for such a great content. You're awesome.
Greattt, especially for me who is self-taught because I got a job as an IT Consultant DBA Now I have become proficient in MSSQL queries. But there are still some that I don't fully understand. This content has really helped me a lot. If I may request, I want to see the content of always on replication
Thank you very much for making this tutorial, it really helped me out! Many tutorials out there just can't compete with your level of quality. Can't wait for intermediate and advanced tutorials! I hope they will be in the foreseeable future :)
After successfully executing the script as instructed at 21:00 . I am unable to see the database on the left hand side of the screen . Please suggest some solution for it.
Excellent presentation. We can't wait for more presentations on intermediate, advanced and master MS SQL from this same tutor, Christina Tedesco. What a genius!
Thank you for providing an excellent tutorial, pitched at exactly the right level for me ! I am now able to construct and execute my own enquiries at work without pestering the IT dept. every time
Am waiting for these advanced SQL tutorials specifically by learnit because they have top-notch instructors, the likes of Chelsea Dohman, Captain Dan McAllister, Sean Bugler etc. I absolutely love their work
To anyone unable to see the Northwind Database on the left side of the screen: (i) Rigth click on the folder "Databases" -> "New Database..." (ii) On "Database name" write Northwind and click OK (iii) Click "New Query", paste and execute the script
Unable to create the database. The script execution is successful but there's no Northwind db after restarting. Edit: the script from GitHub even says "This script does not create a database.". The pubs script works, the Northwind one added tables to System Database.
I always follow learnit for everything I need to learn. Great resource. In this particular lesson, I wish either ranking was explained in more detail or should have been taken out all together. The explanantion was more counfusing. Still a great video to learn or even revise SQL. Covers all the topics beautifully. Thank you @LearnitTraining
Hi,I just started working through the tutorial tips on the video. In the first part when you used northwind.sql,and said to close the sql management studio and connect back in. When i did that,I could not find on the left hand side (object Explorer). What can I do So I can follow along
I've watched this through a few times, practiced every query and now feel pretty confident with the content in this video, thank you for the tutorial! What would you recommend as the next step in learning more SQL? Any help from anyone would be fantastic.
For some reason the database isn't creating like you said it would after logging out then back in. I even saved the file on my desktop. What am I doing wrong?
Hello. Really excited for this tutorial. However, when I go to execute the DB from the files downloaded from github it is not working. The files I have downloaded and am trying to executre are named slightly different. "instnwnd (Azure SQL Database).sql" and "instnwnd.sql." When I open the later it looks identical to what you are showing in the recording, but still will not execute. Your help would be greatly appreciated.
We can't say for sure as we do not have any access to your SQL Server. We do try to provide as many options as possible for being able to access the Northwind Database.
To anyone unable to see the Northwind Database on the left side of the screen: (i) Rigth click on the folder "Databases" -> "New Database..." (ii) On "Database name" write Northwind and click OK (iii) Click "New Query", paste and execute the script Thanks lolo for the great tip! If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
Many thanks for the video. The training is superb but I have issues with loading the Northwind database, hence, couldn't follow along. Pls be kind to explain more on how to load the database to the server.
This article may help: learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases#get-the-northwind-sample-database-for-sql-server
Hi, did everything according to video, installed SSMS v 18.12.1, copied the text to create the northwind db, no errors, close the program and open again, but no northwind db, please advise.
@@steveroody you must use the file depending on your version of software, I got it to work. There are two files one for v12 and higher and one for older versions below v12
Experiencing challenges loading the Northwind scrift onto SSMS, its not creating the relevant tables thus preventing me from further progressing with the course. Kindly advice on how to remedy this.
hi I have a problem, after copy pasting the DB and execute them and logging out and opening the management studio, there is no saved northwindsql on the left side column so I can't continue practicing. would you please help me?
@@LearnitTraining Hi I have the same problem after logging out and opening the management studio, there is no saved northwindsql on the left side column. What are we meant to do with the link you have provided above to fix this?
Thank you! I have a question though. If I want to use the database (excel or access files for example) containing information on my own business (for real life use), how can I import that data into SQL server?
Hello LeneSandNielsen! Press Windows + R to open the Run Command Box on your computer, type MMC in the box, and hit Enter. This will bring up the Microsoft Management Console Interface.
hello i have problem. how can i get the interval hours or total hours in single column Date(timestamp). because of mixing time-in and time-out in single column. also how can i get the first-in and last-out per day at per employeeID. Send me query please :(
hi i finally found the most helpful course to learn from and i really want to practice it , but i got problem in downloading the Northwind sql databases i would love to complete practicing in this course may i have some help in how to effectively download this file???
How do I access the Northwind database script? I have followed the link with no success. I also can't see the responses to others who have asked about this. Thanks.
Hi K H! We just tested the link and the site is still working. Once you get to the page the links are instnwnd.sql, instpubs.sql, and readme.md Instructions on how to install them are lower on the page.
Northwindsql Link: raw.githubusercontent.com/mic... Northwind Alternate: bit.ly/3sIvodn If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute.
Hi all, I've executed the query (NorthwindSql) for database creation. It has successfully executed and completed. However, I do not see this database any where in the object explorer. Please provide the steps. Thank you in advance.
This article may help: documentation.alphasoftware.com/pages/GettingStarted/GettingStartedTutorials/Basic%20Tutorials/Northwind/northwindSQLServer.xml#:~:text=This%20tutorial%20requires%20SQL%20Server%20or%20SQL%20Server,name%20field%2C%20type%20in%20%22northwind%22%20and%20click%20OK
As many others have said. Northwinds doesn't exist and is called something completely different and the database it not there after a restart. Some answers for this would be nice
This article may help - learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases#Get%20The%20Northwind%20Sample%20Database%20For%20SQL%20Server
@@LearnitTraining From script found at link: - - This script does not create a database. -- Run this script in the database you want the objects to be created. -- Default schema is dbo. From SMSS, I first made new txt file & executed: CREATE DATABASE Northwind; Then restarted SMSS & selected Northwind from list of Databases. Select new query & copy & paste the sample database script from link. Execute. The script created necessary tables & inserted data.
To anyone unable to see the Northwind Database on the left side of the screen:
(i) Rigth click on the folder "Databases" -> "New Database..."
(ii) On "Database name" write Northwind and click OK
(iii) Click "New Query", paste and execute the script
Thanks lolo for the great tip!
If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
I cannot see the tables of Northwind Database
Don't forget to click the refresh button/F5 under Object Explorer after performing the above steps
This instructor is probably the best I've seen so far. This course was at the right pace, and the right subject matter and has been such a great help. Thanks so much
You're very welcome!
@@LearnitTraining Hi, you are wonderful teaching, I am having some trouble getting the Northwind.sql file. would you assist me on how to download it. Thank You
@@kolvis78 not only you self, me too
@@kolvis78 I was facing the same, in the end, I made a new database in Management studio. I did it using the right click in the database tree on the left column, named it "Northwind". Opened a query in the database and then pasted the syntax from the file in the description adn saved it. It worked.
After it, I was able to perform all the queries as taught in the lesson.
OMG - perfect diction! Thank you Christina!! Some of the folks on here I cannot understand for they speak about 10,000 mph! Best and thank you for your time! Mort
You are so welcome!
Guys, the instructor here is awesome. Her explanations on sql concepts are excellent. She made me develop a strong desire for sql. Its often been confusing all along in years past.
For the first time i saw there is a fine line separating sql from php though they both go together in my choice of programming. For the first time i wrote sql statements and ran them on the phpmyadmin environment and also saw a button that can help me generate the php code of sql.
Madam, i can't thank you enough. You are a 5 star GENERAL in the teaching of sql. You made it less frustrating and less intimidating. This is what a teacher looks like. Thank you again ma, i had to come back here after a week to give you this feedback, review and to subscribe to your channel. God bless you richly with more wisdom.
Thank you so much for kind words!
I watched a full, 3 minutes long advertisement as a simple way to support this marvelous channel:-;
Thank you so much! Small things like that help us tremendously!
Excellent instructor. Crystal clear explanation! Please add SQL queries intermediate, advanced, expert and database design with her. Dan McAllister also was an amazing instructor. Keep up the good work.
Thank you for watching!
We can't wait for more advanced tutorials by your state-of-the-art tutors like captain Dan McAllister ( the man with a gorgeously coarse voice),Sean Bugler (eloquent man), ma'am Chelsea Dohman (a sweetheart s voice), etc. They made me a programmer. God bless learnit
More to come!
I enjoy Dan's tutorial as well.
Trying to find more and there's none
This is an incredible tutorial. I'm at the 1:57:00 mark and have already learned so much. Well done on teaching this!
Awesome, thank you!
@@LearnitTraining please sir, I can't see the northwind file please where can I get the file, sir.
WOW What a best instructor! this is the most comprehensible SQL tutorial I have came across so far !✅✅✅
Glad it was helpful!
Great instructor! Thank you so much for this course, Christina. Your guidance has been invaluable and truly appreciated
You are so welcome!
Very good video for a refresher! I was able to quickly pick up from where I left when I began learning SQL. Thank you for such a great content. You're awesome.
You're very welcome!
Wow. What a great course! Good job😄 I learned the basics of sql in 3 days and ready to go. Thanks!!
Glad it was helpful!
Very great SQL course and very specific. Thanks for sharing.
You are very welcome Terry!
Greattt,
especially for me who is self-taught because I got a job as an IT Consultant DBA
Now I have become proficient in MSSQL queries.
But there are still some that I don't fully understand.
This content has really helped me a lot.
If I may request, I want to see the content of always on replication
Hi Deny! We are producing a much more robust SQL Reporting Services video series coming soon!
Thank you very much for making this tutorial, it really helped me out!
Many tutorials out there just can't compete with your level of quality.
Can't wait for intermediate and advanced tutorials! I hope they will be in the foreseeable future :)
Thank you for the kind words!
@@LearnitTraining please how can I get the northwind file please, because I can't see it sir.
Cant Wait for your full SQL course!!! so exited!!! 🤩🤩🤩
Soon!
@@LearnitTrainingis it there?
After successfully executing the script as instructed at 21:00 . I am unable to see the database on the left hand side of the screen . Please suggest some solution for it.
You guys make such good courses. I could learn anything explained by you.
Thank for the kind words Lori!
Very good tutorial, straightforward.....have learnt alot. Waiting patiently for the intermediate and advanced Sql tutorial from this Channel.🙏🙏👏👏
Thanks!
Excellent presentation. We can't wait for more presentations on intermediate, advanced and master MS SQL from this same tutor, Christina Tedesco. What a genius!
Thank you for providing an excellent tutorial, pitched at exactly the right level for me !
I am now able to construct and execute my own enquiries at work without pestering the IT dept. every time
Glad it helped!
i love it! looking forward intermediate and advanced sessions as well. thankyou so much for the open upload of such quality content
You're so welcome!
Excellent,although very basic. Looking forward to your intermediate and advanced level of sql server tutorial 👍👍
Coming soon!
Am waiting for these advanced SQL tutorials specifically by learnit because they have top-notch instructors, the likes of Chelsea Dohman, Captain Dan McAllister, Sean Bugler etc. I absolutely love their work
@@LearnitTraining How soon? it's has been 2 years now.
Very insightful tutorial. Very helpful for me learning SQL on my own
Great to hear!
Very clear lecture and easy to follow, thank you ! 👍
You are welcome!
I can't wait for the Intermediate Tutorial video
Hi Meow Meow! It is in production!
To anyone unable to see the Northwind Database on the left side of the screen:
(i) Rigth click on the folder "Databases" -> "New Database..."
(ii) On "Database name" write Northwind and click OK
(iii) Click "New Query", paste and execute the script
Thank you so much for this great tip!
Thanks alot......
Pretty neat, simple, and well-explained! Thanks for this tutorial! It helps me a lot!
You are very welcome! Thank you for watching!
How to download data from github?
Great Video, easy to follow and clear to understand
Glad you enjoyed it!
Awesome Work, I have learnt alot from this. Thanks so much for the good work indeed.
Glad it was helpful!
I cannot download Northwind. From the video description. How can i do it?
Very well explained video.
Very good.
Thank you.
You are welcome!
@@LearnitTraining Thank you
Unable to create the database. The script execution is successful but there's no Northwind db after restarting.
Edit: the script from GitHub even says "This script does not create a database.". The pubs script works, the Northwind one added tables to System Database.
This article may help: learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
Hey, what was the name of the datebase that appeared in SSMS? Is it Northwind? The name im getting is "pubs"...
was really waiting for it.... thanks in advance learnit.
Most welcome 😊
I always follow learnit for everything I need to learn. Great resource. In this particular lesson, I wish either ranking was explained in more detail or should have been taken out all together. The explanantion was more counfusing.
Still a great video to learn or even revise SQL. Covers all the topics beautifully.
Thank you @LearnitTraining
Glad it was helpful!
Hello @LearnitTraining, I was wondering if a download tutorial for mac is available
Sorry we do not have too many Mac videos. Just Pages, Numbers, and Keynote
Thank you for uploading such a helpful video tutorial
You are very welcome!
well done- VOICE of sql ;)
pięknie podane, z jajem-tak to ujmę:)
Thanks!
Hi,I just started working through the tutorial tips on the video. In the first part when you used northwind.sql,and said to close the sql management studio and connect back in. When i did that,I could not find on the left hand side (object Explorer).
What can I do So I can follow along
I did not see the northwind database after logging back in
Please where's the link to these class file described at 0:12 ?
Please I need help to find them
Exercise Files: bit.ly/3n5sr0G
SQL Express Download Link:
www.microsoft.com/en-us/Download/details.aspx?id=101064
Northwindsql Link:
raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/databases/northwind-pubs/instnwnd.sql
Northwind Alternate: bit.ly/3sIvodn
Very helpful video! Thanks for all the hard work.
Our pleasure!
A great tutorial and a nice voice
Thank you kindly!
Amazing Explanation 👍👍
Thank you for watching!
I've watched this through a few times, practiced every query and now feel pretty confident with the content in this video, thank you for the tutorial!
What would you recommend as the next step in learning more SQL? Any help from anyone would be fantastic.
Great content :). Will we be getting a complete course with advanced and expert videos?
Hi Tommy! This is just a single course for now. We are working on more SQL videos however!
For some reason the database isn't creating like you said it would after logging out then back in. I even saved the file on my desktop. What am I doing wrong?
Hi The Generational Wealth Guy! You can get help at Offsite, our online community - www.offsitebylearnit.com
Hello. Really excited for this tutorial. However, when I go to execute the DB from the files downloaded from github it is not working. The files I have downloaded and am trying to executre are named slightly different. "instnwnd (Azure SQL Database).sql" and "instnwnd.sql." When I open the later it looks identical to what you are showing in the recording, but still will not execute. Your help would be greatly appreciated.
Hi Jacob! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
thank you I could use that alternative website but I want to know why I couldn't add that database into my SQL SERVER?
We can't say for sure as we do not have any access to your SQL Server. We do try to provide as many options as possible for being able to access the Northwind Database.
Great work. Unfortunately i cannot connect to the northwind db so the database doesn't even show after i log back in. Any help??
To anyone unable to see the Northwind Database on the left side of the screen:
(i) Rigth click on the folder "Databases" -> "New Database..."
(ii) On "Database name" write Northwind and click OK
(iii) Click "New Query", paste and execute the script
Thanks lolo for the great tip!
If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
Hi, i can t file the file northwindsql in the provided link... can you please let me know where should i look?
Northwindsql Download Link:
github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
Good day. the northwind daabase didnt appear.
all the tables will appear under the master database.
can you help me to solve this.?
thank you
If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
hi transfer northwind file and then execute it but the database won't be shown in the section of database, what should I do?
You can also practice using this site: www.sql-practice.com/
Next level please 😀
Can't create Northwind database. Code in GitHub seems broken.
Super useful! Thanks 🙂
Glad to hear that!
Many thanks for the video. The training is superb but I have issues with loading the Northwind database, hence, couldn't follow along. Pls be kind to explain more on how to load the database to the server.
This article may help: learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases#get-the-northwind-sample-database-for-sql-server
👏👏👏👏👏👏👏 thanks for breaking it down.
Glad it was helpful!
My Northwind file shows up as is an Microsoft Access File, doesn't do It as "Northwind.sql". ¿How can I fix that? Thanks you!
This article may help: learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
Hi, did everything according to video, installed SSMS v 18.12.1, copied the text to create the northwind db, no errors, close the program and open again, but no northwind db, please advise.
Hi Bevan! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
I experienced same problem. After doing everything as said in the video, I still didn’t find the file at the database section
@@steveroody you must use the file depending on your version of software, I got it to work. There are two files one for v12 and higher and one for older versions below v12
Experiencing challenges loading the Northwind scrift onto SSMS, its not creating the relevant tables thus preventing me from further progressing with the course. Kindly advice on how to remedy this.
Hello Nwadike! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
hi I have a problem, after copy pasting the DB and execute them and logging out and opening the management studio, there is no saved northwindsql on the left side column so I can't continue practicing. would you please help me?
Northwindsql Download Link:
github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
@@LearnitTraining Hi I have the same problem after logging out and opening the management studio, there is no saved northwindsql on the left side column. What are we meant to do with the link you have provided above to fix this?
The content in course is very good. Are we getting complete course?
Hi Kyasa! We actually combined the course into one, but we are working on more SQL videos coming soon!
Thank you! I have a question though. If I want to use the database (excel or access files for example) containing information on my own business (for real life use), how can I import that data into SQL server?
Hello Thanh Phan! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
I cant find microsoft managment studio as a program on my labtob. ?????
I have followd the instroction i the video
Hello LeneSandNielsen! Press Windows + R to open the Run Command Box on your computer, type MMC in the box, and hit Enter. This will bring up the Microsoft Management Console Interface.
@@LearnitTraining i get a window Consol1 with an empty folder
Fantastic tutorial
Thank you for the kind words Jean Pierre Beuses!
Can I get a follow up to this Video..? Say the Intermediate and the Master and Expert level..... ..!!!
Hi Aamir! We currently have a full scale SQL class being recorded. It will be a 5 video series. Coming soon!
This may be a stupid question but how do I download the Northwind data?
Well that Northwind DB is a 20 year old database. She should be using the new Adventure Works 2019 database.
Hi 9 to 5 Voyager! The link to the Northwind data is in the video description
hello i have problem. how can i get the interval hours or total hours in single column Date(timestamp). because of mixing time-in and time-out in single column. also how can i get the first-in and last-out per day at per employeeID. Send me query please :(
Hi Erajie! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
Thank you, dear! Will you teach intermediate, advanced, and professional skills? I want to learn your lessons.
We have a SQL Admin video series coming soon!
how do I download the Northwind data? There Is no Northwind SQL in the link now.
Hi Peacemind888! The link to the Northwind data is in the video description
How do you download this for a MAC?
This article may help: www.macworld.com/article/672043/how-to-set-up-and-learn-sql-on-mac.html
hi
i finally found the most helpful course to learn from and i really want to practice it , but i got problem in downloading the Northwind sql databases i would love to complete practicing in this course may i have some help in how to effectively download this file???
If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
How do I access the Northwind database script? I have followed the link with no success. I also can't see the responses to others who have asked about this. Thanks.
Hi K H! We just tested the link and the site is still working. Once you get to the page the links are instnwnd.sql, instpubs.sql, and readme.md Instructions on how to install them are lower on the page.
Why is my Northwind file does not appear?
Try using the alternate:
Northwind Alternate: bit.ly/3sIvodn
Northwinds file come from? It was to fast for me..maybe I'm not ready for sql..
Here you go!
Northwindsql Download Link:
github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
@@LearnitTraining Seems like the Northwinds file was removed from the provided link.
We need the intermediate and advanced version of sql server:)
Hi Josue! Those videos are currently being produced! We will have 6 brand new videos on SQL Reporting Services soon!
I dont need to save the script first?
Hi KwadKen! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Can u teach us VBA in Access aswell? would be awesome too !
Yeahnick! We will definitely look into getting that add to our video production list
@@LearnitTraining awesome!
Great Content.
Thanks a lot.
Glad you liked it!
Where did you get the Northwind file from?
Northwindsql Link:
raw.githubusercontent.com/mic...
Northwind Alternate: bit.ly/3sIvodn
If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute.
northwind isnt showing inmy database, i am using ms sql-server
Here is the link to download: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
i am having the issue where the new northwind file doesn't show up on SSMS after log back in.
please how do i get Northwind.sql file. i cant find it????
Northwindsql Download Link:
github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
is pivoting for beginners? :)
Hello, am having a problem creating the northwind database after executing the queries nothing is created...kindly help
Hello guys, i really need help in executing the northwind database, am already executing but no database is being formed
Is it possible to get a script that is working properly
omo his SQL northwind file is not processing, i have been to the community site its not helpful either
For those who might encounter same issues of line 24 and 25 , remove them and execute, then you are good to go
Thank you Anonde for the tip!
Hi all, I've executed the query (NorthwindSql) for database creation. It has successfully executed and completed. However, I do not see this database any where in the object explorer. Please provide the steps. Thank you in advance.
This article may help: documentation.alphasoftware.com/pages/GettingStarted/GettingStartedTutorials/Basic%20Tutorials/Northwind/northwindSQLServer.xml#:~:text=This%20tutorial%20requires%20SQL%20Server%20or%20SQL%20Server,name%20field%2C%20type%20in%20%22northwind%22%20and%20click%20OK
amazing video!!
Thank you for watching Pratham!
How do I download the script file
Hi Tyler! All the links to the files you need for class are in the video description
Thank You Madam
You are most welcome!
My northwind doesn't appear on database ?
After I add "create database Northwind;" This statement it's appear the Northwind, but now the table doesn't exist
If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/
As many others have said. Northwinds doesn't exist and is called something completely different and the database it not there after a restart. Some answers for this would be nice
This article may help - learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases#Get%20The%20Northwind%20Sample%20Database%20For%20SQL%20Server
@@LearnitTraining
From script found at link:
-
- This script does not create a database.
-- Run this script in the database you want the objects to be created.
-- Default schema is dbo.
From SMSS, I first made new txt file & executed:
CREATE DATABASE Northwind;
Then restarted SMSS & selected Northwind from list of Databases. Select new query & copy & paste the sample database script from link.
Execute. The script created necessary tables & inserted data.
@@tertia0011 This worked for me Thank you so much!
@@tertia0011 Yes, I did this and worked. Thanks
where is the Northwind DB file located
Never mind got it
Hello, I could not find the Northwind.sql file. Could anyone help me, please?
github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
Has anyone been able to download the exercise files?
Hello Pal M! We just tested the links and files. They are currently working.
YES
Great job. However, the exercise file is not available. I d really like to have it
Thank you so much for the kind words Jackie! We are glad you learned so much!
seems interesting but I cant get the Northwind code off the site so I am at an early stop
4/21/2023 ~4:30
great teaching
Glad it was helpful!
Thank you
You're welcome
Thanks very much
You are welcome!