SQL Querying for Beginners Tutorial

No video

SQL Querying for Beginners Tutorial

Рет қаралды 251,192

Күн бұрын

SQL Querying for Beginners Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3n5sr0G
SQL Express Download Link:
www.microsoft....
Northwindsql Link:
raw.githubuser...
Northwind Alternate: bit.ly/3sIvodn
If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute.
Who it's for: This course has been designed for individuals who wish to learn how to use SQL to query databases and extract information.
What it is: SQL stands for Structured Query Language. It’s a common language for gathering, organizing, and exporting data stored in relational databases.
What you'll learn: In this course, you’ll learn basic SQL usage and terminology, as well as how to execute simple queries and queries using criteria conditions. Next, you’ll learn how to summarize, organize, and export valuable query data and results.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitany...
For Private Group Trainings please visit:
www.learnit.co...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Introduction to SQL 0:30
Installing SQL Server 4:27
SQL Keyword Command Language and Hierarchy 8:26
Connecting to a SQL Database 13:35
Creating and Saving a Query 22:44
Using One or More Query Conditions 32:43
Applying AND OR Operators 40:36
NULL NOT NULL 46:48
Range of Values 49:28
Querying Data Using Wildcard Characters 58:04
Formatting Column Headings with Aliases 1:04:48
Formatting Query Data Results 1:10:06
Performing Date Calculations - DateDifDateAdd 1:14:10
Summarizing Data Using Aggregate Functions AVG COUNT SUM min max 1:22:39
Manipulating Text Results with String Functions CONCAT_SUBSTR 1:30:26
Sorting Data Order BY and GROUPBY 1:38:07
RANK and HAVING 1:46:24
Mathematical Financial Expressions 1:52:23
PIVOT 1:58:24
JOIN 2:07:27
Union ALL 2:20:30
Except Clause 2:26:30
Sub Queries 2:28:25
Exports 2:40:41
Conclusion 2:44:04
#SQL #Query
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

Пікірлер: 246

@LearnitTraining 5 ай бұрын

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/

@sepegden Жыл бұрын

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 Жыл бұрын

You're very welcome!

@kolvis78 Жыл бұрын

@@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

@idehaisamuel1320 Жыл бұрын

@@kolvis78 not only you self, me too

@niitnahuja8793 Жыл бұрын

@@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.

@searchformeaning85 Жыл бұрын

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.

@LearnitTraining Жыл бұрын

Thank you for watching!

@mortonwakeland3809 9 ай бұрын

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

@LearnitTraining 9 ай бұрын

You are so welcome!

@samnako Жыл бұрын

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.

@LearnitTraining Жыл бұрын

Thank you so much for kind words!

@omkarchogale1445 2 ай бұрын

Great instructor! Thank you so much for this course, Christina. Your guidance has been invaluable and truly appreciated

@LearnitTraining 2 ай бұрын

You are so welcome!

@kensimba7868 2 жыл бұрын

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

@LearnitTraining 2 жыл бұрын

More to come!

@markhuang368 Жыл бұрын

I enjoy Dan's tutorial as well.

@kevinondimukevin3506 3 ай бұрын

Trying to find more and there's none

@lolo-bd6kx Ай бұрын

@LearnitTraining Ай бұрын

Thank you so much for this great tip!

@JamesNjanjo Ай бұрын

Thanks alot......

@ThekisoPhume Жыл бұрын

WOW What a best instructor! this is the most comprehensible SQL tutorial I have came across so far !✅✅✅

@LearnitTraining Жыл бұрын

Glad it was helpful!

@JamesNjanjo Ай бұрын

Very good tutorial, straightforward.....have learnt alot. Waiting patiently for the intermediate and advanced Sql tutorial from this Channel.🙏🙏👏👏

@LearnitTraining Ай бұрын

Thanks!

@gbadeboabayomi9241 Күн бұрын

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!

@vanillacreem816 Жыл бұрын

This is an incredible tutorial. I'm at the 1:57:00 mark and have already learned so much. Well done on teaching this!

@LearnitTraining Жыл бұрын

Awesome, thank you!

@idehaisamuel1320 Жыл бұрын

@@LearnitTraining please sir, I can't see the northwind file please where can I get the file, sir.

@lorik9940 Ай бұрын

