Learnit Training
« Back to all themes

Training SQL

If your goal is to master specific SQL technology, you can turn to Learnit. Below you will find an overview of our SQL training courses. You can take our SQL courses throughout the country; classroom by open enrolment, in-company or private.

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? Are you assertive? Or perhaps you would like to practice negotiating?

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

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?

Do you want to learn a (different) programming language? Discover our workshops and courses quickly. Under the guidance of an experienced trainer, you will learn the basics of programming in an efficient way. Are you already a little further? Then it is possible to register for an advanced training. You go deeper into the matter. Such training is not only fun, but it also fits in well with the practice. So you are sure you can do something with your new knowledge and skills instantly!

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

Learning data

Dates are valuable! And they are important in the decision-making process within the company. If we adopt it for now, we can take it a step further. Because where should data be met if you want to use them valuable? How do you make them usable?

Conditions for valuable data

Your data is only valuable if you have something to do with it. But also if you have the basics in order. Two points are very important:

  • Reporting should be accurate
  • The interpretation must be correct

If you know how to record your company data neatly and you know how to read these data, you have very valuable information in your hands. (We really wanted to say that you have gold in your hands. For real, data can help you with important operational and strategic decisions.)

How do you make your business data usable?

There are still many companies that do not have a Datadriven decision-making process. When we ask the people in those companies, it often turns out that it is simply not possible to make the collected data usable. Nevertheless, it is useful to make large amounts of data properly. You can do it too! We put some tips on a list:

  • Revise your data collection. Dataverwerkingsprogramma'shebben has had an awful lot of updates in recent years. Just take Google Analytics, which has changed considerably. Functionalities have changed, the user interface is different and there are many more issues about this popular data processing program being revamped. It really doesn't hurt to take a closer look at your dataverzamelmethoden. Is everything still up to date? Do you do things wrong? If necessary, enable an expert's help. This is possible by hiring someone, but also by learning how to collect and analyze your data today. (LINK!) The collection of all data is the basis!
  • Collect. Collect real. With this tip we mean: Import data from different sources and merge all data. You have data from social media, Google Analytics, email marketingcampagnes, Crms etc. Take the time and effort to put all these dates side by side. You should try a little bit to get as complete a picture as possible. (No, you never get it. But striving is good!)
  • Combine quantitatively with qualitative Talk to your employees! They have so much knowledge at home when it comes to data processing. Maybe they don't know that themselves. But you can become an expert in filtering useful information. The usability of your data depends on the correct interpretation. By knowing what's going on (for employees, customers and the market), you can make data much more valuable. Only if you draw the right conclusions based on your quantitative data, you can use data for the (Strategic and operational) decision-making process.

Learn More

Do you want to learn how to best use your data within your company? Take part in one of our training courses. You get practical tips on how to collect data in the right way in the future; and to make all data usable and valuable.

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's a good thing, but since it's not yet the standard to write the way you should write and the way you talk to each other on the street, it's certainly useful to keep your knowledge up to date for the time being. For example with a course, training or free webinar from Learnit Training.

Link

Distraction and concentration

Be derived is a choice

You will probably recognize the following situation all too well at work: you are busy with a certain activity that needs your attention and your phone or a eimail gets you out of your concentration. Annoying. And the time you need to focus further on work may differ per person, but in the end it turns out that if you can work without distraction, you'll be ready much quicker. What is the reason why we are distracted so quickly and we do not have this in hand? From this point of view, we dare to infer the proposition that is a choice.

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

Under self-image we mean the image you have of yourself; The way you judge yourself or the way you see yourself. This image is partly shaped by the information you get from others about yourself. After all, they also look at you, deal with you and form an image of you. They let you notice how they think about you or give their judgement about your behavior. The image you have of yourself does not always match the image that others have of you. This can sometimes make you uncertain. And the way in which you see yourself determines to a large extent what positive or negative feelings you cherish towards yourself.

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

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

Link

Organize your own webinar?

Perhaps you have been planning to organise a webinar for your employees, stakeholders or other relations for some time now. However, a busy agenda always prevents it from actually happening. Or you've heard of the term 'webinar', but don't really know what it means, let alone what new possibilities it can offer your organisation. Discover what a webinar can do for you.

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.

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

Are you spending a lot of time looking for mail? Ideally, your inbox, or your digital workstation, should be as empty as possible. In this blog, we'll give you three helpful 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 our two-day training time Management you will learn to handle your time efficiently and go home a lot less stressed at the end of the day. You will learn not only practical tips as in this blog, but also learn to reflect on your own thinking and acting. Did you know, for example, that assertiveness and delegation skills also play a major role? Discover it in our training.

