DEV Community: advancedsoftwareofficial

Database For New Developers

advancedsoftwareofficial — Sun, 14 Feb 2021 19:22:13 +0000

[Note: This post does not include any affiliates link, just a free course link at the bottom]

Any application needs to store and retrieve data. Is actually the point of creating an application is to help people store and process the data in a meaningful way. To do so we need to have a place to store all these data. This place is the Database where we store our data and we can define relations among this data.

Some articles you might like

How To Learn A Programming Language

advancedsoftwareofficial ・ Nov 24 '20 ・ 2 min read

#codenewbie #beginners

Database

Is the collection of tables and the related database objects that are used to store and retrieve the data. Tables are the main building block of the database. The database has some different types for example there is SQL database, NoSQL, Graph, and other types. No need to know them all we will focus on SQL Database as it is one of the well-known and widely used.

There are different vendors for SQL Databases such as Oracle, SQL Server, Postgres, and MySQL. You can choose any of them they are a lot similar.

Tables

The tables in the SQL Database (Called Documents in NoSQL) contains columns that you create and store the data inside them. The columns have types so you can set the correct data type such as string or date.

To uniquely identify the row in the database we use a Primary Key column to uniquely identify each row. It will not be repeated and you can use it to directly access the row as it is much faster. It will be auto-generated so we don't need to insert it.

Below is a sample table created in SQL Server

After we create the table, we can add edit, or delete the data via SQL. SQL is the language used to modify or add the data in the database.

ER Diagram

Entity Relationship Diagram is a representation of all the tables inside a database. Usually, before starting to work on a database we design its tables and relations so we make sure we are creating a good database design.

If you a new software developer, join our free course to help you get started
https://landing.advancedsoftware.io/software-developer-guide

5 Projects For New Software Developer

advancedsoftwareofficial — Sat, 23 Jan 2021 17:52:33 +0000

[Note: This post does not include any affiliates link, just a free course link at the bottom]
As a new software developer, you need to step up your game and become a top-notch developer in this competitive world. To become a better software developer you need to know how to create projects that fit your client's demand and expectations.

Some articles you might like

Top Programming Languages In Demand

advancedsoftwareofficial ・ Nov 29 '20 ・ 3 min read

#beginners #codenewbie

How To Learn A Programming Language

advancedsoftwareofficial ・ Nov 24 '20 ・ 2 min read

#codenewbie #beginners

So, to become a better developer you need to create some side projects that will help you grow as a software developer and will gain you new skills. We have this list of 5 projects that any software developer can create. Let's get started!

1. Todo List

This is the most basic and well-known project. We choose it because a lot of tutorials will be available for you as a reference to guide you with this project. These are the main components of this project

User Registration Page
Login Page
Todo List Page with Edit/Delete
Todo Add Page

2. Student Registry

Have an app help students of school signup to see his courses and see his grades and other relevant information. This is a medium to a large project that will take considerable time to do everything in it. So try to choose what areas you want to develop no need to do all areas.

Student/Teachers/Parents Registration
Course Management
Course Registration
Exams
Grade Book
Certificates
Attendence

3. Medical Clinic

An app for a medical clinic to help it organize its work and manage its different aspects so it works well.

Patient Management
Appointments
Stock
Payments and Billing

4. Company HR

An app to help manage the employees and their attendance and different aspects.

Attendance
Salaries
Contact Info
Documents

5. Stock Management

An app to help an inventory manager manage the stock. It will provide him with the tools need to add and remove inventory.

Inventory Management
Stock Transactions

We hope you enjoyed this post, please Heart it and follow us.

If you a new software developer, join our free course to help you get started
https://landing.advancedsoftware.io/software-developer-guide

Software Development 101: Source Control

advancedsoftwareofficial — Sun, 06 Dec 2020 17:28:30 +0000

[Note: This post does not include any affiliates link, just a free course link at the bottom]

