Diploma in Databases and T-SQL

This free online Databases and T-SQL course will teach you the core concepts of databases and their structure. It will teach you how to retrieve data from a database using Structured Query Language (SQL) and Microsoft’s variant Transact-SQL (T-SQL). You will learn about queries and the different constraints and clauses you can include in them. You will also study administrative tasks you can perform on a database.

What You Will Learn In This Free Course

Core Database Concepts

Learn more about the fundamental concepts of database. You will be introduced to databases, SQL, DBMS and RDMS. You will also learn about SSQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases.

Relational Concepts

In this module, you will study the relational concepts of database. You will begin by studying Normalization and you will see how the various normal forms impact upon the organization of data in a database. You will also study referential integrity and constraints.

Creating Databases and Database Objects

Learn about what a datatype is and then learn about some of the categories of datatypes. You will also learn about unicode, implicit and explicit datatypes before moving onto database objects and DDL statements.

Using DML Statements

In this module, you will be learning about Data Manipulation Language and you will be introduced to the SELECT statement. You will learn the significance of this statement and its applications in database. The INSERT, UPDATE and DELETE statements will also be discussed.

Sql Server Administration Fundamentals

Study the fundamentals of Sql Server Administration Fundamentals and learn about Securables, Principals and Permissions. You will learn about the three-tiered approach to accessing content and about how Databases and Objects are secured.

Diploma in Databases and T-SQL – First Assessment

You must score 80% or more to pass this assessment.; Module

Introducing Transact-SQL

In this module, you will be introduced to Transact-SQL and you will learn about Structured Query Language, Data Manipulation Language, Data Definition Language and Data Control Language.; Module

Querying Tables with Select

In this module, you will learn how to query tables with select. You will look at removing duplicates and sorting as well as filtering and using predicates.; Module

Querying Multiple Tables with Joins and Using Set Operators

This module will introduce you to Joins and Queries, you will learn about how to use a join and the various types of joins that are used.; Module

Using Functions and Aggregating Data

This module will introduce you to various functions such as Scalar Functions and Logical Functions. You will also gain a greater understanding of GROUP BY and Filtering with HAVING.; Module

Working with Subqueries, Table Expressions and Data

This module will introduce you to Subqueries as well as showing you how certain table expressions work. You will also learn more about Grouping Sets and Pivoting Data.; Module

Modifying Data and Using T-SQL in Programming

In this module, you will learn more about the practicalities of working with data. You will learn about how to input data and also about how to update and delete data in a table. You will also study Batches, Comments and Variables and take a look at Conditional Branching and Looping.

T-SQL – Error Handling and Transactions

In this module, you will learn about Error Messages and Raising Errors. Following on from this, you will study how errors are caught and handled and you will learn about Transactions.; Module

Diploma in Databases and T-SQL – Second Assessment

You must score 80% or more to pass this assessment.; Module

Course assessment