Diploma in Databases and T-SQL
CertificationView course modules
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.
Start Course Now
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 programming 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.
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.