Course Code: TSQL
Duration: 5 days
Our training courses can also be delivered at a location of your choice...
The Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language and more as implemented by Microsoft SQL Server. The course is designed to give delegates practical experience in writing Transact-SQL statements by hand using the SQL Server Management Studio (SSMS) development environment. The basic Transact-SQL statements, including the use of many built-in Transact-SQL functions will be covered along with more advanced coding techniques required by Database Administrators, Database Developers and BI professionals. 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 up to version 2016.
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 exams:
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 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.
Microsoft SQL Server with Transact-SQL
Duration: 5 days
RRP: £1,750.00 exc. VAT
|06 Jan 2020||Limited||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|
|05 Oct 2020||Spaces||Book|
|16 Nov 2020||Spaces||Book|
Thoroughly enjoyed this course. Very helpful and extremely informative and very relevant to my work. The five day course was hugely beneficial and I am glad I completed the 3 day and 2 day course consecutively. The workshops broke the chapters up perfectly.
Amy - Utilities - November 2019
Enjoyed the course - the trainer was very helpful & knows what he's talking about
Daniel - Data Analyst - Finance
Excellent, well-run course - delivered with enthusiasm by an excellent trainer. Good facilities too.
Mike - Government
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