Setting Up SQL Server (SQL)
Video Title: SQL LESSON 1 | GET STARTED WITH SQL | HOW TO INSTALL SQL SERVER FOR DATA ANALYSIS
All right let’s get started so we need to go to this website here uh I’ve put the link to it in the description box and when you get there you need to go down where it says developer and click download and this is going to just save it on your
Computer and now it’s done downloading I’m just going to open it and you need to say yes I’m going to choose basic I’m just going to accept I’ll click install we just give it some time to install now that it’s done installing fast forward we’re going to click on
Install SS SMS so now that we’re here we need to scroll down to the bottom and here we need to click on download free studio um secet server management studio and here we do the same thing with save and it up here it’s downloading so we just give it a couple
Minutes and now it’s done we’re just going to click it here and say open okay now we click on install and we say yes and we just wait a couple Minutes so if you get this error we just need to restart the computer so you need to restart your computer and then you go back to it now that we now that we’ restarted the computer we can now go here and we say yes and we just give it a couple seconds So now that it’s done it might ask you for a restart so you need to restart your computer again if you need to now that we’ve restarted the computer we need to go to the search box and type for SQL Server management studio and you’re going to launch that on your
Computer and that should open up this widget right here and you should see your server name so the server name is the name of your computer and if I click connect this should open on the on the left side here we can see that right now
We don’t have any database and we need to install a database so to install a database we need to go to this uh to this website right here I’m going to put the link in the description box so when you get there you need to scroll down
Here and we see all those databases for this video I’m going to be downloading this adventure Works 2022 so when you download it to your machine just save it and it’s downloading when it’s done we need to head back to secet server and here we open our databases we see that we don’t
Have any database so now we need to right click here and go where it says restore database when I click that I need away says device and you click this Ellipsis here we click add and now we need to navigate to where we have that
Uh B file stalled on that machine so for me I have it in my users in Mimi and we can see it here this file and we just click it and we say okay and it’s fine we click okay and now it’s here we just click okay and we just this has been
Restored successfully so we click okay and now we can see that we have this database Adventure Works 2022 here we can open it and see all our tables and I’m going to expand this as well so we can see that we have all those tables we can just right click on
This to just make sure we have data and click on top select top 1,000 and we can see that we actually have data in our database I’m going to try another table address right click and say select top 1,000 now we have data all right let’s
Get started so let’s say I have this table and I do select stuff from I click execute this is fine and it run real quick because it’s a just if you look to the bottom right here we only have like 19,0 um 972 rows that’s fine but in real
Life sometimes you have millions of rows do not do a celect star because that’s going to take some some time and you can block other other people from accessing the data so what is the way to go about doing a select star if you want to be
Able to get all the column name what you can do instead of Select star is to do a select top 10 star so now if I do to select top 10 star and I click execute now I can still see all the column name
Of my table and I only need that I don’t need it to give me all the million rows in that table this is a tip for interview sometimes they give you a table to work with on an interview and you want to be able to see all the
Column name so that you’ll be able to write your SEL query rule of Tom is to do a top 10 you can even do top one and now we’re good to go to start learning Seco I’ll see you in my next video bye-bye
Video Keywords: SQL
-
Sale!
Wireless WIFI Repeater Extender Amplifier Booster 300Mbps
$29.99$14.99 Add to cartWireless WIFI Repeater Extender Amplifier Booster 300Mbps
Categories: Electronics, Wi-Fi Router, Wireless Wi-Fi Extender Tags: 300Mbps, 802.11N, Amplifier, Booster, Extender, mobile wi-fi booster, Remote, WIFI, Wireless, Wireless WIFI, Wireless WIFI Repeater, Wireless WIFI Repeater Extender, Wireless WIFI Repeater Extender Amplifier, Wireless WIFI Repeater Extender Amplifier Booster, Wireless WIFI Repeater Extender Amplifier Booster 300Mbps$29.99$14.99 -
Sale!
Full RGB Light Design Gaming Headset Headphones with Mic
$24.99$14.99 Add to cartFull RGB Light Design Gaming Headset Headphones with Mic
Categories: Electronics, Gaming, Gaming Headsets Tags: Design, Full, Full RGB Light Design Gaming Headset, Full RGB Light Design Gaming Headset Headphones, Full RGB Light Design Gaming Headset Headphones with Mic, Gamer, Gaming, Gaming Headset Headphones, gaming headset wireless, Headphone, Headphones, Headset, Light, Mic, Package, RGB$24.99$14.99 -
Sale!
Wireless BlueTooth Multi-Device Keyboard Mouse Combo
$39.99$19.99 Add to cartWireless BlueTooth Multi-Device Keyboard Mouse Combo
Categories: Electronics, Gaming, Gaming Keyboards, Keyboard Mouse Combos Tags: Combo, Keyboard, keyboard mouse combos, Mouse, MultiDevice, Set, WireKeyboard Mouse Combo, Wireless, Wireless BlueTooth Keyboard Mouse Combo, Wireless BlueTooth Keyboard Mouse Combos, Wireless BlueTooth Multi-Device Keyboard Mouse Combo, Wireless BlueTooth Multi-Device Keyboard Mouse Combos$39.99$19.99 -
Sale!
High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar
$199.99$139.99 Add to cartHigh Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar
Categories: Gaming, Gaming Chairs Tags: Adjustable, Chair, computer chairs, Desk, Executive, Gaming, Girl, Headrest, High, High Back Leather Executive Adjustable Swivel Gaming Chair, High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest, High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar, High Back Leather Executive Adjustable Swivel Gaming Chairs, Leather, Lumbar, Office, Racing, Swivel$199.99$139.99 -
Sale!
Professional LED Light Wired Gaming Headphones with Noise Cancelling Microphone
$29.99$19.99 Select optionsProfessional LED Light Wired Gaming Headphones with Noise Cancelling Microphone
SKU: N/A Categories: Electronics, Gaming, Gaming Headsets Tags: Cancelling, Gaming, Gaming Headphones with Noise Cancelling Microphone, gaming headset, Headphones, Headset, LED, Light, Mic, Microphone, Noise, Professional, Professional LED Light Wired Gaming Headphones, Professional LED Light Wired Gaming Headphones with Noise Cancelling Microphone, Wired, Wired Gaming Headphones, Wired Gaming Headphones with Noise Cancelling Microphone$29.99$19.99 -
Sale!
Gaming Desk with LED Lights USB Power Outlets and Charging Ports
$349.99$249.99 Select optionsGaming Desk with LED Lights USB Power Outlets and Charging Ports
SKU: N/A Categories: Computer Desk, Gaming, Gaming Desk Tags: and Charging Ports, Charging, Desk, Desks, Gaming, gaming desk with led lights, Gaming Desks with LED Lights, Home, LED, Lights, Monitor, Office, Outlets, Port, Power, Room, Stand, USB, USB Power Outlets, White, Workstation$349.99$249.99 -
Sale!
Wired Mixed Backlit Anti-Ghosting Gaming Keyboard
$99.99$79.99 Add to cartWired Mixed Backlit Anti-Ghosting Gaming Keyboard
Categories: Electronics, Gaming, Gaming Keyboards Tags: Antighosting, Backlit, Blue, brown, Gaming, Gaming Keyboard, gaming keyboards, gaming keyboards and mouse, Keyboard, Laptop, Switch, Wired, Wired Mixed Backlit Anti-Ghosting Gaming Keyboard, Wired Mixed Backlit Anti-Ghosting Gaming Keyboards, Wired Mixed Backlit Gaming Keyboard$99.99$79.99 -
Sale!
Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset
$119.99$59.99 Add to cartWireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset
Categories: Electronics, Gaming, Gaming Headsets Tags: 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset, ANC, Audio, Bluetooth, Cancellation, Ear, Earphone, gaming headset, Headphones, Headset, Hi-Res Over the Ear Headphones Headset, HiRes, Noise, Wireless, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Headphones, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headsets$119.99$59.99 -
Sale!
Wired Sports Gaming Headset Earbuds with Microphone
$19.99$9.99 Select optionsWired Sports Gaming Headset Earbuds with Microphone
SKU: N/A Categories: Gaming, Gaming Headsets Tags: Accessories, Earbud, Earphone, Earphones, Gaming, gaming headset with microphone, Headphones, Headset, IOS, Microphone, Sports, Wired, Wired Sports Gaming Headset Earbuds, Wired Sports Gaming Headset Earbuds with Microphone, Wired Sports Headset Earbuds$19.99$9.99 -
Sale!
150W Universal Multi USB Fast Charger 16 Port MAX Charging Station
$49.99$29.99 Add to cart150W Universal Multi USB Fast Charger 16 Port MAX Charging Station
Categories: Charging Stations, Electronics Tags: 150W, 150W Charging Station, 150W Universal Multi USB Charging Station, 150W Universal Multi USB Fast Charger 16 Port MAX Charging Station, 150W Universal Multi USB Fast Charger 16 Port MAX Charging Stations, 150W Universal Multi USB MAX Charging Station, 16 Port MAX Charging Station, 3.5A, Charger, Charging, Fast, laptop charging stations, Max, Multi, Port, Stand, Station, Universal, USB$49.99$29.99
I can't install it😢?
Thank you so much
But please I don't know anything about SQL can I used it ?