Sharon Faber, Department of Communication & Management

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. The data Manipulation Language (DML): A collection of computer languages to retrieve, delete, add, or modify data from a database. The DML is used by computer programs or database users.
  2. The Data Control language (DCL): A computer language that users use to control access to a relational database.
  3. The Data Definition language (DDL): A computer language that defines data. For example, a DDL is formed by a portion of the SQL commands.

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

Discover with a SQL training data that was previously hidden before you. In our two-day training SQL Base you'll learn all the important ins and OUTS of SQL, such as:

  • 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

Excel-Access 0:1

In the summer of 2015, there has been a large-scale research into the use of Excel worksheets in America. Many thousands of sheets have been viewed. And what turned out? Most of these worksheets do not contain any formula. This apparently means that Excel is mainly used to store data without being counted.

In practice I also come across many Excel users who create all sorts of lists or list in Excel. I understand that too, because the pane layout is useful and simple with filters the correct data can be selected. The problems occur when data from a worksheet needs to be linked to other worksheets. This is not possible with a few simple formulas and is often almost impossible. Although Excel has a number of database functions (DSUM, DCOUNT,..), they are again meant to be counted.

The solution that is not obvious, but often much better, is to import the data into MS Access. This is generally problem-free and Access creates tables. Establishing relationships between data is now easy. In the ' Relationships ' menu option, lines between fields from different tables can be drawn to create relationships. Various options can be used to ensure the integrity of the data. For example, only an order can be added if a customer has been created first. This data integrity is not present in Excel.

Access makes it easy to create forms (input screens) to make it even easier for users. Also to export is thought. Through reports, the information can be printed very flexibly to paper or PDF. It can also be easily exported to Excel. In Access, even most Excel functions can be used to create calculations.

It is always important to use the right tool when working. This also applies in the office. When an EXCEL worksheet does not contain formulas, it is usually better to choose Access.

Muhammad Nadeem

Office Trainer

Do you want personal guidance, feedback and practice with your own situations? Sign up for an Excel training or Access training You can follow our Office training in versions 2007, 2010, 2013 or 2016

Link

Step-by-step plan to de-escalate aggression

