Learn SQL Database : ERD, Basic of SQL Table and Little Example of MySQL Function

    Have you ever wonder, what is database table for? Or have you ever wonder how the customer service like Telkomsel CS, can save people's data?

     First thing first, learn what is usually Customer Service does in the office, especially for telecommunication or networking things. If we understand what they do, then we can continue and design their workflow into an Entity Relation Diagram (ERD) like in this...

      From this ERD, we can now create a database containing each entity. Let's name the database as "customer_service" like this...

     Then after the database, we need tables for the 3 entities in the ERD, which are Customer, Customer Service, and the office. So let's create these 3 tables with the name "customer", "customer_service", and "telkomsel_office" like this...

     Now let's take some samples for the customer and who will be the customer service, then insert those samples to these SQL-Tables. For me, I already sampled some of my friend's data for customer members and myself for the customer service, it looks like this...

     Now these all we need! Now, do you know what is SQL functions? No? Okay, take it easy... I will show you a little bit of it because literally, it's so many. I only remember some of them HAHA. But, if you are curious, pay a visit to this page, it's very useful!

     But for now, let's continue! We want to try some MySQL functions right? First... CONCAT_WS() function. It is used to join two or more Strings or expressions with separators like "-", "&", etc. Second, it will be LCASE() function. Used to lowercase all the capital letters. Third, LENGTH() function. As the name of it, it is used to measures the length of the String. Fourth... UCASE() function. Just like the name of it, it is used to uppercase all the capital letters. And the last is  SUM(). Used as adders for numbers and decimals.

    Okay, now let's try CONCAT_WS first... For example, we want to join the CustomerName and CustomerAddress with a separator " from " like this...

     Now the second function, LCASE() to lowercases the CustomerName, let's try it! It should be like this...

     Third, let's try the LENGTH() function, one of the most powerful functions for me in MySQL. Let's give it a try with my name in CustomerServiceName, It should be something like this...

    It's all easy right? Now for the fourth! UCASE() function... Let's try by uppercasing all the CustomerAddress now!

     Now for the last function, we will use SUM() to add all the CustomerID as Sum_of_ID, wanna try it? Okay, let's do it!

     That's it for the basic of SQL and MySQL functions tutorial, if you have any questions regarding this material, feel free to ask in the comment section below. Thank you :)

My First Page in Telkom University

     Welcome to my blog. I am Prasidya Pramadresana Saftari, or just... Andre Saftari for short. I'm a new D3 Software Engineering student at Telkom University. Now, it is my second week as a student at Telkom University and here, I have many things to tell. This is my story...

    Everything's began from SNMPTN when I applied as an applicant for Computer Engineering of University Indonesia. I was to be one of many students at SMAN 87 Jakarta qualified as an SNMPTN applicant, but unfortunately... it is not my luck, I was rejected from my choices. I also rejected from SBMPTN when I chose Universitas Padjadjaran. On mid-July, 2019 I moved to Bandung to live a new life after my father passed away. Actually it's difficult to leave every memory that ever happened in Jakarta and to leave my friends and bestfriends in Jakarta. But, whatever the cost... This is the path I chose to live.

    In that time, I signed for Telkom University as D3 Software Engineering student and also, for Bandung State Polytechnic as D4 Informatics student. I always believe that "Pain is temporary. Pride is forever" isn't just a quote. Time through times changed and my struggle was paid. I was one of a few people accepted as D3 Software Engineering at Telkom University.

    Here, at Telkom University, my new story begins. Start from registration, I met my 3 roommates from Dormitory 5 of Telkom University room 112, my first new buddies in this Campus. Then from PKKMB 2019 or Campus Student Orientation, there... "Regu 17" created for the very first time and we made a great team those days, but we should continue a different way now. I also have my own path to do, like them.

     And now, I am part of D3 Software Engineering Student Community, like the others. Now, my mission is to finish what I've started, to be a programmer and IoT maker and to be what I have to be, to continue what my father had started, created, researched and published. This is the end of my story, for now.