Your Learner Verification
This is to verify that Justin Fair has completed the course Diploma in Databases and T-SQL on Alison.
Justin Fair
Alison ID: 6396461
Course Completed: Diploma in Databases and T-SQL
Date of Completion: 18th March 2017
Email: [email protected]
Total Study Time: 2h 58m
Final Assessment Score:
Alison courses requires at least
80% to pass the final assessment
86%
CPD Hours Completed:
CPD approved learning hours
completed through this course
1-3h
Course Information
Learn about database technology and how to program using T-SQL, and get a strong boost to your IT career development.
This course begins by introducing you to databases and the key components of a database structure - normalization and referential integrity. The course then teaches you about the Data Definition Language and how to create, alter and delete databases. You will then be introduced to DML or Data Manipulation Language. This includes how to use essential statements and the functions and clauses that come with them, such as the SELECT statement and INTERSECT and EXCEPT functions. This will help you with the next lesson where you will learn how to update and delete data in a database.
Next, you will learn how to program in T-SQL, how to sort and remove duplicates, and how to use and understand the most important types of joins. In this section you will also be introduced to subqueries and their function. Next, the course will teach you about security levels and applying security to your databases. You will then learn to use apply operators, present your data with views, build temporary tables, and pivot your data. Finally, and very importantly, you will learn about errors in a database engine, and how to delete them.
Any aspiring computer programmer who wants to boost their career needs to learn about database technology eventually. If you want to gain a solid understanding of this area, then this is the clear and simple course for you. By the end of the course, you will be up-to-speed on database technology and will have the ability to program in T-SQL. That’s a great reward for a free course that takes less than 10 hours. So why wait? Give yourself a great professional boost today.
Modules Completed
Module 1: Core Database Concepts
Module 2: Relational Concepts
Module 3: Creating Databases and Database Objects
Module 4: Using DML Statements
Module 5: SQL Server Administration Fundamentals
Module 6: Diploma in Databases and T-SQL - First Assessment
Module 7: Introducing Transact-SQL
Module 8: Querying Tables with SELECT
Module 9: Querying Multiple Tables with Joins and Using Set Operators
Module 10: Using Functions and Aggregating Data
Module 11: Working with Subqueries, Table Expressions and Data
Module 12: Modifying Data and using T-SQL in Programming
Module 13: T-SQL - Error Handling and Transactions
Module 14: Diploma in Databases and T-SQL - Second Assessment
Module 15: Diploma in Databases and T-SQL - Final Assessment
