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
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 organiseren deze training ook online. Hiervoor maken we gebruik van Webbex of Zoom. Inloggen met Skype is ook mogelijk. Op verzoek kan deze training ook met Microsoft Teams worden georganiseerd.

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.

"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

"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

"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

"Good training with which you can do a lot in practice." - Assessment: 8.2

R. Doctor, AM Group - SQL Base

"Thanks to the amount of practice and the pleasant way of teaching, this training is extremely suitable for quickly acquiring basic knowledge of SQL". - Review: 8.8

R.C.C.F. Baijens, Kluwer - SQL Base

"The SQL training provides insight into creating queries from databases. During the lessons you will learn how to build a query. During the lessons the theory is first discussed and then carried out with a practical assignment. This is very fun and educational." - Rating: 9.0

G.J. Leferink, Elementis Delden - SQL Base

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

D. Hoekstra, NLO - SQL Report Builder

"The trainer has a lot of knowledge of the matter. He showed homemade examples, which were very interesting. He was going to fully explain these examples. I learned a lot from this and got motivated." - Assessment: 8.4

Anonymous - Writing queries using Microsoft SQL server 2008 Transact-SQL

"Good training. Very clear and applicable. You learn all the facets of SQL." - Rating: 8.6

K. Sijne, AB Vakwerk - SQL Base

"Valuable training with highly skilled trainers, in a pleasant location." - Rating: 8.6

J.J.M. Sanders, Province of Limburg - Oracle Database 10g: SQL foundations 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

"Nice training that's gonna help you a lot if you want to work with SQL." - Assessment: 8.4

R. de Munck, Municipality of Amersfoort - SQL Base

"Good training. Good to follow. The content met my expectations. The transfer of knowledge took place in a very pleasant manner." - Rating: 9.0

Ton van der Velden, Rijkswaterstaat (RWS) - SQL Base

"Very easy to follow especially for people who want to start with SQL. Suitable for both IT and non-IT professionals. Highly recommended!" - Assessment: 7.4

M. Thakoer, NN Group N.V. - SQL Base

"Had good training with good material. Got the basics of SQL well mastered in two days, it may be advisable to do something to prepare in advance to tackle the topics better and faster. The trainer was open to questions and gave a good explanation". - Review: 7.8

R. Direction Blenke, ProQuro Services - SQL Base

"I met my expectations." I can read at least one SQL scripts. Creating yourself is also good for simple things. "

Thata van Meerwijk, Albeda College - Open Learning Form SQL

"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

"Good clear training where the basics of SQL are explained."

- SQL Basis

"Had good training with good material. Got the basics of SQL well mastered in two days, it may be advisable to do something to prepare in advance to tackle the topics better and faster. The trainer was open to questions and gave a good explanation". - Review: 7.8

R. Direction Blenke, ProQuro Services - SQL Base

"Do you have an affinity with ICT, but no experience with SQL yet, then this course is perfect to learn this". - Review: 8.8

J. Witvoet, S.R.S. B.V. - SQL Base

"Got refreshed with my sql skils" - Rating: 6.0

Tejasvi Sabale, Mapscape B.V. - SQL Base

"Nice training that's gonna help you a lot if you want to work with SQL." - Assessment: 8.4

R. de Munck, Municipality of Amersfoort - 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

"This trainer is a very knowledgeable person who communicates the material of the training to the participants in a calm, well-considered and thorough way.

- SQL Basis

"I'm positive. I don't feel like I'm getting lost in other people's queries. For my job it is not a requirement to make queries, but it is a requirement to make a small adjustment every now and then to generate output". - Assessment: 7.4

J. van de Putte, CIBG - 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

"A training in an informal atmosphere, where personal contact is paramount. In this way, everyone can take in the dust at their own pace and there is enough room to achieve your goals". - Assessment: 8.2

J. Koopmans, Roba Mentals B.V. - 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

"Good relationship between presentation and doing assignments yourself. Good variation in the level of difficulty of the assignments, there were some nice challenging ones. The trainer had a lot of knowledge and explained well how to tackle a problem in a structured way". - Review: 8.8

S. Rodewijk, NUON - Oracle Database: SQL Fundamentals part I

"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

"This training is ideal for people who are going to work with SQL databases. A lot is explained, tempo is never too low. All kinds of queries are dealt with, as well as the cross use of types. Recommended!" - Assessment: 8.2

J. the Great, Kemira - SQL Base

"A good basic course in which my knowledge has improved 100%. Good subject matter, quiet pace and excellent assignments. Highly recommended as a basic SQL course." - Assessment: 8.2

R. Wolters, DSV Venlo - SQL Base

"The training exceeded my expectations, highly recommended. The trainer had a lot of knowledge."

- SQL Report Builder

"An SQL course that can be followed by anyone without any programming experience by means of a piece of theory with subsequent assignments. In small groups allowing personal interaction with the trainer". - Review: 8.8

S. Grootendorst, PSfm B.V. - SQL Base

"SQL is a language. The training teaches you how to read and understand this language and how to use it to tell a simple story. The location (Amsterdam, Muziekgebouw aan het IJ) was great - top location, with all the necessary facilities, hospitality, a bit of the feeling of home. Learnit Training met my expectations - approachable, good dialogue, no unnecessary waiting time, good information supply, clear". - Assessment: 7.4

K. Gnezda Meijer, Diebold - 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

"It was all explained clearly and enthusiastically. The trainer came across as an expert. We got enough attention, but we were also with a small club. Satisfied expectations. I've achieved my learning goals. It was also a beautiful location (Amsterdam, Muziekgebouw aan 't IJ)". - Rating: 8.0

J. Hensbroek, IDS - SQL Base

"Good training. Good to follow. The content met my expectations. The transfer of knowledge took place in a very pleasant manner." - Rating: 9.0

Ton van der Velden, Rijkswaterstaat (RWS) - SQL Base

"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

"If the preparations are good and tailored to the organization (type/type) of the client, this can be an excellent course for most essential SQL statements". - Review: 6.7

John van Enst, Municipality of Groningen - SQL Continued

"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

"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

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

Geert Jansen, Van Mossel Leasing - 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

"SQL Basic Oracle is a training that I can confidently recommend. The practical applicability is very great! - Rating: 8.6

N. Meijer. Rijksdienst voor Ondernemend Nederland - SQL Base - Oracle

"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

"The teaching material is clear and of a good level. The assignments are clear with sufficient and constructive depth and the trainer is calm and competent". - Assessment: 8.2

Anonymous - SQL Report Builder

"The SQL course was very instructive. The course was brought in a fun way by a trainer who has a lot of knowledge. All the basic functions of SQL have been offered step by step so that I can certainly continue with them within my company". - Rating: 8.6

Nicky Tulip, ENOT bv - Open Learning Form SQL