Loading

Diploma in Databases and T-SQL - Revised

Learn about database technology and how to program using T-SQL, and get a strong boost to your IT career development.

Databases
Free Course
This free online database course is designed to teach you all you need to know about database technology and how to program using T-SQL, so you can boost your IT career in just a few short hours. Databases underlie a huge range of programming applications, and businesses are becoming more and more invested in using databases to monitor markets. Understanding how database technology works is essential for any aspiring programmer.
  • Duration

    6-10 Hours
  • Assessment

    Yes
  • Certification

    Yes
  • Responsive

    Yes
  • Publisher

    Channel 9

Description

Modules

Outcome

Certification

View course modules

Description

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

Modules

Core Database Concepts

Relational Concepts

Creating Databases and Database Objects

Using DML Statements

Sql Server Administration Fundamentals

Diploma in Databases and T-SQL - First Assessment

Introducing Transact-SQL

Querying Tables with Select

Querying Multiple Tables with Joins and Using Set Operators

Using Functions and Aggregating Data

Working with Subqueries, Table Expressions and Data

Modifying Data and Using T-SQL in Programming

T-SQL - Error Handling and Transactions

Diploma in Databases and T-SQL - Second Assessment

Course assessment

Learning 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

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.

Careers

    Notification

    You have received a new notification

    Click here to view them all