Diploma in Databases and T-SQL

Course Description

In the free online course Diploma in Databases and T-SQL you will learn about databases and their functions. You will learn about retrieving data from your database using Structured Query Language(SQL) and using Microsoft’s variant Transact-SQL(T-SQL). You will learn about the core concepts of databases and their structure. You will also learn queries, various constraints and clauses you can include in them. This course also teaches about administrative tasks you can perform on a database, from security to dealing with errors.

The course begins by introducing you to database and its core concepts. You will learn about the concepts that are the fundamental pieces for your database construction. You learn about Normalization and referential integrity - the key to components of a database structure. You will also learn about objects that make up your database and the datatypes that you save your data as. You will learn about using the Data Definition Language to create, alter and delete databases.

Next you will be introduced to DML or Data Manipulation Language. This course teaches you about retrieving data from database with the select statement. You will learn to apply functions and clauses to your select statement, update and deleting data in your database. The course also teaches about security, its terminology, levels and applying security to your databases.

Next you will learn about T-SQL and using the select statement to create queries. You will learn about the various data types, working with them and using NULL values in your database. It also includes sorting and removing duplicates, using joins and knowing about different types of joins. You will learn about using Intersect and Except in your queries, the different functions you can use in your queries.

In the end, you will learn about Subqueries and their function. You will learn to use apply operators, present your data with views, temporary tables, and to pivot your data. The course also includes modifying and deleting data in your database tables, batches, comments and declaring variables for your queries. You will also learn to create conditional branching and looping within your queries. Lastly you will learn about errors in a database engine, how to raise, handle and catch them.

This free Alison course would be of interest to those who wish to learn about databases and the use of T-SQL to create queries to retrieve data from databases.

CERTIFICATION

To qualify for your official ALISON Diploma, Certificate or PDF you must study and complete all modules and score 80% or more in each of the course assessments. A link to purchase your Diploma certificate will then appear under the My Certificates heading of your My Account page.

LEARNING OUTCOMES

Having completed this course you will be able to:
- Describe a database and give an example of real life uses.
- List common database terms and explain their part in a database.
- Describe normalization.
- Explain three forms of normalization.
- Describe referential integrity.
- Recognize how constraints are part of referential integrity.
- Describe different data types.
- Discuss how to create a basic database.
- Describe Data Definition Language (DDL) statements for creating databases.
- Use the SELECT statement to retrieve data from your database.
- Modify your database using INSERT, UPDATE AND DELETE.
- Use aggregate functions with the SELECT statement.
- Secure your database and its objects.
- Add users and set their permission levels.
- Backup and restore your data base.
- Identify the elements of database engine errors.
- Recognize the process error handling and catching errors in Transact-SQL code.
- Discuss the concept of transactions.
- Distinguish how to add data to a database using the INSERT function.
- Indicate how to update and delete data from a database using the respective functions.
- Explain creating variables for use within SQL queries.
- Illustrate the importance of comments to describe SQL code
- Identify programing constructs such as IF statements and loops in SQL queries.
- Illustrate how to use subqueries within your queries.
- Describe using APPLY operator to use SQL query results in another SQL query.
- Describe a Temporary table, its uses and drawbacks.
- Identify common table expressions(CTEs) in SQL queries.
- Explain how to group data using GROUPING SET sub-clause of GROUP BY clause.
- Describe pivoting data and unpivoting data using the PIOVT and UNPIVOT operators.

Share This Course!

Tweet