Learnit Training
« Back to all themes

SQL training courses

If your goal is to master specific SQL technology, Learnit can help you. Below you will find an overview of our SQL training courses. You can follow our SQL courses throughout the country; classroom-based via open registration, in-company or private.

link]

Applying successfully

Applying for a job, an exciting process for many! In times of crisis, partly due to the coronavirus, jobs are not easy to come by and it is important that you, as a candidate, can distinguish yourself from the others.

In this blog we will give you 10 tips that you can apply to increase your chances of getting a job!

1. It all starts when you read and search for vacancies. Apply specifically and take a good look at the job requirements in the vacancy. Do they match your skills?

2. Always apply with a CV and motivation. Limit your CV to 2 A4's and write down both soft skills and hard skills. Soft skills are qualities in the area of cooperation, Agile working and time management. Hard skills are more focused on computer skills, such as Excel and Office.

3. Potential employers do not always look at your CV and motivation, but often also at other channels. Think of your Linkedin Profile or social media. Pay attention to what you put online.

4. "What should I wear to a job interview?"; you only get one chance to make a first impression, so make sure you look presentable, and if in doubt: better 'overdressed' than 'underdressed'.

5. Prepare thoroughly, but go into the interview relaxed, as if it were a friendly competition. This will make you more receptive and flexible, which will improve the contact and the chance of a click.

6. Be on time. Preferably a little early. This not only makes a punctual impression, it also gives you the opportunity to get used to the new environment.

7. Always introduce yourself nicely and preferably shake hands firmly (not in the 1.5m society of course). Always look at the person talking to you, but don't stare.

8. Answer the questions that are asked and don't beat around the bush. If you don't have an answer immediately, you can say that you will think about the question and come back to it at the end of the interview.

9. Also think about what substantive questions you want to ask; you will not only be judged on the answers you give, but also on the questions you ask. This will show to what extent you have studied the company.

10. Never speak negatively about previous employers or organisations. This can create a wrong impression and you never know which contacts your potential employer has. Finally, you have been invited for an interview so the potential employer already thinks you are a suitable candidate. Stay yourself and take your time!

More self-confidence in your application process? Take a look at the Self-confidence course of Learnit!

link]

SQL: the programming language that continues to grow in popularity

Are you interested in IT? Then you may have seen the term Structured Query Language (SQL) before. After more than 40 years, SQL is still one of the most popular programming languages. Especially when you are just starting out in the IT world, the use of SQL is a godsend. SQL can best be described as a language that enables you to extract desired information from a database. But why is SQL so popular? After reading this blog, you will know why SQL is used by many people in the IT world!

How does SQL work?

Nowadays, many companies collect data and from this data companies can then filter the desired data. But how exactly do you obtain this data? For this, you need a programming language such as SQL. SQL can be seen as a language for communicating with your own (relational) database. By means of various commands, you are able to filter, modify or delete data from a database. For example, do you only want to retrieve the data of men from your database? With the command 'WHERE' you can retrieve these data. Do you want to sort the data in your database according to surnames? Then the command 'ORDER BY' is useful!

Webinar and training on SQL

Learnit offers the possibility to watch a short introduction webinar SQL, in which a number of important 'commands' are discussed and explained. Are you interested in learning this programming language? Check out our YouTube channel for our free webinar SQL! In addition, we also offer the possibility to follow a SQL Basis course at various training locations. Are you interested in our two-day SQL Basis course? Then click Here. Are you already familiar with SQL and do you wish to learn more about this programming language? Then our course SQL Continued course is just what you are looking for!

SQL in practice

These are three practical examples where SQL can come in handy if you work in the IT world:

  • SQL can be used to retain or delete certain data. Think, for example, of saving the data of someone who creates an account in your webshop. Isn't it convenient to keep this data?
  • By using SQL, you can combine data from different tables with a simple command. This is much faster than manually combining the data.
  • In addition, you can easily modify existing data in your database using SQL. Suppose, for example, that a customer wants to change his address. In such a case, it can be useful for your own administration to also change this address in your database.
link]

Top 10 most popular programming languages

At the end of last year, a list of the most popular programming languages of 2020 was announced. Not entirely surprisingly, as ultimate favourite, C was still on top of TIOBE's index. This year, Python did manage to surprise us: for the first time in history, Python overtook Java and we find Python on place 2 and Java on place 3 in the top 10. Besides Python, also R, Perl and Go are gaining popularity. R even ended surprisingly on place 9 in the top 10 list; TIOBE has therefore labelled R as 'programming language of the year 2020'.

Why is Python gaining popularity?

The CEO of TIOBE's INDEX Paul Jansen said about Python catching up with Java: "Some time ago I had a flat tire and called the road patrol to help me out. The mechanic asked about my living and when I used the word 'software' in my answer, he smiled and started talking very enthusiastically about his own passion: programming in Python. From that moment on, I knew Python would become ubiquitous." Whereas ten years ago it was mainly software engineers who were concerned with the various programming languages, nowadays you see that more and more people on the shop floor have programming skills. This has everything to do with the fact that there is a shortage of classical programmers. Moreover, a programming language such as Python is relatively easy to use when you want to work with large quantities of data. Would you like to work with data yourself, but do you have little or no knowledge of a programming language? Then take a look at our courses Python programming basics or Python for data analysis. Do you already have a fair knowledge of Python? Then the course Python programming continuation course is really something for you!

Why is 'R' gaining popularity?

Big data is a term that most people undoubtedly hear more than once. Programmes such as R are perfect for converting these so-called big data into useful information for organisations, and R is also a lot easier to use than a language such as 'C'. For example, did you know that R is one of the programming languages that was used to find a COVID-19 vaccine? In addition, you can see that universities and colleges are increasingly exchanging static programmes such as Stata, SAS and SPSS for static programming languages such as R. Professional groups in which many static analyses occur are also increasingly using R. Think for example of data analysts, mathematicians, econometricians but also marketers. The advantage of a programme like R is that it costs nothing: it is an 'open source' project, which anyone can use and improve. In addition, R is known for the fact that you can easily visualise data with packages such as 'ggplot2', with which you can make a graph, for example.

link]

The differences between SQL and Excel

Many people use Excel for (relatively simple) data analyses. When you want to perform more complicated analyses in Excel, you run into a number of problems. You can easily make a mistake which is difficult to trace and Excel is very slow when you are working with large data sets. Moreover, it is also difficult to reproduce a previously used analysis, because it takes some effort to trace which steps were taken earlier. You can easily avoid these problems by making smart use of the SQL programming language. Are you thinking of switching from Excel to SQL? Then it is important to take into account the following differences and properties!

  • SQL is a programming language, Excel is a program. Before you switch from Excel to SQL, it is useful to realise that SQL is a programming language and that its use is therefore different from Excel. When you want to use Excel, you click on the green icon on your computer. In SQL, however, this works somewhat differently. When you want to use SQL, you must first choose a database program, which can then communicate with SQL. Examples are MySQL or Oracle. Do you want to learn how to apply SQL in such databases? Then take a look at our training MySQL basics or Oracle Database: SQL Fundamentals Part I.
  • Data is stored in a database versus the data is stored on your computer. Another important difference between SQL and Excel is where you store your data. If you want to use data in Excel, it is important that your data (file) is stored on your own computer. In other words, you have the data you want to use at hand. This is slightly more complicated in the case of SQL. In SQL, you write and send so-called 'queries' to a database. This database then provides you with the information you ask for in your queries. Next, the data is stored in a database and organised in tables. A major advantage of this is that it is easy to find out which data you are requesting.
  • What is SQL best used for versus what is Excel best used for? SQL is best used when dealing with large data sets. Moreover, you can easily use SQL in different databases. Perhaps the most important advantage of SQL is that you can easily find errors and correct them where necessary. This makes your data analyses much more reliable. Excel has its own strengths. For example, it is possible to enter data manually, which makes the programme reasonably flexible. In addition, the programme is able to perform spell-checks, for example, which enables you to detect errors in names or columns easily. The most important advantage of working with Excel compared to SQL is the visualisation possibilities of the programme. Tables, graphs, pie charts, it is all possible in Excel.

SQL training courses

Did you know that Learnit offers various training courses in SQL? During our training SQL Basics you learn how to easily retrieve relevant data from your database. In the training SQL Advanced not only the basic concepts within SQL are dealt with, but we also play with deeper SQL commands, in the form of T(ransact)-SQL. In addition, we also offer a training SQL Report Builder training. SQL Report Builder offers various visualisation possibilities, allowing you to create a professional report from your data. Ideal, for example, if you want to make a management report! Click on the orange buttons below for more information about one of the SQL trainings mentioned or click here for the complete overview of SQL training courses from Learnit.

