Cargo Surabaya | Ekspedisi Vendor Langsung

Hello guys, if you are interested in learning SQL with MySQL database and looking for some awesome resources e.g. books, tutorials, and online courses then you have come to the right place. In past, I have shared some useful books and tutorials and in this article, I am going to talk about some of the best MySQL online courses from Udemy and Pluralsight which you can join to learn SQL and MySQL from the comfort of your office or home. In last couple of years, you might have heard the statement that everybody should learn to code , which is great. Coding is now like reading, writing and speaking skill and in today's Information technology-centric world it is must-have and there is no better way to start coding than learning SQL, the most popular programming language. SQL is the language to talk to the database, to get your answers and insights from the database and you would be surprised to know that it's more popular than programming languages like Python and Java. It's sur...

Here is my list of some of the most usefulMySQL commands which I have used in my day to day life while working with MySQL database in Linux. This comes straight from my notes so you may not find a lot of documentaries around it but they all are very useful. If you need to know more about any command you can always drop a note or look into resources I have shared at the end of this article. If you need a course to start learning MySQL from scratch, I recommendThe Ultimate MySQL Bootcamp on Udemy, one of the most comprehensive courses on MySQL for beginners. You can also buy in just $10 which is very cost-effective to learn a useful skill like MySQL. 1. For Checking Wheather MySQL Server is running on Linux or not ------------------------------------------------------------- $ ps -auxwww | grep mysql If it returns any row then MySQL server is running otherwise no. You can also check the output to verify its actually the MySQL server itself and not any other script which has MySQL in its ...

The Select command in SQL is one of the most powerful and heavily used commands. This is I guess the first command anyone learn in SQL even before CREATE which is used to create a table in SQL. SELECT is used in SQL to fetch records from database tables and you can do a lot many things using Select. For example, you can select all records, you can select few records based on the condition specified in WHERE clause, select all columns using the wild card (*) or only selecting a few columns by explicitly declaring them in a query. In this SELECT SQL command tutoria l, we will see some examples of select command or Select Statement and will write SQL queries to demonstrate the result. We will use the following table and data for our SQL query examples, one table represent Stocks listed in various market and another table contains Details of market e.g. Country. MySQL is my favorite RDBMS and great for learning purpose you can download MySQL and start working on it. My suggestion is to...

Truncate and delete in SQL are two commands which are used to remove or delete data from a table. Though quite basic in nature both SQL commands can create a lot of trouble until you are familiar with details before using it. The difference between Truncate and delete are not just important to understand perspective but also a very popular SQL interview topic which in my opinion a definite worthy topic. What makes them tricky is the amount of data. Since most Electronic trading system stores, large amounts of transactional data, and some even maintain historical data, a good understanding of delete and the truncate command is required to effectively work in that environment. I have still seen people firing delete commands just to empty a table with millions of records which eventually lock the whole table for doing anything and take ages to complete or Simply blew log segment or hang the machine. Most of the enterprise stock trading system maintains two kinds of database one transa...