 So you want to build better my SQL projects where you reach right video, let me explain. This video was brought to you by DigiLink Academy. You're number one source to learning programming fast and get to that six figure freelance salary you desire. Our courses include our SQL project course, our freelance Kickstarter, our Python course and our interview programming course and much, much more. So if you haven't already, go ahead and click the link below to get to our free seven step freelance guide so that we can help take your career to the next level. I'll see you guys in the course. All right guys, let's jump right into some of the problems that you guys are having with my SQL and we're gonna help you guys solve them and put you in a better position. I got some points here. I wanna make sure I cover to make sure I give you clear and concise answers. So a lot of problem you guys are having is just focusing purely on back end projects. You're trying to be more of a full stack developer on the front end, which again, I'm not gonna knock you for that. If you're focused, you got projects, you know what you wanna do, but a lot of you guys are just generally learning any and everything or thinking that's gonna acquire you a better chance to be a software developer. But it's not, if it's not focused, if it's not geared to solving real world problems and I wanna help you guys get closer to that here. But before I get into it, I want you to share your experience learning my SQL, some of the projects that you guys been working on and just give me a sense of where you are, roadblocks that you're having and I wanna help you guys start a conversation below. So go ahead and share your experience with my SQL or just building projects in general with a database and we can start a conversation below. That being said guys, I wanna jump into some of the five projects that gonna really help take your career, your portfolio, your interview and just how people perceive you better. It's gonna take things to the next level for you guys to have these projects. And just to get, before I get started, projects is that thing that advances your career. I know you're learning how to code and you think that's advancing your career, which is a part of it. But the project is the thing that people can look at and say, if you completed that, I know exactly where you are as far as just how you can help me out. You can replicate that on my end and kind of get a good sense of you before they even learn all the details. So let's make sure we get our projects in order guys. That being said, first project, any CRM, any ERP related projects are gonna help you guys tremendously. Here specifically Sugar CRM, it's a free CRM that you can get a basic web hosting plan. And you can just look at the data models, look at how they build it, look at some of the things that you can take and actually add to your portfolio as far as just knowledge and skills you can acquire. Go in Sugar CRM, add to another table in there and start storing data, just not necessarily building things specifically in this specific case. You wanna actually start off just learning how they do things, how you architect. And that's how a lot of other programs, CRMs and ERPs actually handle their specific programs. Again guys, it's all about making sure you can communicate, you have domain knowledge, you know how to solve problems and you have that balance of technical knowledge as well. Especially as a freelancer, but a lot of you W2 employees, a lot of you aspiring developers who're trying to get started, Sugar CRM is a good way to find insight about a specific program. Number two, QuickBooks RGP. QuickBooks is another of my SQL database. You can do a lot of database related stuff, store procedures, just learning different tables, all that good stuff guys. MySQL works with QuickBooks as well, depending on what kind of installation you have. And there's some opportunity there as well. GP is more of a Microsoft SQL database, but the same concept applies guys. So MySQL and MSSQL are pretty similar. So if you can get one, the other works as well, but that gives you an accounting project under your belt. Number two, or number three, WordPress. WordPress is a good project to actually, not necessarily build because it's already made, but you can start to add the integration between Google Analytics, website traffic, customer linking between the CRM that I was telling you about earlier and your website. What customers went to your buy page and didn't buy? When did a customer come to your page? Did they reach out to you? Did somebody follow up with what made them come to that page? You're seeing how these projects start to tie together, right? And then you can actually take that and actually integrate it with more data as well. Number four, deep ERP accounting and website portal integration guys. The following three I just talked about, they work in unison if done correctly. You can actually track customers, you know who need to pay, you know, are they active? Are you getting orders? What's going on? And really have a better relationship with that customer. Knowing what their needs are, knowing their needs before they actually need it so that you can be ready to go or even suggest things to them. This what makes good freelancers make that good money and make good W2 employees be lead developers when you're actually developing these solutions because you're just not coming at it as a peer developer now. You're coming at it as a problem-solvering. Problem-solver, you just happen to have a skill set as a software developer. This stuff is key guys, some really good stuff here. Number four is ERP and imaging integration. So let's just say every company got a main system, main software that they use and they take orders. Well, those orders come with documentation that's outside of that system that they need to link to specific orders in that system. Having an imaging system in place will allow you to do that. It's not a ton of imaging systems that are free out of the box that are open source but I find WordPress have some integrations there with images you can tie to specific orders. Check that out for me. I'm gonna see if I can put some links below. I know in my seven step guide, we go over this and we have links there. So if you haven't already, go ahead and sign up for my free seven step guide and if you already signed up for my free seven step guide go ahead and check out some of my premium courses guys. I'm gonna help take your career to the next level and also got some good rates on that complete software developer toolkit. Links are below. That being said guys, yeah. Imaging is very important. You need to jump on imaging. That's one of the things that most companies need and they don't even know. They probably got images stored somewhere in a file share or even a hard drive somewhere that's not optimal to link that order to that image. There's a lot of things you can do. You can make a living off that. They learn that one area. Most of these you can make living together along with these but have just the general knowledge of each and have your specialties is probably the way to go. Last but not least, reporting, event triggering via the database guys. Everything that I talked about here on this project list you can do through MySQL. Reporting, QuickBooks, WordPress integration, SugarCRM, all this time MySQL and you can tie all this data together via store procedures, reports, any kind of way depending on what the customer needs are. You got triggers, you got business event that's happening. People wanna know this information before it happens or how often it happens so that they can get more insight of their business. This is where you can start tying in AI. This is where you can start tying in machine learning. We haven't even got to any of that stuff guys. The possibilities are endless. That's why I tell you guys we go over this in detail in my seven step guide. I can't cover everything here. I haven't mentioned blockchain algorithms, a lot of DevOps projects, a lot of the data science stuff just to cheer top of the mountain. We haven't even got DPSO guys. Go check that out. Like, subscribe to the content. If you have additional questions, comment below, share your experiences. Where are you hitting the road block head? Give me that information so that we can help solve your problems. Go check out my premium courses if you haven't already and sign up for my free seven step guide. I'll put a link here on the screen. Go check that out. I'll see you guys in the next video.