Learnit Training
Transact-SQL Basic Course-MS SQL Server
  • Easily learn how to create queries to retrieve data
  • Suitable for multiple databases (SQL, Oracle etc.)
  • Modify, manipulate and adapt SQL data and table structures
  • Very experienced trainer
  • Small groups

"With this training you will learn in 2 days what SQL is, how to use it and what the known mistakes are. The trainer is very professional and has a lot of knowledge of the subject matter." - Rating: 9.6

learnit Transact-SQL Basic-MS SQL Server

Transact-SQL Basic Course-MS SQL Server

SQL is the language used to communicate with relational databases. For example, SQL can be used to easily obtain the desired data from a large administration system. Because SQL is standardized (ANSI SQL), it can be used with multiple database systems. Transact-SQL is the default that Microsoft maintains with SQL Server and is an extension of ANSI SQL.

In our two-day Transact-SQL base-MS SQL Server training, the basis OF Transact SQL is handled, with the focus on using a Microsoft SQL Server database AND using SQL Server Management Studio. In The training there is room to identify the aspect of SQL or the Microsoft Tools you want to focus on.

Topics

  • Introduction to SQL, Basic principles: Data types, keys (primary key, foreign key)
  • Retrieving data (SELECT FROM, TOP, DISTINCT)
  • Sort data (ORDER BY)
  • Filter data (WHERE, comparison operators, BETWEEN)
  • Advanced Filtering (AND, OR, IN NOT)
  • Filter using wildcards (LIKE)
  • Calculated fields (concaters)
  • Customizing data with Functions (ROUND, LTRIM, RTRIM, DATE PART)
  • Summarize data (COUNT, SUM, AVG, MAX, MIN)
  • Grouping data (GROUP BY, HAVING)
  • Working with subqueries
  • Combine data from multiple tables with join (INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER join)
  • Advanced Joins (Table aliases
  • Combine Queries (UNION)
  • Add data (INSERT INTO)
  • Modify and delete data (UPDATE, DELETE)
  • Create, modify, and delete tables (CREATE, ALTER, DROP)
  • Transact-SQL as an addition to ANSI SQL

Target

This training is intended for users of Microsoft SQL Server and participants who will work as an application administrator or user with a Microsoft SQL Server database.

Training materials

You will receive a clear book with exercises and practice files at the start of the training. This can also be used as a reference book after the training. Because the terminology in the software is mostly English, the training material is also.

Prior knowledge

This training requires no prior knowledge and is suitable for novice database users.

Note

For platform-independent training, we would like to refer you to SQL Base. For a similar training for Oracle databases, we would like to refer you to SQL Basic-Oracle.

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 2 days 4 sessions of three hours
Price per day, excl. VAT € 425,- € 340,-
Total, incl. VAT € 1028,50 € 822,80

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

The training lasts 4 sessions of 3 hours, spread over 4 weeks.

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

The course Transact-SQL Basic - MS SQL Server has been assessed with an average of 8.3.

"With this training you will learn in 2 days what SQL is, how to use it and what the known mistakes are. The trainer is very professional and has a lot of knowledge of the material". - Assessment: 9.6

D. Brothers, Alfa Accountants and Consultants - Transact-SQL Basics - MS SQL Server

"This basic training met my expectations. The teacher was knowledgeable and relaxed, with sufficient individual attention if necessary". - Assessment: 8.2

A. Arkeraats, ANWB - Transact-SQL Basics - MS SQL Server

"The combination of short explanations and assignments I have experienced as very pleasant. The trainer has a pleasant way of transferring the knowledge and processes practical experience through the lesson material". - Rating: 8.0

R. Sleeves, ATEA Group - Transact-SQL Basics - MS SQL Server

"SQL Basis was an excellent training and directly applicable in practice. The trainer is friendly and patient and open. He certainly has knowledge and enjoys being challenged by his students." - Assessment: 8.4

M. Sybesma, GGZ River Dunes, - Transact-SQL Basics - MS SQL Server

"Good basic training to get you started with SQL." - Rating: 8.0

Ed Riemens, APG - Open Learning Form SQL

"Definitely recommended if you work with SQL. Techniques not previously known to me I learned during this training." - Rating: 10.0

A. Puijn, DSV Venlo - SQL Base

"You learn the basic commands to query a database and combine tables. This fitted in perfectly with the issues I encounter in daily practice. I was lucky to meet a class that participated in the training with the same goals. Because of this the pace was high and you didn't have to wait for other students. It is a requirement to have some knowledge of application management and to have questioned databases, so you can translate the content directly into daily practice". - Review: 8.8

P. de Best, Municipality of Westland - SQL Base - Oracle

"Clear explanation of SQL with lots of useful examples and good exercises. It was all good to do and after attending this basic training I gained more than enough knowledge to perform all necessary queries on our database. And that yielded a lot of useful information. In short: Excellent training! - Review: 8.8

V. Young, Kyocera Document Solutions Nederland B.V. - SQL Base

"Great course for when you really get acquainted with this material. There is clear and concise learning material with enough exercises to learn SQL."

- Open Learning Form SQL

"Nice and interesting workout. Clear explanations, examples and assignments. Also nice that the assignments are set as a colleague would set them to you, so you have to think for yourself how you are going to do it. Many functions learned in a short time." - Review: 7.6

Helene Hallebeek, Transavia - Open Learning Form SQL

"Good training when you have no knowledge of SQL. You can get right to work with what you've learned." - Rating: 9.0

F. van Nuland, Sevagram - SQL Base

"The trainer conveyed his knowledge well and clearly. The combination of theory and practice was very pleasant!" - Review: 8.8

P. Biermans, CompuGroup Medical (CGM) - SQL Base

"Without much programming experience, I learned a lot from SQL these two days. If you then look at what query you can make at the end of the second day, you'll actually see the progress you've made during those two days. The trainer paid attention to everyone and he took plenty of time for that". - Rating: 8.0

J. Blow, A.S.R. Insurances - SQL Base

"Very good training that can be applied in practice."

- SQL Basis

"For a good SQL base, this is definitely a training course that is recommended. I also like the way of teaching and practice. What you learn you do immediately to understand it better". - Review: 7.8

M. Amasslam, Quby B.V. - SQL Base

"E. van Herijnen - "Positive impression. Good location, training, exercise material and applicability in practice." - Rating: 7.2"

- SQL Basis

"Fine, short and yet complete basics course."

- SQL Basis

"By gaining basic knowledge of SQL across the board, it helps me in practice to create simple queries and to be able to read and modify more extensive queries. That's exactly what I was looking for. What certainly makes a difference is that the small scale is tailored to the participants". - Assessment: 8.4

J. Citizens, Municipality of Haarlemmermeer - SQL Base

"Good training to take the first step towards SQL connoisseur." - Review: 7.7

Geert Jansen, Van Mossel Leasing - Open Learning Form SQL

"Got a nice explanation of all the basic principles within SQL and its various dialects. Also highly recommended as a refresher course". - Review: 8.9

Erwin Fox, OFGV - Open Learning Form SQL

"Great training. Excellent teacher" - Rating: 9.0

Ernst Lesterhuis, Global Knowledge - SQL Base - Oracle

"Excellent training for basic queries. A clear book with good examples and good structure, the trainer is very skilled. Kept the attention by his way of explaining. Clarifying explanation." - Assessment: 8.2

Anonymous - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"The training is interactive... Within two days you will have a clear picture of the possibilities of SQL". - Assessment: 9.2

C. de Wolff, The Dutch Central Bank - Open Learning Form SQL

"Great training. Excellent teacher" - Rating: 9.0

Ernst Lesterhuis, Global Knowledge - SQL Base - Oracle

"It's a good training for filling in the gaps if you have patchy knowledge, due to on the job learning, like I did." - Rating: 8.0

Laszlo Iliasics, Mapscape B.V. - SQL Base

"Connect very well to the step to being able to see and use SQL. For my work, we're going to have more to do with SQL. For this I needed more insight into SQL from the function of functional administrator. And this has worked out well with the professional training of Learnit Training. This is already my second Learnit training. Given the very wide range of training, I think it will not have been the last". - Rating: 9.0

H. van den Driesche, Evides - SQL Base

"Great course to start as a layman. You will first get acquainted with the software package after which you will immediately get to work on small assignments. allowing me to create small databases and reports." - Assessment: 7.4

J. Kramer, HC Group - SQL Report Builder

"The training is a good stepping stone to continue in SQL. The training will certainly contribute to the more effective performance of work on our Oracle database". - Rating: 7.0

R. Speelmans, Enexis - Oracle Database: SQL Fundamentals part I

"Practical course in which a user/information analyst quickly learns how to unlock (relational) databases using the basic principles of SQL". - Assessment: 8.1

Arthur Wagenaar - Open Learning Form SQL

"My main learning goal was to be able to read and understand queries/scripts better. By writing your own scripts and getting acquainted with a number of possibilities of SQL, this learning objective was certainly achieved. By practicing some scripts yourself, you get some insight and a principle. You have to do something with them yourself and practise at work or at home. Then the dexterity will certainly come". - Review: 7.6

Han Bennink, AFAS Software B.V. - Open Learning Form SQL

"Nice basic training, perfect location (Amsterdam, Muziekgebouw aan 't IJ)." - Assessment: 7.4

S. Buster, The Dutch Central Bank - SQL Base

"Good basic training to get you started with SQL." - Rating: 8.0

Ed Riemens, APG - Open Learning Form SQL

"Useful and practical training for anyone who wants to master the SQL fundamentals." - Rating: 9.0

Daniel van der Krans, Mobile Management & Advice - Open Learning Form SQL

"Briefly and clearly. Lestempo good and to follow. Practical exercises instead of theoretical assignments. The trainer had attention for everyone. Personal and always asking if the material is still understandable. Expert enough and honest about their own knowledge. Learnit Training is professional and service-oriented". - Review: 7.6

T.M. Mingoen, Cobalt - MS SQL Server 2005 Querying

"Very good workout. In two days there is a lot of treatment, but this goes at a pleasant pace. Good alternation of theory and doing exercises yourself. Great trainer, has a lot of knowledge of the material and can convey this clearly and in a pleasant way". - Rating: 9.0

T. Wolfs, NUON - SQL Base

"Great course where the full basics are explained, trainer can also discuss issues that are not within the scope of the course". - Rating: 8.0

A. Reuijl, Grant Thornton - SQL Base

"Good training with an excellent trainer who could give a clear answer to all our questions. Not only theoretical knowledge, but many practical assignments." - Review: 7.6

R. Uters, Efteling - SQL Base

"Training is given on a topic-by-item basis. The number of exercises is discussed, after which you go to work yourself and speak it through. The method appealed to me because of its clarity."

- Open Learning Form SQL

"Good trainer, enough training material. I've achieved my initial goals." - Assessment: 8.4

H. Vranac-Arapovic, Municipality of Breda - SQL Base

"Good clear training, really for building reports for beginners." - Rating: 9.0

D. Hoekstra, NLO - SQL Report Builder

"Recommended for people with little SQL-knowledge, in 2 days the base is fine!" - Assessment: 8.4

W. de Rijke, Delta Energy B.V. - SQL Base

"Good course to bet the basics of SQL!" - Rating: 8.0

Paul Bakker, Randstad Nederland B.V. Headquarters - SQL Base

"The trainer had a lot of experience and thorough substantive knowledge. Excellent training!" - Review: 7.6

J. Green, Kennemerland Police - SQL Base

"Good training with an excellent trainer who could give a clear answer to all our questions. Not only theoretical knowledge, but many practical assignments." - Review: 7.6

R. Uters, Efteling - SQL Base

"Practically applicable in my own work organization." - Assessment: 8.4

S. Greens, Zuidzorg - SQL Base

"Effective training from an experienced trainer with ample knowledge. The trainer was able to switch quickly between people and also focused on the people who needed it without forgetting the others". - Rating: 8.0

J. Heijmink, Norbert Dentressangle - SQL Base

"Very nice training and organization, very satisfied!" - Rating: 9.0

N. Claessens, UWV - SQL Base

"Good training to take the first step towards SQL connoisseur." - Review: 7.7

Geert Jansen, Van Mossel Leasing - Open Learning Form SQL

"Training largely matched the impression I had from the brochure. Excellent trainer who was clear and straightforward; took into account different levels within the group and divided the ratio theory/exercises very well". - Rating: 8.0

T. Koenraadt, AkzoNobel Decorative Paints - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"This training has a clear structure and structure. In addition to theory, there is plenty of room to practice and present practical situations to the trainer. Quiet, qualified and clear trainer. Knew what he was talking about and how the training works. All in all, a good way to get started with SQL." - Rating: 8.6

R. Kemmenaar, Triage-IT - SQL Base