link]

Zoom: How do you deal with privacy sensitivity?

Last year, many people will have experienced how important video calling has become. Various tools, such as Microsoft Teams or Google Meet, have suddenly become an essential means of communication. One of the biggest players in video calling in the workplace in the Netherlands is Zoom. The company was discredited in March for possibly sharing user data with Facebook, and it would have been easy for intruders to infiltrate a meeting just like that. After adjustments to their system and security, however, this problem is in the past, and since March Zoom has only become more popular in the Netherlands. In this blog, we will explain exactly what Zoom does to protect your data, but also what you can do to ensure the safety of your data.

How does Zoom ensure that they can guarantee privacy and security?

You can read important elements in Zoom's privacy statement here:

  • Zoom is Privacy Shield- and SOC2 type II-certified, which can be seen as a good privacy standard for a US company.
  • Zoom does not sell user data to third parties. The company only shares user data with Google Analytics and Google Ads, provided that you give your consent for advertising cookies on their website.
  • Zoom ensures that messages that users send to each other are encrypted, so that third parties are unable to read these conversations.
  • Zoom is currently working on end-to-end encryption, which can be seen as an extra security key that no external party (not even Zoom) can infiltrate in a meeting. The host of the meeting has the option to turn this feature on.

What can you do as an organisation or employee to guarantee privacy and security before, during or after a Zoom call?

As an organisation or employee, it is of course always wise to think about the security of important data and the privacy sensitivity that video calls entail. Some tips to make your own data more secure can be found here:

1. Make sure you receive notifications when you are invited to a Zoom meeting. It can happen that you suddenly appear in a Zoom meeting without realising it. As you can understand, this can lead to uncomfortable situations. Make sure that Zoom always sends you a notification before you join a meeting. You can do this by checking the box in your settings that says 'Always show video preview dialog when joining a video meeting'.

2. Make sure you have really left a meeting. It sometimes happens that a video meeting is ended without people checking whether their sound or screen is no longer connected to Zoom. We probably don't need to explain that you could accidentally share unwanted information with others. You can prevent this by checking the following box: 'Ask me to confirm when I leave a meeting'.

3. Turn off your recording setting. Zoom has a recording option that allows people to record a video of themselves. When you share privacy-sensitive information with others, it's a good idea to make sure you've at least set your own recording settings so that no recordings are made of you. In Zoom's default settings, the 'record video during sharing' is automatically on, so turn it off yourself.

4. As a 'host', be aware of your responsibility. If you are the host of a meeting, it is important to realise that if you record a meeting or save certain information from a chat, you must share this with the other users. Even as a host, it is not allowed to make recordings or save data, if this has not been discussed or recorded with the other Zoom users in a meeting. Make sure that you are responsible and accountable for this, and not Zoom.

5. Prevent other users from saving conversations. As a host, you have the option of preventing other participants from saving conversations. If you want to prevent this, you should check the option 'prevent participants from saving chats' in your settings.

Would you like to know more about Zoom and how you can best use it in the workplace? Then take a look at our training course 'Zoom: organising online meetings'. In these 2 sessions of 3 hours each, you will learn all about how to get the most out of Zoom, as well as how to protect data during a Zoom meeting. Click here for more information about the training.

link]

Tips for an online job interview

Applying for a new job often brings a lot of tension with it. Things like "Which outfit should I wear?" or "Do I have the right skills for this job?" can run through your head. In the year 2020, we can add another 'worry'. How do you ensure that your job application is successful when it takes place online? Read below what you can do to steer an online job interview in the right direction and towards your desired outcome.

1. Wear an appropriate outfit. Now that we often sit at home, you might opt for a comfortable outfit. However, if you want to make a good first impression, it is important to wear a suitable outfit for an online job application as well. It is also important that you sit up straight and are clearly visible in the picture.

2. Pay attention to your background. Always check in advance whether your background is visible when you are going to video call. Your children's toys on your background may not look very professional.

3. Avoid being late because of technical problems. It is obvious that being late for a physical job interview does not leave a good first impression. The same goes for online job interviews. So always check well in advance that your wifi, sound and camera are working. This way you avoid stress just before your interview starts.

4. Check where the camera of your laptop is. During a physical conversation, it is easy to look at the person you are talking to. In an online conversation, this works a little differently. Therefore, always check where the camera of your laptop is or how you have adjusted your webcam. If you look straight into the camera, the person you are having the conversation with at least has the idea that you are actually looking at him or her.

5. Avoid noise in the background. If you conduct the job interview from home, it is possible that your interviewer will pick up on background noise. During a job interview you would of course prefer to avoid this. Therefore, try to find a room where you can have your interview without being disturbed, with the door closed. In addition, it can sometimes help to 'unmute' yourself if you are not speaking for a while, so that you do not hear any background noise.

6. Ask questions. An online job interview is often shorter and more static than a 'real life' interview. Therefore, do not forget to ask questions. An employer will appreciate assertiveness and this will prevent your interview from ending in no time. If you ask questions, this often leads to further discussion. This is an opportunity to show more of yourself.

Did you know that Learnit offers an interactive webinar 'Making Conversations Go Your Way'? During this 3-hour webinar, you have the opportunity to learn all about techniques that ensure that a conversation runs exactly as you would like it to, including a job interview! Click here to find out more about this webinar or to register now.

link]

Don't let your training budget go to waste!

2020 has been a year of adjustment for all of us, both in our personal lives and in the workplace. Working in an office was suddenly no longer possible due to COVID-19 and working from home became the new norm for many people. Despite rapid adjustments by both employers and employees to keep on working, some developments on the shop floor will have been put on hold this year. Think, for example, of courses, training or education of employees.

Did you know that many organisations set aside a certain training budget for their employees each year? This is in fact laid down in many collective labour agreements. Now, it is completely understandable that both you and your employer have not paid much attention to your personal development this year due to all the hectic activity surrounding COVID-19. This makes it all the more important for you to think about how you can further develop yourself in the workplace. Have you always wanted to improve your communication skills? Or could you use a boost in your Excel skills? Then now is the time to do some quick research and find a training or course that suits your learning goals. If you do this now, you won't have to cut next year's budget!

Read below 3 tips to get the most out of your training budget:

1. Consult with colleagues. Talk to colleagues beforehand about skills that are important for your departments. Maybe you have no idea what you want to develop, but there are certain points of interest that could help your departments. For example, is there no one in your departments who knows how to use Power BI? Maybe this is a great opportunity for you! Click here to view Learnit's course overview and get inspired.

2. Group training. In addition to training that focuses solely on your individual skills, group training can also be of great value to both employer and employees. Think for example of an intervision training where departments get to know each other better and where they strive for better communication and personal growth of all employees with the help of a competent discussion leader. For more information about intervision training, click here.

3. Further training for 2021. Did you know that your training budget for this year will be lost if you do not use it on time? This would of course be a shame! A possible solution is to already register for a training or course, so that it can still be invoiced to your organisation this year. However, it can also be the case that you have not yet decided which training course is best suited to your wishes or needs. In this case, a strippenkaart from Learnit can offer a solution. With the Learnit strippenkaart your organisation can flexibly purchase training days at a fixed rate. Click here for more information about the Learnit strippenkaart.

Learnit strippenkaart action weeks

To encourage personal growth and support companies in this hectic period, Learnit introduces the annual budget discount weeks. Until the end of the year we offer a 10% discount on the Learnit Strippenkaarten. This allows Learnit to offer the following strippenkaarten at a reduced rate:

  • The red strippenkaart: With this strippenkaart you can buy both Office and basic webdesign training days.
  • The blue strippenkaart: With this strippenkaart you can purchase communication and management training.

Both strippenkaarten are available in the variants: 10 days, 20 days or 50 days. Whereby 1 strip equals 1 training day. In short: a strippenkaart gives you and your colleagues the opportunity to follow a training of their choice for a whole year, without having to deal with price increases in the interim and without having to look specifically at training courses in advance. Ideal for employees who have not yet decided what training they want to take, but who still have a training budget! Would you rather first discuss the possibilities or find out which training courses from our range exactly fall within the 'strippenkaarten'? Then contact us by calling + 31 20 6369179 or click Here.

link]

Big data - 5 common questions

Big data is a term that seems to be appearing more and more frequently in the business world. Multinationals and larger companies, in particular, seem to be using big data a lot. But when exactly do we talk about big data? And can big data also be meaningful for your business? In this blog, we will address 5 common questions about big data.

