Free online course: Diploma in Databases and T-SQL - Revised

Published: Thursday September 19, 2019 16:36

Study the fundamental concepts of databases and learn about their structures by studying the course ‘Diploma in Databases and T-SQL’. You will also learn about retrieving data from a database using Structures Query Language (SQL) and using Microsoft’s variant Transact-SQL (T-SQL). The course will then introduce you to queries and various constraints and clauses you can include in them.

You will learn about administrative tasks which you can perform on a database from security to dealing with errors. The course opens by introducing you to databases and the key components of a database structure – normalization and referential integrity. You will study the objects that make up your database and the datatypes that you can save data as. You will learn about the Data Definition Language and how to create, alter and delete databases.

This course will teach you about retrieving data from a database with the SELECT statement. As well as this, you will learn to apply functions and clauses to your SELECT databases. Following on from this, you will be introduced to T-SQL and using the SELECT statement to create queries. The various data types will be discussed, you will learn about working with them and using NULL values in your database. You will learn about the use of functions such as INTERSECT and EXCEPT in your queries.

Finally, you will be introduced to subqueries and their function. You will learn to use apply operators, present your data with views, build temporary tables, and pivot your data. The course also includes methods for modifying and deleting data in database tables, as well as using batches, comments and declaring variables for your queries. You will learn how to create conditional branching and looping within your queries. Lastly, you will learn about errors in a database engine, and how to delete them.

For more information click here
558 Views