Wow. What a great course! Good job😄 I learned the basics of sql in 3 days and ready to go. Thanks!!

@LearnitTraining Ай бұрын

Glad it was helpful!

@janikabourne7903 Жыл бұрын

I watched a full, 3 minutes long advertisement as a simple way to support this marvelous channel:-;

@LearnitTraining Жыл бұрын

Thank you so much! Small things like that help us tremendously!

@wintermorillo6567 Жыл бұрын

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.

@LearnitTraining Жыл бұрын

You're very welcome!

@dkorobchenko1 2 жыл бұрын

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 :)

@LearnitTraining 2 жыл бұрын

Thank you for the kind words!

@idehaisamuel1320 Жыл бұрын

@@LearnitTraining please how can I get the northwind file please, because I can't see it sir.

@terrychen2662 2 жыл бұрын

Very great SQL course and very specific. Thanks for sharing.

@LearnitTraining 2 жыл бұрын

You are very welcome Terry!

@kebincui 2 жыл бұрын

Excellent,although very basic. Looking forward to your intermediate and advanced level of sql server tutorial 👍👍

@LearnitTraining 2 жыл бұрын

Coming soon!

@kensimba7868 2 жыл бұрын

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

@ojiehkingsley918 2 ай бұрын

@@LearnitTraining How soon? it's has been 2 years now.

@lori3248 2 жыл бұрын

You guys make such good courses. I could learn anything explained by you.

@LearnitTraining 2 жыл бұрын

Thank for the kind words Lori!

@Ikilledthebanks 2 жыл бұрын

Incredibly well done, I wish you could zoom in a bit when working in the query editor but really great job. Thank you very much

@LearnitTraining 2 жыл бұрын

Thank you so much for watching!

@box5329 Жыл бұрын

Very clear lecture and easy to follow, thank you ! 👍

@LearnitTraining Жыл бұрын

You are welcome!

@1982epm 2 жыл бұрын

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

@LearnitTraining 2 жыл бұрын

Hi Deny! We are producing a much more robust SQL Reporting Services video series coming soon!

@davidnana6568 Жыл бұрын

Very insightful tutorial. Very helpful for me learning SQL on my own

@LearnitTraining Жыл бұрын

Great to hear!

@soundofmusic0613 2 жыл бұрын

Pretty neat, simple, and well-explained! Thanks for this tutorial! It helps me a lot!

@LearnitTraining 2 жыл бұрын

You are very welcome! Thank you for watching!

@dexxxxxxxx 2 жыл бұрын

How to download data from github?

@user-zu3lf2qi3y Жыл бұрын

Cant Wait for your full SQL course!!! so exited!!! 🤩🤩🤩

@LearnitTraining Жыл бұрын

Soon!

@amos0140 2 жыл бұрын

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

@LearnitTraining 2 жыл бұрын

Glad it helped!

@divyanshsingh2764 9 ай бұрын

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.

@berziboy1090 2 жыл бұрын

Great Video, easy to follow and clear to understand

@LearnitTraining 2 жыл бұрын

Glad you enjoyed it!

@bambina5604 11 ай бұрын

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.

@LearnitTraining 11 ай бұрын

This article may help: learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases

@rahilvaseer2809 11 ай бұрын

Hey, what was the name of the datebase that appeared in SSMS? Is it Northwind? The name im getting is "pubs"...

@hiscanopy9336 2 жыл бұрын

Awesome Work, I have learnt alot from this. Thanks so much for the good work indeed.

@LearnitTraining 2 жыл бұрын

Glad it was helpful!

@shnuiiwithdoublei Жыл бұрын

i love it! looking forward intermediate and advanced sessions as well. thankyou so much for the open upload of such quality content

@LearnitTraining Жыл бұрын

You're so welcome!

@user-il7kr3my6f 6 ай бұрын

Thank you for uploading such a helpful video tutorial

@LearnitTraining 6 ай бұрын

You are very welcome!

@User-qw1ir Жыл бұрын

I cannot download Northwind. From the video description. How can i do it?

@meowmeow6605 2 жыл бұрын

I can't wait for the Intermediate Tutorial video

@LearnitTraining 2 жыл бұрын

Hi Meow Meow! It is in production!