1. What is big data?

We speak of big data when the data meets three different conditions: it is data that is generated in large quantities (Volume), at a high speed (Velocity) and the data must be diverse (Variety). In other words, the data must satisfy the three Rs. In case you are wondering what a 'large' volume of data is: we are talking about data volumes expressed in exabytes. This means that if we are talking about 1 exabyte, we are talking about the number 1 with 18 zeros.

2. Where does big data come from?

Big data can be generated from various channels. This includes data from social media channels, transactional data from the business world, but also, for example, data from machines. In short, big data is everywhere. You can actually see it as a collection of information.

3. What is the difference between structured and unstructured data?

When we talk about data, we can distinguish between two different types of data. Structured data is data that is easy to work with, data that already has some kind of structure: think of a company's customer database. This often contains data such as name, age and gender, neatly sorted into different columns. However, we are often dealing with unstructured data. Think, for example, of social media data such as a Twitter or Facebook message. This data is much more difficult to analyse because there is no standard format for such data, there is no fixed structure in a Facebook message.

4. Is big data only used by 'big' companies?

Big data is as big as your business. Relatively large companies will obviously have a larger data flow and therefore need more data tools than smaller companies. This does not mean that collecting (big) data is not useful for smaller companies. Why you should start collecting big data today? There are many reasons for collecting data, but the most important ones are to optimise your company's profitability and customer satisfaction. We probably don't need to explain that such things are important for every business.

5. How can I work with (big) data myself?

Although people are working more and more with data and there are more and more data (visualisation) tools available, it remains difficult to work with data yourself if you are not yet at home in the IT world. It can therefore be useful to start with a course. Learnit offers various courses to help you understand the possibilities of big data or to teach you how to work with data. Take a look at our courses Big data, Google Analytics Basics or SQL Basics.

link]

Work at home, learn at home, have time for yourself!

The corona crisis has a major impact on the way we work. Many people work at home and this, in combination with children and the household, is quite a task. But, because many things are closed, you also have more time left to work on: yourself!

Learnit offers various E-learnings, in which you can develop yourself at your own pace. Take for example an E-learning from Microsoft. For following this training you receive official Microsoft study and exercise material. You will receive the e-book that serves as a reference book for the practical execution of assignments in an online learning environment. You will have access to this learning environment for six months. You do not need any software, only a computer with an internet connection. In the labs, you work through scenarios in which you can immediately apply what you have learned in practice. A practice exam allows you to prepare well for the corresponding Microsoft exam. This practice exam can also be taken online. It consists of questions similar to those you can expect on the actual exam and provides detailed explanations of both correct and incorrect answers. The training course is in English and can be completed in approximately 3 days.

The Microsoft E-learnings are technical training courses in which you acquire hard knowledge. Do you prefer a more communicative E-learning?

View all E-learnings via this link.

Advantages of E-learning:

  • Everything you need is in the package (book, practice test, optional exam)
  • Organise your own time, just from home.
  • You can upload the obtained certificate on Linkedin.
  • Now is the time to work on yourself, at your own pace!

In addition to the E-learnings, Learnit also offers free mini training courses. Are you a beginner in Excel? are you assertive, or perhaps you want to practice negotiating?

View all free mini training courses via this link and get an idea of our methodology.

link]

Internet of Things

More and more devices are becoming connected to each other and to the internet. Just think of the 'smart' thermostat in your house, the alarm clock in your bedroom or perhaps your Google Home speaker. Research has shown that by 2020, more than 26 billion devices will be connected to the internet. The connections between all these devices is called the 'Internet of Things'.

What is the Internet of Things?

In short, the Internet of Things consists of all devices connected to the Internet. These devices are able to communicate with the Internet and with each other, and they can send data into the cloud without human intervention. This automation saves costs and reduces the physical effort required of people. This sounds fantastic, of course, but on the other hand, people are also criticising the Internet of Things. Some people are afraid that technology will eventually take over the world, and others point out the possible problems with privacy.

Benefits of the Internet of Things

The Internet of Things has several advantages, here are the three most important ones:

    Time-saving. First of all, it saves a lot of time that devices can communicate automatically with each other and the internet without human intervention. An example of this is a smart thermostat; it can tell you via an app exactly what your energy consumption is and how you can save on it. When a human being has to give this feedback to you, you can imagine that it takes more time and effort.
  • Cost-saving. Human activity is reduced through the use of devices that are constantly connected to the Internet and to each other. This means that certain jobs will not be needed, or will be needed less, which in turn will save companies and individuals money.
  • Convenience. Many smart devices can be controlled remotely these days. Think of a video doorbell, where you can remotely see who is at your front door. Not only are you able to see immediately who is at your front door using the app, you can also communicate directly with someone at your door. Smart devices therefore increase the ease of use.

Disadvantages of the Internet of Things

Besides the many advantages that the Internet of Things offers, there are also a number of objections:

    Everything revolves around technology. Technology is indispensable nowadays, the question is when will the world have enough technology? Many people wonder whether it is good that so much of life revolves around technology and whether it would not be wiser to return to simpler times. Aren't we becoming too dependent on technology and therefore less sharp? In addition, this new technology is also causing jobs to disappear, as much of the work can be taken over by technology.
  • Hackers. Smart devices are increasing data traffic, making it more and more interesting for hackers to hack into devices. Especially data sent over free wireless networks (wifi) is easy to intercept.
  • Privacy is at risk. When hackers have intercepted data, it can be at the expense of your privacy. Imagine that you remotely switch on and off the lights of your house during a holiday by means of an app that is connected to lamps in your house. When a hacker realises that you do this by using an app instead of physically turning on the lights, he or she knows exactly when you are or are not at home. As you can imagine, this is valuable information for burglars.

Using the Internet of Things for your own organisation?

The Internet of Things offers many opportunities for organisations, but also a number of challenges. To ensure that your organisation can make a flying start by deploying the Internet of Things, Learnit offers a training 'Internet of Things'. During this 2-day training you learn all about the terminology and application possibilities, but also about the security surrounding the Internet of Things. Click here for more information about the training.

link]

Incompany training: the many advantages!

An in-company or group training is a tailor-made training that is given within your own organisation. All our training courses can be provided in-company and if necessary, the training can also be organised at a Learnit location. We have listed the advantages of an in-company training for you!

Made-to-measure

The main advantage is that all aspects of the training content can be tailored to the learning objectives and expectations of the employees and the organisation. This makes it possible to reflect your company philosophy in the training. A tailor-made programme is developed. Multiple training sessions could possibly be combined. Because we find it important to have a good click with the trainer, we plan an (telephone or Skype) intake with the contact person of the training. By means of this intake, prior to the training, we jointly determine which subjects will be emphasised, whereby it is possible that we still add or adjust subjects. During the training you can also use your own practical examples as input. In this way, we ensure that the training will be a perfect fit.

Costs

In order to guarantee the quality of the training, we recommend a maximum group size of eight participants. As soon as there are more participants, the training will become more affordable. If you register more than eight participants, we recommend dividing them into several groups. This way, there will be sufficient individual attention for each participant, making it easier to achieve personal learning goals. Because the training is given at your company or organisation, Learnit does not need to rent space and an in-company training can be offered at a lower rate than an open registration.

Plans

The final advantage of an in-company training is that you are not dependent on our training dates. Training dates are set in consultation and based on the availability of our trainer. In general, our training times are from 10:00 to 17:00. If you have other wishes, please let us know. Your schedule is central. The number of days of training is also not fixed, this can be adjusted according to your learning goals. It does not matter where the company is located, Learnit trains throughout the Netherlands. This makes a difference, as your employees will spend less time travelling.

Curious about the possibilities for your organisation? Please feel free to contact us or request a no-obligation quote!

link]

You can learn to program!

Visit any job site and you will see it immediately: there is an unprecedented demand for programmers. If you are looking for a well-paid job with excellent future prospects, then learning to program is a must. Even for jobs where you do not program yourself, a programming language is an excellent addition to your CV. However, there are countless programming languages, so where is the best place to start? And which languages are interesting for the future? We made an overview of the 10 most important programming languages. Languages in which you can also receive training immediately: let those jobs come!

Java

Java was the most popular programming language for employers for many years. Although it has recently been surpassed by SQL, it is still very popular. Java is the standard for many enterprise software, is used by more than 9 million developers and is used to control more than 7 billion (!) devices worldwide. The programming language owes its popularity mainly to the simplicity and readability of the code, which makes it a good starting point for beginning programmers. Also, one of Java's basic principles is compatibility, which ensures that older applications continue to work.

