Tag Archives: sql

How to export data from a .bak file to Excel

bak_to_excelWere you ever faced with the situation in which you had to extract and export data from a .bak file to Excel (.xls, .xlsx or .csv format).

Surely if you have arrived here you are facing this problem and looking for a solution. Well, you have come to the right place. In the article below we will show you how you can achieve this.

Continue reading How to export data from a .bak file to Excel

Learn SQL #4: How to write a SQL query (1)

sql querySo, in our previous articles we introduced you to what is SQL, for what it is used, how it stores data in database and tables , and how it is works through commands (SQL query), and how the commands are different based on what SQL type you use.
Now that we have the overview, we are going to dive into writing our first SQL command, which in technical terms is called a query, as you might already know.
Continue reading Learn SQL #4: How to write a SQL query (1)

Learn SQL #3 : SQL Commands

SQL Commands Now that we know how SQL works in a database system, it is now time to learn what  sql commands (code) we need to write for specific operations.
As we said in our previous post, SQL gives you complete power over your data. But what does this mean exactly? We have many types of commands which allow you to do different operations with your data.
Continue reading Learn SQL #3 : SQL Commands