 So you want to build better SQL projects where you reach the right video? Let me explain This video is brought to you by Digitalink Academy You're no more source to learning programming fast and get to that six-figure freelance salary you desire Our courses include our sequel 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, I got a couple of points here I want to cover just to make sure all of us is on the right page or same page as far as just projects and importance of it And a real-world project at the end of the day guys real-world projects are the thing that's going to advance your career the most It's gonna help regardless of what area you are in in your coding career When it comes to interviews when it comes to your resume your portfolio your promotions at work Everything's gonna be dictated about the projects that you guys complete and that you can showcase as far as your value A lot of us get tied up into the actual learning how to code phase And that's okay at the beginning when you're trying to kind of get things or get it Be aware of coding the fundamentals and all that stuff But you're gonna quickly find out what really set you apart from other developers It's the projects the impact you have on an organization and really taking your career your skills to the next level using Projects that being said guys. I got a couple of points here I want to cover as far as just five Projects that you guys need to do as a developer you can build you reckon it can really set your self up for a career as a Software developer that being said One of the things that I like to do guys is deep ERP system integrations with accounting via the database via sequel When it comes to applying cash to a system, let's just say you got a ERP or a management system and That management system pushes invoices to this accounting system that being said these two systems need to communicate on a very deep level In order to make your business run efficiently and out of the box and you know the can integration It's okay, but you need deeper integration That's gonna allow you to make decisions faster and make you be aware of what's going on the left hand or the right hand doing so Building that deep integration applying cash between the two systems when you have invoices You want to be able to know hey, I'm putting the order over here is this customer paying these invoices You need credit limits all that stuff over here the data is over here in this system But you want to actually be able to share it with this other ERP system That's a great project you guys can do for any company You can do that for a property management company. You can do it for banks anybody who use ERP or management systems Which is mostly 99% of organizations nowadays use some form or fashion of an ERP or management system And they have some kind of accounting system where they keep old invoices accounts payable accounts receivable All that good stuff and to be able to integrate that with sequel is a great way to get started guys I talk about a lot of this stuff in my seven step guide to really get into depth So if you haven't already go sign up for my seven step guide and also is free And if you already signed up for my seven step guide, I have premium courses below sequel projects That's gonna help you take your career to the next level and be a part of our free community It's gonna help you take your career to the next level. So resources below go ahead and sign up for that guys So sticking with the ERP system guys imaging is a very critical piece of any organization I know it's 20 21 and you would think paper would not be a significant part of an organization But it is you see the mailman is always running you see people are always scanning printing stuff out Well, you're gonna have to eventually get that back into your organization So people can use that information and store it be able to take action To complete orders or complete tasks based off of that You want that paper in your system as fast as possible If you can get external people or external processes to scan it in so that you can do processes off it RPA robotics machine learning AI whatever the method you want to get that image in the system You can leverage that via databases. He can trigger events. He can trigger certain workflow processes so you can be able to store that data and Display that in some form of fashion using a sequel trigger guys. This is one that is not used enough Because a lot of people just see imaging as imaging which I can understand that a virtual document What more can that be but you got to think of it as People need to see that information at the right time. That's data. Just like a database That's unstructured data and you need to be able to put that unstructured data in a structured format So that people could take action on it and the bit quickest way you do that The more money a company you make the better decision they can make the more informed decision They can make and the more information that executive team have on the day-to-day workflow of a specific order A specific resource it can be a property if you have property management all like this stuff guys So you got to be aware that it's well. So Imaging is a very a key part of all that number six Deep employee onboarding and off-boarding guys. This is something else You can leverage sequel in databases with guys a lot of it dealing with single sign on Microsoft a lot of that power sale stuff You can store that in the database and you can actually have each application have their own Different user table you can populate that table with single sign on information with the passwords and all that stuff So when you onboard a user based off a certain role, you can put that in the database and guess who got access to all the applications Day one, you don't have to necessarily have somebody going to each individual systems to log them in and The best part of all when people leave you go and active directory or Azure or Google whatever your Sign-on client is if you disable them that same process will go into those other systems and disable them as well a lot of you guys think man that say Software a system Administrating role Developers can really come in and make a difference as far as just that DevOps kind of feel and make sure you know We put the team in a position so that we work on projects that actually matters not the onboarding and off-board There's a routine stuff that you can automate. That's a project that any company needs guys Because the truth of the matter nowadays Companies have a lot of cloud-based applications. It does a lot of integration stuff for single sign-on And you need that deep integration. Yeah, a lot of you guys may think well, right the company I work for they already have Single sign-on. Yeah, they have the general single sign-on I'm talking about deep single sign-on where you can actually specify specific roles based off of AD groups Be able to push that data to any application and sign off Which a lot of them don't have just say for an example I go in AD and I disable that user that user should not be able To get any other applications that I got single sign-on enabled. So that's another project you guys can do Event report triggering guys. This is one that a lot of developers think may ride. This is a Analyst role. This is something I do more than just reporting. Yeah, you do more than just reporting But guys we're talking about company impact. We're talking about developing systems That's gonna allow people to be more efficient to have better output to be able to really take their day-to-day Workflow to the next level and if you can provide somebody a specific piece of information when a specific trigger happens So that not only they know what's going on But things are getting done and you just alerting them of it, you know And you get to the point where you even automating it through machine learning just when you were really taking things up to the next level guys and a lot of times you have to Start with they just just a simple report to get to that advanced stages where you automate you use AI and machine learning So again, that's goes into the infrastructure knowing what a company internal infrastructure is So you can introduce or move that client to using more of these advanced tactics guys. I have More than just these four guys. I have a whole list and we talk about this in detail the complete list and my seven-step Freelance guide so go ahead and pick that up It's free and I also go really in-depth to show you how to apply this to your portfolio When you start to buy some of my premium courses guys So links are below for those goodies and go ahead and sign that up guys All of these are good projects you guys should be integrating into your portfolio Because at the end of the day guys like I was telling you before real-world projects Dictate how your career as a software developer is going to advance you can be the best coder in the world But if you can't plot any of that to the real world, it's a waste of time You know in the golden days of development where nobody have any software systems and everybody just need a pure coder Yeah, you can get away with just learning a code and just just really implementing code based stuff But now people have systems they have software they have procedures So yeah, it's more of a project based experience now instead of you coming in and putting in a whole brand new system without having to Account for existing system. So that's the name of the game in 2021 I want you guys to really position yourself so that you can be the top developer or get that job that you want Or just really update your portfolio so it can put you in a position to get to that next stage in your career Like subscribe to the content if you have questions Comment below if you agree with me comment below if you disagree with me comment below as well Let's start a conversation and we'll go from there guys So like subscribe to the content. I'm gonna put a link to my seven-step guide up here So go ahead and grab that and I'll see you guys in the next video. Peace