Course Code: TSQLA
Duration: 2 days
Our training courses can also be delivered at a location of your choice...
The Advanced Querying Microsoft SQL Server with Transact-SQL course is designed to give delegates practical experience in using more complex Transact-SQL techniques. This course covers Microsoft SQL Server up to version 2016.
The delegate will learn and acquire skills as follows:
IT Professionals and non-technical 'power users' who are required to implement more complex Transact-SQL queries.
To provide more advanced coding skills for those already familiar with using basic Transact-SQL or as a follow-on course for those who have previously attended the Querying Microsoft SQL Server with Transact-SQL course.
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.
A working knowledge of SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite Querying Microsoft SQL Server with Transact-SQL course.
Advanced Querying Microsoft SQL Server with Transact-SQL
Duration: 2 days
RRP: £750.00 exc. VAT
|09 Jan 2020||Limited||Book|
|20 Feb 2020||Spaces||Book|
|02 Apr 2020||Spaces||Book|
|21 May 2020||Spaces||Book|
|02 Jul 2020||Spaces||Book|
|20 Aug 2020||Spaces||Book|
|08 Oct 2020||Spaces||Book|
|19 Nov 2020||Spaces||Book|
Very interesting and enjoyable course, a considerable step-up from the initial T-SQL course which was very welcome. Small class sizes mean there's plenty of chance for direct interaction with the lecturer who was more than helpful. The first course is really good; the advanced course is even better.
Milo - Market Analyst - Utilities - March 2019
The trainer went above and beyond to make the course as applicable and accessible as possible.
Claire - Senior Commercial Analyst - Retail / Hire
I thought this course was very useful. It showed me what is possible in SQL using techniques I did not know about beforehand. I feel better prepared to write SQL in the future.
Pernilla - Retail / Hire
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