fbpxl

Transact-SQL Courses

T-SQL is Microsoft’s dialect of SQL. SQL (Structured Query Language) is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements. 

T-SQL is a very rich and complex scripting language offering you a great degree of flexibility in how you use it. Most programs focus on the graphical user interface as a mechanism for enabling data entry. While you can enter data into SQL Server using GUI-based interfaces, you can manipulate SQL data with Transact-SQL (T-SQL). 

The popularity of Microsoft SQL Server makes knowing the T-SQL language an excellent addition to your CV. Thousands of IT job postings include experience with T-SQL as a job requirement. Whether you are exploring a career as a business intelligence analyst, IT developer, SQL programmer, data analyst or developer, learning T-SQL can help. 

Find out which T-SQL course suits you best! 

Check in a piece of paper the following affirmative sentences: 

V

I understand the logic behind T-SQL and thinking in terms of sets.

V

I understand Logical Query Processing and its relevance to writing correct and robust T-SQL code.

V

I write queries against a single table applying filtering, grouping and sorting of data.

V

Write queries against a single table applying filtering, grouping and sorting of data.

V

I write queries against single and multiple tables.

V

I understand the logic behind T-SQL and thinking in terms of sets.

V

I understand Logical Query Processing and its relevance to writing correct and robust T-SQL code.

V

Write queries against multiple tables using joins, subqueries, APPLY and set-operators.

Get your results!

If you didn´t check that many boxes… then you need the TSQL Fundamentals Course! 

VIEW MORE INFO 

Did you check most of them? Then consider the advanced TSQL Course 

VIEW MORE INFO 

 

Fairly familiar with TSQL? Check the T-SQL Fundamentals course

 

This course is intended both for people who just started working with SQL Server, as well as those with some experience. If you are self-taught, and gained your knowledge “by the seat of your pants,” this course can fill the gaps in your knowledge and teach you how to think correctly in SQL terms. This course doesn’t get into performance discussions and advanced problems* rather focuses on the logical aspects of T-SQL. Note though that it is not merely a step-by-step course. It doesn’t just focus on syntactical elements of T-SQL, rather explains the logic behind the language and its elements. It’s recommended to be familiar with basic relational database concepts and SQL.

Many SQL intro/fundamentals classes only teach you about the language elements and how to use them. However, not focusing on their mathematical roots or why the language elements were designed the way they were designed. This course teaches you both. It emphasizes the unique elements of SQL and the mindset you need to adopt, like thinking in relational terms; thinking of a set as a whole, with no ordering; what the language guarantees and what it doesn’t; common pitfalls and bugs, and best practices to avoid them.

Delivery options:

Following this T-SQL Fundamentals course, you will be ready to take our Advanced T-SQL course, if you want to go deeper in this path.

Already know the basics and the fundamentals?

Let´s try the same exercise as before, checking those boxes of the things you can do already: 

V

I understand logical query processing and SQL Server’s internal data structures.

V

I am able to analyze & tune query performance, and analyze query execution plans.

V

I can handle data and time data, including intervals.

V

I can describe performance problems related to use of user defined functions and possible workarounds.

V

I can describe the changes between the legacy and new cardinality estimators.

V

I am able to solve complex querying and programming tasks.

V

I can create system-versioned temporal tables.

V

I can think of terms of sets, and be able to compare set based and iterative solutions.

V

I am able to migrate on-disk data to memory-optimized data.

If you didn´t check many of the boxes, then Advanced TSQL Course is the right one for you!

VIEW ADVANCED COURSE

If you checked most of them, then CONGRATULATIONS! You are almost an Itzik Ben-Gan yourself!
However, if you are looking for TSQL Courses and these don´t match your criteria… Talk to us! We can help you and your team!

 

  • By submitting this information, you acknowledge that you have read the Privacy Policy and that you consent to our data processing in accordance with this Statement.

 

Invite & Earn

X
Signup to start sharing your link
Signup