@niitnahuja8793 Жыл бұрын

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

@LearnitTraining Жыл бұрын

Glad it was helpful!

@marinosanagnostou8116 2 жыл бұрын

Very well explained video. Very good. Thank you.

@LearnitTraining 2 жыл бұрын

You are welcome!

@marinosanagnostou8116 2 жыл бұрын

@@LearnitTraining Thank you

@tommya1086 2 жыл бұрын

Great content :). Will we be getting a complete course with advanced and expert videos?

@LearnitTraining 2 жыл бұрын

Hi Tommy! This is just a single course for now. We are working on more SQL videos however!

@ntonyjaime_ 7 ай бұрын

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

@pinielchitare9221 2 жыл бұрын

A great tutorial and a nice voice

@LearnitTraining 2 жыл бұрын

Thank you kindly!

@infini.tesimo 2 жыл бұрын

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?

@LearnitTraining 2 жыл бұрын

Hi The Generational Wealth Guy! You can get help at Offsite, our online community - www.offsitebylearnit.com

@kirawu4507 2 жыл бұрын

Very helpful video! Thanks for all the hard work.

@LearnitTraining 2 жыл бұрын

Our pleasure!

@jacobirish9826 2 жыл бұрын

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.

@LearnitTraining 2 жыл бұрын

Hi Jacob! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com

@ryansarwar6814 2 жыл бұрын

was really waiting for it.... thanks in advance learnit.

@LearnitTraining 2 жыл бұрын

Most welcome 😊

@michalrw5713 5 ай бұрын

well done- VOICE of sql ;) pięknie podane, z jajem-tak to ujmę:)

@LearnitTraining 5 ай бұрын

Thanks!

@shaghdaei 3 ай бұрын

thank you I could use that alternative website but I want to know why I couldn't add that database into my SQL SERVER?

@LearnitTraining 3 ай бұрын

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.

@aamirahmed9744 2 жыл бұрын

Can I get a follow up to this Video..? Say the Intermediate and the Master and Expert level..... ..!!!

@LearnitTraining 2 жыл бұрын

Hi Aamir! We currently have a full scale SQL class being recorded. It will be a 5 video series. Coming soon!

@paduaronel Ай бұрын

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

@LearnitTraining Ай бұрын

If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/

@mytinystars Жыл бұрын

Amazing Explanation 👍👍

@LearnitTraining Жыл бұрын

Thank you for watching!

@cornucopiahouse4204 Жыл бұрын

Can't create Northwind database. Code in GitHub seems broken.

@mariham_ad1137 5 ай бұрын

I did not see the northwind database after logging back in

@dexxxxxxxx 2 жыл бұрын

Next level please 😀

@giulianociolacu4637 2 жыл бұрын

Hi, i can t file the file northwindsql in the provided link... can you please let me know where should i look?

@LearnitTraining 2 жыл бұрын

Northwindsql Download Link: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

@amosufit3174 9 ай бұрын

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.

@LearnitTraining 9 ай бұрын

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

@shaghdaei 3 ай бұрын

hi transfer northwind file and then execute it but the database won't be shown in the section of database, what should I do?

@LearnitTraining 3 ай бұрын

You can also practice using this site: www.sql-practice.com/

@jeanpenus 2 жыл бұрын

Fantastic tutorial

@LearnitTraining 2 жыл бұрын

Thank you for the kind words Jean Pierre Beuses!

@rofinejoy7455 4 ай бұрын

👏👏👏👏👏👏👏 thanks for breaking it down.

@LearnitTraining 3 ай бұрын

Glad it was helpful!

@thanhphan2374 2 жыл бұрын

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?

@LearnitTraining 2 жыл бұрын

Hello Thanh Phan! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

@smn2275 Жыл бұрын

Northwinds file come from? It was to fast for me..maybe I'm not ready for sql..

@LearnitTraining Жыл бұрын

Here you go! Northwindsql Download Link: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

@stanleyshengamo4798 Жыл бұрын

@@LearnitTraining Seems like the Northwinds file was removed from the provided link.

@abdulsalamaramidedammy2692 Жыл бұрын

northwind isnt showing inmy database, i am using ms sql-server

@LearnitTraining Жыл бұрын

Here is the link to download: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

@ancienthuman 10 ай бұрын

