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.

♪ Rolling in the deep ♪ ♪ I learned coding on the streets ♪ ♪ You don't need a degree ♪ ♪ To become a ♪ ♪ Software engineer ♪ How long does it actually take to become a software developer? And how long does it take to actually get your first job? 

Today I have a comment for you that will actually answer all of those questions and more, so without any further ado let's jump right into it. This is Abhishek, also known as Techy from techyhydra.com. 

This article is taken from Clever Programmer just for education purposes.

Now today I'm gonna read to you that comment, but first of all, I do wanna say this is day seven of the challenge that I've been doing, and this is also video seven so I'm committed to making one video every day for the next 30 days. Now, as a motivation for you and some accountability for you, I am doing that and letting you know. So if you wanna use this time to code for 30 days in a row, you may do so alongside me and you can tag me in stuff too on Instagram posts and I will reply to you. I'm really active on Instagram so my Instagram is right here, techyhydra. 

Go to my Instagram, add me, and then you can actually tag me in your posts where you're coding every day for let's say 20 minutes, 10 minutes, 30 minutes, whatever it may be, all right. So let's jump into this video. I'm gonna read you this comment now. This comment was made on one of my videos and that video was called How I Learned to Code in Less Than 2 Months. Really amazing video, go check it out. 

So Jon Story says, "Today was my first day as a developer slash programmer slash designer "however you wanna call it "and this video gave me the courage and the strength "to start a new career as a self-taught developer. "And I just wanna say thank you for the inspiration, "it's been a long journey, "it took me almost two years, "not two months, to get to this point. "I started around June or July 2017, and today, January 28th, 2019 was the very first day of my first job in the industry. "Just like Les Brown says, "One idea can change your life, ""One idea can turn your entire life around." "I come to the same video where everything started. "Thank you, Clever Programmer, for the inspiration." 

So this was a pretty monumental moment, and it was a really incredible comment to actually have the privilege to read, and I'm gonna be honest, like, when I was actually walking around and I got it, I was somewhere outside, I saw this comment and it brought tears to my eyes. I almost wanted to like, cry, I got really teary-eyed and I messaged everybody I knew, I made a post on Instagram and everything and then I sent him a reply as well. I just thought it was so inspiring that he'd come a full circle. The video where he started, that gave him that inspiration to actually become a developer, he came back to that video to actually leave that comment. 

It was really remarkable and for me, it was like, if my YouTube channel had any purpose, like that alone for example could be worth it. Even though we have so many people who have similar stories where they become a developer, but even if I could help one person even be inspired to do that and go on that journey, it's like my job is complete. All the blood, sweat, and time and effort I've put into building a Programmer is completely worth it. So that was an amazing moment. 

Now, what do you get out of that comment? 

That video I made, I pushed for that you could actually become a software developer in two months, you can become a software developer in three months. And I learned actually code in two months but in the case of Jon, it took two years, actually two years, maybe just a little bit less than two years to really, actually get his first job. For everybody it's gonna take a different amount of time, all right? And now it also has to do with how much time are you actually able to put in? 

Let's Talk About it

Most people really are able to put in a few hours a day, maybe a few hours a week because they have prior commitments, different responsibilities, some of you might have kids, jobs, bills to pay, things of that nature. For me to actually get my first freelancing client in as little as three months and I share that story, it's because I also had no life at that time. I mean, I did, but I also didn't, right? So you have to understand that I personally was living with my parents at the time, I had lots of support, I had a financial safety net, I didn't have kids to take care of. I mean, I was still going to college and I was still working a lot, and I had to create time and I still managed my time really well and I was productive, but there were many, many, many, many days where for example, when I wasn't going to college or I had a little bit of break I had the luxury to spend 15 to 18 hours a day to code. 

So when I shared those thoughts about you can become a software developer in three months or two months, or you can at least get your first job at that time, I feel people take it the wrong way. And I think what they understand from that is that it's actually really easy to become a developer and he's saying that you could do it overnight. And that's actually not what I'm trying to tell you. 

What I'm trying to tell you is becoming a developer is very hard. 

• If you are looking to do this just as your side income, don't do it because it's gonna be really difficult to-- like there are many other ways you could earn a side income that is much easier. Like for example, look up dropshipping and learn how to use Amazon for that. Or use Uber or Lyft and it'll be much easier to actually get a job and start making side income. But get into this field if you're fascinated by it, if you find it interesting, and if you feel inspired by it.

• If this is something you can see yourself doing every day. With that said, if you are spending one hour or two hours a day it's gonna take you a long time and for most people, in Jon's story, it will take two years. So the majority of you by default, statistically speaking, it will take you two years or longer to become a software developer. It's a long, arduous journey. It's exciting and it's amazing, it's beautiful. Like you could tell, when he got his first job like it made everything worth it for him. But it is a long path. But if you are able to compress those hours instead of spending one hour a week or two hours or three hours a week, or just one hour a day. 

If you're able to compress that timeline and just put in a lot more grind time it is very possible for you to achieve lots of those goals earlier on, okay. So this is why I push freelancing 'cause the barrier of entry is lower and I was able to start earning an income three to five months into my programming career. I also became really good at that time and again, the reason was 15 to 18 hours a day of coding. So it makes me a statistical anomaly, but my obsession is crazy. The same thing I did when it came to chess. When I was learning how to play chess, it takes people an average of 10 years to hit the USCF rating of 2,000. It took me about three years, three and a half years to actually do that. What happened is that there wasn't any like a weird secret that I did, I just had put in a lot of time and energy into it because I loved it and I was just obsessed with it. 