SQL

You will find SQL everywhere. Database technologies such as MySQL, PostgreSQL and MicrosoftSQL keep banks, universities, hospitals, small and large companies up and running. It is no exaggeration to say that every computer and person with access to technology has come into contact with SQL in one way or another. For example, iOS and Android devices have access to SQLite, an SQL database, and there are countless mobile applications that use SQL directly.

C

C dates back to the early 1970s, when it was developed as a generic programming language. As one of the oldest programming languages in existence, C provides the building blocks for other popular languages such as C++, Java, Javascript and Python. C itself is mainly used for operating systems and industrial applications.

C++

C is an object-oriented programming language based on C. Since the language was developed in the 1980s, it has been used to develop Adobe and Microsoft applications, MongoDB databases and large parts of Mac OS/X operating system. It is considered by many to be the best programming language to learn for applications where performance is of great importance, such as games or audio/video editing.

iOS / Objective C / Swift

Until 2014, Objective C was the programming language used by the Apple operating system. It plays a role in Apple's OS X, iOS and its APIs. For a long time it was the language in which you as a programmer had to write iPhone applications, until Apple came up with its own programming language a few years ago: Swift. Swift is very similar in many ways to C++ and its predecessor Objective C, but is a little easier to learn for most programmers.

Javascript

Javascript - not to be confused with Java - is widely used to add interactivity to websites and is supported by all major internet browsers. Not only can it be used for simple functionality such as pop-ups or simple games, it also forms the basis for Node.js - a server technology widely used in real-time communication.

PHP

PHP was actually never intended to be a programming language. Danish-Canadian programmer Rasmus Lerdorf developed PHP in 1994 as a set of tools that enabled him to manage his personal website (Personal HomePage). Today, the meaning of the abbreviation has changed to Hypertest Pre-Processor and the language is used on servers to generate HTML websites dynamically. PHP is easy to learn, but has many advanced features that are of great value to experienced programmers.

HTML / CSS

HTML forms the basis for web pages. The programming language does this by basically laying down a structure that can be extended or adapted by other languages. For example, Javascript can be used to add advanced interactivity and CSS influences the presentation, formatting and layout of web pages. Although PHP can generate HTML from a server, knowledge of HTML and CSS is an absolute must for web developers.

Python

Python is a server-side programming language for websites and mobile applications. It is a relatively easy language to learn, thanks to the readability and conciseness of the code. In Python, it is often possible to express a concept in fewer lines than in many other languages. Python is used in applications such as Instagram and Pinterest in the form of the Django web framework. Google, Yahoo! and NASA all use Python.

Ruby

Ruby is - like Python - a programming language that is very user-friendly for beginning programmers. At the same time, the object-oriented language is very dynamic and therefore popular for developing websites and mobile apps. It is the basis of the Ruby on Rails framework used by Groupon, Shopify, Scribd and GitHub.

Complete the list!

Of course, there are many more programming languages. We have listed just a few of the most popular ones for you. Do you have any additions? Are you missing a language that you use really often? Share your knowledge and experience with us!

Want to learn a programming language?

Do you want to learn a (different) programming language? Then quickly discover our workshops and courses. Under the guidance of an experienced trainer, you will learn the basics of programming in an efficient manner. Are you a bit further on? Then it is possible to register for an advanced training. You will then go deeper into the subject matter. Such a training course is not only fun, but it is also closely linked to practice. That way, you know for sure that you can put your new knowledge and skills into practice immediately!

link]

Taming Dragons: 4 tips to make dragons of SQL queries easier

Dragons may not exist, but I do come across dragons of queries far too often. Complex-looking codes that at first glance you would rather not fight with.

We give you four tips to make sure your queries don't turn into dragons:

1 | Friendly-looking dragons

With a bit of friendly formatting, dragons look a lot less imposing. But what does a friendly query look like?

  1. Spread the query over several lines. It is no problem if the query becomes long. Clarity prevails over brevity of your query.
  2. All 'SQL words' such as SELECT, FROM, WHERE, etc. in capitals. Also, functions such as ROUND, SUM etc. are easiest to recognise when capitalised.
  3. Jump in so that it becomes clear and the query aligns neatly.

Fortunately, there are (online) tools that can do this automatically for you. Here you enter a dragon and the tool returns a much friendlier looking query. For example: http://www.dpriver.com/pp/sqlformat.htm

2 | Documentation

The formulation of more complicated queries involves some puzzle work. Which steps have been taken is not directly reflected in the query. For this reason, they should be included in a piece of documentation. Documentation does not have to be an extensive book, but can be added directly in the SQL. Start your comments with -- and they will be ignored when executed. Above each query you make, state what it does and of course where the pitfalls are. Pay special attention to sub-queries; they often add extra complexity that needs explanation.

3 | Calling a spade a spade

Table names can be long and cryptic. To avoid typing them all the time, you can use a single-letter alias. Instead, an alias can also be a short name or abbreviation. Again, clarity prevails over brevity in your query!

4 | Divide and rule

Sometimes it can be useful to cut the problem into several pieces. For example, when combining/joining many tables and filtering the desired data. Views can be a perfect intermediate step.

Do you want to learn how to use aliases, create sub-queries, joins and views? Then follow our SQL Basis training!

link]

To write or not to write

Why? Because of that!

Who is not guilty of this? You are writing a text or an article for study or work and you can't think of the right spelling. What about Dutch spelling and grammar! Then you look up the correct spelling on Google, or at least you hope so! On the other hand, when it comes to mastering a foreign language, the Dutch score pretty well. Compared to other non-English speakers, the English language holds no secrets for us.

Teaching language

A fun way to share your own language knowledge is to become a language volunteer. However, when explaining the Dutch language to non-Dutch speakers, you are also confronted with the many challenges and exceptions to the rule that the Dutch language is rich in, such as with article words, sounds, vowels and consonants. And sometimes the only explanation that remains is "because that's the way it is", because just like life itself, language is not always logical. And there is nothing wrong with that.

Language lives

Language has come into being by (continuing) to develop. Every hundred to a thousand years, a language develops along with a country and its culture. But also under the influence of political policy; for example, is there money and attention for multilingual education? And sometimes something surprising happens in the field of language. For example, in 2016, the Frisian dialect officially established itself on the map, an Ameland dictionary (Amelander Woa'deboek) was published and, over the past 500 years, the importance of language has been increasingly linked to written language.

Language changes, language shifts

Whereas Latin is a dead language, the Dutch language is a living language. A language is living when it is someone's mother tongue. Another characteristic of a living language is that new words are added to it, sometimes from another language or from spoken language. And although it may seem a contradiction, reading books is on the rise again and spoken language is increasingly supplanting our written language.

What are you saying?

We live in a time where we read in a cursory manner (scanning headlines) and we take in much of our information via vlogs and animations. And there is definitely a good side to this development, from writing to spoken language. As a result, long and technical sentences with a complicated writing structure (as in this sentence) are gradually being replaced by more visual sentences. Street language, therefore, language that immediately makes clear what someone wants to say.

Update your language skills!

And that is a good thing, but since it is not yet standard to write the way you hear it and the way you talk to each other in the street, it is certainly useful to keep your knowledge up to date for the time being. For example with a course or free webinar from Learnit Training.

link]

Distraction and concentration

Being distracted is a choice

You probably recognise the following situation all too well at work: You are busy with a certain activity that needs all your attention and your phone or an e-mail takes you away from your concentration. Annoying. And the time you need to concentrate again may vary from person to person, but in the end it turns out that if you can continue working without being distracted, you finish much faster. What is the reason that we are so easily distracted and is it not in our own control? From this point of view, we would venture the theory that being distracted is a choice.

Concentration requires attention.

There is a difference between the work and the concentration you need to do it. Writing a report with financial influences requires more concentration than a memo about cleaning up the coffee cups, to give just one example. It is therefore good if you can label the work that requires concentration. By classifying the tasks, you gain insight into how high the concentration must be and how annoying it is to be distracted by that particular task.

Concentration requires action

When you know what concentration is needed to do your work efficiently, you will also understand that concentration requires action. Sometimes it may be necessary to literally isolate yourself by sitting apart. Sometimes it is enough to turn off your phone and your e-mail program. But what always applies is that you have to take action yourself in order to achieve this. Now, you may think that not being available or not immediately responding to an e-mail does not come across as customer-friendly, but nothing could be further from the truth. If you take the time to answer the phone or read your e-mail at a fixed time, you will also have the time to concentrate on your work.