As a software developer, one of the things that you need to deal with on a daily basis is Source Control. Source Control is the tool that if you are not using you are wasting your time and not deliver high-quality products.

What Is Source Control?

In short words: A tool that you use to keep track of your code versions. Your code will always change and grow, and it will never be the same as you start. To maintain your code and even to share your code with others you use Source Control.

Source Control is a powerful tool that will help you get ahead. You will be able to manage the program and the code features via it. Also, for example, if you are in a large team and you want to share your code with others they will be able to see your code and use it and even modify it. The best thing, you will be able to go back to older versions of your code. So if by accident remove something you can retrieve it from Source Control.

How Important is Source Control?

Very Very important, if you are not using it you are reinviting the wheel like a lot. Also, it is for free and would not cost you or your team anything.

Git

One of the most popular and well-known Source Control out there. And I use it for each project I create. You can Download the client from here. The client will help you setup a local repository and use it. But, a better option is to check out online sites such as GitHub, BitBucket and Azure DevOps

TFS

It is a well known Source Control and is used mostly with .NET applications and also you can use it with other languages. It has most of what Git offers but it has tighter control over files.

Git Demo

It is very easy to create a repository that contains your code in Git and put it online either as a public or private repo to share an open-source project or to collaborate with others. We will use VS Code. Make sure Git is installed on your machine.

Open VS Code and open the command palette. Select 'Git: Initialize Repository' command and select a folder that you want to use as the repo folder.

After that, add any file to the workspace. Notice that the file is colored in Green to show you that it has been add/changed.

After that, go to the Source Extension and click on the Tik sign above to commit your changes. You will need to input a message just as a description of your work. After that, you will be able to add and edit the file while having different versions from it.

We hope you enjoyed this post, please Heart it and follow us.

If you a new software developer, join our free course to help you get started
https://landing.advancedsoftware.io/software-developer-guide

Top Programming Languages In Demand

advancedsoftwareofficial — Sun, 29 Nov 2020 17:56:00 +0000

[Note: This post does not include any affiliates link, just a free course link at the bottom]
So, you decide to become a software developer. Join the club!

To start, you need to know a programming language that you can use to build apps and software. We already did a post about how you can learn a programming language, you can see it from here:

How To Learn A Programming Language

advancedsoftwareofficial ・ Nov 24 '20

#codenewbie #beginners

Now, you need to choose a programming language but still which one to learn? We will give you this guide based on Stack Overflow Developer Survey.

JavaScript

I don't hate it but personally, I wish it had much better standards. But, still, you will use it one way or another. You will face it anytime so start early. But, still, you need to know a backend language that can support you as it alone will not go further.

Python

This language is a hot topic right now since it has many applications in programming, data science, ML, AI, and more! It is very worthy to learn and have decent standards. You will love the fact that it does not end each statement with a semicolon.

Java

Can be used in different ways with amazing tools and a large community. But, things going to take time to reach as a pro developer in this language. Also, sometimes difficult to learn but still with time it will get easier.

C

Easy to learn and has a wide range of applications. I saw the community grow and it now has a great toolset. You can use it to build websites, mobile apps, cloud applications, ML, IoT, and more. I've been developing in C# for the past 8 years and it keeps growing and growing each year.

TypeScript

This is the new JavaScript. Still, it lacks behind from other languages but ahead from JavaScript. It is JavaScript with many rules and way better to use. Still, you need to know JavaScript to fully understand TypeScript. And it is used in many popular frameworks around the world.

PHP

It is up to you if you want to be just dedicated to web technologies you can learn PHP. For me, I like to have options where I can develop mobile apps and other things using the same language. Still, it powers many leading platforms online such as Facebook and the leading CMS WordPress.

C++

This language is one of the reasons we have programming advanced and changed. It is considered the grandfather of all the languages and was ahead of its time. And still, it keeps going and has many usages in different areas such as games, databases. But, it can be difficult to learn and use.

Go

This language is getting popular each day. It can be used to develop backend programs with high performance. It can be used as C++. It is developed by Google.