i am having the issue where the new northwind file doesn't show up on SSMS after log back in.

@nwadikej8989 Жыл бұрын

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.

@LearnitTraining Жыл бұрын

Hello Nwadike! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/

@josueg8852 2 жыл бұрын

We need the intermediate and advanced version of sql server:)

@LearnitTraining 2 жыл бұрын

Hi Josue! Those videos are currently being produced! We will have 6 brand new videos on SQL Reporting Services soon!

@alexrosen8762 2 жыл бұрын

Super useful! Thanks 🙂

@LearnitTraining 2 жыл бұрын

Glad to hear that!

@abrilgonzalez7892 8 ай бұрын

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!

@LearnitTraining 8 ай бұрын

This article may help: learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases

@erajiemarvic6903 2 жыл бұрын

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 :(

@LearnitTraining 2 жыл бұрын

Hi Erajie! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com

@shimamirlou4194 2 жыл бұрын

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 2 жыл бұрын

Northwindsql Download Link: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

@cullie815 2 жыл бұрын

@@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?

@venkatkyasa 2 жыл бұрын

The content in course is very good. Are we getting complete course?

@LearnitTraining 2 жыл бұрын

Hi Kyasa! We actually combined the course into one, but we are working on more SQL videos coming soon!

@SumiyaG Жыл бұрын

Thank you, dear! Will you teach intermediate, advanced, and professional skills? I want to learn your lessons.

@LearnitTraining Жыл бұрын

We have a SQL Admin video series coming soon!

@GozallHasan Ай бұрын

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???

@LearnitTraining Ай бұрын

If you are having issues downloading the northwind file please use this online practice lab: www.sql-practice.com/

@RealLamasyah 9 ай бұрын

Please where's the link to these class file described at 0:12 ? Please I need help to find them

@LearnitTraining 9 ай бұрын

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

@yashshah6919 2 жыл бұрын

Thank You Madam

@LearnitTraining 2 жыл бұрын

You are most welcome!

@LeneSandNielsen Жыл бұрын

I cant find microsoft managment studio as a program on my labtob. ????? I have followd the instroction i the video

@LearnitTraining Жыл бұрын

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.

@LeneSandNielsen Жыл бұрын

@@LearnitTraining i get a window Consol1 with an empty folder

@franzkern4208 2 жыл бұрын

Great Content. Thanks a lot.

@LearnitTraining 2 жыл бұрын

Glad you liked it!

@KH-uz4hc 2 жыл бұрын

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.

@LearnitTraining 2 жыл бұрын

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.

@bevanbooy5468 2 жыл бұрын

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.

@LearnitTraining 2 жыл бұрын

Hi Bevan! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

@steveroody 2 жыл бұрын

I experienced same problem. After doing everything as said in the video, I still didn’t find the file at the database section

@bevanbooy5468 2 жыл бұрын

@@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

@prathamgupta7605 2 жыл бұрын

amazing video!!

@LearnitTraining 2 жыл бұрын

Thank you for watching Pratham!

@lindseydolman7291 Жыл бұрын

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

@LearnitTraining Жыл бұрын

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

@tertia0011 Жыл бұрын

@@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.

@leeleesgotgame7748 Жыл бұрын

@@tertia0011 This worked for me Thank you so much!

@ethanwhite9568 7 ай бұрын

@@tertia0011 Yes, I did this and worked. Thanks

@peacemind888 2 жыл бұрын

how do I download the Northwind data? There Is no Northwind SQL in the link now.

@LearnitTraining 2 жыл бұрын

Hi Peacemind888! The link to the Northwind data is in the video description

@yeahnick4260 2 жыл бұрын

Can u teach us VBA in Access aswell? would be awesome too !

@LearnitTraining 2 жыл бұрын

Yeahnick! We will definitely look into getting that add to our video production list

@yeahnick4260 2 жыл бұрын

@@LearnitTraining awesome!

@ujjwalmundhra2884 6 ай бұрын

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.

@LearnitTraining 6 ай бұрын

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

@firdausismail3020 8 ай бұрын

Why is my Northwind file does not appear?

@LearnitTraining 8 ай бұрын

Try using the alternate: Northwind Alternate: bit.ly/3sIvodn

@9to5Drone 2 жыл бұрын

This may be a stupid question but how do I download the Northwind data?

@codyscorner1829 2 жыл бұрын

Well that Northwind DB is a 20 year old database. She should be using the new Adventure Works 2019 database.

@LearnitTraining 2 жыл бұрын

Hi 9 to 5 Voyager! The link to the Northwind data is in the video description

@rubenalcidesfigueroa1655 Жыл бұрын

Awsome

@LearnitTraining Жыл бұрын

Thanks!

@ahmadbeizaei6009 2 жыл бұрын

Thank you

@LearnitTraining 2 жыл бұрын

You're welcome

@isamirzayev9905 2 жыл бұрын

thank you

@LearnitTraining 2 жыл бұрын

You're welcome

@anondebennett9219 2 жыл бұрын

omo his SQL northwind file is not processing, i have been to the community site its not helpful either

@anondebennett9219 2 жыл бұрын

For those who might encounter same issues of line 24 and 25 , remove them and execute, then you are good to go

@LearnitTraining 2 жыл бұрын

Thank you Anonde for the tip!

@SalvageRestorationAndTechTips 2 жыл бұрын

is pivoting for beginners? :)