Concentration and time saving

You often hear that the time you have is too short to do all the work you want to do or are asked to do. It is precisely by using your concentration in the right way that you save time. You are less distracted, you function more pleasantly and if you take the time to work with a good plan and to manage your time correctly, you will see that choosing to concentrate and to alternate your work with other tasks will increase your productivity far more than if you allow yourself to be disturbed.

The choice to be distracted is therefore in your own hands. The question is: what are you going to do now? link]

Self-confidence and self-image

By self-image we mean the image you have of yourself; the way you judge yourself or the way you see yourself. This image is partly formed by the information you receive from others about yourself. After all, they also look at you, interact with you and form an image of you. They let you know how they think about you or give their opinion about your behaviour. The image that you have of yourself does not always correspond to the image that others have of you. This can sometimes make you insecure. And the way you see yourself determines to a large extent which positive or negative feelings you harbour towards yourself.

It is not uncommon for people to have a false image of themselves. When the image you have of yourself largely corresponds to the image others have of you, it shows that you mostly show yourself as you are or want to be. Is there a difference between the image you have of yourself and the image others have of you? This does not necessarily mean that you do not know yourself well or that others do not know you. You show different sides of yourself in different situations with different people.

Being insecure about yourself, how you come across to others or about your position in a certain situation is quite normal. But this insecurity can also go too far. A lack of self-confidence quickly leads to a negative spiral: you no longer dare to take on challenges, you lower your standards less and less, which in turn leads to a deterioration in your self-image. In this way, it becomes increasingly difficult to escape from this vicious circle.

To help you with this, we have developed a two-day self-confidence training course. The training teaches you to recognise the causes of your lack of self-confidence and highlights the importance of verbal and non-verbal communication in relation to your self-image. In addition, the training uses realistic role-plays from real life. Mutual feedback and video analysis ensure that old behaviour patterns are broken. During the training we work with the following topics, among others:

  • Working on a realistic self-image
  • Your own qualities and capabilities
  • The importance of verbal and non-verbal communication in relation to self-image
  • A positive mental attitude (creating and holding)
  • Recognising the causes of loss of self-confidence
  • Breathing and relaxation exercises
  • Setting realistic goals
  • Fears and challenges
  • Labelling of negative and positive labels
  • Assertiveness: standing up for your own interests
  • Dealing with negativity and criticism

Would you like to know more about our approach and the training possibilities? Then take a look at our training page or contact one of our advisors via info@learnit.nl or 020 6369179.

link]

Want to organise a webinar yourself?

Perhaps you have been thinking about organising a webinar for your employees, stakeholders or other contacts. However, a busy schedule prevents you from actually doing so. Or you have heard of the term 'webinar' but do not really know what the phenomenon entails let alone what new possibilities it could offer your organisation. Discover what a webinar can mean for you.

Help in organising webinars

If you want to organise a webinar, we can assist you in all aspects. Whether it is expert advice on how to set up a webinar and how to carefully tailor it to a specific target group, or the provision of our professional studio equipped with all the necessary advanced equipment: we are happy to assist you!

The technology

By organising your webinar with us, you can make use of our webinar studio and the expertise of our expertise of our staff. We arrange all the technical facilities that are involved in the organisation and implementation of a webinar. Would you rather organise a webinar at your own location? That is no problem either! With our mobile studio we can travel to any desired location.

The presentation

Because every webinar is different, it is also possible to organise a webinar in different settings. For example, you can be the presenter alone in front of the camera, but you can also be supported by a host or moderator or organise the webinar in the form of an interview. It is also possible to show the viewers what you are doing on your screen for example.

Taking care of the webinar yourself

If you want to master all aspects of organising a webinar yourself, then our two-day training Webinar Organising is for you. The training covers all the technical aspects of setting up a webinar. We will also look at the presentation of a webinar and the associated interaction and communication with an online audience.

Want to know more about this training? Then ask for an offer without engagement. You can also request more information about organising your own webinar by sending an email to info@yourwebinar.nl or calling 020 6369178.

link]

Which SQL training is right for me?

If you want to retrieve data from a relational database in a simple manner, you can use the query language SQL(Structured Query Language). In addition, SQL allows you to modify, manipulate and adapt table structures.

Are you about to use relational databases, or do you already use them but want to gain more in-depth knowledge of SQL? Then you can follow one of our SQL training courses. Below, we briefly explain the differences between the courses.

SQL Basics

Our two-day basic training is suitable for both beginning database users as well as functional administrators and data analysts. This training teaches you the basics of SQL and how to easily create queries to retrieve data from a database. This includes querying, sorting, filtering, summarising, modifying and grouping data, but also working with sub-queries and combining queries.

SQL Report Builder

This two-day course is suitable for users who want to create their own reports with Microsoft SQL Report Builder/Reporting Services. During this training you will learn to work with the software at your own pace, so that you are able to quickly and easily extract complex reports from large databases. You will learn how to obtain data and how to design and create reports.

Transact-SQL Basis - MS SQL Server

Our two-day Transact training is suitable for users of an MS SQL Server database and participants who will be working as application administrators. The training covers the basics of Transact SQL with a focus on using an MS SQL Server database and using SQL Server Management Studio.

SQL Basics - Oracle

The two-day Oracle training course is intended for users of an Oracle database and participants who are going to work as application administrators. The course covers the basics of SQL, focusing on the use of an Oracle database and the use of SQL Developer.

In addition to the basic SQL Oracle training, we also have several in-depth Oracle Database training courses on offer. Click here to view the full Oracle offering.

Need advice?

Please contact us via info@learnit.nl or 020 6369179 to discuss your learning goals with one of our training advisors. We will be happy to discuss your learning objectives and advise you on the best training course for you.

link]

Get a grip on your mailbox with 3 handy tips

Do you spend a lot of time searching for emails? Ideally, your inbox, or digital workspace, should be as empty as possible. In this blog we will give you three handy tips, using the settings in Gmail as an example:

Tip 1: Use 3 main labels

Almost all e-mail programmes give you the opportunity to personalise your inbox. By processing incoming e-mails in a structured way, you can keep a good overview. How often do you have to search endlessly through your inbox to find that one e-mail? Use 3 main tags: what you need to do, what you need to reply to and what you have completed. In Gmail, set this up as follows:

  1. Go to the gear icon and select "settings".
  2. Go to the "Labels" tab and click on "Create new label".
  3. Set the labels, for example: 01 | To do, 02 | Waiting for answer and 03 | Finished
  4. If you want to distinguish between your folders at a glance, you can give colour to the labels. You do this by hovering your mouse over the label (on the left-hand side of your inbox) and selecting the colour. For example, give the colour red to what you still have to do (to do), yellow to things in progress (waiting for answer) and green to tasks that are finished (finished).

The image below shows an example of what your "to do" folder might look like:

Tip 2: Use sub-labels

By creating 3 main labels at tip 1, you have already worked with labels, but you can expand this by creating additional labels for your various activities. Think for example of customer contact, promotional matters or work meetings. You set up the labels in the same way as in tip 1. These labels can also be given a colour.

In the image below you can see an example of how your label "customers" could look like. You can also see the status at a glance, because in tip 1 you already created three folders for your incoming e-mails:

Tip 3: Put yourself in the BCC with requests

You know the situation: you send an e-mail to someone with a request or question, but have not (yet) found a good way to keep track of whether you have received a response. This can result in the fact that it sometimes occurs to you too late that you still need to know something from someone.

You can prevent this by putting yourself in the BCC of e-mails in which you are waiting for a response from someone else. You can set up a filter in Gmail that sends all e-mail that comes from your e-mail address and where you have put yourself in the BCC, directly to the folder 02 | Waiting for reply created in tip 1:

  1. Go to the gear icon and select "settings".
  2. Go to the 'Filters and blocked addresses' tab and click 'Create new filter'.
  3. Enter your own e-mail address under "from" and "to" and click on "Create filter with this search".
  4. Select "Skip Inbox" and select "Apply Label". Choose (for example) the label "02|Waiting for reply" and click "Create filter". All messages you have sent with questions or requests will now be in this folder. Once you have a response you can move the email to, say, "03|Finished".

In our two-day Time Management training, you learn to manage your time efficiently and go home a lot less stressed at the end of the day. You will not only learn practical tips like those in this blog, but you will also learn to reflect on your own thinking and actions. Did you know, for example, that assertiveness and delegation skills also play a major role? Discover it in our training!

link]

SQL: the must-learn for database users

