Learnit Training
Link

Top 10 most popular programming languages

Late last year, a list of the most popular programming languages of 2020 was announced. Not entirely surprisingly, C as ultimate favorite 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 on a surprising 9th place in the top 10 list; TIOBE therefore appointed 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 in the workplace 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 amounts of data. Do you want 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 will have heard before. Programs such as R are ideal 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 programs such as Stata, SAS and SPSS for static programming languages like R. Professional groups in which static analyses occur are also increasingly using R. Think for example of data analysts, mathematicians, econometricians but also marketers. The advantage of a program like R is that it costs nothing: it is an open source project that 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 work with large data sets. Furthermore, it is also difficult to reproduce a previously used analysis, because it takes some effort to find out 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 realize that SQL is a programming language and that the use of SQL 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 include 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 short, you have the data you want to use at hand. For SQL this is a bit more complicated. You write and send so-called 'queries' in SQL to a database. This database then provides you with the information you request in your queries. Next, the data is stored in a database and organized in tables. A big 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. Furthermore, 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 a lot more reliable. Excel has its own strengths. For instance, it is possible to enter data manually, which makes the program quite flexible. Furthermore, the program is capable of performing spell-checks, for example, which allow you to easily detect errors in names or columns. The most important advantage of working with Excel compared to SQL is the visualization possibilities of the program. Tables, graphs, pie charts, it is all possible in Excel.

Training SQL

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 Continuation 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. We also offer a training SQL Report Builder training. SQL Report Builder offers various visualization options, allowing you to create a professional report from your data. Ideal if you want to make a management report, for example! 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 allegedly making it easy for intruders to infiltrate a meeting. After adjustments to their system and security, this problem is now in the past, and since March Zoom has only become more popular in the Netherlands. In this blog we will explain exactly what Zoom is doing 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?

Important elements of Zoom's privacy statement can be found 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 you consent to ad cookies on their website.
  • Zoom ensures that messages that users send to each other are encrypted, so that third parties are not able to read these conversations.
  • Zoom is currently working on end-to-end encryption, this can be seen as an extra security key which makes it impossible for any external party (not even Zoom) to infiltrate a meeting. The host of the meeting has the ability 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 organization or employee, it is 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, you can read 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 their sound or screen to make sure they are no longer in contact with 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 make a video recording 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 realize 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 with the other Zoom users in a meeting. Make sure that you are responsible for this, and not Zoom.

5. Prevent other users from storing conversations. As a host, you have the ability to prevent 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' to that list. How do you make sure 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 more often than not. However, if you want to make a good first impression, it is important to wear an appropriate outfit, even for an online job application. 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 to what extent 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 your laptop's camera is. During a physical conversation, it is easy to look at the person you are talking to. In an online conversation, this works a bit differently. That's why you should always check where the camera of your laptop is placed 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 you are actually looking at him or her.

5. Avoid noise in the background. If you are conducting the job interview from home, it is possible that your interviewer will pick up on some background noise. During a job interview you would of course prefer to avoid this. 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 the techniques that ensure that a conversation takes place 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!

For all of us, 2020 has been a year in which we have had to adapt a lot, both in our personal lives and in the workplace. Working at the office was suddenly no longer possible because of COVID-19 and working from home became the new norm for many people. Despite rapid adjustments by both employers and employees in order to be able to continue the work, some developments on the work floor will have come to a standstill this year. Think for example of courses, training or education of employees.

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

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

1. Consultation with colleagues. Consult with colleagues beforehand about skills that are important for your departments. You may not yet have any idea what you want to develop yourself into, but there are certain points of interest that could help your departments move forward. For example, is there no one in the departments who can deal with Power BI? Maybe this is a good opportunity for you! Click here to view Learnit's course overview and get inspired.

2. Group training. In addition to a training course in which you only focus on your individual skills, group training can also be of great added value for both employer and employees. Think for example of intervision training where departments get to know each other better and where the aim is to improve 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 don't make use of it in time? Of course this would be a shame! A possible solution is to register for a training or course, so that it can be invoiced to your organization this year. However, it is also possible that you are not quite sure yet which training course is best suited to your wishes or needs. In such a case, a Learnit strippenkaart may be the solution. With the Learnit strippenkaart your organization can purchase training days at a fixed price. Click here for more information about the Learnit strip cards.

Learnit strippenkaart action weeks

To stimulate 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 strip tickets 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 buy communication and management trainings.

Both strippenkaarten are available in the variants: 10 days, 20 days or 50 days. Where 1 strip equals 1 training day. Briefly explained: a strippenkaart gives you and your colleagues the opportunity to follow training courses of your choice for a year, without having to deal with interim price increases and without having to look specifically at training beforehand. Ideal for employees who are not quite sure yet what kind of training they want to follow, but still have a training budget left over! Would you like to discuss the possibilities or ask which training courses from our offer fall within the scope of the strippenkaart? Then contact us by calling + 31 20 6369179 or click here. here.

Link

Big data - 5 common questions

Big data is a term that seems to be becoming more common 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 V's. In case you are wondering what a 'big' amount of data is: we are talking about data volumes expressed in exabytes. This means that when we talk 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 of social media data like a Twitter or Facebook message. This data is much more difficult to analyze 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 is. Relatively large companies will obviously have a larger data stream and thus need more data tools than smaller companies. This does not mean that collecting (big) data does not make sense for smaller companies. Why you should start collecting big data today? Collecting data can have multiple reasons, but the most important ones are to optimize 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 data is being used more and more and there are more and more data (visualization) tools available, it is still difficult to work with data yourself if you are not familiar with 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 Basic or SQL Basics.

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 allows 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 there are many companies that collect data and from that 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 used to communicate with your own (relational) database. By means of various commands, you are able to filter, modify or delete data from a database as you see fit. 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 by last name? Then the command 'ORDER BY' is useful!

Webinar and course on SQL