Swift

If you are into developing iOS apps this is your tool. You will need an Official Apple Device such as Macbook Pro to use the Xcode IDE to use this language. It has a fair demand and it is fun and easy to learn. I recommend learning another language with it as Typescript.

There are many languages available for you as well beyond this list but make sure there is a good market for it and you can secure a job in the case who you are working for closes or layoff.

We hope you enjoyed this post, please Heart it and follow us.

If you a new software developer, join our free course to help you get started
https://landing.advancedsoftware.io/software-developer-guide

How To Learn A Programming Language

advancedsoftwareofficial — Tue, 24 Nov 2020 18:02:24 +0000

[Note: This post does not include any affiliates link, just a free course link at the bottom]
For a new Software Engineer, they need to learn a lot of things and for sure they need to take a look at a certain programming language and learn how to use it effectively and correctly.

Some people learn by seeing a YouTube tutorial, others may be going to a conference or reading a book. There is nothing wrong with any of these but you want to be able to take advantage of all the language features which can make your life easier and write better software.

So, how we learn a Programming Language?

Poke through the documentation

This is the best way to see what the language has. I know the documentation is boring sometimes and not that exciting. But, it is the best place to know all the language functions and capabilities.
There is no better place than this no matter how the documentation looks like.

Practice by project

I recommend this after reading the entire documentation. For sure it will be hard at the start, but later on, you will pick up the pace and become much better at it.

Read book

I know, you are wondering where is the YouTube and Udemy courses in the list. Well, we want you to be professional in this language as you might use it for several years. Books in my opinion are the best source, it takes the documentation and applies it to real-world cases.

Talk to fellow developers

I used to think that I have to do everything myself. You don't need to, just go to LinkedIn and look for fellow developers who have been using the same language and ask them what resources they used and if they can help you. I guarantee you almost everyone you contact will help you as simple as that.

Online Courses and YouTube

Not because they are bad I list them at the end. But, they usually touch the surface of language capabilities. They can give you a good start, but it will not go deep as the other sources. Many times you might have questions and you will not find someone to answer them. Still, not a bad way to learn.

We hope you enjoyed this post, please Heart it and follow us.

If you a new software developer, join our free course to help you get started
https://landing.advancedsoftware.io/software-developer-guide

5 Tips For New Software Developers

advancedsoftwareofficial ・ Nov 18 ・ 2 min read

#codenewbie

5 Tips For New Software Developers

advancedsoftwareofficial — Wed, 18 Nov 2020 19:13:22 +0000

So, you decided to join the Force of Software Developers where you will able to create apps websites, and more! Welcome to the club, but before you start I have five things I want to let you know about it so you can have fun and grow.

1. A new JavaScript Framework pops up every day

JS is the most hated and loved language of all time. I don't think it is bad but some points with it make it a little bit difficult to handle.
No issue my friend, you don't need to know and use all these frameworks. Find a well known one such as Angular or Vue and master it. Don't ride the hype train it will make no difference.

2. Software Development Is a collaborative work

It's not only about writing code, you can write code alone but you can't create a program alone. It is the collaborative efforts between you and the Project Manager, Product Owner, QA, and more.

Work with your team to get the software up and running. You can't and will never be able to do it alone.

3. Self Learning

No one will show you what to read and learn. You need to keep yourself up to date no matter what. Don't see other people who just are passing by and not doing what is needed. Keep yourself updated it will pay off in the future.

4. Work until it is done

Sometimes you will go through times where you have a task that will take extra time. You can leave at 5 pm and leave the task incomplete. But, it will be reflected on you and how people see you. Commit to finish or trust me it will be against you.

5. Build your online profile

If one thing I wish to change, I want to create more content online. I want to have my own personal blog and brand. It will never be taken away from me. Also, a collection of GitHub Repos where I can show off my coding skills.

Hope you find this material useful. Please check out our developer guide course for new software developers

https://landing.advancedsoftware.io/software-developer-guide