Gain insights into T-SQL syntax, table creation, data manipulation, and relationships. Delve into advanced constructs like stored procedures, functions, and triggers to enhance your database development skills.

tsql.tar.gz

T-SQL-SPA

T-SQL is a dialect of SQL that is used in Microsoft SQL Server. The popularity of Microsoft's database management system sustains high market demand for people well versed in T-SQL. 

This course teaches the core concepts and syntax of T-SQL. First, you will learn how to create tables, insert data, update existing records, and create relationships between tables. Then, you will be exposed to more advanced constructs of T-SQL, like stored procedures, functions, and triggers. 

By the end of the course, you will be sufficiently adept with T-SQL and be able to perform your day-to-day tasks as software and database developers effectively.

Querying Databases Using Transact-SQL

Not all errors cause a transaction to roll back and cancel all the commands it contains. For example, if a timeout occurs on the client’s side, there will be an error, but changes made prior to the timeout will be saved. Also, errors related to constraint violation do not make the transaction roll back, by default.

## Example: Constraint violation

Let's try setting `NULL` to a column that does not allow `NULL` values:

Not all errors cause a transaction to roll back and cancel all the commands it contains. For example, if a timeout occurs on the client’s side, there will be an error, but changes made prior to the timeout will be saved. Also, errors related to constraint violation do not make the transaction roll back, by default.

# Example: Constraint violation

Let's try setting `NULL` to a column that does not allow `NULL` values:

Learn how to roll back the changes in case of errors within transactions.

Before We Start

T-SQL Basics

Querying Multiple Tables

Grouping and Aggregation

Subqueries

T-SQL Fundamentals Assessment

Built-in Functions

T-SQL Programming Basics

Additional Programming Constructs

Course Comprehension Assessment

Conclusion

Transaction Rollbacks

Example: Constraint violation