Practical course in which you learn to apply the AI capabilities in and around SQL Server: Copilot in SSMS, Azure OpenAI in T-SQL and vector search in SQL Server 2022.
Free cancellation up to four weeks before the start, so feel free to book now.
In brief. AI for SQL Server is a 1-day classroom course. You can attend it in Amsterdam and The Hague, in a group of no more than 8 participants. The price is € 725,- excl. VAT per participant, including course materials, lunch on site and a certificate of attendance. For a team or department we also deliver this course in-company.
Copilot in SSMS, Azure OpenAI in T-SQL and vector search in SQL Server 2022: the AI options around your database have matured in a short space of time. In this course you apply these techniques to your own data and build a complete AI layer on top of an existing SQL Server.
SQL Server has gained a substantial set of AI capabilities. Copilot in SSMS (preview) generates queries based on natural language, explains existing T-SQL and suggests indexes and query rewrites. In this course you learn to put those features to genuinely productive use, not as a toy but as a day-to-day working environment.
You also connect Azure OpenAI to your database. From T-SQL you call an endpoint, use Machine Learning Services for R and Python and work with the new vector data types in SQL Server 2022. Storing embeddings, running similarity searches and combining results with classic SQL: it is all covered.
You practise in a Learnit test environment with SQL Server 2022 and a connected Azure OpenAI endpoint. That way you work with real data and real AI calls, without first having to set up your own infrastructure.
To finish, you build a complete use case: classifying customer tickets, determining sentiment on text fields and making documents searchable with vector search. Security has a fixed place in this, from preventing prompt injection to shielding data outflow.
For teams and organisations. If you want a database or data team to start with AI in SQL Server together, we also offer this course in-company. The team learns the same approach to security and audit trails around AI calls, and in consultation with you we work with examples from your own practice.
After this course you will work productively with the AI capabilities in and around SQL Server. You use Copilot in SSMS as a fully fledged working partner, connect Azure OpenAI to your database and add vector search to existing tables.
Specifically, by the end you will be able to:
The course is aimed at experienced SQL Server professionals who want to add the new AI capabilities to their toolkit. You work with SSMS and T-SQL on a daily basis and want to know how to apply Copilot, Azure OpenAI and vector search to your own databases.
The course is intended for:
The course is also suitable for technical application administrators and developers in IT departments who manage customer data, tickets or documents in SQL Server and want to apply AI to them, provided you work with T-SQL daily.
The course is entirely hands-on and technical in design. You work in a Learnit test environment with SQL Server 2022 and a connected Azure OpenAI endpoint, so you can get started straight away with real data and real AI functions. Short explanations alternate with practical assignments in which you build your own queries, embeddings and classifications.
Because of the technical depth, we work in small groups of no more than 6 participants. This gives you room for your own questions and personal guidance from the trainer, including on points that are specific to your database environment.
You receive a workbook with a dataset and step-by-step plan, a reference document with code examples and a certificate of participation. By the end you will have delivered a working AI use case, including vector search and classification on customer tickets.
You have solid T-SQL skills, gained in our SQL Advanced course or through equivalent practical experience. You are comfortable working with SQL Server Management Studio and know the basics of relational databases. Prior knowledge of Azure or OpenAI is not required; we cover those from the ground up. Experience with Python is an advantage, not a requirement.
You work on a Learnit laptop with SQL Server 2022 and a connected Azure OpenAI endpoint. Bring your own laptop if you prefer, but this is not necessary.
The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.
Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.
Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.
1 training day. In order of date.
No suitable start date? Send us a date request, and we'll look at the options together.
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
“After taking this course I had a very good impression of SQL and its possibilities. I immediately started developing ideas about applications in my own working environment and those of others. We do know SQL, but only once the basics are clear do you begin to understand what you can do and how to do it. This course was perfect for that.”
“I had never been on a course or training before, and the course and everything around it actually exceeded my expectations.”
“A good course with good materials. I got a solid grasp of the SQL basics in two days. I would recommend doing some preparation beforehand so you pick up the topics better and faster. The trainer was open to questions and explained things well.”
“A good balance between listening and practising. After this course you have a solid basis to get started on your own.”
"It was all explained clearly and enthusiastically. The trainer came across as an expert. We received plenty of attention, but then again we were a small group. It met expectations. I achieved my learning objectives. The location was lovely too (Amsterdam, Muziekgebouw aan 't IJ)."
“The course has given me enough tools to get started with SQL. You gain the experience in practice, but this course gives you enough firm ground under your feet.”
“A course in an informal atmosphere, where personal contact comes first. This way everyone can take in the material at their own pace and there is plenty of room to achieve your goals.”
"This basic course gives a good overview of what SQL is and what you can do with it. Following a logically structured approach, you go from a very simple query to a fairly advanced, in-depth query in two days."
“I have no experience at all with SQL. But the course was explained at a steady pace, so you could master the material. I would recommend it for beginners.”
“Good set-up, sound structure, recommended.”
“Good course with a good trainer! I now have the basics under control and can keep practising with the material provided.”
“If you would like to learn the basics of SQL, this course really comes recommended.”
“Excellent course with plenty of depth added to the basic material by a professional trainer.”
“Excellent course, easy to follow. The content met my expectations. The knowledge was conveyed in a very pleasant way.”
“Good course with clear explanations at a calm pace. Also manageable without prior knowledge.”
“The content met my expectations. Gaining basic SQL knowledge. The trainer was very knowledgeable and also gave plenty of good tips.”
“The course largely matched the impression I had from the brochure. Excellent trainer who was clear and to the point; took account of the different levels within the group and struck a good balance between theory and exercises.”
“You learn the basic commands for querying a database and combining tables. This tied in perfectly with the issues I come across in my daily work. I was lucky to be in a class where everyone took part with the same goals. As a result the pace was high and you didn't have to wait for other participants. It is a requirement to have some knowledge of application management and database querying, so that you can translate the content straight into daily practice.”
“Interesting and practical course. The trainer responded quickly to the feedback given, which made it feel even more like a tailor-made course!”
“If you have no experience with sql and would like to learn the basics, this course is a good start! Now I know a bit about what sql involves.”
“You get value for money. And you leave with the knowledge to write your own SQL statements.”
“A good course for anyone who wants to feel, in just 2 days, that they understand SQL and can start using it with confidence.”
“The course largely matched the impression I had from the brochure. Excellent trainer who was clear and to the point; took account of the different levels within the group and struck a good balance between theory and exercises.”
“This is an excellent programme for learning the basics of SQL!”
“Valuable course with highly capable trainers, at a pleasant location.”
“A good course that you can put to plenty of use in practice.”
“The course material is clear and of a good standard. The exercises are clear with sufficient and progressive depth, and the trainer is calm and competent.”
“A clear training course with plenty of useful tips.”
“Received a good explanation of all the basic principles within SQL and its various dialects. Highly recommended as a refresher course too!”
“A course with a good pace. Pleasant alternation between plenary treatment of the material and doing individual exercises. Excellent value for money if you want to start working with SQL in practice.”
“Clear explanations and good exercises gave a good picture of what SQL can do.”
“Clear explanation of SQL with plenty of usable examples and good exercises. It was all very manageable and after following this basic course I have gained more than enough knowledge to run all the queries we need on our database. And that has produced a lot of useful information. In short: an excellent course!”
“A course that brings you up to a level within two days from which you can then get to work in practice yourself. The content of the course matched my expectations very well. I now have a good grasp of the basics of the SQL language.”
“A good course for learning the basic principles of SQL. Plenty of practical exercises, so you get to grips with SQL quickly. It was led by a good trainer who took the time to explain things. Teaches with enthusiasm. A sociable and friendly person. Learnit Training is a professional organisation, customer-focused and with good, fast service.”
“I would like to move into an IT role, preferably one involving working with databases. As a maintenance engineer with an above-average interest in MS Access, I found this trainer reasonably easy to follow. The content was clear, with practical exercises. Well balanced.”
“This basic course met my expectations. The trainer was knowledgeable and relaxed, with plenty of individual attention where needed.”
“My first introduction to SQL in this SQL Basics course. Good, clear explanation of the material. Plenty of exercises to put the material into practice straight away, and an enthusiastic trainer make this course a recommendation for anyone who wants to know more about SQL.”
“An excellent course to start with as a complete beginner. You first get to know the software package and then get straight to work on small assignments. As a result, I am now able to create small databases and reports.”
“A useful and practical course for anyone who wants to master the SQL fundamentals.”
“Enjoyable course that will be very useful if you want to get started with SQL.”
“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.”
“Excellent training with a lot of information realized by experienced and professional teachers. I wish it lasted longer, so I could learn even more that I did. I recommend it without any hesitation. Learnit Training is a professional company, they are doing what they promise. Their teachers are profesionals who know what they are talking about.”
“Good course to bet the basics of SQL!”
“The course is interactive. Within two days you have a clear picture of the possibilities of SQL”
“Very good training course. A lot is covered in two days, but still at a comfortable pace. Good alternation between theory and doing exercises yourself. Excellent trainer, has a great deal of knowledge of the subject and is able to convey this clearly and in a pleasant way.”
“Useful in the organisation where I work”
“Very good course for learning how to build basic queries. Clear book with good examples and a good structure. The trainer is highly knowledgeable. His way of explaining things held our attention. Clarifying explanations.”
“Good set-up, sound structure, recommended.”
“Very good, the trainer had a lot of knowledge. Good examples. Room for questions.”
“The trainer sets a good pace for beginners, keeps your attention and is extremely clear in the way he communicates. As a result you remember everything better and stay motivated!”
Yes. Up to four weeks before the first day of the course you can cancel free of charge, without giving a reason. You then receive a credit note or, if you have already paid, a refund. If you cancel later, you pay part of the course fee: 25% between four and two weeks before the start, 75% in the two weeks before it and 100% in the final week. Moving to another start date is free of charge up to two weeks before the start, after that 50%. Sending a colleague in your place is always possible. Read the cancellation terms.
You can find the current price at the top right of this course page, along with the schedule, location and delivery format. For in-company or bespoke courses we are happy to provide a quotation on request.
You have solid T-SQL skills and are comfortable working with SQL Server Management Studio. You can reach that level, for example, with our SQL Advanced course or through equivalent practical experience. Prior knowledge of Azure or OpenAI is not required; we cover those from the basics. Experience with Python is a plus for the Machine Learning Services part, but not a requirement.
The course is intended for SQL Server database administrators, data engineers, BI developers and application developers who work with T-SQL and want to increase their productivity with AI. Data architects who want to determine strategically how AI functions fit within their data platform will also find the right depth here. You do not have to be a data scientist: the starting point remains SQL Server.
You learn to use Copilot in SSMS (preview) to generate queries based on natural language, have existing T-SQL explained and request optimisation and index suggestions. You ask schema questions to quickly find the right tables and relationships, and you use Copilot to decipher error messages. The emphasis is on working productively, not on demos.
Yes. In addition to classroom groups at our locations, we also offer the course in-company and online. For in-company courses we are happy to work with a test environment that matches your own SQL Server version and Azure tenant. Request a proposal via the course page and we will think along with you about the content.
Yes. If you have attended the course in full, you receive a certificate of attendance from Learnit. This is proof that you took an active part in the day and covered the topics dealt with. It is not an exam certification.
The course is entirely hands-on. Short explanations alternate with practical assignments in a Learnit test environment with SQL Server 2022 and a connected Azure OpenAI endpoint. You receive a workbook with a dataset and step-by-step instructions, plus a reference document with code examples that you take back to your own workplace afterwards. With a maximum of 6 participants per group, there is room for your own questions.
Separate experiments with ChatGPT quickly give you a feel for prompts, but not for the integration in SQL Server itself. In this course you work with the built-in Copilot in SSMS, with a real Azure OpenAI connection from T-SQL and with vector search in SQL Server 2022. These are architectural choices and security questions that you will grasp more quickly in a single guided day than in weeks of self-study.
You can use Copilot in SSMS to write queries faster and document existing code. You can connect an Azure OpenAI endpoint to your database and from there classify text fields, analyse sentiment or make documents searchable with embeddings. The complete use case you build during the course day serves as a blueprint for your own environment.
The SQL Advanced course focuses on advanced T-SQL: subqueries, window functions, stored procedures and performance tuning without AI. This course builds on that and adds the AI layer: Copilot, Azure OpenAI, Machine Learning Services and vector search. The SQL Advanced course is good preparation if you want to sharpen your T-SQL level first.
Yes, provided you have solid T-SQL skills. BI developers get a great deal out of the sections on sentiment analysis, customer segmentation and document search: these are exactly the enrichments you can then visualise in Power BI. The course itself focuses on the SQL Server side of that enrichment, not on Power BI reporting.
Security has a fixed place. You learn how prompt injection works, how to separate user input from instructions and how to prevent sensitive data from flowing to the OpenAI endpoint unintentionally. We also cover setting up audit trails, so you can look back afterwards at which AI calls were made and with which data. That way you remain demonstrably in control, even when you put AI into production.
Free cancellation up to four weeks before the start, so you can secure a place now.