SQL course #9: Creating a program – .com

The time has come: In today’s class we are going to create a mini customer management program (from scratch) with everything we have learned. Here we go!

9.1 – Insert clients to the database

Indeed, in these two classes we are going to create a program from scratch. Specifically, it will be a client management program in a database. It will be very simple, but it will help us to review, and also to motivate us, because we will see a practical use that we can give to what we have learned in the course.

So let’s start at the beginning. We are going to see how to create the basic interface, and we will see how to add clients to our database.

Great right? You have already seen that it is not as difficult as it seems. It is true that at some point it may seem complicated, but if you review the video little by little, you will see that there is no secret. A little complex, but nothing difficult 🙂

And now that we have it ready, and we know how to add clients through our management software, we are going to make lists of them.

9.2 – Show the clients of the database

Now that we have added several clients to our database through the form that we have created, we are going to list them all. Attention, because our software is beginning to take shape!

You see it! Not bad at all, right? We already have the most basic of our program. We can create and list clients. It’s great! Who would have told you before starting the course that you could achieve something like this? I will always remember the first programs I did, and how good it felt to see the result.

See also  Social media course #10. Audience Insight - .com

So now you know. Today’s homework, of course, is:

  • Create a form to introduce clients to our database
  • introduce a few
  • You create a function that lists the customers from our database
  • Create a text box to filter customers based on various parameters

We are sure that you will be able to do it without problems, but in the event that you get stuck, you already know: Contact form on the Intranet, and Luis will be delighted to assist you.

See you in the next class, in which we will finish our first SQL program. Until then… Very good morning! 🙂

Remember that if you will have access to everybody the courses and you can also enjoy everything from .

All chapters in this course:

Loading Facebook Comments ...
Loading Disqus Comments ...