Transact-SQL Basis - MS SQL Server incompany
A two-day course just for your group. You choose the date and the place, and the trainer tailors the content to your practice beforehand.
NRTO quality markEerder gevolgd door medewerkers van Alfa Accountants en Adviseurs, GGZ Rivierduinen, ANWB, ATEA-Groep.
- Tailored: matched to the level and goals of your team
- Trainers from the field, who do the work themselves
- At your premises, at ours or online, on a date that suits you
- In Dutch or English, in the language of your choice
What the course covers
You work with data in Microsoft SQL Server and want to be able to write your own queries. In this course you will learn the building blocks of T-SQL: from simple SELECT statements to joins, groupings and subqueries.
Lees het volledige programma van Transact-SQL Basis - MS SQL Server
How an in-company course works
- RequestYou tell us which course it concerns, how many people and roughly when. You receive a quotation with a fixed price for the group.
- AlignmentWe discuss what the group can already do and what should be different afterwards. The trainer adapts the examples and exercises accordingly.
- The courseOn the day and at the place you chose, with course materials for every participant.
- AfterwardsEvery participant receives a certificate of attendance.
Practical information
- Duration
- Two-day course
- Group
- Only your own people
- Location
- At your office, at one of our locations or online
- Date
- You choose
- Language
- Dutch or English
- Included
- Course materials and a certificate of attendance
- Price
- Fixed price per group, in a tailored quotation (scheduled course: EUR 1100 excl. VAT per participant)
Wat deelnemers zeggen over Transact-SQL Basis - MS SQL Server
Transact-SQL Basics course - MS SQL Server: average of 8.6 from 4 reviews
“This course teaches you in 2 days what SQL is, how you can use it and what the well-known mistakes are. The trainer is highly professional and has a great deal of knowledge of the subject.”
“SQL Basics was an excellent course and immediately applicable in practice. The trainer is friendly, patient and open. He certainly knows his subject and enjoys being challenged by his participants.”
“This basic course met my expectations. The trainer was knowledgeable and relaxed, with plenty of individual attention where needed.”
“I found the combination of short explanations and exercises very pleasant. The trainer has an agreeable way of conveying knowledge and weaves practical experience into the course material.”
Veelgestelde vragen over Transact-SQL Basis - MS SQL Server incompany
Waar vindt de incompany training Transact-SQL Basis - MS SQL Server plaats?
Wherever suits you: at your office, at one of our training locations or online. You also choose the date.
Can the content be tailored to our organisation?
Yes. Before the course we discuss with you what the group can already do, where things go wrong in practice and what should be different afterwards. The trainer uses examples and exercises from your own work.
How large can the group be?
That depends on the course. For a skills course we prefer to work with a small group, so that everyone can really practise. If more people are involved, we schedule several groups or set up a fixed programme.
Wat kost Transact-SQL Basis - MS SQL Server incompany?
You receive a fixed price for the whole group, in a tailored quote. For a group this works out cheaper than booking everyone individually. By way of comparison: a place on the scheduled course costs € 1100,- excl. VAT per participant.
Can the course be delivered in English?
Yes. For in-company courses we deliver the training in the language of your choice, Dutch or English. Mention it in your request.
Do participants receive a certificate?
Yes, every participant receives a certificate of attendance afterwards.
How do I request a quote?
Via the quote form: state the course, the number of participants and roughly where and when you would like it. An adviser will then contact you.
What is Transact-SQL and how does it differ from standard SQL?
Transact-SQL (T-SQL) is Microsoft's SQL variant for SQL Server. It contains all the standard SQL commands such as SELECT, INSERT and JOIN, and adds extra capabilities for logical blocks, variables, error handling and procedural programming. This allows you to run more complex logic directly in the database with T-SQL.
Do I need prior knowledge to take this course?
No, you do not need any specific prior knowledge of SQL or databases. An affinity with data and logical thinking is useful, however, as you will be working with queries and relationships between tables.
Who is this T-SQL course intended for?
The course is intended for beginning users of Microsoft SQL Server. Think of data analysts, BI professionals, junior database managers and administrators, report builders and software developers who want to be able to write their own queries.
Which software is used during the course?
You work with Microsoft SQL Server and SQL Server Management Studio (SSMS). The software and the course material are in English; the explanations are in Dutch.
What exactly will I learn during the?
Day one focuses on the basics: SELECT statements, filtering, sorting and simple calculations. Day two goes deeper into functions, grouping, subqueries, joins between tables, UNION and data manipulation with INSERT, UPDATE and DELETE. You also manage tables with CREATE, ALTER and DROP.
Do I receive a certificate on completion?
Yes, on completion you will receive the Learnit certificate of participation. This demonstrates that you have completed the Transact-SQL Basics course.
Is this course also suitable as a stepping stone to advanced SQL?
Yes. After this basic course you will have mastered the building blocks you need for follow-up courses on advanced T-SQL, database development or business intelligence with SQL Server.
Can I also take this course in-company?
Yes, in addition to the scheduled courses you can also follow this course in-company, on location or online. We then tailor the content and examples to the working practice within your organisation. Request a quotation for the options.
Transact-SQL Basis - MS SQL Server voor jullie team?
Vraag vrijblijvend een offerte aan, je hoort snel van een adviseur. Met een of twee collega's? Transact-SQL Basis - MS SQL Server staat het komende jaar 13 keer open gepland, in Amsterdam, Den Haag, Utrecht, Rotterdam, Eindhoven, Arnhem, Groningen, Zwolle.