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:

import React from 'react';
import { shallow, configure } from 'enzyme';
import Adapter from 'enzyme-adapter-react-16';

configure({ adapter: new Adapter() });

import HelloWorld from './app';

var TestResult = function() {
    this.succeeded = false;
    this.reason = "";
    this.input = "";
    this.expected_output = "";
    this.actual_output = "";
}

export const executeTests = function() {

  var results = [];

  result = new TestResult();
  result.input = 'HelloWorld Component';
  result.expected_output = "span containing text 'Hello World'"

  let wrapper = shallow(<HelloWorld />);

  // Call your Challenge function here.

  let type = wrapper.type();
  let testSuccessful = true;
  let failureReason;

  if (type !== 'span') {
    testSuccessful = false;
    failureReason = "You need to render exactly one span HTML element";
  } else if (wrapper.props().children != "Hello World") {
     testSuccessful = false;
     failureReason = "You have rendered wrong message in your span element";
  }

  result.actual_output = wrapper.html();

  if (testSuccessful) {
    result.succeeded = true;
    result.reason = "Succeeded"
  } else {
    result.succeeded = false;
    result.reason = failureReason;
  }

  results.push(result);

  return results;
}


React

Dart

GoJS React

Typescript React

Vue.js

In the output, we see the current date and time of the system that hosts our MS SQL Server instance. 

If an application needs to support multiple time zones, it is better to store dates and times in UTC instead of the local time zone. The `GETUTCDATE()` returns the current date and time in UTC:

Now, we see the UTC date and time. If the system clock is not configured to be in the UTC time zone,  we’ll see the difference between the results of the `GETDATE()` and `GETUTCDATE()` functions.

# Parts of `DATETIME`

The `DATETIME` object encapsulates the full date and time. There could be situations, however, when we only need a specific part of the `DATETIME` object (for example, the month or year). There are functions that can extract the part we need:

- `DAY()`: Retrieves the day part from a `DATETIME` object.
- `MONTH()`: Retrieves the month from a `DATETIME` object.
- `YEAR()`: Retrieves the year from a `DATETIME` object.

In the following code snippet, we’ll use each of the functions above to extract individual parts of the current date:


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