What is SQL?

We all know data is all around us. We used to store data on paper in big filing cabinets. But eventually, we store them online in what we call databases. How do we easily pull the data we want to look at it? 

That's what SQL is for. It's a language that communicates with databases. Welcome back to TechyHydra. Your easy insights into Bob's big data and artificial intelligence. 

SQL stands for the structured query language. People call it SQL or Sequel. 

In short, SQL is the name for a language that is used to communicate with databases. Databases that store your data. If you want to pull, edit, add information to a database, you can use the language of SQL to do that. 

But how does SQL work? Think of a database like a warehouse. Data tables like filing cabinets and data like files. This warehouse or database stores data. The warehouse database was built using coding languages like C++ or C or Java. 

Now imagine regular Lego people need to access the files. How do they do that? Option one. You could have a storefront built to the warehouse so that customers can ask for files, add files, delete files, but eventually, this means you are building something that takes a lot of time, money. In the real world, this is the equivalent of building a whole app just to access the files in the database as to all comes in, which is the second option, SQL. 

This is like you hiring a specialized delivery-translator. Her name is Sally Sequel. She knows how to talk to the database and she knows how to speak in the language of SQL. So if you learn to speak SQL, then you can ask her to get files for you. Okay, so how do you speak Sally's SQL language? 

Here are the requests you can make. If you're a Lego Mayor and you want to know the name of your citizens, you'll ask Sally SQL, select name from lego_people.

The request you select the name, that column from lego_people, which is the name of the table. Or if you're a Lego doctor and want to know the name of citizens that are higher than three centimeters, you would ask Sally Sequel to select a name from lego_height where centimeter is greater than three. 

She returned two Lego people, Sarah and Craig because their centimeters are greater than three and she pulled from the name column within the table called lego_height. Or if you're a statistician and you want to know both the height and age combination of citizens but this data is stored in two separate tables, here is what you'd say to Sally Sequel.

Not all tables are found together, Sally joins the two tables because what both two tables had in common, the names column, she was able to join the two matchings by the names in each table. But you can also do other things. You can add data. If you want to add Joe, whose age 12. Or you can update data. Make Joe 13. You can also delete Joe altogether. From creating tables to joining tables to altering tables, Sally SQL could do it all. So here are three things you need to remember about SQL. 

•  SQL is the one language you probably should learn. If you are in business or marketing or sales or anything that you wouldn't normally think you need to learn to code, SQL is the one language you probably should learn. The reason why is because most companies nowadays have an online presence and are keeping records of data on a database. So the more you know how to communicate to this database and pull data, the better you can be at your job because now you can pull the data, analyze it. 

• SQL languages have variations. Different companies with different data SQL databases have different SQL syntaxes. They're a small variation. So it's the equivalent of having different Sally SQL Barbie with different accents. Three. SQL only speaks to a specific kind of database called a relational database, which is essentially a database that has a tabular schema. So it's a lot like a data table with rows and columns. 

Next time you hear about Sequel, just remember Sally Sequel. 

Comment down below if the company you work for uses Sequel to pull data from the database. Thanks so much and I'll see you the next time.

Top five programming languages for you to learn in 2020 to get a job without even needing a college degree. 

I make a video on this topic every single year, and you guys seem to eat it up. A video I made in 2018 got over two million views, and another one I made in 2019 got over one million views. I just wanna say thank you so much, I love your beautiful face. I love the support that you give to this channel. Let's continue. 

Now, just like my last few videos, we are going to be ranking the programming languages on three main factors. 

• Number one, the time it takes for you to learn, even if you're a complete beginner, and make real-world projects. 
• Number two, the job market. What are the demand and the overall salary that you can make with this programming language in 2020? 
• And number three, what is your overall productivity going to be with this programming language? This really matters when it comes to your own personal development with coding. How fast can you build real-world projects? 

And when you're working at startups and smaller companies, they need people to be able to build real applications in a much shorter amount of time. By the way, I would love it if you help me beat the YouTube algorithm, it's been destroying my channel. If you wanna help me do that, smash that Like button. Like, no, like really just go and destroy that Like button, okay, right now. Please subscribe to the channel if you haven't already, and let's keep going. 

