Reading and writing always come together. Thus, after presenting the way to read from a file, now it is time to be able to write: Writing in PHP is not a challenge, the only tricky part is to…
Category: Just Tricks
All the other languages.
PHP – Reading from a file into a HTML table
As I have already mentioned in a previous article here, lately PHP has attracted my attention. Thus, today I will show how to build a small HTML table from a txt file, using each line in the file as a…
SQL Server – Solution of the first part of the SoftUni Exam for SQL Server
Just a day ago I have participated at an exam, organized from SoftUni for SQL server. The exam can be found here and the questions for it are here. In the current article I will present my answers from the first part…
SQL Server – Create two tables with primary and foreign key with SQL code
There is a simple way in VBA and in Python to create tables in the database you need, giving the tables a name of a variable and the type of a variable. In SQL Server, we also have a way…
SQL Server – Get data below the avarage; Difference between Left and Right Join Explained
I have started to explain tricks with SQL Server in a series of articles about a week or two ago. Today I will use a database, mentioned in a previous article. Get data below average The task is to get top…
SQL Server – Conditional Query And Multiple Tables Join (Many to Many Query)
As I have already started some time ago with SQL Server, in this article I will present the way to write a if-else case in sql query. The database is available here, I have used a sample DB for one…
SQL Server – Simple Transaction in SQL Server
So, after starting with SQL Server custom views, SQL Server Triggers, SQL Server Procedures and Functions, now it is time to pay some attention to SQL Transaction as well. What are transactions? Microsoft says the following: A transaction is a single…
SQL Server – Procedures and Functions in SQL
So, continuing from yesterday with the SQL Server subject, it is time to introduce some nice ways of writing functions and procedures in SQL. What is the idea, behind the functions and the procedures in SQL? Pretty much, I would…
SQL Server – create trigger to log changes in DB
About 6 months ago I wrote about the way to create a log sheet in Excel with VBA. Nowadays, as far as I am doing a small upgrade from MS Excel to MS SQL Server 🙂 , I was interested…
SQL Server – Create Custom View in Microsoft SQL Server Management Studio
Speaking about SQL, I have noted something really interesting in MS SQL Server Management Studio, which would probably be of use in MS Access as well. This is the saved custom view. It is not present in MS Access, but…
SQL Server – Generate data in Microsoft SQL Server Management Studio
The legend says that when the chess was invented, the inventor was asked to pick a price from the local king. Thus, he asked for one grain for the first cell of the chess board, 2 for the second, 4…
SQL Server – How to generate sql script from a db
If you are interested in DB development, then most probably you have tried to generate a sql script from your database. In this article I will show you how to do it with Microsoft SQL Server Management Studio. So, lets…
Linux – Install MonoDevelop for Ubuntu and Mint
This is probably the shortest article I have written. After some time trying to install an environment for C# in my Mint and my Ubuntu systems, I found out the following: the name of the environment is MonoDevelop. the installation…
Ubuntu – Setup jQuery project with node.js and server from scratch
Yup! That is what we are gonna do – Setup jQuery project with node.js and server from scratch in Ubuntu. There are plenty of ways to do it in the internet. Setting up a jQuery project is something, that should be…
JavaScript – Make Custom Functions with Prototype
In the current article, I will show you how to build functions for built-in objects in JavaScript. The way I know is using a prototype. Thus, I will create functions, giving us the last n values of an array or returning a capitalization…
Node JS – Manipulation with files and JSON
JSON is somehow powerful. With Node JS and JSON you may build almost anything you can think of (if you have unlimited time and coffee/beer). How about building a small console application with the following options: Yesterday, I started to…
Tagged with: add to json, get json, JSON, json in table, json load from file, json save file, json search, node js, update json in node js
Ubuntu – A few useful terminal commands
In the current article, I will present a few useful commands, for the Linux(Ubuntu) terminal. The article is going to be updated constatly with new entries:) Here they come: General Python Related Java Script and Git related
Simple Excel – Usage of column names for formulas
In the current article, I show why it is convenient to use the Format as Table option in Excel. Pretty much, it enables a new feature – you may refer to the cells in it not by an address, but with the…
Excel – Usage of Checkmark with formulas and custom formatting
Plenty of times, when I open some someones Excel files I see something as a check column, where you have only “YES” and “No” as values. They check something and if you are used to it, it can be quite…
Java Script -Build a Table – Exam Problems
On 27. July I have participated in an exam organized by the SoftUni for Java Script. This time, I managed to get 220 points out of 400, which ranked me in 58th place out of 204 participants for the day and…
Java Script -Reveal Triangles – Exam
As I have mentioned in the previous post, I have participated in a Java Script competition from the SoftUni, where I made it to the top 31% of the competition 🙂 (not something to be extremely proud of, but considering…
Java – Exam – Congate Words
Some time ago, to be more honest last Sunday, I participated at some Java exam again. The results were not something to boast, quite on the contrary, but I did not have a lot of time to prepare 🙂 The…
Java – Exam – Couples Frequency
In the last java articles I have solved (or commented) the exam problems, given at the Java exam at the SoftUni. I have started with the easiest tasks (in my opinion) and I have gradually came to the toughest ones.…
Java – Exam – Pythagorean Numbers
In this article, I will comment the original solution for the Pythagorean numbers problem from the SoftUni Java contest. You have the following input – first a number N, telling you how many numbers you would have. Then you simply…
Java – Exam – Longest Odd-Even Sequence – Challenge!
As you probably know, for a long time (about 5 weeks) I started to learn Java from scratch. Today, I have decided to take a look at one of the exam problems at the Software University and I have spent some…
Java – Exam – Three largest Numbers
This trivial task was given at the SoftUni exam for Java. There are not a lot of problems that I can solve, but this one was definitely one of them 🙂 So, what is the input and what is the output? At…
Java – Exam Problem – Largest 3 Rectangles + Some Eclipse Shortcuts
As you have probably noticed, this is probably my 5th or article, concerning Java Exam problems from the SoftUni. Today, I will take a deeper look into a problem, which is supposed to calculate the best sum of triangles. The…
Java – Exam Problem – Beers Count
After a week or so, I have started to master Java, as a part of the courses at the SoftUni. Today, I tried to resolve one of the problems, given about 3 weeks ago at the exam – CountBeers. The…
Java – Exam Problem – Simple Expression
Last Sunday I was taking part in Basic Java Exam at the SoftUni. I managed to get 130 points (out of 400) and thus to be somewhere in top 50% of the participants. I had 100 points at this problem,…
Java – Exam Problem – Video Length
As I have already mentioned in this article, I have had a small fiasco at the Java Exam of the SoftUni. Anyway, I managed to pass the exam, so actually if I manage to graduate in my certificate Java would…
Top