When dealing with aggressive people it is important to know that aggression provokes aggression. Sometimes a way of looking, saying something or a certain posture can already provoke aggression. Interest can be interpreted as meddling ("Hey, what are you looking at?" Do I have something for you? "), while that is not meant at all. It is important to pay attention to your own way of communicating, because your behavior can be just those drop that the bucket is doing to someone else.

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

Aggression is at least more manageable and brings less suffering when you get more instruments to recognize violent behavior early, to de-escalate, and to obtain a clear picture of your own behaviour in the situation. With the help of professional actors, these skills are fully developed and rediscovered in our training Dealing with aggression and (verbal) violence and the specialized variant Aggression Training for Boas. Link

Use and necessity of aggression training

Violence in the public area is increasing. We are increasingly reading headlines like "Steekwerend Vest in Haagse trams", "conductor to hospital after abuse" and "security victims often victim of violence". A behavioural and cultural change is undoubtedly necessary, but the impact of aggression can be reduced by thorough training.

For Boas, security guards, conductors, desk staff, agents, bailiffs, teachers or other professionals working in the public space, we have therefore developed two aggression trainings. These trainings provide tools to:

  • To better understand the physical and mental effects of aggression;
  • To recognize aggressive behaviour early;
  • To be able to anticipate this behaviour quickly;
  • De-Escalating to act;
  • Assertiveness further develop and
  • Mapping your own behaviour through video analysis.

We do this by working with professional actors, a proven program and by offering the training very tailor-made. As a student you always have a connection with your own work situations, because we take this as a starting point when developing practice exercises.

We offer two training variants:

After following one of our aggression trainings you will stay (better) in balance and you Are (DER) in difficult situations. Please contact us via info@learnit.nl or call one of our training advisors to discuss the possibilities (020 6369179). [link]

10 important reasons to organize a webinar

In the past, anyone who wanted to make a product, service or message known to a large group of people could set up a conference or business meeting for this purpose. It goes without saying that the interested parties who wanted to be there had to have the time and means to travel to the agreed location. Thanks to modern technology, this is no longer necessary these days. With a seminar via the internet, also known as a webinar, you can reach your target group in a much easier way. What's more, the people who want to attend your webinar don't have to travel. This makes it a lot more attractive for them to get to know your message. But there are many more good reasons to organize a webinar.

1. Organising a webinar saves all parties time and money

In principle, following a webinar can be done between companies, but not only costs the interested parties considerably less time and money. For the person organizing the webinar it also delivers the necessary savings. For example, there is no need to rent space or arrange catering, and the online lecture or presentation can be promoted inexpensively via the Internet.

2. Suitable for large and small numbers of participants

The participants can simply attend the webinar via their computer. This means that you don't have to worry about how many people are coming, whether the room is too big or too small, whether there is enough parking space, and whether everyone arrives on time.

3. Direct contact with your target group

The audience has the possibility to communicate directly with you during a webinar. This gives you an even better view of what your target group wants and allows you to get to know them optimally. These kinds of insights and information are invaluable for an entrepreneur.

4. Fast interaction with potential interested parties

In a traditional seminar, the attendees generally listen to a speech in silence. Organizing a webinar, on the other hand, invites interaction between speaker and audience. This is a much more effective way of building a relationship with your target group than through one-way traffic, such as with a written text or a video message.

5. Webinar can often also be viewed in retrospect

Because a webinar can usually still be viewed if it has already taken place, you can even reach your target group afterwards. This makes it an extremely powerful and long-lasting marketing tool. Of course, a condition is that your webinar is easy to find online. To draw the public's attention to it, you can distribute the link of the webinar afterwards via your social media channels.

6. Good way to get more brand awareness

Especially when a company is a relative newcomer, organizing a webinar can help generate brand awareness. It provides support in creating awareness among your potential audience, while at the same time you work on building and expanding your business network and business contacts.

7. Ideal for effective product promotion

Organising a webinar lends itself perfectly to advertising your book, product, event, etc. As an organizer, you can refer to passages from your book in your story, or include parts of your video in it. At the end of the webinar you show the viewers a link where and how they can buy the product.

8. Make a product of your webinar

Many webinar services offer the possibility to record a live webinar. This gives you the opportunity to make a podcast or online video of it later on. If desired, the webinar can also be released on DVD. You can use this DVD for sales or, for example, to give away as a business gift.

9. Organising a webinar that generates money directly

When you, as an entrepreneur, are on top of certain developments or regularly introduce novelties, a webinar can already be financially lucrative at the moment it takes place. You do this by asking people who are interested in the latest news within your sector to contribute to the online seminar.

10. Collect contact details via your webinar

Organizing a webinar lends itself perfectly to collecting email addresses and other information among your target group. As a condition for participation in the webinar, you can, for example, ask interested parties to register in advance. The resulting data is particularly valuable to a company's marketing team or sales department.

Would you like to organize a webinar after reading the blog? Sign up for our two-day training Webinar organization or request a free quote. You can also contact YourWebinar part of Learnit Training, who can take the technical aspects of a webinar completely out of your hands.

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 like those of the New York Times, Fortune and NRC. How is that actually? In This blog we give you 10 good reasons to start using WordPress too.

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

The WordPress programming code is freely available and anyone can tinker with it. And that also 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 adapt it. You can create (or have them made) custom-made things.

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

Is it a project?

Since 1980, project-based work has become increasingly important due to the increasing dynamism and complexity of society and the organisations themselves. Nowadays almost every job is called a project; Even cleaning up the filing cabinet is a project. I think it comes through the time spirit, project management is trendy. That every activity is called a project is clearly a trap ' the bells are heard, but do not know where the clapper hangs '.

You know the memory game of the past: ' I'm travelling and I'll take it.. '. The first player says, "I'm going to travel and I'll take it: a swimsuit". The second player repeats this and adds something. The third player repeats the word of player one and two and adds something, and so on. By means of a holiday planning I outline the choice of ways of working and the distinction.

Every year you go to the same destination via a fixed route, you take the goods with you and the budget is determined accurately by the years of experience. This is routine. If you routinely find ' boring ' and want more spontaneity and adventure, then you choose to improvise. Your global desire is ' where the sun is shining ', so you get in the car and drive. The course is regularly adjusted to the circumstances. New ideas arise during the trip. It is not good to prepare therefore you take different stuff with it and lots of money.

When you approach your holiday planning project, you have a more outlined goal (culture in France, alternating with relaxation). You first determine the functional requirements (castles and beach) and operational requirements (solar hours per month in the region and maximum distance). Then you will find out what choices are available for holiday destinations. You make a choice, determine the route and pick up the necessary stuff and leave. Minor changes are possible at any time of choice.

Project work is between routine and improvising: there is no guarantee that the predetermined result will be achieved by following established procedures, but there is sufficient experience in (type) equal situations to make a road Which is likely to bring the formulated objectives closer.

Within an organisation there are several ways to look at projects and project work. For example, building a house, designing and building is seen as a project in which the architect and the contractor work together. From the top the whole is seen as a project. Masons and carpenters work routinely. From the execution it is seen as routine.

It may also be that the parent organisation performs very regularly activities in the form of a project, for example in the case of renewal of products and research. From the top these activities are seen as routine. The executive researchers work on a project basis. Different layers can be judged on routine and project work.

' Something ' lends itself to a project if there is a comprehensive description of a demonstrable, desired end result beforehand. In addition, the specific effort comes to an end, after reaching the end result. Thirdly, there is a considerable degree of uncertainty as to the end result and/or the road.

When you are again instructed to be involved in a "project", it will stop at this foot light and make a conscious and critical assessment of whether it is an activity or whether it is actually a project. A project is a temporary work of a number of people – usually different disciplines – to achieve a predefined goal with a set budget.

Link

Day Flash. Hello Animate CC!

It is so far. Flash Professional CC Gets a new name: Adobe Animate CC. Of course, not only changes the name, but also new features are added. Animate CC is supposed to be the new standard tool for anyone who wants to create webanimations. SWF and AIR formats are still supported, as well as HTML5. By collaborating with Google and Facebook, Adobe wants to keep the existing Flash content still available. Adobe says Flash Professional CC all the way from the beginning to have rebuilt to make this possible. Why do they change names and what are the new possibilities you can use later? Read on here and find out all you need to know about Adobe Animate CC.

Why do they change the name?

Flash has created a turbulent past and a bad identity. When Apple stopped supporting Flash on the iPhone and IPad, it seemed to be all end story. However, many marketers still continued to use them. Now, among others, advertentieblockers have become so popular, this path does not seem profitable for them either. And because of several problems with the program and different versions, Adobe is clever to throw the helm with a completely new name. What changes?

Possibilities

Because HTML5 is primarily used, Adobe strongly emphasizes this by a new HTML5 video player that replaces the original Flash variant. What are the possibilities you can make more use of?

Draw

  • Better brushes that make it easy to create tight vector lines and access live previews.
  • Adjacent frames can now have different alpha and color values, making it easy to create intricate animations.
  • With Vector art brushes, you can adjust the path of a line after it is drawn and scale to any size without losing quality. It is also possible to create or import brushes yourself.
  • It becomes easier to manage audio loops directly on the timeline and without code.
  • Change colors more quickly because they can be adjusted automatically in the rest of the project.
  • You can rotate the canvas 360 degrees to really put every point well on the I.

Output

  • It is now possible to export videos for the latest Ultra HD and HI-HPI displays.
  • Want to continue working in Adobe Muse, DPS, InDesign, or Dreamweaver? No problem, simply export your project as a. OAM file.
  • HTML5 Canvas, Flash (SWF), WebGL, Air, and other platforms like SVG are simply supported by Adobe Animate CC.
  • Do you have any old content? Revive them by optimizing them for each resolution.

Integration

  • Creative Cloud Libraries give you easy access to all your images, colors, brushes, and vector artwork.
  • In Adobe Stock Chalk you have instant access to millions of illustrations with which you can even animate.

Link

Do you still have a training budget of 2015?

The beginning of 2016 is in sight and the training plans for the new year are made again. But what should you do with your remaining training budget? Our team of training advisors will be happy to help you, so we can see together how to get the most out of your education budget and development. Look for our offer, some of our trainers and our working method in our information brochure. To download it click here.

Should it be that you do not have time to attend a training this year, we can still send the invoice this year, but you can only follow the training in 2016. In addition, together with your colleagues you can bundle the training budget through our strip card and receive a 5% discount for when you purchase the stripping card before 31 December 2015. For more information about our stripping card click here.

Link

The 8 most convenient Office 2016 features

Microsoft Office, for many known as Word, Excel, PowerPoint, Access and Outlook, has been completely revamped for the 2016 edition. As in every new version, a lot of changes have been made, and we like to put the 8 most convenient of these on a row.

1. Real-time co-authorship

Collaborating efficiently is one of the main objectives of Microsoft Office 2016. It will not surprise you that from this version you can work with different people simultaneously on the same document. While you are already reading the first paragraph in your Word document, your colleague can continue to write to the following paragraphs, without your work being overwritten by the other. The same goes for PowerPoint, but Word has a unique perk: Here you can even see each other in real-time typing.

2. Send larger files

Send your PowerPoint presentation of 300mb by mail? This is no longer a problem in the new Outlook. As soon as you add an Office 2016 product as an attachment to an email, it will be converted into a link where the recipient can easily download the file. The only condition for this is that the file is already synchronized with a OneDrive account or a SharePoint folder.

3. Smart Lookup

The Smart Lookup function ensures that you don't have to leave Word, Excel or PowerPoint when you want to look up the meaning of a word in your document. Simply select the word in question, right click and then select the option "Smart Lookup". The results you receive are generated by Bing and will be displayed in an "Insights" tab within your document.

4. One-click Forecasting

Excel-Ninjas will undoubtedly count this feature up to their favorites. In the chart section of Excel, you can now conjure up predictions with a simple mouse click. To this end, Microsoft uses the standard "Exponential Smoothing algorithm (ETS) to show effective reliable forecasts.

5. Skype Integration

As mentioned earlier, working together efficiently is very important in Office 2016 and that also proves the Skype integration in the various desktop apps. This allows you to start a Skype call within Word, Excel or PowerPoint, both with Instant messaging, voice calls and video calls. But you can also without leaving the document, share your screen via Skype.

6. Office groups in Outlook

This is perhaps the least discussed novelty of Office 2016, but therefore certainly not the least useful. Thanks to Office groups, it has been done once and for all with traditional distribution lists or cluttered mail conversations. You can now bring together the colleagues you collaborate with in one group, which has a shared Inbox, Calendar, File store, and even integrated OneNote notes.

7. New graphs

For those who are looking forward to the standard charts in Microsoft Office, there is good news. In fact, new chart types have been added that help you to visualize financial or hierarchical data better.

8. Better cross-device support

Finally Office 2016 also puts a big step forward in cross-device support of various programs. Create your Word document on your smartphone, update it on your tablet and add the finishing touch to your PC, all can be done easier than before.

Link

Playing with SQL: SQLFiddle

Do you want to run the queries on this blog yourself? Or do you want to quickly try something with SQL without installing an SQL server? Use SQL fiddle! SQL fiddle is an online tool that allows you to try out queries and share them with others. Using it is easy:

Step 1
Although there is an ANSI SQL standard, there are differences between SQL servers. Especially if you are getting started with features and stored procedures. Fortunately, SQL fiddle supports 7 different SQL servers.

Step 2
After selecting the server you can create the schema (the tables of data). The queries for this are in the left part of the screen. The database with the results of our students is here.

Step 3
If the creation of the schema is successful you can start writing the queries. This can be in the right screen. Note: With MySQL you can only make selection queries and not add records or modify tables.

Run SQL sends the query to the server and gives you the result at the bottom of your screen. (The processing time depends on the server's busyness).

You can share the query with others by simply copying and forwarding the URL.

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);
?>
Link

SQL-5 tips for filtering with WHERE

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:

  • All students from Amsterdam
  • All students from The The Hague with a result of at least 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 <="" pre="">

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.

Link

5 reasons to communicate with your SQL database via PDO

There are several ways to communicate with a database from PHP. Since PHP 5.1 A nice extension has been released: PHP database Objects (PDO). Do you use the old fashioned mysql_connect() And mysql_query() Features? Here five reasons to switch:

  1. Binding parameter

    Creating a query with input from website visitors brings with it dangers. Visitor Input can contain dangerous SQL code. If the code component becomes a query there is a SQL injection, a common vulnerability.

    With PDO you can better arm against SQL injections thanks to ' parameter binding '. PDO offers the ability to use placeholders in your query. This will prevent unwanted SQL code from entering the query.

  2. Exploits of a mom

    Randall Munroe, xkcd.com, CC BY-NC 2.5

  3. Transactions

    Changes to your database are often not self-explanatory. Often, one request from the visitor asks for changes to multiple tables. When making an order in a webshop, not only the order must be saved, but also the inventory will be updated.

    If one of these queries does not go well, for example because the inventory is insufficient, the database will be in an inconsistent state. With transactions, you can do a "rollBack" in such a case, which will undo all changes to the database since the start of the transaction.

  4. ' Universal ' interface

    With PDO you are not tied to one database. No less than 12 database systems are supported, including MySql, PostgreSQL, Microsoft SQL Server and Oracle. Thanks to PDO, your program can communicate with it in the same way. When you connect, you indicate what type of database it is, then you can ask them using the same methods.

  5. Disappearance of old functions

    The obsolete mysql_*() Features are no longer supported from PHP version 5.5.0. In the latest versions (from PHP 7.0.0) They are not even included and therefore no longer use.

  6. Object oriented

    PDO is completely object oriented. So you have all the advantages of object oriented programming, including exceptions. Exceptions allow you to handle errors, such as connection problems, in an elegant way.

Note: Is the PDO extension not available on the system where your website Is running, and do you use a MySQL database? Then switch to Mysqli. Less universal and elegant than PDO, it also provides parameter binding, transactions and stored procedures.

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

Deepening in the Trainersvak

What makes someone a good trainer? During the Train the trainer, we will elaborate on the essences of the Trainersvak and ask if: How do you decide what the training should take? How do you define the subjects and create a tactile thread? How do you get participants to start using new behaviors or skills? During Train the trainer, you will also be treated as a trainer. We take the participants along the route we are doing as a trainer. Because that is what the profession is about: making always informed choices (both before and during training), which lead to the desired end result. -Trainer Mieke

Train the trainer-shapes

1. Classroom or Incompanytrainingen

In the classroom train the trainer-training you come as a participant in a group with students who have almost equal learning goals. The training consists of a carefully compiled combination of classroom introductions, explanations, examples and practical applications. A incompanytraining is a tailor-made training that is given within your own organization. If necessary, the training can also be organised at a Learnit location. 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.

Below are some topics that can be treated during a Train the trainer-training

  • How can you drop a stimulating workout?
  • Substance in a didactically responsible manner
  • Gaining insight in your own style as a trainer
  • The importance of communicating well
  • Different forms of work
  • Dealing with (critical) questions and troublesome students
  • Learn styles of participants and how to play here

Do you want to follow the training Train the trainer? Sign up for a location and start date of your preference. Do you want to organise the training incompany or at a Learnit location? Request a free quote .

2. Trajectory

In the train the trainer you will learn everything there is to know about training in six months: from preparing to executing to evaluating. In these six months you will meet a total of seven times with an expert trainer and a small group of other interested parties. These seven days, 14 sessions, are divided into three blocks of two days and one trainees. Between the blocks you independently create different assignments and you learn further through inspiring and instructive literature. Our journeys are very interactive, you are going to work a lot yourself: doing and experiencing are our first priority. In this way, the course offers a high learning efficiency and you can work flexibly, which also fits your schedule. In other words, you become a professional in the field of training within six months.

Below you will find a brief overview of the three blocks and what is dealt with globally:

Block 1. You as a trainer

  • Working on personal Training style
  • Giving stimulating training
  • Preparation
  • Structuring
  • Building
  • Didactic skills
  • Lesson Plan

Block 2. Your trainees

  • Learning Styles Trainees recognize
  • Customize Trainingstijl to Trainee's learning style
  • Creative forms of work
  • Dealing with questions from trainees
  • Coping with resistance of trainees

Block 3. Floor

In this block, the theory goes deeper and you are going to put all the scholar into practice by giving a short training on a subject of your choice. This will look at what you have learned so far and what you still want to learn.

Do you want to follow the train the trainer? Sign up for a location and start date of your preference. Do you want to organise a customised course in-company or at a Learnit-location? Request a free quote .

3. Workshop

With a workshop train the trainer you collaborate with your colleagues in an active, instructive, fun and inspiring way new knowledge and skills. In consultation with the trainer, your organisation will determine anywhere in the workshop. The workshop can range from two to four hours and is well combined with social business activities.

Do you want to organise the workshop Incompany or at a Learnit location? Request a free quote .

Contact

Please contact Our training advisors and planners for advice, information, quotations and the training fashions.

Link

The bygone good intentions

Good intentions: At the end of December we cannot get enough. Everyone is sure that they will really reach ' it ' this coming year. Those ten pounds lose weight, stop smoking, save for that one nice trip, get better with time learning, master a new language or skill and go on. But why do many of these intentions die a silent death sometime mid-January? Because most intentions are no longer sustained than until 2 January, if they already come through New Year's night. And this leads to disappointment or even shame. But is this self reproach rightly? At Learnit Training we find that good intentions do not only have to start on 1 January, but can be pursued all year round. To help you achieve your goals effectively, 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 good intentions for 2014 to make yourself a new skill or to gain a good dose of new knowledge on a particular subject? Take a look at what Learnit training, with an offer of more than 800 high-quality training courses, can mean for you in this beautiful year!

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