If you need a gift this year, check out my lil side project: quickandeasygifts.com! Video coming eventually on how to build an income-generating website.
Hey, has this website generated you any significant income? I clicked on it and so far it seems a little janky... (React App and favicon in the tab window)
@@adityagarg2185 no, it made a few bucks but since then Amazon has implemented an identical feature. I'd like to do a video sometime bc the backend was rather neat and it cost nothing (uses lambda). Also - I'm not a great designer as you can see!
@Andrei C MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY YEARS.
Thanks, man! I am thinking of taking some online classes to learn a new skill but I was worried I might not understand how this works. But with this visual walkthrough I think I should be able to get a firm grasp on it.
very good tutorial for a beginner. i am loving how you take it step by step. i tried other youtubers and i was almost giving up until i stumbled into your tutorial, thats what motivated me, thanks James Vance. I just subscribed for more.
I've been building SQL in Access for a little bit and I've never seen it explained this way. I needed help with syntax though. Thanks. I'm sure it's a benefit.
Thanks! I was inspired by a similar situation where someone was explaining UNION statements and making it way harder than it had to be. Glad it helped!
Exam is in about 9 hours, so that's ~540min, that means that I can watch this video 54 times but if I speed it up to 1.5, I can watch it about 80 times... yeah, I got this.
Thanks for the video! My professor is an idiot and I'm really glad that this great video was made for desperate fools with exams in the morning like me.
I've recently viewed a couple of other youtube channels and so far from the couple of videos I've watched none of them don't break it down to the bare bones of what SQL really is? its usually a youtuber instructing you to download my "mysql" or or some other application to download, then they provide a poor tutorial on the subject by over explaining the subject. I appreciate the simplicity of how you introduce the subject matter. The video was simple and to the point and wasn't over elaborate, thank you.
Great video! It even helped me understand the Join Tables function in ArcGIS! I really appreciate the visual here. Trying to get traction teaching myself GIS and indexing has not been easy. There are so many amazing open source programs and free education tools out there, but so much of it doesn't start with properly orienting the student. Context, application examples, and visuals are really helpful. :) Quick question: What language would you suggest I learn for library/museum indexing? I want to be able to sort collections, extract data I can put into tables, and then use those tables to potentially create visual representions of the data through ArcGIS. I am working on learning Python right now. I am not sure that will be enough, though.
Oh and to your question, I would definitely recommend Python if you're asking about languages. Its user friendly, it integrates into things like Excel and you can literally do anything in it. I've gone from basic data analysis to building my own website in not much time. Bon fortuna!
Thanks a lot! I do have more videos in progressively more advanced SQL: * Intermediate SQL (ua-cam.com/video/xpwEYcmhtKs/v-deo.html) * Deep dive on joins (ua-cam.com/video/tvMGoxmQzgQ/v-deo.html) * Fill out your knowledge (ua-cam.com/video/SMO-I2YhOdU/v-deo.html) Hope it helps!
PL-SQL and Transact-SQL are scoring the very similar special casus for keyword SELECT. Instruction SELECT...FOR XML (by attributes like RAW, AUTO or Explicit similar to the common on whole SQL COMMIT and ROLLBACK and implicite-explicite in C++) is able to check whole ontology (including XML Schemas) and validate informations even same good as scrpit by Perl, Ruby on Rails, Python or Jython (the etc) ... UNION and UNION ALL are same on both Oracle and Microsoft version. Personally I do not know how by PL-SQL can be check or search XML information datagram document, but SELECT INTO is very similar to this case, which can be used similar to the Trigger. Excellent as sum up can be introduction to LINQ, best as always are free compilers, parsers and validators on our WWW`s ... Before ontologies we had LISP, DATALOG and PROLOG ... Knowledge data bases and data mining is the future, but also alredy done and implemented ...
ive been learning sql, i worked in a transport office where they used access and excel and it just didnt work, so I thought id have ago at building a full transport and warehouse db, which so far works easier and better. However with the db built, would you have to build a gui or some software to use it externally? As ppl who cant use sql wont know how to do it, however if they had a simple userface, it would just need inserting and would update itself
Theres actually some tools where you could pre-load excel macros to pull or update data connected to the SQL database. A connection like ODBC can help hook up excel to your database
James, i am new to IT field i have no experience at all, can you give me a guidance as to how and where i should start, as i am planning to get certified in DBA. Thanks in advance!
Well there are many, many paths and I am not an expert on IT careers. However if you would like to become a certified DBA I would say some sort of cloud certification would be an excellent companion. Many companies are in the cloud and many more are transitioning. I subscribe to acloud.guru which I've found helpful passing AWS certs
I'm a data analyst just learning SQL if I want to practice this at home what do I need to download? How and where do I access the platform to enter the SQL code. Also with the tables how to I name them, I assume it's easy if they are in Excel. First off?
Yes, you can load excel data into a SQL database for practice. However, there are a lot of datasets already in sqllite format that would be easier to import. I'd recommend downloading sqlite and sqlite studio and then using a Kaggle dataset. Here's an example with food reviews from Amazon: www.kaggle.com/snap/amazon-fine-food-reviews. You can use sqlite studio to import the data
@@alexandermoritz4937 hmm I think it might just be the x marks that are too big. I see 2 rows with red in the blue column and they disappear after the where statement
@@machinelearninginterview Well maybe im missunderstanding something simple. But at 4.47 there is 6 "rows" in every column ( column_blue, column_orange, column_yellow and column_green). Then at at 4.50 all columns now have only 4 "rows", not just the blue column that you specified.
I'd suggest Postgres since its easy to load data and comes with the PGAdmin editor. Or you could play around in the browser www.w3schools.com/sql/trysql.asp?filename=trysql_asc
Group By looks for same values in Blue column right? I wish you used names or other ways to indicate the blue column, for example maybe it was warehouse numbers warehouse 1, warehouse 2, warehouse 3, warehouse 1, and you somehow had two of these (maybe because you used Union) so now you are combining two warehouse 1 stock quantity reported by different workers. I love your simple explanation but we to explain to people how SQL or basic database can be utilized on day to day operation. Most people have no clue how to utilize sql. They think it's complicated and requires a lot of investment, while it's just a fancy excel.
Yeah, that's fair. Sometimes trying not to be specific makes it more confusing. And agreed on the utilization point. Soon I'm hoping to make more technical videos but also some less technical concept videos for data & analysis. Stay tuned!
@@machinelearninginterview please incorporate forms and design in access, I've been trying to do this so I can enter info to excel with autocomplete that completed other cells when you type one in another. If I put x in cell A1, I want it to put Z in A2, for example...
If you need a gift this year, check out my lil side project: quickandeasygifts.com! Video coming eventually on how to build an income-generating website.
Hey, has this website generated you any significant income? I clicked on it and so far it seems a little janky... (React App and favicon in the tab window)
@@adityagarg2185 no, it made a few bucks but since then Amazon has implemented an identical feature. I'd like to do a video sometime bc the backend was rather neat and it cost nothing (uses lambda). Also - I'm not a great designer as you can see!
Bro did you got selected?😂😂
Real Helpful buddy! created in August 5, 2017. but still useful in January 5, 2020. Thumbs up!
You got it! So glad it helped!
@Andrei C MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY YEARS.
Ah January 5, 2020, what an innocent time
Have interview in 2hours, good video for recall my computer science lessons.
"Or a bunch of columns smashed together!! No one knows"
Never Subscribed so fast!!
This video is great! Explaining visually how SQL understand the commands is just the most effective way! Thank you a lot for the job!
This visual explanation makes it possible for my newb brain to actually understand what the commands are doing. Thank you!
Thanks, man! I am thinking of taking some online classes to learn a new skill but I was worried I might not understand how this works. But with this visual walkthrough I think I should be able to get a firm grasp on it.
very good tutorial for a beginner. i am loving how you take it step by step. i tried other youtubers and i was almost giving up until i stumbled into your tutorial, thats what motivated me, thanks James Vance. I just subscribed for more.
What a great comment. It always feels impossible before its finished! Good luck on your learning journey!
This was a great introduction. Thanks for posting. Look forward to seeing more of this, particularly for analysts.
What type of analytical topics?
Awesome job man! I actually feel like I can wrap my head around SQL now. Thanks a million!
Thanks a lot!
I love the way you visualize what the code is actually doing, great work.
Thanks man. For whatever reason YT has seriously hit the brakes on recommending it. If you know anyone else who might like it please share 😀
Thank you. That was a good introductory video. It gave me a good understanding of SQL.
Realyl useful thank you lol . My database class is coming up this morning and now I'll be slightly ahead than the rest of the class.
This is great overview. Nicely done.
I've been building SQL in Access for a little bit and I've never seen it explained this way. I needed help with syntax though. Thanks. I'm sure it's a benefit.
Let me know if there's other areas these videos could touch on :)
Such a helpful video. Explained it better than most other UA-cam videos i've watched.
Very good explanation. Anyone does not teach like this.
OMG THANK YOU SO MUCH, my professor has the most confusing powerpoint on SQL's and this video made me understand the logic so easily !!!
Thanks! I was inspired by a similar situation where someone was explaining UNION statements and making it way harder than it had to be. Glad it helped!
Awesome explanation in an easy to grasp manner. Well done!
Thanks , Trying to take my MTA 98-361 and needed a crash course in SQL
This is brilliant. I'll use similar examples to teach others and I'll refer them to this video as well.
Love the visualizations
Love it. Wish I didn't have so much trouble telling your blue from purple, but I can still follow.
Thank you very much, James, for this video! It was really simple to understand and I learnt a lot!
This is such an eloquently simple explanation of SQL basic concepts.
Merci :)
Exam is in about 9 hours, so that's ~540min, that means that I can watch this video 54 times but if I speed it up to 1.5, I can watch it about 80 times... yeah, I got this.
I hear if you leave it on while you sleep you'll remember the next day :p
@@machinelearninginterview ommelette du fromage
@@throwaway.mp4931 Dexter’s Laboratory 😱
10/10 thank you friend!
I think this was an awesome brief overview. I'll know more after further research, but great start right here. Thanks
It's great to hear that! Good luck on your learning!
I started a new job today and part of their requirements are that I learn basic sql queries, this video will help me out so many thanks.
That's great to hear. Good luck!!
What a perfect video, will be using it !
Fantastic demonstration/explanation/introduction! Thank you! This is personally very helpful for me.
Thats awesome to hear!!!
God bless u bro for giving all this knowledge out for free
Thanks for this James. Very helpful!
I got my job after just watching this video!!
That is awesome! Congrats! :p
ya right! stop joking around u serious?
@@Noname23489 I think it's a joke based on other comments about passing tests, acing interviews and getting dates :p
You are so lucky
I hope this is me!!!!!
finally an accent that is clear and understandable!
Thank you so much
Glad it helped!
This is very helpful! As someone who is green and looked at other resources, you did a great job....hopefully you made more!
Thanks! More coming soon!
It's ok if you're green. We're all about diversity and inclusion here.
You’re a genius!
Thank you so much for doing these videos. 🙏
You're quite welcome!
Parts 2 and 3 of this series are coming this weekend 2/25/18. Stay tuned!
This ever come out?
A little behind with another project. Coming very soon!
Here we go: ua-cam.com/video/xpwEYcmhtKs/v-deo.html
please keep it up. you have the potential to make good and helpful videos.
This video is so underrated! Great job!!!
Thanks that's very kind!
Great explanations of the purpose and execution of UNION and GROUP BY statements. They can be a bit confusing, even for experienced SQL writers.
Kevin Clarke thanks a lot! When Unions first clicked for me I realized it was easier to just visualize it and that inspired the video
Thank you for this amazing tutorial!
Thanks James Vance! So clear and easy to understand.
☺
Simple and Clear ..... Thank you
Game changing SQL explanation.
Thanks for the free and useful Tutorial!
I like your approach to teaching thank you!
Thank you James, awsome idea to teach sql basic
Sure thing! Thanks a lot
THANKS FOR THE BASICS!
Great intro course. Would recommend it to beginners
Thanks so much! More visual-based vids coming soon!
Very helpful to beginners!
I have a final on SQL in 40 minutes. Hopefully this video gets me an A!
Go get 'em!!
how did it turn out?
Kristian Scharff C lol
ChrisG- I actually watched it too right before my exam.
I did ok i guess
ChrisG- I got a 5.7 btw. Not bad.
Legit pfffd with a smile at that intro about the fancy logo :)
Thanks for the video! My professor is an idiot and I'm really glad that this great video was made for desperate fools with exams in the morning like me.
That's what its here for :) Good luck!
James Vance!! Vance Refrigeration!!
I'm sure you've never heard that one before. In all seriousness, thanks for the video. Very informative!
Haha yup I get that all the time!
Thanks for the video! Very helpful.
6:26 Thank you, this visualization really helped joins click with me.
And, uh, I got a job as a Senior SQL Engineer after watching it...
Congrats! I expect nothing less from my viewers :p
very useful, thank you!
Awesome Beginning
This is brilliant .. really
Very good tutorial!
Very good , keep it up
thank you, this was a useful vid
Uses normal english, really useful lthanks
I've recently viewed a couple of other youtube channels and so far from the couple of videos I've watched none of them don't break it down to the bare bones of what SQL really is? its usually a youtuber instructing you to download my "mysql" or or some other application to download, then they provide a poor tutorial on the subject by over explaining the subject. I appreciate the simplicity of how you introduce the subject matter. The video was simple and to the point and wasn't over elaborate, thank you.
Dude, that's awesome. That's all I was trying to do
best sql tutorial thus far
Thank you 😀
Thanks, really helpful.
Thank you for making such a great video
I HAVE A JOB INTERVIEW TOMORROW AND HAVE NO IDEA WHAT THIS IS ALL ABOUT! I HOPE THIS VIDEO HELPS
Good luck!!!
OMG, I thought I was the only one! Same here!
Same here! Ahaaha..aaaaaa...Did you get the job?
lmao
I have one on Friday. how did yours go?
Thanks 👍👍👍👍👍
Very useful..Thank you hun..You earned a new subscriber..
Thank you! More vids coming next year!
@@machinelearninginterview Aww..looking forward to those x
Thank you :)
You're welcome!
great video
Great video! It even helped me understand the Join Tables function in ArcGIS! I really appreciate the visual here. Trying to get traction teaching myself GIS and indexing has not been easy. There are so many amazing open source programs and free education tools out there, but so much of it doesn't start with properly orienting the student. Context, application examples, and visuals are really helpful. :)
Quick question: What language would you suggest I learn for library/museum indexing? I want to be able to sort collections, extract data I can put into tables, and then use those tables to potentially create visual representions of the data through ArcGIS. I am working on learning Python right now. I am not sure that will be enough, though.
Thanks a lot :) If you're working on Python I'd really recommend the sentdex channel. Not a ton of GIS but great stuff. Best of luck!!
Oh and to your question, I would definitely recommend Python if you're asking about languages. Its user friendly, it integrates into things like Excel and you can literally do anything in it. I've gone from basic data analysis to building my own website in not much time. Bon fortuna!
@@machinelearninginterview Awesome! It is nice to know I am on the right track.
Thank you very much.
Excellent!
Thanks!
really good. thanks a lotttt
Appreciate it!
Amazing video for beginners. Do you have a series?
Thanks a lot! I do have more videos in progressively more advanced SQL:
* Intermediate SQL (ua-cam.com/video/xpwEYcmhtKs/v-deo.html)
* Deep dive on joins (ua-cam.com/video/tvMGoxmQzgQ/v-deo.html)
* Fill out your knowledge (ua-cam.com/video/SMO-I2YhOdU/v-deo.html)
Hope it helps!
PL-SQL and Transact-SQL are scoring the very similar special casus for keyword SELECT. Instruction SELECT...FOR XML (by attributes like RAW, AUTO or Explicit similar to the common on whole SQL COMMIT and ROLLBACK and implicite-explicite in C++) is able to check whole ontology (including XML Schemas) and validate informations even same good as scrpit by Perl, Ruby on Rails, Python or Jython (the etc) ... UNION and UNION ALL are same on both Oracle and Microsoft version. Personally I do not know how by PL-SQL can be check or search XML information datagram document, but SELECT INTO is very similar to this case, which can be used similar to the Trigger. Excellent as sum up can be introduction to LINQ, best as always are free compilers, parsers and validators on our WWW`s ... Before ontologies we had LISP, DATALOG and PROLOG ... Knowledge data bases and data mining is the future, but also alredy done and implemented ...
this video age like a fine wine
Thank you 🙏
Love you dude
;)
Fancy logo James :d
I got a date with a hot girl in 30 min. Hope this video helps !! kappa
Uhh...better watch it twice?? :p
Guess ill do that then. Maybe ill get the 2nd date. kappa
HAHAHAHA You won the internet
It's not twitch, please don't say kappa.
And this was also 9 months ago, holy...
if you get nice job because of knowing that, she will be very glad to be with you
2:25 Did I just get vibe checked by an SQL tutorial?
Don't doubt your vibe ;)
@@machinelearninginterview awful reference. I hate it. Thanks for the vid tho
please leave a link to examples and other references to your website in the description....
Will do, and thanks for your suggestion
ive been learning sql, i worked in a transport office where they used access and excel and it just didnt work, so I thought id have ago at building a full transport and warehouse db, which so far works easier and better. However with the db built, would you have to build a gui or some software to use it externally? As ppl who cant use sql wont know how to do it, however if they had a simple userface, it would just need inserting and would update itself
Theres actually some tools where you could pre-load excel macros to pull or update data connected to the SQL database. A connection like ODBC can help hook up excel to your database
There are also gui tool like alteryx, microsyrategy and cognos if your company will pay for licensing
Thanks
James, i am new to IT field i have no experience at all, can you give me a guidance as to how and where i should start, as i am planning to get certified in DBA.
Thanks in advance!
Well there are many, many paths and I am not an expert on IT careers. However if you would like to become a certified DBA I would say some sort of cloud certification would be an excellent companion. Many companies are in the cloud and many more are transitioning. I subscribe to acloud.guru which I've found helpful passing AWS certs
SQL is just crap going into a certain order, the obtaining the good data is the hard part.
The last one confused me, only the dark red/green were added up why?
I'm a data analyst just learning SQL if I want to practice this at home what do I need to download? How and where do I access the platform to enter the SQL code. Also with the tables how to I name them, I assume it's easy if they are in Excel. First off?
Yes, you can load excel data into a SQL database for practice. However, there are a lot of datasets already in sqllite format that would be easier to import. I'd recommend downloading sqlite and sqlite studio and then using a Kaggle dataset. Here's an example with food reviews from Amazon: www.kaggle.com/snap/amazon-fine-food-reviews. You can use sqlite studio to import the data
Put the volume a little higher when you export plz
how can i Learn this; do you have a tutorial you can refer to me?
The free Codeacademy one works very well www.codecademy.com/learn/learn-sql
Would this video help for QA tester?
Definitely. Being able to query sql to understand the state of a system is crucial for a qa tester
New to SQL but why does the RED values get filtered in the other columns aswell? Since you only specified where Blue column RED
RED shouldn't get filtered in other columns but I could have made a mistake in my graphic. Do you have a timestamp?
@@machinelearninginterview thanks for answering so quickly. Yeah its around 4.45 ish.
@@alexandermoritz4937 hmm I think it might just be the x marks that are too big. I see 2 rows with red in the blue column and they disappear after the where statement
@@machinelearninginterview Well maybe im missunderstanding something simple. But at 4.47 there is 6 "rows" in every column ( column_blue, column_orange, column_yellow and column_green). Then at at 4.50 all columns now have only 4 "rows", not just the blue column that you specified.
great
I am color-blind so what I saw was different shades of grey columns and grey dashes... 😩 Nice job... Although good tutorial...
Yes I will not make this mistake again!! Tried to be too abstract, sorry. Glad you liked it despite :)
@@machinelearninginterview to be honest your tutorial was so good I managed to complete a problem in a live competition.. I am subbed and on board....
can u suggest any sql software to download which we can practise at home
I'd suggest Postgres since its easy to load data and comes with the PGAdmin editor.
Or you could play around in the browser
www.w3schools.com/sql/trysql.asp?filename=trysql_asc
@@machinelearninginterview thx
Group By looks for same values in Blue column right? I wish you used names or other ways to indicate the blue column, for example maybe it was warehouse numbers warehouse 1, warehouse 2, warehouse 3, warehouse 1, and you somehow had two of these (maybe because you used Union) so now you are combining two warehouse 1 stock quantity reported by different workers. I love your simple explanation but we to explain to people how SQL or basic database can be utilized on day to day operation. Most people have no clue how to utilize sql. They think it's complicated and requires a lot of investment, while it's just a fancy excel.
Yeah, that's fair. Sometimes trying not to be specific makes it more confusing. And agreed on the utilization point. Soon I'm hoping to make more technical videos but also some less technical concept videos for data & analysis. Stay tuned!
@@machinelearninginterview please incorporate forms and design in access, I've been trying to do this so I can enter info to excel with autocomplete that completed other cells when you type one in another. If I put x in cell A1, I want it to put Z in A2, for example...