Learnit offers the possibility to follow a short introduction webinar SQL, in which a number of important 'commands' are discussed and explained. Are you interested in learning this programming language? Then please subscribe to now for our free webinar SQL, more current than ever! In addition, we also offer the possibility to follow a basic SQL course at various training locations. Curious about our two-day SQL basics course? Then click Click here. Are you already familiar with SQL and would you like to learn more about this programming language? Then our course SQL Advanced course is just what you need!

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 remove certain data. Think, for example, of saving the data of someone who creates an account in your webshop. Isn't it nice 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. For example, suppose a customer wants to change his address. In such a case, it may be convenient for your own administration to also change this address in your database.
  • Enthusiastic? Then sign up quickly for the webinar about SQL on October 15th 2020! link]

    Successful job application

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

    In this blog we give you 10 tips you can apply to have a better chance of getting a job!

    1. It all starts with reading and searching for vacancies. Apply specifically and take a good look at the job requirements in the vacancy. Do they match your skills?

    2.You always apply with 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 field of collaboration, 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 at other channels as well. 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 well-groomed, and in case of doubt: better 'overdressed' than 'underdressed'.

    5. Prepare yourself very thoroughly, but enter the conversation in a relaxed way, as if it were a friendly match. This makes you more receptive and flexible, which promotes 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 neatly and preferably give a firm hand (of course not in the 1.5m society). Always look at the person who is talking to you, but don't stare.

    8. Answer the questions asked and don't beat about the bush. If you don't have an immediate answer you can, for example, indicate that you are thinking about the question and come back to it at the end of the conversation.

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

    10. Never be negative about previous employers or organizations. This can make the wrong impression and you never know what contacts your potential employer has. Finally, you have been invited for an interview so the potential employer will already find you a suitable candidate. Stay yourself and take your time!

    More self-confidence in your application process? Take a look at Learnit's self-confidence course!

    Link

    Working from home, learning at home, time for yourself!

    The corona crisis has had 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, where you can develop yourself at your own pace. Take for example an E-learning from Microsoft. To follow this training you will officially receive Microsoft study and practice material. You will receive the e-book that serves as a reference for the practical execution of assignments in an online learning environment. You will be given access to this learning environment for six months for which you do not need any software, only a computer with an internet connection. In the labs, you work through scenarios in which you can directly apply what you have learned in practice. By means of a practice exam you can prepare yourself well for the accompanying Microsoft exam. You can also take this practice exam online. It consists of questions similar to the questions you can expect at the actual exam and gives detailed explanations for both correct and incorrect answers. The training is completely in English and will be completed in approximately 3 days.

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

    View all E-learnings via this link.

    Advantages of E-learning:

    • Everything you need is in the package (book, practice test, exam optional)
    • Organize 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? Do you want to be assertive or perhaps practise negotiating?

    View all free mini trainings 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. Think of the 'smart' thermostat in your home, 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 that are connected to the internet. These devices are able to communicate with the internet and with each other, and they can also send data to the 'cloud' without human intervention. This automation saves costs and reduces the physical effort required of people. This of course sounds fantastic, but on the other hand people also criticize the Internet of Things. Some people are afraid that technology will eventually take over the world, others point out the possible problems with privacy.

    Advantages of the Internet of Things

    The Internet of Things has several advantages, these 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 continuously 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 allow companies and individuals to save on costs.
    • Convenience. Many smart devices can be controlled remotely these days. Consider a video doorbell, where you can remotely see who is at your front door. Not only are you able to see who is at your front door instantly using the app, you can also communicate directly with someone at your door. So, smart devices ensure that the ease of use is increased.

    Disadvantages of the Internet of Things

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

      Everything revolves around technology. Technology is indispensable these days, the question is just when will the world have enough technology? Many people wonder whether it is good that so much in 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, because a lot of work can be taken over by technology.
    • Hackers. Smart devices are increasing data traffic, making it more and more interesting for hackers to hack 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 using an app that is connected to the lights in your house. When a hacker realizes 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 get off to 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 Incompany or group training is a tailor-made training that is given within your own organization. All our trainings can be provided in-company and, if necessary, the training can also be organized at a Learnit location. We have listed the advantages of an incompany training for you!

    Custom

    The main advantage is that the content of the training in all aspects can be tailored to the learning objectives and expectations of the employees and the organization. This makes it possible to get your company philosophy back in the training. A tailor-made programme is being developed. Several trainings could possibly be combined. Because we find a good click with the trainer important, we plan a (telephone or Skype) intake with the contact person of the training. By means of this intake prior to the training we determine jointly which subjects the accent will be placed, where it is possible that we still add or modify topics. You can also use your own practice examples as input during the training. In this way we ensure that the training fits perfectly.

    Cost

    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 becomes more profitable. When you register more than eight participants, we recommend that you divide them into several groups. For example, there will be sufficient individual attention per participant, so that personal learning goals are better achieved. Because the training is given to your company or organization, Learnit does not need to rent space and an incompany training can be offered at a cheaper rate than an open registration.

    Plans

    The last advantage of an incompany training is that you do not depend on our training data. Training dates are determined in consultation and based on the availability of our trainer. Generally our training times are from 10:00 to 17:00 hours. If you have other wishes you can of course indicate this. Your agenda is central. Also the number of days of the training is not fixed, this can be adjusted according to your learning objectives. It does not matter where the company is located, Learnit trains throughout the Netherlands. This saves your employees less time to travel.

    Curious about the possibilities for your organisation? Feel free to contact us or request a free quote !

    Link

    You can learn programming!

    Visit any vacancy site and you will see it immediately: there is an unprecedented demand for programmers. If you are looking for a paid job with excellent perspectives for the future, learning programming is a must. Even for jobs in which you don't directly program yourself, a programming language is an excellent addition to your CV. However, there are numerous programming languages, so where can you start best now? And which languages are interesting for the future? We made an overview of the 10 most important programming languages. Languages where you can also directly follow a training course: let those jobs come!

    Java

    Java was for years the most-requested programming language for employers. Although this has recently been outpaced 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. Its popularity owes the programming language mainly to the simplicity and readability of the code, which makes it a good starting point for novice programmers. Also, one of the basics of Java is the compatibility that ensures that older applications continue to work.

    SQL

    You'll find SQL everywhere. Database technologies like MySQL, PostgreSQL and Microsoft SQL Keep banks, universities, hospitals, small and large companies running. It is not exaggerated to say that every computer and person with access to technology somehow comes into contact with SQL. For example, iOS and Android devices have access to SQLite, a SQL database, and numerous mobile applications that use SQL directly.

    C

    C originates from the early years 70, when it was developed as a generic, general programming language. As one of the oldest programming languages available, C gives us 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 in the years 80 was developed it has been used to develop Adobe and Microsoft applications, MongoDB databases and large portions 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/videobewerking.

    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 had to write iPhone applications as a programmer, until Apple came up with its own programming language a few years ago: Swift. Swift seems to be very much like C++ and its predecessor objective C, but it is easier for most programmers to learn.

    Javascript

    JavaScript – not to be confused with Java – is widely used to add interactivity to websites and is supported by all larger internet browsers. Not only can it be used for simple functionality like popups or simple games, it also forms the basis for Node. JS – A server technology that is widely used in real-time communication.

    PHP

    PHP was in fact never meant as a programming language. The Danish-Canadian programmer Rasmus Lerdorf developed PHP in 1994 as a series of tools that enabled him to manage his personal website (Personal homepage). Today we changed the meaning of the abbreviation to Hyper test Pre-Processor and used the language on servers to dynamically generate HTML websites. PHP is easy to learn, but in addition possesses much advanced functionality that is of great value for experienced programmers.

    HTML/CSS

    HTML forms the basis for Web pages. This does the programming language by actually setting a structure that can be extended or modified 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 for Web developers is an absolute must.

    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 brevity of the code. In Python, it is often possible to express a concept in less rules than in many other languages. Python is used in applications such as Insta gram and Pinterest in the form of the Web-framework Django. Google, Yahoo! and NASA all make use of Python.

    Ruby

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

    Fill in the list!

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

    Learning A (different) programming language yourself?

    Would you like to learn a (different) programming language yourself? Then quickly discover our workshops and courses.Under the guidance of an experienced trainer you will learn the basics of programming in an efficient way. Have you moved on? Then it is possible to register for an advanced training. You will then go deeper into the subject matter. Such a training is not only fun, but it also fits in well with practice. This way you can be sure that you can immediately do something with your new knowledge and skills!

    Link

    Dragons taming: 4 tips to make dragons of SQL queries simpler

    Dragons may not exist, but I am far too often opposed to dragons of queries. Complex-looking code where at first glance you would rather not take the fight.

    We'll give you four tips to make sure your queries don't change in Dragons:

    1 | Friendly looking Dragons

    With a piece of friendly layout, dragons look a lot less impressive. But what does a friendly query look like?

    1. Divide the query across multiple lines. It is no problem if the query gets long. Clarity goes above shortness of your query.
    2. All ' SQL words ' such as SELECT, FROM, WHERE, etc. in uppercase. Also functions like ROUND, SUM etc are the easiest to recognize when they are capitalized.
    3. Jump in to make it clear and align the query neatly.

    Luckily there are also (online) tools that can do this for you automatically. 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

    When compiling more complex queries, some puzzle work is being looked at. The steps that have been taken cannot be read back directly in the query. Put it in a piece of documentation. Documentation does not have to be a comprehensive book, but can be added directly into the SQL. Start your comment with--and it will be ignored when executed. Put above each query you make what he does and of course where the pitfalls are. Pay special attention to subqueries; These often add extra complexity that needs explanations.

    3 | Name a little beast

    Table names can be long and cryptic. To not always type it, you can use an alias from a single letter. Instead, an alias can also be a short name or abbreviation. This also applies: Clarity is above the shortness of your query!

    4 | Divide and conquer

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

    Do you want to learn how you can use Aliasses, subqueries, joins and views? Then follow our SQL basic training!

    Link

    Why Crystal reports?

    Crystal reports make it easy for you to create your own interactive report (with a neat, professional design). You can link the reports to almost any data source, which makes the program for almost everyone valuable. And that's what you see in the figures: almost 20 million people worldwide use this software to create reports of company data. Want to know why? We give you three good reasons.

    1 | Crystal reports is user-friendly

    You do not need help from an IT specialist to create Repporten in Crystal reports and to interpret the data. And yes, that delivers a lot of savings in profit and money. And it just works more pleasantly if all employees can report themselves. The program owes its simplicity to the fact that visibility is so easy to control.

    2 | Crystal Reports is affordable

    For less than €500.00 you already have a version that lets you as a user. A complete version! That makes Crystal reports very affordable.

    3 | Crystal reports make you look for customization

    You can use Crystal reports in combination with an application that you like (or that your organization uses). Think of Exact, SAP and Microsoft Visual Studio. The data is imported from various sources, such as XML. The result is self-determining. With the user-friendly software you create your own report, which you shapes nicely and in which you display the data exactly the way you want it. Annual accounts, mailing, KPI: With Crystal reports you can create a variety of reporting.

    Do you want to learn how to really get everything from Crystal reports?

    Sign up for one of our Crystal reports training sessions. You can start with a basic training, so you can get started quickly. You will learn how to design and send professional reports. Have you often worked with Crystal reports? Sign up for a challenging workout for the more advanced users. Then you really learn how beautiful and clever this software really is!

    Link

    To write or not to write

    Why? Therefore!

    Who is not guilty of it? You write a text or an article for study or work and you don't know the right spelling as quickly. So how did the Dutch spelling and grammar appear?! To find the right way to write through Google, at least you hope! And on the other hand, in controlling a foreign language, we as Dutch also score quite well. Compared to other non-English speakers, the English language has no secrets for us.

    Language teaching

    A fun way to share your own language skills is to become a language volunteer. However, when you explain the Dutch language to speakers, you are also confronted with the many challenges and exceptions to the rule that the Dutch language is rich in, such as the articles, the sounds, vowels and consonants. And sometimes there is only one "because it is like this" as an explanation of it because just as life itself is, language is not always logical. And there is nothing wrong with that.

    Language lives

    Language has been created by (continuing to) develop. Every hundred to a thousand years, a language is developing into a country and the culture of a country. 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 language area. In 2016, the Frisian dialect officially settled on the map, a Ameland dictionary (Amel other Woa'deboek) came out and the importance of language is increasingly linked to writing language in the last 500 years.

    Language changes, language shifts

    Where Latin is a dead language, the Dutch language is a living language. A language is alive when it is one's mother tongue. Another characteristic of a living language is that new words are added to it, sometimes from another language or by speaking language. And although it seems like a contradiction, reading books is emerging again and speaking language is increasingly pushing our writing language.

    What are you saying now?

    We live in a time when we read volatile (cups scanning) and we take a lot of our information through vlogs and animations to us. And there is certainly a good side to this development, from write-to-speak language. This makes complicated long and technical phrases with a complicated writing structure (as in this sense) gradually becoming more and more replaced by more visual phrases. Street language, language that immediately makes it 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 on the street, it is certainly useful to keep your knowledge up to date for the time being. For example with a course Course or free webinar from Learnit Training.

    Link

    Distraction and concentration

    Be derived is a choice

    Waarschijnlijk herken je de volgende situatie maar al te goed op je werk: Je bent druk bezig met een bepaalde activiteit die al je aandacht nodig heeft en je telefoon of een email haalt je uit je concentratie. Vervelend. En de tijd die je nodig hebt om weer geconcentreerd verder te werken mag dan per persoon verschillen, maar uiteindelijk blijkt dat als je zonder afgeleid te zijn door kan werken, je veel sneller klaar bent. Wat is toch de reden dat we zo snel afgeleid zijn en hebben we dit niet zelf in de hand? Vanuit dat oogpunt durven wij de stelling aan dat afgeleid worden een keuze is.

    Concentration requires attention.

    There is a difference between the work and the concentration you need to carry out this work. Writing a reporting with financial influences requires more concentration than a memo about clearing the coffee cups, just to give an example. It is therefore good if you can give a label to the work in which concentration is required. By classifying the work, you gain insight into how high the concentration should be and how tedious it is to be distracted from that particular task.

    Concentration requires action

    If you know what concentration is needed to do your work in an efficient way, you will also understand that concentration requires action. Sometimes it may be necessary that you literally separate yourself by sitting down separately. Sometimes it's enough to turn off your phone and your email program. But what is always true is that you have to take action yourself to realize this. Now you may think that it is not reachable or does not respond directly to an email does not happen to customer friendly, but nothing is less true. If you take the time to answer your phone at a fixed time or read your email, you also have the time to work focused.

    Concentration and time gain

    Often you hear that the time you have is too short to do all the work that one wants to do or that you are asked for. Just by putting the concentration in the right ways you win time. You are less distracted, you function more pleasantly and if you take the time to work with good planning and manage your time in the right way then you will see that the choice for concentrated works alternate with other work your productivity much Higher than if you think you are disturbed.

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

    Self-confidence and self-esteem

    Onder zelfbeeld verstaan we het beeld dat je van jezelf hebt; de manier waarop je over jezelf oordeelt of de wijze waarop je jezelf ziet. Dit beeld wordt mede gevormd door de informatie die je van anderen krijgt over jezelf. Zij kijken immers ook naar je, gaan met je om en vormen een beeld van jou.Ze laten je merken hoe ze over je denken of geven hun oordeel over jouw gedrag. Het beeld dat jij van jezelf hebt komt niet altijd overeen met het beeld dat anderen van je hebben. Dit kan je soms onzeker maken. En de manier waarop je jezelf ziet, bepaalt voor een groot deel welke positieve of negatieve gevoelens je ten opzichte van jezelf koestert.

    It occurs regularly that people have a wrong image of themselves. When the image you have of yourself largely matches the image that others have of you, it turns out that you usually show yourself the way you are or want to be. Is there a difference between the image you have of yourself and the image that others have of you? This certainly does not mean that you don't know yourself well or that others don't know you. You can see different aspects of yourself in different situations with different people.

    Being uncertain about yourself, how you happen to others or about your position in a particular situation is quite normal. But this uncertainty can also go too far. A lack of self-confidence quickly leads to a negative spiral: you do not dare to face any challenges, the bar is becoming less high, which again leads to a deterioration of your self-image. In this way, it is becoming increasingly difficult to escape from this vicious circle.

    To help you, we have developed a two-day self-confidence training. In training you will learn to recognize the causes of your lack of self-confidence and underline the importance of verbal and non-verbal communication in relation to your self-image. In addition, the training is practiced through realistic role-playing games. Mutual feedback and video analysis ensure that your old behavior patterns are broken. In the training we will work on the following topics:

    • Working on a realistic self-image
    • Your own qualities and capacities
    • The importance of verbal and non-verbal communication in relation to Jezelfbeeld
    • A positive mental institution (creating and holding)
    • Recognising causes of loss of self-confidence (h)
    • Breathing and relaxation exercises
    • Setting realistic goals
    • Fears and challenges
    • Labeling negative and positive labels
    • Assertiveness: Defend your own interests
    • Dealing with negativity and criticism

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

    Link

    Organize your own webinar?

    Misschien dat je al langer met het voornemen loopt om voor je medewerkers, stakeholders of andere relaties een webinar te organiseren. Een drukke agenda verhindert echter telkens dat het er ook echt van komt. Of je hebt wel gehoord van het begrip ‘webinar’, maar weet niet goed wat het fenomeen inhoudt, laat staan welke nieuwe mogelijkheden het jouw organisatie kan bieden. Ontdek wat een webinar voor jou kan betekenen.

    Hulp bij het organiseren van webinars

    If you want to organize a webinar we can be of service in all aspects. Whether it's expert advice on how to set up a webinar and attune it carefully to a specific target group, or providing our professional studio with all the necessary advanced equipment: we are happy to be of service!

    The technique

    By organizing your webinar through us, you can use our webinar studio and the present expertise of our employees. We arrange all the technical facilities involved in the organisation and execution of a webinar. Would you rather organize a webinar at your own location? That's 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 organize a webinar in different settings. For example, you can stand in front of the camera as a presenter, but you can also be supported by a host or moderator or organize the webinar in the form of an interview. It is also possible, for example, to show the viewers what you are doing on your screen.

    Taking care of the webinar yourself

    If you want to master all aspects of organizing a webinar yourself, then our two-day training course Webinar organizing is for you. During the training all technical aspects involved in setting up a webinar will be discussed. In addition, the course will focus on the presentation of a webinar and the related interaction and communication with an online audience.

    Want to know more about this training? Then request a free quote. You can also request more information about organizing your own webinar by sending an e-mail to info@yourwebinar.nl or calling 020 6369178.

    Link

    Which SQL training is right for me?

    If you want to easily retrieve data from a relational database, you can use the SQL (structured Querylanguage) question language. In addition, you can modify, manipulate, and modify table structures with SQL data.

    Are you going to use relational databases soon, or do you already use it, but do you want to delve into SQL? Then you can follow one of our SQL training courses. Below we explain briefly the differences between the courses.

    SQL Basic

    Our two-day basic training is suitable for both novice database users and functional administrators and data analysts. In This training you will learn to master the basics of SQL and you can easily create queries to retrieve data from a database. This includes querying, sorting, filtering, summarizing, modifying, and grouping data, as well as working with subqueries and combining queries.

    SQL Report Builder

    This two-day training is suitable for users who want to create reports by using Microsoft SQL Report Builder/Reporting Services. In this training you will learn to work at your own pace with the software, so you are able to quickly and easily extract complex reports from large databases. You will get to work on getting data and designing and shaping reports.

    Transact-SQL Basic-MS SQL Server

    Our two-day Transact-training is suitable for users of an MS SQL Server database and participants who will work as an application manager. The training treats the basis of Transact SQL, where the focus is on using an MS SQL Sever database and using SQL Server Management Studio.

    SQL Basic-Oracle

    The two-day Oracle training is intended for users of an Oracle database and participants who are working as an application manager. In the training, the basis of SQL is treated, with the focus on using an Oracle database and using SQL Developer.

    In addition to the basic training of SQL Oracle, we have some deeper Oracle database trainings in our offer. Click here to view the complete Oracle offer.

    Advies nodig?

    Please feel free to contact us via info@learnit.nl or 020 6369179 to discuss your learning goals with one of our training advisors. We like to think about your learning goals and can advise you which training suits the best.

    Link

    Grip on your mailbox with 3 handy tips

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

    Tip 1: Make use of 3 labels

    Almost all email programs allow you to personalize your inbox. By processing incoming e-mails in a structured way, you can keep the overview well. How often does it not occur that you have to search in your inbox for endless time to find that one email? Make use of 3 important labels: what to do, where to get answers 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 Tags tab and click ' Create new label '
    3. Set the labels, for example: 01 | To do, 02 | Waiting for reply and 03 | Completed
    4. If you want to quickly distinguish between your folders at a glance, you can give color to the labels. You can do this by hovering your mouse over the label (left in your Inbox) and selecting the color there. For example, give the color red to what you still have to do (to do), yellow to current affairs (waiting for answer) and green to tasks that are ready (abyss).

    In the picture below you see an example of how your folder "To do" can be seen:

    TIP 2: Make use of sub-labels

    By using 3 labels on tip 1 You have already worked with tags, but you can extend this by creating additional labels of your different work. For example, customer contact, promotional business or work consultations. You set the labels the same way as with tip 1. These labels can also be coloured again.

    In the picture below you see an example of how your label "Customers" can get out of it. In this way you can also see at a glance what the status is, because at tip 1 you have already created three folders for your incoming emails:

    Tip 3: Put your own in the BCC in case of a visit

    You know it: 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 or not you have received a response. This may result in you sometimes being too late to have to know something about 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 a filter in Gmail that all mail from your email address and where you put yourself in the BCC will be forwarded directly to you in Tip 1 created folder 02 | Waiting for reply:

    1. Go to the Gear icon and select ' Settings '
    2. Go to the ' Filters and blocked Addresses ' tab and click ' Create New Filter '
    3. Fill in "from" and "to" your own email address, and click "Create Filter with this search".
    4. Select "Skip Inbox" and select "Apply the label". Choose (for example) the label "02 | Wait for answer "and click" Create Filter ". All messages you have sent with questions or requests can now be found in this folder. Once you have a response you can move the email to for example "03 | Completed ".

    In onze tweedaagse training Timemanagement leer je efficiënt met je tijd omgaan en ga je een stuk minder gestrest naar huis aan het einde van de dag. Je leert niet alleen praktische tips zoals in deze blog, maar je leert ook te reflecteren op je eigen denken en handelen. Wist je bijvoorbeeld dat assertiviteit en delegatievaardigheden ook een grote rol spelen? Ontdek het in onze training!

    Link

    SQL: The must-learn for database users

    SQL, we can't get around it anymore. The structured Query Language is now 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 an absolute must-learn for potential database users.

    Why SQL?

    SQL is a unified language that can be used to work well as querying plus customizing data in relational databases. SQL can be used with virtually any modern relational database product.

    The default language SQL has as roots the relational algebra and was originally developed by IBM. The ambition was to have business managers use SQL to effectively analyze complex business. The biggest advantages of SQL are as follows:

    • SQL allows you to create every conceivable query. You can use the results of the queries for reporting purposes.
    • The default SQL language works independently of specific databases. Therefore, the acquired SQL knowledge can also be applied to other environments such as Oracle or Access.
    • Advanced, in-database analytics at no extra cost. With SQL, customers can make better decisions by using the easy-to-use analysis tools that seamlessly combine external data, company data, and even unstructured big data.
    • SQL provides constant positive user experiences, both on-premise and in the cloud. This is possible through the use of shared management and development tools.
    • Innovations are integrated by default. 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 collectively unlock information:

    1. Data Manipulation Language (DML): een verzameling aan computertalen om gegevens uit een database te halen, te verwijderen, toe te voegen of aan te passen. De DML wordt gebruikt door computerprogramma's of database gebruikers.
    2. Data Control Language (DCL): een computertaal die gebruikers inzetten om de toegang tot een relationele database te controleren.
    3. Data Definition Language (DDL): een computertaal die data definieert. Een DDL wordt bijvoorbeeld gevormd door een deel van de commando's van SQL.

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

    Training SQL Basic

    Ben jij geïnteresseerd in het leren van deze programmeertaal? Bekijk dan eens onze tweedaagse training SQL Basis en leer alle belangrijke ins en outs van SQL, zoals:

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

    Link

    Step-by-step plan to de-escalate aggression

    Bij het omgaan met agressieve mensen is het belangrijk om te weten dat agressie agressie uitlokt. Soms kan een manier van kijken, iets zeggen of een bepaalde houding al agressie uitlokken. Interesse kan geïnterpreteerd worden als bemoeizucht ("Hé, wat kijk je nou? Heb ik iets van je aan?"), terwijl dat helemaal niet zo bedoeld is. Het is belangrijk om op je eigen manier van communiceren te letten, omdat jouw gedrag net díe druppel kan zijn die de emmer bij iemand anders over doet lopen.

    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 for example a robber. Sometimes it is good to let someone out raging, sometimes to show understanding and sometimes to run as hard as possible. Every situation requires good judgement. To help you get going, we'll share a global roadmap to deal with different forms of aggression:

    1. Approach the other with an open posture

    Aggression is often a reaction to a person or a situation. When you have an aggressive person in front of you, it is often your first reaction to react aggressively too. However, it is better to stay calm and to take an open attitude towards the other. If you react aggressively, the other will be worse and more aggressive with all the consequences.

    2. Let the other express his or her anger by listening

    It's best to get a piece of ' call ' in what the aggressive person has to say. If he can lose his story, he will be quieter. He feels heard and understood. Sometimes it helps the simple sentence: "I see that you are evil" already.

    3. Summarizing and asking questions

    Make an estimation of what kind of aggression you are dealing with To determine the continuation of the call:

    In emotional aggression/frustration aggression:

    Emotional aggression is often the result of an accumulation of frustrations. Take the problem seriously and let the other express his or her anger. For emotional aggression, do the following:

    4. Understanding Show

    Not for the aggressive behaviour, but for the situation. In the eyes of an aggressive person, he or she is wronged. Do not argue, but show understanding. One who feels understood, makes less stennis.

    5. Giving Information

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

    6. Offer solution

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

    7. Positive closure

    The best thing is if you can end the conversation in a positive way. A friendly word or a cup of coffee does wonders. Always close positively. And beware of sarcasm. Unfortunately, it will not always be possible for the other to make a positive move. But make sure you close the conversation positively.

    For instrumental/Targeted aggression:

    In instrumental aggression people use aggression on purpose. They demand something and because they think they don't get it for each other, they have the idea to get it through aggression. This is why you have to draw your limits before. If it is needed pretty soon though after step 1.

    4. Setting limits

    Border control is very important in dealing with aggression. This to be a professional To be able to respond properly. For example, say (kindly but decide) that you want to listen and talk, but not if they behave like that.

    5. Offer solution/Choice

    Give the angry person the options that are there. In The waiting room of the infirmary: "You can choose: you are going to sit quietly, you will be helped immediately. Or you are not going to sit, but then I call the surveillance now. "

    6. Exit

    If the solutions given are not sufficient, please indicate clearly that there is no other option than the choice to work or stop. Be very positive here.

    Follow Training

    Agressie wordt op z’n minst beter beheersbaar en brengt minder leed toe wanneer je meer instrumenten in handen krijgt om gewelddadig gedrag vroeg te herkennen, de-escalerend op te treden en een duidelijk beeld te verkrijgen van je eigen gedrag in de situatie. Deze vaardigheden worden, met behulp van professionele acteurs, volop ontwikkeld en herontdekt in de verschillende omgaan met agressie trainingen die wij aanbieden. Klik here om naar de algemene agressie trainingspagina te gaan en vind de training die het beste bij jou aansluit. 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 give you 10 good reasons to start using WordPress as well.

    1. Ease of Use

    If you don't want to make it too complicated, WordPress doesn't have to be more than a Microsoft Word-like interface. In the base there is practically no programming knowledge required for users. That's also exactly where this Content Management System is intended: The user controls the content, WordPress takes care of the rest.

    2. It is open source

    WordPress programming code is freely available and anyone can tinker with it. And that's what happens, 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 modify it. Really everything can be made to measure (or have it made) according to your wishes.

    3. The community

    Because WordPress is used so often, almost every challenge imaginable has occurred before. So for most of the problems new users encounter, a ready-to-use solution is already online. And if not, the vibrant 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 on the basis of so-called themes, which determine how your website looks – both at the back and in terms of the actual webdesign. There are thousands of themes available, allowing you to create a professionally designed website. So many users don't need a web designer anymore.

    5. Plugins

    WordPress installations are expanding with small program, called Plugins. There is now a plugin for almost every functionality. And here too the community does its job: there is a comprehensive rating system that allows you to easily estimate whether a plugin is good or not.

    6. Reliable

    WordPress is now over ten years old, and many thousands of experienced programmers have collaborated on the project to improve it. That means that WordPress is far beyond the stage of childhood illnesses.

    7. SEO-Friendly

    With some simple customizations – whether or not using a plugin – WordPress is very SEO-friendly. Not only users, but also search engines like this CMS.

    8. Safe

    A general misconception is that WordPress would be unsafe. That is because it is often attacked. But that's just the case because it has so many users: attackers simply go for maximum revenues, and focusing on the largest system is a logical step. Users who carefully observe the prescribed basic security measures, such as regular updates, are rarely affected.

    9. Scalable and powerful

    WordPress is often seen as a system for small users. That, however, is entirely wrong. Some of the world's largest websites use WordPress, with perhaps the most important example Wordpress.com, the service that offers a hosted version. Although no WordPress installation can withstand such a lot of Internet traffic, the system is basically able to do it. So WordPress can grow with you.

    10. It's popular

    The bigger WordPress becomes, the better. This is because it is open source, but also because more and more users are increasingly able to help each other. It certainly doesn't go for any system, but in the case of WordPress popularity is really an advantage.

    Do you want to get started under the guidance of a trainer? Sign up for our WordPress training or request a free quote .

    Link

    Export SQL database to CSV

    With PHP you can easily provide information from your database to your visitors in a CSV file. CSV (Comma separated values) is a simple format that separates each value with a comma. It is open with Excel, after which you can leave data analyses on or make graphs of them.

    We will write a PHP script that retrieves results from our database and converts it into a CSV file. In our case the results of course exams.

    The first step is to retrieve the data from the database. We use PDO (5 reasons to USE 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();
    }	
    

    Here We use a try-catch to capture exceptions that can occur with a verbindingprobleem. The result of the query is a PDOStatement Object. Here we can take the records out, but first we have to prepare:

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

    Using the header function, we adapt the HTTP header. We want the visitor 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 opening the standard output we can write 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 recognizes that this is a UTF-8 encoding, the CSV tooth should start with 0xEF, 0xBB, 0xBF.

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

    Fputs ($fp, "ID, name, email, resultaat\r\n");
    

    The \r\n The end of the string indicates a line break. If we did not add the following data would be pasted instead of a new line. Note: This only works in strings with double quotes.

    The next loop is repeated as long as records can be fetched. This converts 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. This writes the array to the CSV file. The third argument of this function is the separator character. In Place of the comma (,) we could also use a different separator, for example the semicolon (;). To complete the whole, we neatly 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);
    ?>
    

    Training SQL Basic

    Are you interested in learning this programming language? Discover with an SQL training data that has previously been hidden from you. In our two-day SQL Basic 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 compose a filter. Here are 5 tips to avoid common mistakes when filtering with WHERE.

    You can also try out all the examples on sqlfiddle.com with the results database.

    Tip 1

    If you filter by text, it must be placed between some quotes. But it can, of course, occur that the searched text itself contains a quote. You can "escape" by typing two instead of one quote. The quote that is geëscaped is no longer seen as a closing, but as part of the text. The query to find all students from The The Hague looks like this:

    SELECT
    FROM Results
    WHERE place = ' ' The Hague ';
    

    Tip 2

    It remains difficult not to use the comma as a decimal separator anywhere in the world. This creates confusion for our Dutch people. The ANSI standard of SQL has been chosen for the U.S. number format. In queries, decimals must ALWAYS be quoted with a point.

    SELECT
    FROM Results
    WHERE Result > = 8.5
    

    Don't be confused if you see a comma in the result, the comma has a different meaning in a query.

    Tip 3

    It is possible to combine multiple filter conditions, for example by AND As a OR To use:

    SELECT
    FROM Results
    WHERE place = ' Amsterdam ' OR place = ' ' The Hague ' 
            AND Showing > = 8.5
    

    There is a snag here: conditions are not combined from left to right. The AND Operator binds stronger than the OR. Our sample query results in:

    • Alle studenten uit Amsterdam;
    • Alle studenten uit 's-Gravenhage met resultaat van minimaal 8,5.

    But that was not what we had in mind, we only wanted to see the students from The The Hague and Amsterdam who scored at least a 8.5. We now also see students from Amsterdam who score less than a 8.5. Fortunately this is easy to solve by using parentheses:

    SELECT
    FROM Results
    WHERE (place = ' Amsterdam ' OR place = ' ' The Hague ') 
            AND Showing > = 8.5
    

    Tip 4

    Showing all students with a digit in the range 8.5 through 9 can use 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 may cause confusion; Our Dutch BETWEEN Often translated with ' between '. However, the figures with limit values, in our example 8.5 and 9, are also shown in the result. A better translation of BETWEEN Is ' from... To '.

    Tip 5

    To make queries more compact, you can sometimes use the IN Keyword. For example, to show all students from Amsterdam, Rotterdam and The The Hague:

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

    This can also be the case:

    SELECT
    FROM Results
    WHERE TO Place (' Amsterdam ', ' Rotterdam ', ' ' The Hague ')
    

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

    Training SQL Basic

    Are you interested in learning this programming language? Discover with an SQL training data that has previously been hidden from you. In our two-day SQL Basic training you will learn all the important ins and outs of SQL!

    Link

    Nomination Professional Award Trainer of the Year!

    The Dutch order of professional trainers (NOBTRA) has announced the nominees for the election of ' Trainer of the Year '. ' Trainer of the Year ' is the prize for the person who, according to colleagues and clients, is the best trainer in the Dutch language area. This professional award introduced the NOBTRA in 2011. On the 25th of September the jury will be making a effort during the ' Day of the Trainer '! In Bussum we know who can call themselves the next year ' Trainer of the Year '.

    We are very honored to have been nominated for this title by the head of our communications and Management department.

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

    The NOBTRA aims to recognise, test and develop professional trainers, inspire and bind and defend the profession ' professional trainer '. According to the NOBTRA, an ideal trainer is a trainer who:

    • Has a bachelor's degree and working level;
    • has a relevant and accredited trainee training, and therefore has a broad theoretical knowledge in the field of learning and behaviour, communication, didactics, group dynamics and work and organizational science;
    • Two years of work experience;
    • Can show a professional basic attitude;
    • Reflects on its own work and development;
    • durably professionalizes;
    • can develop and implement a training proposal that fits the client's demand and has the skills to guide learning processes in a motivating and clear manner.

    As a result, such a professional award also gives our customers an idea where the quality is. Due to the presence of professional awards, the development of our trainers and qualitative didactic ideas is stimulated even further. It is a kind of hallmark for our customers and gives confidence towards our participants and the organizations we train. It is an honor to be nominated for this. It gives recognition to the training business. That which I do with all my being and in which I believe in is also appreciated by our clients and participants. Beautiful as it meets!

    What do you think is a ' Trainer of the year '?

    General: recognition of quality and an exemplary function for others. Someone who approaches 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 where my passion is for years, in the widest sense of the word. With customers this results in beautiful, insightful advice interviews, coaching, training and (team) coaching. To increase insight into own ability and to investigate which beliefs may hinder the other to take a next step. By listening carefully what is (not) said, a mirror to hold and to join the customer. I want to put people on the move from contact and connection and from the conviction that each participant knows best what is needed, but sometimes it needs a push in the right direction. In particular, my approach is to create a safe environment to go out of your comfort zone, experience action-oriented exercises that can be confrontational, but where laughter is certainly not lacking. Each training, group and individual is different, and therefore always customization. I find that fun and instructive! For me, the Trainersvak means continuous reflection and self-growth.

    I am doing my work with great enthusiasm and I am not even a long-time teacher. Since last year I work alongside my job at Learnit Training as trainer at ' The School for Coaching ' where I take care of the ' Learning course Coaching for Professionals '. An incredibly beautiful new step in my need for deepening and development. The transformation that participants are through is beautiful and gives an even deeper meaning to the role of supervisor.

    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 good cooperation. We naturally continue to develop and challenge ourselves. Joining the customer's practice and integrating it into every program is self-evident. Confronting the customer occasionally, pointing out possible effects and keeping the result in mind makes us a pleasant partner for organizations and also frequently ask for them. So I also think this is what a trainer should have in the house.

    What does this nomination mean to you?

    A beautiful recognition, and at the same time it is also stimulating to develop myself. On the other hand, this makes it more familiar to organizations and customers for Learnit Training. I am also proud of our company and my colleagues that it has managed to put down what we are now in trainers land and that I have been part of it for 12 years. That I am the trainer I am now is also thanks to Learnit Training, where growth and development are always stimulated.

    How would you like to give the title if you can bear it?

    Anand : I've ever started training psychology students in college. Where the first years in particular was about training above the water surface, concrete behaviour and becoming more effective in your actions, I transformed as a trainer by going more and more into what is happening under that water surface. By giving confidence, actually listening to what the participant is telling and investigating there, it became possible to accept for the participant how it really was and possible behavior to adjust if desired. In recent years, now that I advise and train with large companies, my interest has expanded to the systemic work, the context that influences and give recognition for undercurrents that are of great influence. Training is certainly not at all the answer. I hope that I will be able to expand and develop this more in the coming years. Increasing the visibility of companies that a quick fix does not exist and that deepening, being connected to your employees and being really interested in each other in addition to taking into account the business results, is a golden combination. And that occasionally a training can be very effective and valuable (if this is inspired and given enough reflection!) but not the answer is on everything. I want to do more with it, with or without the title.

    Link

    The bygone good intentions

    Good 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 beautiful trip, learn to deal with time better, master a new language or skill and so on. But why do many of these resolutions die a quiet death somewhere in January? Because most resolutions are not kept longer than January 2, if they even get through New Year's Eve. 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 fantasizing!

    A first step to success in the form of achieving your intentions or goals is to set realistic and achievable ' between goals '. Everyone can fantasize about that perfect dream trip or that legendary gig, but often you have to start with smaller steps to get to these big dreams. So force yourself to put your finances in order and to set aside money per month, or music at least ten minutes a day. Achieving these relatively easy intermediate goals means that you remain motivated to achieve your real goal.

    2. Write your intentions and hang them 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 the desire to achieve the goals on the one hand and not want to make the actual effort on the other hand, makes the goals fall into oblivion. Therefore, make sure that you continue to confront yourself with that desired end situation. By writing down your goals and hanging them in places where you meet them daily, you stay in touch and don't forget them.

    3. Create a plan

    To monitor the overview of your current situation, what you want to achieve and how you want to get there, you need a plan. Work your intermediate and final goals in a realistic time plan and stick to this. Hang this plan up next to the final goals and write down your progress, as every step forward motivates. This way you keep your overview and control of your schedule and the final goal will be visibly closer. Do you not only have to achieve goals for yourself, but also in a larger professional whole? Then the training project Management can help you with this. During this training you'll 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 do not dare to face any challenges, and the bar is becoming increasingly less high, which again leads to the failure to achieve your good (for ambitious) intentions or final goals. If you find that a lack of self-confidence is standing your way both in daily life and in pursuit of ambitions, you can benefit greatly from a (personal) training or coaching. This will give you insight into the underlying causes of your lack of self-confidence and use this knowledge to create a positive self-image. Believing in yourself is an important prerequisite for success!

    5. Replace your habits

    In order to achieve good intentions related to the breaking down of bad habits like smoking and obsessive eating, it is important to replace these habits instead of eliminating them. Know in what situations you exhibit certain habits, such as grabbing a cigarette when boredom. When you do not replace them, you are quickly inclined to intervene in those situations back to your old, bad habits. Therefore, make sure you have something positive to replace the bad habit, such as eating your favorite 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 greatest influence on you and everyone likes to show success to this group. In addition, they offer healthy social pressure and can easily form a group with friends who have set themselves equal goals for that extra support in the back. Do you (for your feeling) in your immediate environment not someone who can motivate you (enough) or you are looking for professional support, then the coaches of Learnit are ready for you. They will work with you on your motives, dreams, wishes, motives and ideas and help you realize a lasting and valuable change in your behavior, situation or thinking patterns.

    7. Give yourself Small Rewards

    Motivate yourself by giving small rewards when you achieve between goals and a great reward in achieving the final goal, if that is no reward already in itself of course. Finally, go to the musical you want to go to for years (and so good that-ie is still running!) or indulge yourself with a wonderful day out in the sauna. Be honest, success motivates and all the 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

    Reorganizing: The magic word in times of crisis. Far-reaching changes for organizations, teams and individuals are daily costs-many people have to make themselves or through their environment with reorganizations. A reorganization can be associated with renewal, improvement and a chance to clean up the ship. But not all the consequences of a reorganization are equally rosy.

    In addition to the fact that jobs are often lost, workers have to get used to the new situations in which they end up. The ' survivors ' must say goodbye to colleagues and old, familiar methods and protocols. Because fewer people are employed, the workload increases. New teams and socio-hierarchical links are created. This combination of factors can cause stress, irritation and uncertainty: things that do not benefit the productivity of both individual and (new) team, while that is precisely the purpose of the reorganization. How can companies ensure that a reorganization has the desired effect?

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

    But it could also be that a team as a whole is not functioning well and here comes team coaching around the corner look. Team coaching is a powerful tool to get the utmost out of a team, even (or: right) under the difficult and changing circumstances that entail reorganizations. Sometimes teams or departments are consciously or unconsciously maintaining patterns, beliefs, and behaviors that no longer fit into the new work context. Team coaching focuses on the team as a whole, creating a new way of thinking and working. A team is more than the sum of its parts; A change can be a real success when worn and lived by the whole team.

    Team coaching assists teams in finding and finding thresholds, but also has a preventive effect when new teams are set up. Important here is the complete external role of the team coach, which is completely outside the system and therefore can operate freely and openly. One of the core lessons that the coaches are trying to bring about is learning to realize that the heterogeneity of a team-the differences between the members causing conflicts so often-is precisely the strength of the team. Attempts by both executives 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 maintain a healthy mirror for failed teams or even to prevent this from being needed. More (together) work pleasure, reduction of absenteeism and increase in productivity are the positive consequences of this.

    Want to discover what team coaching can do for your team? Read more information about team coaching on our website request a free quote or plan a conversation with one of our specialists via 020 6369179 or info@learnit.nl