What's up guys, this is Abhishek from techyhydra.com. Now, before we get into the meat and potatoes of this video and we talk about different languages, there are multiple programming languages where you can make over $100,000 a year. 

Before we get into that, I do wanna let you know that I have put together a really amazing three-part masterclass for you, especially if you wanna become a freelance developer and be on your path to go from zero to six figures per year. The way you can get your hands onto that training is by clicking the link below in the description and signing up for it. The best part, it's absolutely free, so go ahead and do that now. 

Let's continue. 

5. Java. 

Java, Java, Java. It's a pretty amazing programming language that a lot of people know. This is an object-oriented programming language, and this is used in lots of Android applications. That's one of the primary reasons why people use Java as of even today. Lots of big companies are still using Java. 

There are lots of trading applications made with it as well. It's currently declining a little bit in popularity because of programming languages like Kotlin, which you can now use to create Android applications. 

This is why, if you look at Google Trends, you will see in the last five years Java has a little decline. Outside of that, there are still lots of jobs that are offered for Java, and the salary for an average Java developer in the United States is $103,000 a year according to indeed.com.

4. Swift.

Swift is an iOS programming language that is used for Apple. If you ever dreamed of making an app that shows up in the App Store, ranks highly, or you wanna be able to make, you know, the dream of every developer ever, make monthly recurring income or passive income from an app that they created with passion, love, and heart, and put it out in the app store, and people in the Apple world can download it and use it, that is why you would learn Swift. 

Now, you can freelance with it, or you can get a full-time job. It's a very popular language. It's not getting more popular, but the great thing, it's not also going down. It has been stable over the last five years if you look across on Google Trends. That shows me that it's a very stable programming language, not going anywhere, and is great to invest your time in and to learn it. I would say it's really beginner-friendly as well. 

There are tons of tutorials on YouTube that support the learning of it, but not only that, it's a lot of fun. Java is a pain in the ass to learn if you are a complete beginner, but I think Swift is a little bit easier to learn just because you can make stuff and put it on your iOS device, and it's a lot of fun. Awesome programming language. 

The average salary of a developer in the United States is $115,000 a year, according to indeed.com. 

3. SQL.

I call it Sequel. Both ways are completely fine of calling it. This programming language, some people will argue it's not actually a programming language. It ultimately doesn't matter. This is called a structured query language. 

That's what SQL stands for. And why I recommend learning this, and why I think it's so important for everybody to actually know some of this, is almost no matter what programming language you're gonna work with, if you ever dream of creating applications and web applications, you're gonna have to deal with data. 

When you have to deal with data, you're pretty much not gonna getaway if you don't understand SQL, okay? So if you wanna make an application that can store data and save information? For example, if you go on Instagram, right? 

When you Like somebody's comment, or you Like somebody's post, that Likes is stored somewhere. Or when you make a post on Instagram or Facebook, that post is stored somewhere. When you log back in, that post is still there. Guess what is saving your post? It's SQL; it's SQL being able to talk to databases, all right? So that's why I think this programming language, this language, query language, is very, very important to learn. 

I put it at number three, but I think this is very, very vital, and almost any type of development you wanna do, especially any web development you wanna do, whether you wanna become a backend developer or a full-stack developer, you kinda have to know SQL. It will serve you really, really well. And the average salary of a SQL developer is $89,000 a year in the United States, according to indeed.com. 

2. JavaScript.

Ooh, this one is a controversial one. Everybody goes crazy. "Why did you pick JavaScript number two? "Why isn't it number one?" (mumbles) Everybody's gonna go crazy in the comments. 

JavaScript, according to the PYPL index and the Google Trends, JavaScript at number two in popularity compared to the number one language, which I will be talking about after this, but let's get into what can you do with JavaScript? 

JavaScript is a very incredible programming language. If you have dreams and aspirations to do anything related to web development, creating web applications, you're probably gonna need to learn JavaScript. Whether you wanna do full-stack or front-end development or backend development, it would help you to know JavaScript to a good extent.