SQL, we can no longer ignore it. The Structured Query Language now forms the heart of all relational databases. SQL provides a standard interface to databases such as Oracle, Access, SQL Server and other relational databases. SQL is therefore an absolute must-learn for potential database users.

Why SQL?

SQL is a uniform language that can be used to perform tasks such as querying and modifying data in relational databases. SQL can be used with almost every modern relational database product.

The standard language SQL has its roots in relational algebra and was originally developed by IBM. Its ambition was to allow business managers to use SQL to effectively analyse complex business data. The main advantages of SQL are as follows:

  • With SQL, you can make every conceivable query possible. The results of the queries can be used for reporting purposes.
  • The standard language SQL works independently of specific databases. Therefore, the SQL knowledge gained can also be applied to other environments such as Oracle or Access.
  • Advanced, in-database analytics at no extra cost. Customers can make better decisions with SQL, thanks to its easy-to-use analytics tools that seamlessly combine external data, enterprise data and even unstructured big data.
  • SQL provides consistently positive user experiences, both on-premises and in the cloud. This is made possible through the use of shared management and development tools.
  • Innovations are integrated as standard. Think of in-memory, security, HA, mobile BI & advanced analytics. This makes it unnecessary for customers to purchase expensive add-ons.

How does SQL work?

SQL is divided into three parts, which together provide access to information:

  1. Data Manipulation Language (DML): a collection of computer languages to extract, delete, add or modify data from a database. The DML is used by computer programs or database users.
  2. Data Control Language (DCL): a computer language that users use to control access to a relational database.
  3. Data Definition Language (DDL): A computer language that defines data. A DDL is formed, for example, by part of the SQL commands.

SQL works with advanced queries. A so-called query is a string of characters that is sent to the database management system as a query. This database management system (DBMS) processes the query and sends the requested data back to the program that issued the query.

SQL Basics training

Are you interested in learning this programming language? Then take a look at our two-day SQL Basis course and learn all the important ins and outs of SQL, such as:

  • the basic principles;
  • Retrieve, sort, modify and filter data;
  • Working with (sub)queries;
  • create, modify and delete tables, and;
  • The differences in SQL between database systems.

link]

Roadmap for de-escalating aggression

When dealing with aggressive people, it is important to know that aggression provokes aggression. Sometimes a certain way of looking, saying something or a certain attitude can already provoke aggression. Interest can be interpreted as meddling ("Hey, what are you looking at? Is something on your mind?"), while this is not at all the intention. It is important to pay attention to your own way of communicating, because your behaviour can be the straw that breaks the camel's back.

Non-verbal and verbal communication play an important role in dealing with aggressive people. Of course, there is a big difference between someone who is just angry and, say, a mugger. Sometimes it is good to let someone rage, sometimes to show understanding and sometimes to run away as fast as possible. Every situation requires good judgment. To help you on your way, we share below a rough roadmap for dealing with different forms of aggression:

1. Approach the other person with an open mind

Aggression is often a reaction to a person or a situation. When you are confronted with an aggressive person, your first reaction is often to react aggressively. However, it is better to remain calm and adopt an open attitude towards the other person. If you react aggressively, the other person will become even more angry and aggressive, with all its consequences.

2. Let the other person express their anger by listening

It is best to 'go along' a bit with what the aggressive person has to say. If he can tell his story, he will become calmer. He feels heard and understood. Sometimes the simple phrase: "I can see that you are angry" helps.

3. Summarising and asking questions

Make an assessment of what kind of aggression you are dealing with to determine the continuation of the conversation:

In case of emotional aggression/frustration aggression:

Emotional aggression often stems from an accumulation of frustrations. Take the problem seriously and let the other person express his or her anger. In case of emotional aggression, do the following:

4. Showing understanding

Not for the aggressive behaviour, but for the situation. In the eyes of an aggressive person, he or she has been wronged. Do not argue with them, but show understanding. Someone who feels understood will make less of a fuss.

5. Providing information

Explain why the situation is as it is. Tell calmly what is going on and ask for understanding.

6. Providing a solution

Try to find a solution together or by yourself, or if possible an alternative. Offer a solution and link this to concrete agreements, as far as you are able to. If you are not the one who can or may agree on things, get the person who can to do so.

7. Positive conclusion

The best thing is if you can end the conversation in a positive way. A friendly word or a cup of coffee works wonders. Always end on a positive note. And watch out for sarcasm. Unfortunately, it will not always be possible to make the other person leave on a positive note. But make sure you end the conversation on a positive note.

In case of instrumental / targeted aggression:

In instrumental aggression, people use aggression intentionally. They demand something and because they think that they will not get it done otherwise, they have the idea in advance to get it done through aggression. This is why you have to draw the line earlier. If necessary, you can do so quite soon after step 1.

4. Setting limits

Border control is very important when dealing with aggression. This is necessary in order to be able to be able to react properly as a professional. For example, say (in a friendly manner) that you would like to listen and talk, but not if they behave like this.

5. Offer solution/choice

Show the angry person the choices that are available. In the waiting room of the emergency room: "You can choose: You sit down and they will help you right away. Or you don't sit down, but then I will call the security guard now."

6. Close

If the solutions provided are not sufficient, clearly indicate that there is no other option than to cooperate or to stop. Be very clear about this.

Follow training

At the very least, aggression becomes more manageable and causes less harm when you have more tools at your disposal to recognise violent behaviour early on, to de-escalate it and to get a clear picture of your own behaviour in the situation. These skills are, with the help of professional actors, fully developed and rediscovered in the various Coping with Aggression training programmes that we offer. Click here to go to the general aggression training page and find the training that suits you best. link]

10 good reasons to use WordPress

According to a recent estimate, WordPress is now used by more than a quarter of all websites, tens of millions in total. And not only hobbyists use this CMS (content management system), but also big names, including news websites such as those of the New York Times, Fortune and NRC. Why is that? In this blog we will give you 10 good reasons to start using WordPress too.

1. Ease of use

If you do not want to make things too complicated, WordPress hardly needs to be more than a Microsoft Word-like interface. Basically, users require practically no programming knowledge at all. That is exactly what this Content Management System is meant for: the user controls the content, WordPress takes care of the rest.

2. It is open source

The WordPress programming code is freely available and anyone can tinker with it. And so they do, for free and 24/7. This not only ensures a high-quality and always up-to-date system, but also means that you have complete freedom to customise it. You can customise (or have customised) absolutely everything.

3. The community

Because WordPress is used so frequently, almost every conceivable challenge has been encountered before. Most of the problems that new users encounter are therefore already solved online. And if that is not the case, the lively and generous WordPress community is often able to provide it quickly and free of charge, for example through the official forums.

4. Themes

WordPress is installed using so-called themes, which determine how your website will look - both at the back and in terms of the actual web design. There are thousands of themes available that allow you to design a website in a professional manner. Many users therefore no longer need a web designer at all.

5. Plugins

WordPress installations can be expanded with small programs called plugins. There is a plugin for almost every functionality these days. And the community is doing its job here too: there is an extensive rating system with which you can easily assess whether a plugin is good or not.

6. Reliable

WordPress is now more than ten years old, and many thousands of experienced programmers have worked on the project to improve it. This means that WordPress is far beyond the teething stage.

7. SEO-friendly

With a few simple adjustments - via a plugin or otherwise - WordPress is very SEO-friendly. Not only users, but also search engines love this CMS.

8. Safe

A common misconception is that WordPress is unsafe. That is because it is often attacked. But that is only the case because it has so many users: attackers simply go for maximum yield, and focusing on the largest system is a logical step. Users who carefully observe the basic security measures prescribed, such as regularly performing updates, are rarely affected.

9. Scalable and powerful

WordPress is often seen as a system for small users. However, this is completely unjustified. Some of the largest websites in the world use WordPress, with perhaps the most telling example being Wordpress.com, the service that offers a hosted version. Although no WordPress installation can cope with such an amount of internet traffic, in principle the system can. So WordPress can grow with you.

10. It is popular

The bigger WordPress becomes, the better. This is because it is open source, but also because more and more users are able to help each other. It certainly does not apply to every system, but in the case of WordPress, popularity really is an advantage.

Do you want to work under the guidance of a trainer? Then sign up for our WordPress training or request a no-obligation quote.

link]

Export SQL database to CSV

PHP allows you to easily present information from your database to your visitors in a CSV file. CSV (Comma Separated Values) is a simple format where all values are separated by a comma. It can be opened with Excel, for example, after which you can use it for data analysis or to create graphs.

