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

All applications work with date and time at some point. Fortunately, we do not have to reinvent the wheel and write our own functions when working with date and time in MS SQL Server. T-SQL has a number of functions for this purpose.

## Current date and time

We can check the current date and time by looking at the system clock. The `GETDATE()` function returns an object of type `DATETIME`, which will show the local date and time according to the system clock:

All applications work with date and time at some point. Fortunately, we do not have to reinvent the wheel and write our own functions when working with date and time in MS SQL Server. T-SQL has a number of functions for this purpose.

# Current date and time

We can check the current date and time by looking at the system clock. The `GETDATE()` function returns an object of type `DATETIME`, which will show the local date and time according to the system clock:

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

Date and Time Functions

Current date and time