Diploma in Databases and T-SQL | Online | Alison
Loading

Diploma in Databases and T-SQL - Revised

Learn about the core concepts of database including the structure by studying this free Databases and T-SQL course.

Databases
Free Course
This free online Databases and T-SQL course will teach you the core concepts of databases and their structure. It will teach you how to retrieve data from a database using Structured Query Language (SQL) and Microsoft's variant Transact-SQL (T-SQL). You will learn about queries and the different constraints and clauses you can include in them. You will also study administrative tasks you can perform on a database.
  • 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 discussing the fundamental concepts of a database. You will be introduced to databases, SQL, DBMS, and RDMS. You will also learn about SQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases. You will study the relational concepts of a database, datatype and its categories, the Data Manipulation Language and the SELECT statement, and the fundamentals of SQL Server Administration.

You will then look into Transact-SQL. SQL stands for Structured Query Language, and is generally used as a standard across the industry for interrogating databases. Transact-SQL, on the other hand, is Microsoft's implementation of SQL syntax which is the same as standard SQL with a few Microsoft specific twists, used for Microsoft's database products. You will also learn how to use functions and aggregate data, work with subqueries, modify data and use T-SQL in programming, handle error and transactions, and more!

Learn more about databases and the use of T-SQL to create queries for retrieving data from databases with this free online course. It will greatly enhance your computer programming skills and keep you ahead of your peers. You will not only learn the key components of a database structure but learn administrative tasks that you can perform on a database, from security to dealing with errors. These are highly valuable skills so make sure to check out this course now! 

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 an official Diploma, which is a great way to share your achievement with the world. Your Alison Diploma 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 for you to continue empowering yourself through lifelong learning

Alison offers 3 types of Diplomas 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, posted to you with FREE shipping
Framed Diploma - a physical version of your officially branded and security-marked Diploma in a stylish frame, posted to you with FREE shipping

All Diplomas are available to purchase through the Alison Shop. For more information on purchasing Alison Diplomas, please visit our FAQs. If you decide not to purchase your Alison Diploma, 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 Diploma pricing, please visit our Pricing Page.

Careers

    Notification

    You have received a new notification

    Click here to view them all