We are going to write a PHP script here that retrieves results from our database and puts them in a CSV file. In our case, the results of course exams.

The first step is to retrieve the data from the database. For this, we use PDO(5 reasons for using PDO with SQL databases).

$db_user = 'learnit';
$db_pass = 'geheim';
$db_name = 'uitslagen';
$db_host = 'localhost';

try {
    $db = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8", 
                  $db_user, 
                  $db_pass, 
                  // Als een error optreed moet PDO een exception gooien
                  array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
	$query = "SELECT id, naam, email, resultaat FROM Uitslagen";
	$pds = $db->query($query); 
} catch(PDOException $ex) {
    echo "An Error occured: " . $ex->getMessage(); 
	exit();
}	

We use a try-catch here to catch exceptions that may occur with a connection problem. The result of the query is a PDOStatement Object. We can retrieve the records from here, but first we need to make some preparations:

header('Content-Type: text/csv' );
header('Content-Disposition: attachment; filename="results.csv");

With the help of the header function we modify the HTTP header. We want the visitor to be able to download the file directly. We do this by specifying in the header that it is a CSV file and that it is called "results.csv".

Now that we have opened the standard output, we can start writing the CSV file itself:

$fp = fopen('php://output', 'w');
fputs($fp, chr(0xEF) . chr(0xBB) . chr(0xBF));

In the CSV file we want to use the UTF-8 encoding. To ensure that Excel recognises that this is a UTF-8 encoding, the CSV file must start with 0xEF,0xBB,0xBF.

Now we can add the first line to the CSV file. This contains the headings of the data:

fputs($fp, "id, name, email, result");

The ►C1 at the end of the string indicates a line break. If we did not add it, subsequent data would be pasted behind instead of on a new line. Please note that this only works in strings with double quotes.

We repeat the following loop as long as records can be fetched. This puts the data into the CSV file.


while($uitslag = $pds->fetch(PDO::FETCH_ASSOC)) {
	fputcsv ($fp, $uitslag, ','); 
}

When writing to the file, we are helped by the fputcsv() function. It writes the array to the CSV file. The third argument of this function is the separator. Instead of the comma (,), we could also use another separator, such as the semicolon (;). To finish off, we close the file:

fclose($fp);

The entire script:

 PDO::ERRMODE_EXCEPTION)
                  );
	$query = "SELECT id, naam, email, resultaat FROM Uitslagen";
	$pds = $db->query($query); 
} catch(PDOException $ex) {
   	echo "An Error occured: " . $ex->getMessage(); 
	exit();
}	

header('Content-Type: text/csv' );
header('Content-Disposition: attachment; filename="uitslagen.csv"');

$fp = fopen('php://output', 'w');	
fputs($fp, chr(0xEF) . chr(0xBB) . chr(0xBF) );
fputs($fp, "id, naam, email, resultaat\r\n");
while($uitslag = $pds->fetch(PDO::FETCH_ASSOC)) {
	fputcsv ($fp, $uitslag, ','); 
}
fclose($fp);
?>

SQL Basics training

Are you interested in learning this programming language? Discover with an SQL training course data that previously remained hidden for you. In our two-day SQL Basis training, you will learn all the important ins and outs of SQL!

link]

SQL - tips for the WHERE command!

When selecting data from a database, you often need to create a filter. Here are 5 tips to avoid common mistakes when filtering with WHERE.

You can also try out all the examples yourself here at sqlfiddle.com with the Results database.

Tip 1

If you filter on text, it should be enclosed in single quotes. But of course it can happen that the text you are looking for contains a quote itself. You can escape this by typing two quotes instead of one. The quote that is escaped is then no longer seen as an ending, but as part of the text. The query to find all students from 's-Gravenhage looks like this:

SELECT *
FROM Results
WHERE city = ''s-Gravenhage'';

Tip 2

It remains inconvenient that the comma is not used as a decimal sign everywhere in the world. This sometimes causes confusion for us Dutchmen. In the ANSI standard for SQL, the American number notation has been chosen. In queries, decimals must therefore ALWAYS be entered with a dot.

SELECT *
FROM Results
WHERE result >= 8.5

Do not be confused if you see a comma in the result, the comma has a completely different meaning in a query.

Tip 3

It is possible to combine several filter conditions, for example by using both a AND as a OR to be used:

SELECT *
FROM Results
WHERE city = 'Amsterdam' OR place = ''s-Gravenhage 
        AND result >= 8.5

There is a catch: conditions are not combined from left to right. The AND operator binds more strongly than the OR. Our example query results in:

  • All students from Amsterdam;
  • All students from 's-Gravenhage with a result of at least 8.5.

However, that was not what we had in mind; we only wanted to see the students from The Hague and Amsterdam who score at least 8.5. We now also see students from Amsterdam who score less than an 8.5. Fortunately, this is easily solved by using brackets:

SELECT *
FROM Results
WHERE (location = 'Amsterdam' OR location = ''s-Gravenhage') 
        AND result >= 8.5

Tip 4

Displaying all students with a grade in the range 8.5 to 9 is possible with the following query:

SELECT *
FROM Results
WHERE result >= 8.5 AND result <=9

However, a separate keyword is also available for selecting a range. The keyword BETWEEN makes the query a little shorter. It can be used in the following way:

SELECT *
FROM Results
WHERE result BETWEEN 8.5 AND 9

But beware, the keyword BETWEEN it can be quite confusing; with us Dutchmen, it is BETWEEN often translated as "between". However, the numbers with limit values, in our example 8.5 and 9, are also shown in the result. A better translation of BETWEEN is 'from ... up to and including'.

Tip 5

To write queries more compactly, you can sometimes use the IN keyword. For example, to show all students from Amsterdam, Rotterdam and 's-Gravenhage:

SELECT *
FROM Results
WHERE city = 'Amsterdam' OR 
        city = 'Rotterdam' OR 
        place = ''The Hague

That is also possible:

SELECT *
FROM Results
WHERE city IN ('Amsterdam', 'Rotterdam', ''s-Gravenhage')

The latter notation is not only much shorter, but also much easier to expand.

SQL Basics training

Are you interested in learning this programming language? Discover with an SQL training course data that previously remained hidden for you. In our two-day SQL Basis training, you will learn all the important ins and outs of SQL!

link]

Nomination Trainer of the Year Award!

The Dutch Association of Trainers (NOBTRA) has announced the nominees for the election of 'Trainer of the Year'. Trainer of the Year' is the award for the person who, according to colleagues and clients, is the best trainer in the Dutch language area. The NOBTRA established this professional award in 2011. On 25 September, the professional jury will announce who will be named 'Trainer of the Year' for the coming year during the 'Day of the Trainer' in Spant!

We are very honoured that Carlijn Hoogeveen, head of our Communication and Management Department, has been nominated for this title!

What do you think is the meaning and value of a professional award such as the title 'Trainer of the Year'?

Carlijn: The NOBTRA aims to recognise, test and develop professional trainers, to inspire and bind and to promote the prestige of the professional trainer profession. According to the NOBTRA, an ideal trainer is one who:

  • has a higher vocational education (hbo) thinking and working level;
  • has a relevant and recognised training course for trainers, and therefore has a broad theoretical knowledge in the field of learning and behaviour, communication, didactics, group dynamics and labour and organisation science;
  • has two years' work experience;
  • can show a basic professional attitude;
  • reflect on their own work and development;
  • continues to professionalise;
  • can develop and implement a training proposal that fits the client's needs and has the skills to supervise learning processes in a motivating and clear way.

Therefore, such a professional award also gives our customers an idea of where the quality lies. The presence of professional awards further stimulates the development of our trainers and qualitative didactic ideas. It is a kind of hallmark for our clients and gives confidence to our participants and the organisations we train for. It is an honour to be nominated for this. It gives recognition to the training profession. What I do with all my heart and what I believe in is also appreciated by our clients and participants. It's great when it comes together like this!

What do you think characterises a 'Trainer of the Year'?

Carlijn: General: Recognition of quality and an example to others. Someone who by approach clears a path for others in the rapidly changing training jungle.

Specifically, what is the essence of training for me: Reflecting and developing are two concepts that have been my passion for many years, in the broadest sense of the word. With clients, this results in beautiful, insightful advice, guidance, training and (team) coaching. Increasing insight into one's own abilities and examining which convictions might be blocking the other person from taking the next step. By listening carefully to what is (not) being said, holding up a mirror and connecting with the client. I want to set people in motion on the basis of contact and connection and from the conviction that every participant knows best what is needed, but sometimes just needs that little push in the right direction. My approach is to create a safe environment to get out of your comfort zone, to experience action-oriented exercises that can be confronting, but which also include a smile. Every training, group and individual is different, and therefore always customised. I find that fun and instructive! For me, being a trainer means continuous reflection and growth.

I do my work with great enthusiasm and I still have a lot to learn. Since last year I work next to my function at Learnit Training as educator coach at 'The School for Coaching' where I teach the 'Course Coaching for Professionals'. This is a wonderful new step in my need for deepening and development. The transformation that participants go through is wonderful and gives an even deeper meaning to the role of a coach.

My vision for our department at Learnit Training: In our trainings and during coaching and advising, we work from (com)passion with our customers. We believe that a good connection with our customers is crucial for a good cooperation. We find it self-evident that we continue to develop and challenge ourselves. Connecting with the practice of the client and integrating this into every programme is self-evident. Confronting the client from time to time, pointing out possible effects and keeping the result in mind makes us a pleasant partner for organisations and one that often asks us back. I therefore believe that this is what a trainer must have.

What does this nomination mean to you?

Carlijn: A nice recognition and at the same time stimulating to develop myself further. On the other hand, this provides more awareness among organisations and customers for Learnit Training. I am also proud of our company and my colleagues that together we have managed to establish what we are today in the world of trainers and that I have been part of it for 12 years. That I am the trainer I am today is partly due to Learnit Training, where growth and development are always stimulated.

How would you like to interpret the title if you are allowed to wear it?

Carlijn: I once started training psychology students at university. Whereas in the first few years it was all about training above the water surface, concrete behaviour and becoming more effective in your actions, I transformed as a trainer by focusing more and more on what happens below the water surface. By trusting, really listening to what the participant says and investigating this, it became possible to accept for the participant how it really was and possibly adjust behaviour if desired. In recent years, now that I advise and train large companies, my interest has broadened to systemic work, the context that influences and acknowledging undercurrents of influence. Training is certainly not the answer to everything. I hope to be able to expand and develop this even more in the coming years. To increase companies' understanding that there is no such thing as a quick fix and that deepening, connecting with employees and taking a genuine interest in each other, as well as taking the company's results into account, are a golden combination. And that a training course now and then can be very effective and valuable (provided it is given with enthusiasm and sufficient reflection!) but is not the answer to everything. I want to do more with that, with or without the title.

link]