@JosephKuriaNjau 7 ай бұрын

Hello, am having a problem creating the northwind database after executing the queries nothing is created...kindly help

@JosephKuriaNjau 7 ай бұрын

Hello guys, i really need help in executing the northwind database, am already executing but no database is being formed

@JosephKuriaNjau 7 ай бұрын

Is it possible to get a script that is working properly

@user-br2gc9ov1q Жыл бұрын

please how do i get Northwind.sql file. i cant find it????

@LearnitTraining Жыл бұрын

Northwindsql Download Link: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

@idehaisamuel1320 Жыл бұрын

I love the vedio but I can't follow along because I can't see the file used for the vedio anymore 🥺🥺🤦🤦💔💔

@LearnitTraining Жыл бұрын

Exercise Files: bit.ly/3n5sr0G SQL Express Download Link: www.microsoft.com/en-us/Downl... Northwindsql Download Link: github.com/Microsoft/sql-serv...

@idehaisamuel1320 Жыл бұрын

@@LearnitTraining thanks 🥰🥰🥰

@idehaisamuel1320 Жыл бұрын

@@LearnitTraining sir I couldn't convert the file I tried copy the text in employee 1 but it showed error

@idehaisamuel1320 Жыл бұрын

@@LearnitTraining sir how can I convert those file so I can practice with the video sir.

@juantapia7832 4 ай бұрын

Great job, thank you very much! I don´t understand the difference between JOIN (or inner join) with subqueries. Can you explain me, please?

@LearnitTraining 4 ай бұрын

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!

@juantapia7832 4 ай бұрын

oh great@@LearnitTraining ! Thank you very much for your help dedicated. Greetings!

@estherkanyi215 6 ай бұрын

great teaching

@LearnitTraining 6 ай бұрын

Glad it was helpful!

@KLNYC 2 жыл бұрын

I dont need to save the script first?

@LearnitTraining 2 жыл бұрын

Hi KwadKen! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

@johnpopolizio9518 Жыл бұрын

seems interesting but I cant get the Northwind code off the site so I am at an early stop

@theestherealtor 8 ай бұрын

How do you download this for a MAC?

@LearnitTraining 8 ай бұрын

This article may help: www.macworld.com/article/672043/how-to-set-up-and-learn-sql-on-mac.html

@didingdharmadi2965 Жыл бұрын

Hello, I could not find the Northwind.sql file. Could anyone help me, please?

@LearnitTraining Жыл бұрын

github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

@user-bv3cd9im5s 2 жыл бұрын

Thanks very much

@LearnitTraining 2 жыл бұрын

You are welcome!

@superfreiheit1 2 жыл бұрын

Thanks for the video, but its to small.

@LearnitTraining 2 жыл бұрын

Hi Joe! We are currently producing a much longer video series on this topic!

@ingasiradeghyan5402 2 жыл бұрын

Great :)

@LearnitTraining 2 жыл бұрын

Thank you! Cheers!

@seekeroftruth5481 7 ай бұрын

Where did you get the Northwind file from?

@LearnitTraining 7 ай бұрын

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.