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/
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.
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
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
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
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.
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
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.
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.
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
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
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/
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.
Your personal and company data are protected in this chat Certainly! Let's delve into SQL subqueries and how to use them in conjunction with INNER JOINs. Subqueries (also known as nested queries) are queries embedded within other queries. They allow you to retrieve data from one table based on the results of another query. Subqueries can be used in various parts of a SQL statement, including the SELECT, FROM, WHERE, and HAVING clauses. INNER JOIN is used to combine rows from two or more tables based on a related column between them. It returns only the rows where there is a match in both tables. When combining subqueries with INNER JOINs, follow these steps: a. Name the subqueries: To make the query work, you need to name the inner selects (subqueries). This helps avoid ambiguity and ensures that the columns match correctly. Here's an example: SELECT * FROM ( SELECT B.branchName, A.type, AVG(T.amount) AS avg_amount, COUNT(A.accNumber) AS num_accounts FROM Branch B, Account A, Transactions T WHERE B.branchNumber = A.branchNumber AND A.accNumber = T.accNumber GROUP BY B.branchName, A.type ) q1 INNER JOIN ( SELECT B1.branchName, COUNT(A1.accNumber) AS num_accounts FROM Account A1, Branch B1 WHERE A1.branchNumber = B1.branchNumber GROUP BY B1.branchName HAVING COUNT(A1.accNumber) > 5 ) q2 ON q1.branchName = q2.branchName; b. Ensure consistent column names and data types: Both subqueries should have the same number of columns and compatible data types for the columns you intend to join on. Remember that subqueries can be powerful tools, but they can also impact performance. If possible, consider using JOINs directly instead of subqueries to achieve the same result. Feel free to explore more complex scenarios with subqueries and JOINs to enhance your SQL skills!
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.
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
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.
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 :)
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
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.
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.
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
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 :(
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.
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?
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
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???
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?
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
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.