The dashed good intentions

Resolutions: at the end of December we can't get enough of them. Everyone knows for sure that they are really going to achieve 'it' this coming year. Lose ten kilos, quit smoking, save up for that one nice trip, manage time better, master a new language or skill and so on. But why do many of these resolutions die a quiet death somewhere in mid-January? Because most resolutions are not kept until 2 January, if they make it through New Year's Eve at all. And this leads to disappointment or even shame. But is this self-reproach justified? At Learnit we believe that New Year's resolutions do not only need to start on 1 January, but can be pursued throughout the year. To give you a hand with actually reaching your goals, we offer you the following seven tips.

1. Be realistic, stop fantasising!

The first step to success in achieving your resolutions or goals is to set realistic and achievable 'intermediate goals'. Everyone can fantasise about that one perfect dream trip or that legendary performance, but often you have to start with smaller steps to get to these Big Dreams. So, force yourself to get your finances in order and put money aside each month, or make music for at least ten minutes a day. Achieving these relatively easy intermediate goals will keep you motivated to reach your actual goal.

2. Write down your intentions and hang them up in a visible place

Good intentions are nothing more than goals that lead to a situation that seems desirable to you. But the internal conflict that arises from wanting to achieve the goals on the one hand and not putting in the actual effort on the other, causes the goals to be forgotten. Therefore, make sure that you keep confronting yourself with that desired final situation. By writing down your goals and putting them in places where you encounter them daily, you stay in touch with them and do not forget them.

3. Make a plan

To keep track of your current situation, what you want to achieve and how you want to get there, you need a plan. Put your intermediate and final goals into a realistic time plan and stick to it. Hang this plan visibly next to the final goals and write down your progress, because every step forward motivates you. In this way, you keep an overview and control over your planning and the final goal comes visibly closer. Do you not only have to achieve goals for yourself, but also in a larger professional context? Then the Project Management training can help you with that. During this training you learn step by step how to set up a project and bring it to a successful conclusion.

4. Trust in yourself

A lack of self-confidence quickly leads to a negative spiral: people no longer dare to take on challenges and set the bar lower and lower, which in turn leads to failing to achieve your good (because ambitious) intentions or final goals. If you notice that a lack of self-confidence both in daily life and in the pursuit of ambitions gets in the way, you can benefit greatly from a (personal) training or coaching. In this training you gain insight into the underlying causes of your lack of self-confidence and you use this knowledge to create a positive self-image. Because believing in yourself is an important condition for success!

5. Change your habits

To achieve good intentions related to breaking bad habits such as smoking and obsessive eating, it is important to replace these habits instead of eliminating them. Know the situations in which you exhibit certain habits, such as reaching for a cigarette when bored. If you don't replace them, you are likely to revert to your old bad habits in those situations. Therefore, make sure you have something positive to replace the bad habit with, such as eating your favourite fruit or playing a short game.

6. Do it together (with a coach)

Share your good intentions with friends, acquaintances and colleagues. The people around you have the biggest influence on you and everyone likes to show success to this group. In addition, they offer healthy social pressure and you can easily form a group with friends who have set similar goals for themselves for that extra push. If you do not have someone in your immediate circle who can (sufficiently) motivate you, or if you are looking for professional support, then the Learnit coaches are ready to help you. Together with you they will explore your motives, dreams, wishes and ideas and help you realise a lasting and valuable change in your behaviour, situation or thinking patterns.

7. Give yourself small rewards

Motivate yourself by giving small rewards for achieving your intermediate goals and a big reward for achieving the final goal, if that is not a reward in itself of course. Finally go to that musical you have wanted to go to for years (and which is so good it is still playing!) or treat yourself to a nice day at the sauna. Because let's face it, success motivates and all small successes in life deserve to be celebrated!

Is one of your New Year's resolutions to learn a new skill or gain a lot of new knowledge about a certain subject? Then take a look at what Learnit, with a range of more than 300 high-quality training courses, can do for you!

link]

The power of the team coach

Reorganisation: the magic word in times of crisis. Far-reaching changes for organisations, teams and individuals are daily fare - many people have to deal with reorganisations themselves or through their environment. Reorganisation can be associated with renewal, improvement and a chance to put things right. But not all consequences of a reorganisation are equally rosy.

Besides the fact that jobs are often lost, employees have to get used to the new situations they find themselves in. The 'remainers' have to say goodbye to colleagues and to old, familiar methods and protocols. The pressure of work increases because fewer people are employed. New teams and socially hierarchical relationships arise. This combination of factors can cause stress, irritation and uncertainty: things that do not benefit the productivity of either the individual or the (new) team, which is precisely the aim of the reorganisation. How can companies ensure that a reorganisation has the desired effect?

Coaching can play an essential role in successful reorganisation. Individual coaching can be of value when a specific employee is not functioning well and has mental and/or physical complaints. Raising the alarm in time is then of great importance, so that someone can be supported in an individual trajectory to, for example, get used to changes in position or team.

But it may also be the case that a team as a whole is not functioning well, and this is where team coaching comes in. Team coaching is a powerful tool for getting the most out of a team, even (or especially) in the difficult and changing circumstances that come with reorganisations. Sometimes, teams or departments consciously or unconsciously maintain patterns, convictions and behaviours that no longer fit the new work context. Team coaching focuses on the team as a whole, leading to a new way of thinking and working. A team is more than the sum of its parts; a change can only be truly successful when it is carried and lived by the entire team.

Team coaching assists teams in searching for and finding thresholds, but also has a preventive effect when new teams are being set up. Important here is the completely external role of the team coach, who is completely outside the system and can therefore operate freely and openly. One of the core lessons that the coaches try to convey is that the heterogeneity of a team - the differences between its members that so often cause conflicts - is precisely the team's strength. Attempts by both managers and team members to homogenise employees lead, more often and more intensely than the actual differences, to an unpleasant and non-productive working atmosphere.

Coaching a team is the way to hold up a healthy mirror to failed teams, or even prevent them from doing so. The positive consequences of this are greater job satisfaction, lower absenteeism and increased productivity.

Do you want to discover what team coaching can do for your team? Read more information about team coaching on our website, request a quote without obligation or schedule a meeting with one of our specialists by calling 020 6369179 or info@learnit.nl.