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

Views are tables with extended functionality.

Views can be thought of as reusable `SELECT` queries.

**(Select all that apply.)** Which statement(s) are true about views? 


(Select all that apply.) Which statement(s) are true about views?

```SQL
DECLARE @SomeDate AS DATETIME
SET @SomeDate = '2022-10-10 12:15:00'
```

```SQL
DECLARE @SomeDate = '2022-10-10 12:15:00'
```

```SQL
DECLARE @SomeDate
SET @SomeDate = '2022-10-10 12:15:00'
```

```SQL
DECLARE @SomeDate AS DATETIME
SELECT @SomeDate = '2022-10-10 12:15:00'
```

```SQL
DECLARE @SomeDate AS DATETIME
@SomeDate = '2022-10-10 12:15:00'
```

**(Select all that apply.)** Which option(s) are a correct way to declare a `DATETIME` variable and assign it a value?

(Select all that apply.) Which option(s) are a correct way to declare a <code>DATETIME</code> variable and assign it a value?

```SQL
CREATE FUNCTION dbo.Cube(@Number INT)
RETURNS INT
AS
BEGIN
    SET @Number = @Number * @Number * @Number
END;
```

```SQL
CREATE FUNCTION dbo.Cube(@Number INT)
RETURNS INT
AS
BEGIN
    RETURN @Number / 2;
END;
```

```SQL
CREATE FUNCTION dbo.Cube(@Number INT)
RETURNS INT
AS
BEGIN
    SET @Number = @Number * @Number * @Number
    RETURN @Number
END;
```

```SQL
CREATE FUNCTION dbo.Cube(@Number INT)
RETURNS INT
AS
BEGIN
    RETURN 'Cube'
END;
```

```SQL
CREATE FUNCTION dbo.Cube(@Number INT)
AS
BEGIN
    SET @Number = @Number * @Number * @Number
    RETURN @Number
END;
```

**(Select all that apply.)** Which function’s syntax is defined correctly?


(Select all that apply.) Which function’s syntax is defined correctly?

Stored procedures are similar to functions in the sense that they aid code reusability.

Stored procedures can have input and output parameters.

We execute a stored procedure using the `SELECT` keyword.

**(Select all that apply.)** Which statement(s) about stored procedures are **not** correct? 


(Select all that apply.) Which statement(s) about stored procedures are not correct?

Consider the following stored procedure:

```SQL
CREATE PROCEDURE GetSomeNumber
AS
BEGIN
    DECLARE @Numbers AS TABLE (Number INT)
    INSERT INTO @Numbers (Number)
    VALUES (17), (23), (65), (24), (87)

    SELECT MAX(Number) - MIN(Number) FROM @Numbers
END;
```

What is the result of executing the procedure above?


Consider the following stored procedure:
<pre><code class="language-SQL">CREATE PROCEDURE GetSomeNumber
AS
BEGIN
 DECLARE @Numbers AS TABLE (Number INT)
 INSERT INTO @Numbers (Number)
 VALUES (17), (23), (65), (24), (87)

 SELECT MAX(Number) - MIN(Number) FROM @Numbers
END;
</code></pre>
What is the result of executing the procedure above?

T-SQL Programming I Quiz

T-SQL Programming I Quiz

Test your knowledge of basic programming constructs of T-SQL.

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: T-SQL Programming Basics