Your timeline could look to give you a realistic idea from three months, rare. Three months you can get your first freelancing opportunity, I wouldn't even say the full-time job. Maybe you could get an internship if you have a lot of connections, right, but you have to push yourself and it is possible. But I wanna give you more statistical facts in this video. So three months. You have the timeline between three months to two to 2.5 years where you could become a developer and you could get a job, all right. This is a very realistic, I hate that word, realistic, but I know a lot of people want to know what's realistic because they can only do realistic things 'specially with their times and responsibilities, so. 

Between three months of being very aggressive and then 2.5 years 'cause that's plenty of time. You have that window of becoming a software developer. With that said, I also wanna tell you that you should pick your language and what you're gonna be specializing in because you wanna kinda see what's gonna be happening two and 2.5 years later and if you look at the predictions and the way different languages grow it's gonna be a very major determining factor in what language you should go for. I mean, even though languages aren't that important, the ideas and what you do with them is more important. For example, if you pick C++, C# then you might get better at lots of the things that you do with that language. Like, for example, let's say you pick up Swift and you start learning mobile development, right? Swift is more predisposed towards mobile development. 

If you might spend a lot of time there and then later you're like I wanna become a web developer, you will need to spend a little bit of extra time to then learn the web development skills. Instead of picking something like JavaScript, let's say, right at the start of your journey where you not only learn it but then you're improving the skill set. So by the time, whether it's six months, one year, two years for you, you have this skill set of being a web developer, right. Because JavaScript is just more predisposed towards web development. 

You're obviously gonna need to learn other languages as you're improving, that's just a natural process, but I'm just saying which language you should kind of push towards a little bit at the start. I personally love Python, this whole channel I always talk about Python so I'm obviously gonna recommend Python to start off with. And even when you look at the trends and the 2019 predictions and the upcoming years. So let's say if you're starting your journey now, and you're kind of a beginner, might take you 1.5 to two years to become a developer if you follow the realistic timeline. In that journey, if you're doing Python web development or Python development in general, just understand that the trend for Python is going really, really high up. 

And 'specially with machine learning and lots of data visualization and data analysis, Python is killing it in that regard. And those things are gonna be very, very important for AI in the upcoming years. You can expect Python to continuously just be growing at a tremendous rate. I mean, it was Googled more than Kim Kardashian in 2018. 

Know what I'm saying? 

All right, so with that said, I will say have that timeline, have that timeframe so you understand what is going on. To compress it, put in lots of hours and have a solid game plan of what you wanna be doing. Instead of haphazardly just picking random tutorials to learn from, actually be building projects. And if you are building projects and you're working on a few long-term projects and as you learn new concepts you keep adding them into your projects, you keep taking those projects and putting them up on your GitHub where recruiters and people can see it.

If you're focusing on your LinkedIn, your online presence, and your resume, and you constantly have all these ways of getting people's eyes on your project, you can keep compressing that timeline from two years to earlier and earlier and earlier. Another thing I always talk about is also being able to build those relationships and going to local events, local meetups where you could have access to internships and job opportunities long before you actually ever need them. 

And by the time you're even remotely ready you have people who you've built relationships with who will think this person is perfect, I can bring this person, train them, I've seen their hard work, I've seen their dedication, I've seen that they love coding and they've been consistent, let me bring this person in. I can just teach him. 

• Let's say you're doing Python and they have a job opportunity for let's say Java or JavaScript or something in web development, they'll just bring you on and teach you that, right. They know where your skillset is, they know how long it'll take to show you that. They also know you're reliable. So you might actually get a job or internship or freelancing opportunity just a few months into your career. I hope this gives you an idea and I hope I have provided you with a few tips. I suggest you go back to the part where I gave a few tips and just write them down 'cause they are very powerful. And I do wanna let you know I have a program coming out very soon in probably a week or two. 

It's gonna be called Earn 1K With Python and the idea behind that program is to show you the eight steps that I used to become a software developer and get my first job in less than four months. In less than three months, all right. Right around that timeline, I got my freelancing opportunity, and that's where my career started taking off. I'm gonna just distill all these points, give it to you in a very simple, easy to understand fashion. And this course is all about transformation, not information. 

There's gonna be more stuff for you to do but it's gonna be very results-oriented and each week we build on so that you can then have a strong foundation to become a high income-earning software developer. Whether that's $60,000 for you or $70,000 but my goal is to give you a very strong foundation to be going towards that six-figure mark. And with this program, my hope for you is to earn your first $1,000 with Python, and then hopefully that'll give you enough momentum to keep going and growing a lot faster. 

Thank you so much for reading this article. 

I love your face, and if you wanna get emails about my upcoming course which is gonna be coming soon, and you want to have access to this epic three-part masterclass I've put together as well, then go to cleverprogrammer.com. I've put the link in the description below as well, just click there and pop in your email. That way when my course comes out I'll let you know, and I'll also give you access to my epic three-part masterclass. 

That's it for this post, thank you so much for reading. I love your beautiful face and as always I'll see you on the next day. Take Care...

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.