T-SQL Coding Specialist Certification

Candidates for this exam are SQL Server database administers, system engineers, and developers who want to validate their skills and knowledge in writing queries using Transact-SQL. This certification will prove mastery of Transact-SQL data management, database programming and queries.

Prior to taking the exam, a candidate is expected to have approximately 150 hours of hands-on experience or lectures with programming using T-SQL.

Candidates should also have the following experience:

• Reviewing and optimizing the performance of a Query.
• Designing and developing tables aiding to the principles and architecture required.
• Articulate experience in designing programming views, procedural and transactional programming
• Understanding the implementation of a cloud with a database can be an added advantage.

Skills Measured:

1. Operate data with Transact-SQL
2. Query data with Transact-SQL components
3. Manage databases using Transact-SQL

1. Operate data with Transact-SQL

• Sort data
  • The ORDER BY clause
• Work with Set operators
  • UNION ALL
  • INTERSECT
• Work with the CASE statement
  • Normal case and searched case
• Apply looping
  • WHILE
• Apply String operations
  • the LIKE operator
  • the BETWEEN operator
  • REPLACE function
• Program User Defined Functions
  • The Create Function command

2. Query data with Transact-SQL components

• Use aggregate functions
  • COUNT
  • MAX
  • GROUP BY
• Create subqueries
  • Correlated subqueries and uncorrelated subqueries
• Use Table Expressions
  • Common Table Expressions
  • Derived tables
• Apply WINDOW functions
  • the ROWNUMBER(), RANK() and DENSE_RANK() function LAG
• Update data
  • the UPDATE in combination with the SET keyword
• Work with PIVOT
  • Derived tables
• Use XML exports
  • The FOR XML command and its options
    

3. Manage databases using Transact-SQL

• Establish links between tables
  • Use correct JOIN type
• Use DDL Commands
  • the Create Table command
  • use correct GUIDS
  • The Create View command
• Work with NULL values
  • the COALESCE function
  • IS NULL
• Apply conversion functions
  • The DATETIMEOFFSET datatype
  • CAST / CONVERT / TRY_CAST / TRY_CONVERT
• Use Exception handling
  • The THROW command
• Use Transactions
  • The COMMIT command
  • CONCURRENCY keywords

Everyone can achieve more with practice!

T-SQL Coding Specialist Practice Test by Knowledge Pillars offers aspiring and professional database administrators, system engineers, and developers the ability to assess their knowledge and prepare for the TCSC international certification exam. This assessment performed live-in-the-app combines a variety of Parsons programming puzzles, drag-and-drop matching and multiple-choice question types. You can also choose the objective domains you want to practice. Those students who sign-up and practice frequently are guaranteed to pass their international certification exam. 

Each time you complete a practice test round, you receive a full performance and score report to help you focus on the exam domain objectives that require more practice. You can use the practice test as many times as you like within 90 days and observe how you improve by comparing your previous performance and score reports.

Practice Test Details

Number of questions: 120
Access Limit: 90 days
Format: Linear and Live-in-the-App
Modes: Real Test and Practice Test

Get Practice » (coming soon)

If you’re ready to get T-SQL certified, all you need to do is follow the steps below:

• register on Knowledge Pillars and create your account,
• purchase your exam voucher from the Knowledge Pillars webshop,
• you will receive email instructions on how and where to take the exam, be sure to check your email SPAM and add Knowledge Pillars to your email contact list.

Once you have passed your T-SQL exam, you will get a confirmation email from Knowledge Pillars informing you where and when you will access your digital transcript and digital certificate.

Please view our Exam Policies for more information.

IMPORTANT: Knowledge Pillars Certifications are available through remote proctoring. Scheduling instructions will be provided in the order confirmation e-mail. Please contact our support for more information: support@knowledge-pillars.com