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

What date is the result of the following query?

```SQL
SELECT DATEADD(day, LEN('Mark') + LEN('Walter'), '2022-09-20')
```

What date is the result of the following query?
<pre><code class="language-SQL">SELECT DATEADD(day, LEN('Mark') + LEN('Walter'), '2022-09-20')
</code></pre>

```SQL
SELECT DATEADD(day, 70, GETDATE());
```

```SQL
SELECT DATEADD(hour, 1800, GETDATE())
```

```SQL
SELECT DATEADD(minute, 1800, GETDATE())
```

```SQL
SELECT DATEADD(day, 75, GETDATE())
```

**(Select all that apply.)** Select the option(s) that calculate a date and time that is 1800 hours after the current date and time.

(Select all that apply.) Select the option(s) that calculate a date and time that is 1800 hours after the current date and time.

Which query is not a valid way to convert an object from one data type to another?

Which query is not a valid way to convert an object from one data type to another?

```SQL
SELECT TRY_CONVERT(INT, 'Hello World!')
```

```SQL
SELECT ISNULL(TRY_CONVERT(DATETIME, 'February 24'), NULL)
```

```SQL
SELECT COALESCE(NULL, 27, NULL, NULL)
```

**(Select all that apply.)** Which option(s) will return `NULL`?


(Select all that apply.) Which option(s) will return <code>NULL</code>?

What is the result of the following query?

```SQL
SELECT LEN(RTRIM(LTRIM('   Some text surrounded by spaces   '))) / 2
```

What is the result of the following query?
<pre><code class="language-SQL">SELECT LEN(RTRIM(LTRIM(' Some text surrounded by spaces '))) / 2
</code></pre>

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

Quiz Yourself: Built-in Functions