Spanish
French
Italian
Brazilian Portuguese
Diploma in Databases and T-SQL - Revised
Description
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.
This course will be of great interest to learners who wish to learn more about databases and the use of T-SQL to create queries for retrieving data.
Start Course NowLearning Outcomes
After studying module one you should 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;
- Explain three forms of normalization and referential integrity;
- Describe different data types. - Discuss how to create a basic database;
- Use the SELECT statement, including aggregate functions, to retrieve data from your database.
- Modify your database using INSERT, UPDATE AND DELETE.
- Add users and set their permission levels. - Backup and restore your data base.
- Set up an Azure SQL Database environment.
- Describe the different data types and their uses.
- Explain NULL functions, removal of duplicates and how they work with SQL queries.
- Choose how to sort SQL query results. - Describe the concept
Certification
All Alison courses are free to enrol, study and complete. To successfully complete this Diploma course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Diploma course, you have the option to acquire official Certification, which is a great way to share your achievement with the world. Your Alison Certification is:
Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive to you to continue empowering yourself through lifelong learning
Alison offers 3 types of Certification for completed Diploma courses:
Digital Diploma - a downloadable Diploma in PDF format, immediately available to you when you complete your purchase
Diploma - a physical version of your officially branded and security-marked Diploma that is posted to you (with FREE standard shipping worldwide)
Framed Diploma - a physical version of your officially branded and security-marked Diploma in a stylish frame that is posted to you (with FREE standard shipping worldwide)
All Certification is available to purchase through the Alison Shop. For more information on purchasing Alison Certification, please visit our faqs. If you decide not to purchase your Alison Certification, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Certification pricing, please visit our Pricing Page.