JavaScript is a very popular language. If you even look at GitHub, there's always a new framework coming out for it. And there are tons of amazing frameworks and libraries always being produced for JavaScript, right? Like, for example, you got React, people talk about Vue.js, there are all kinds of craziness that goes around JavaScript. 

Even if you forget all the trendy stuff that's happening around, it's just a great programming language. Every web browser supports it and runs JavaScript, and I think it's one of the must-know tools that you need in your arsenal when it comes to programming and web development especially. 

The average salary of a JavaScript developer, according to indeed.com, in the United States is $113,000 a year. Real quick for those of you JavaScript nerds. I wanna give you a resource that will help you on your journey to becoming a JavaScript developer. 

I scour the Internet for a lot of stuff, you know, whether it's Udemy or Udacity or Coursera, or just YouTube in general, or some of my own courses, one thing I found that is actually really useful is on Skillshare, I found this course that's on JavaScript, and this course is very, very helpful. This, I think will help you. 

I would recommend you to check this course out. It looks pretty good. If you use the link that I have below in the description for Skillshare, you'll get actually two months of premium for free, so I would highly recommend going check it out. Skillshare, they have really amazing tutorials. This tutorial, to me, specifically, by Chris looks useful. Give it a try. With that said, let's jump right back into the video. 

1. Python! 

Python is the number one programming language, and now, it's not just according to me anymore, guys. That's a beautiful thing. According to Google Trends in the last five years, it's now officially the number one most popular language, and also according to the PYPL index, it is the number one most popular programming language. 

What's amazing about Python, it's a general-purpose programming language that you can use for many different things, but it's also very powerful. Before I get into the use cases of it, let me just tell you what types of companies use Python. So Google is built off of Python. YouTube is built off of Python. Dropbox, Quora, Hipmunk, Reddit, Instagram, and the list goes on. 

This is just to give you a taste of what types of things you can build with Python. So if you want to do web development, you could do it with Python. There are many different frameworks and libraries in Python that support and allow you to do lots of data science applications. And the real reason why Python has become so goddamn popular is because of data science. 

Data science has grown so much over the last few years, right? Like, look at the self-driving cars, the self-checkout at Walmart that's being implemented, Google self-driving cars, Tesla self-driving cars, and lots of the automation and machine learning algorithms that are being done as of today, a lot of them are being done in Python, and that has skyrocketed its growth. 

Why I really put it at number one is because it's very beginner-friendly. Out of all of the last four languages that I've talked about this is probably the easiest to pick up. But the amazing thing is, you can build real-world projects with Python and do that very, very fast. 

You can do web development really well with Python with its frameworks, like Django or Flask, those are unbelievable, and you can go on and do data science with it as well. I do think the language that you pick and choose and stick with matters. 

It's just like where you live matters and defines your culture and your accent, and everything around you, and kind of the things that you grow up to do. So I think the language that you start off with first defines a lot of things you're gonna do, right? 

For example, if you start with Swift and learn a lot of Swift, you're probably gonna become, or much more likely to be influenced by, iOS applications 'cause you're spending a lot of time building them and learning them, and you'll very likely end up doing something in the iOS section. If you learn Java, you're gonna spend a lot of time around Android applications. So it's really important what your goal is. If your goal is to make Android apps, go with Java. 

If your goal is to make iOS apps, go with Swift. If your goal is to just do web development and that's kind of it, go with JavaScript and stick with node.js and all of those frameworks. If your goal is to just do stuff with databases and become a data analyst and specialize in that section, go with SQL. But if your goal is to do web development, or you wanna do machine learning or data science, or any of those things, then you definitely wanna stick with Python.

 It's easy, gives you tons of flexibility, and the other amazing reason is the average salary for a developer in the United States, according to indeed.com, is $118,000 a year. So there you have it, all five programming languages that are incredible for you to learn in 2020 to get a job without even needing a college degree, as long as you have the skillset, the determination, and the persistence to go through. 

Please help beat the YouTube algorithm and give this video a Like. Smash that Like button, subscribe to the channel, and I do have a three-part masterclass for you that helps you become a freelance developer with Python. Go from zero to making six figures.