Course Code: TSQLI
Duration: 3 days
Our training courses can also be delivered at a location of your choice...
The Querying Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language as implemented by Microsoft SQL Server. The course is designed to give delegates practical experience in writing Transact-SQL statements using the SQL Server Management Studio (SSMS) development environment. The basic Transact-SQL statements, including the use of many built-in Transact-SQL functions are covered on this course. This course covers Microsoft SQL Server up to version 2016.
The delegate will learn and acquire skills as follows:
Anyone who needs to access and work with a Microsoft SQL Server Database.
To provide the Transact-SQL (T-SQL) coding skills needed to query and modify data held within a Microsoft SQL Server database.
This course will cover some of the topics required for exam:
Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience. The Microsoft website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
There are no formal pre-requisites for the Querying Microsoft SQL Server with Transact-SQL course, although an understanding of databases and exposure to information technology in general would be useful. This knowledge can be gained by attendance on the Relational Databases & Data Modelling Overview course.
Querying Microsoft SQL Server with Transact-SQL
Duration: 3 days
RRP: £1,125.00 exc. VAT
|23 Sep 2019||Limited||Book|
|11 Nov 2019||Limited||Book|
|06 Jan 2020||Spaces||Book|
|17 Feb 2020||Spaces||Book|
|30 Mar 2020||Spaces||Book|
|18 May 2020||Spaces||Book|
|29 Jun 2020||Spaces||Book|
|17 Aug 2020||Spaces||Book|
I really enjoyed the course, being a complete beginner it gave me confidence to take it back to the workplace. It was explained in a manner that I could understand and grasp.
Joanne - Analytic Support - Government - September 2019
The instructor was very knowledgeable and was more than happy to go into more detail on any of the courses topics - even exposing us to some more advanced material at the end. The course handbook was extremely useful and I will certainly be referring back to it when using SQL for work. Would certainly consider doing the follow on advanced TSQL course.
Milo - Market Analyst - Utilities - January 2019
Course was well paced, catered for a varying range of abilities. I never found myself bored or uninterested.
Samuel - Sales Office Manager - January 2019
The trainer was excellent. He provided greater insight into the different SQL's and what queries and functions would be appropriate to each system. He answered questions very greater ease unlike some courses. He showed other approaches in dealing with issues on SQL. In all, the trainer's approach to this course was excellent.
David - Market Analyst - Utilities - October 2018
Well structured and well paced. Engaging instructor with a good balance of practical work and theory.
Katie - Data Analyst - Academic
Public Scheduled and Closed
UK and Overseas
Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.
Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!
Our Course Curriculum