Loading
Alison Logo

Diploma in Databases and T-SQL Free Course

certifcate icon
  • Description
  • Outcome
  • Certification
  • The free online course Diploma in Databases and T-SQL will introduce you to the core concepts of databases and their structure. You will also learn about retrieving data from a database using Structured Query Language (SQL) and using Microsoft’s variant Transact-SQL (T-SQL). You will learn about queries, and various constraints and clauses you can include in them. The course also teaches about administrative tasks you can perform on a database, from security to dealing with errors.

    The course begins by introducing you to databases and the key components of a database structure - normalization and referential integrity. You will also learn about objects that make up your database and the datatypes that you can save data as. The course teaches you about the Data Definition Language and how to create, alter and delete databases.

    You will be introduced to DML or Data Manipulation Language. This course teaches you about retrieving data from a database with the SELECT statement. You will learn to apply functions and clauses to your SELECT statement, and how to update and delete data in a database. The course also teaches about security levels and applying security to your databases.

    Next, you will learn about T-SQL and using the SELECT statement to create queries. You will learn about the various data types, working with them and using NULL values in your database. It also includes sorting and removing duplicates, using joins and knowing about different types of joins. You will learn about using INTERSECT and EXCEPT in your queries, and other functions you can use 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 free Alison 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 from databases.

  • 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 programing 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 study. To successfully complete a course you must score 80% or higher in each course assessments. Upon successful completion of a course, you can choose to make your achievement formal by purchasing an official Alison Diploma, Certificate or PDF.

    Having an official Alison document is a great way to share your success. Plus it’s:

    • Ideal for including in CVs, job applications and portfolios
    • An indication of your ability to learn and achieve high results
    • An incentive to continue to empower yourself through learning
    • A tangible way of supporting the Alison mission to empower people everywhere through education.

Modules List( 15 )
  • Diploma in Databases and T-SQL
  • Module 1: Core Database Concepts
    • Learning Outcomes
    • Introduction
    • SQL Server Management Studio
    • Lesson Summary
  • Module 2: Relational Concepts
    • Learning Outcomes
    • Normalization
    • Referential Integrity
    • Constraints
    • Lesson Summary
  • Module 3: Creating Databases and Database Objects
    • Learning Outcomes
    • Datatypes
    • Database Objects
    • DDL Statements
    • Lesson Summary
  • Module 4: Using DML Statements
    • Learning Outcomes
    • SELECT Statement
    • SELECT Statement Demonstration
    • INSERT, UPDATE and DELETE Statements
    • Lesson Summary
  • Module 5: SQL Server Administration Fundamentals
    • Learning Outcomes
    • Securing Databases and Objects
    • Database Backups and Restores
    • Lesson Summary
  • Module 6: Diploma in Databases and T-SQL - First Assessment
    • Diploma in Databases and T-SQL - First Assessment
  • Diploma in Databases and T-SQL - Course Resource Files
  • Module 7: Introducing Transact-SQL
    • Learning Outcomes
    • Course Introduction
    • Introduction to Transact-SQL
    • The SELECT Statement
    • Data Types and working with NULL
    • Lesson Summary
  • Module 8: Querying Tables with SELECT
    • Learning Outcomes
    • Removing Duplicates and Sorting
    • Filtering and Using Predicates
    • Lesson Summary
  • Module 9: Querying Multiple Tables with Joins and Using Set Operators
    • Learning Outcomes
    • Join Concepts and Syntax
    • Inner Joins
    • Outer Joins
    • Cross Joins
    • Self Joins
    • Union Queries
    • Intersect Queries and Except Queries
    • Lesson Summary
  • Module 10: Using Functions and Aggregating Data
    • Learning Outcomes
    • Scalar Functions
    • Logical Functions
    • Window and Aggregate Functions
    • Group by and Filtering with Having
    • Lesson Summary
  • Module 11: Working with Subqueries, Table Expressions and Data
    • Learning Outcomes
    • Subqueries
    • APPLY Operator
    • Views
    • Temporary Tables and Table Variables
    • Table Valued Functions
    • Derived Tables
    • Common Table Expressions
    • Grouping Sets
    • Pivoting Data
    • Lesson Summary
  • Module 12: Modifying Data and using T-SQL in Programming
    • Learning Outcomes
    • Inserting Data
    • Update and Delete
    • Batches, Comments and Variables
    • Conditional Branching and Looping
    • Stored Procedures
    • Lesson Summary
  • Module 13: T-SQL - Error Handling and Transactions
    • Learning Outcomes
    • Error Message and Raising Errors
    • Catching and Handling Errors
    • Transactions
    • Lesson Summary
  • Module 14: Diploma in Databases and T-SQL - Second Assessment
    • Diploma in Databases and T-SQL - Second Assessment
  • END OF COURSE ASSESSMENT
  • Module 15: Diploma in Databases and T-SQL - Final Assessment
    • Diploma in Databases and T-SQL - Final Assessment
Topics List ( 4 )
Module 1: Core Database Concepts
In this module you will be introduced to what a database is and how they are organised. You will learn about different database terminology and applications for performing tasks and interacting with your database.
Topics List ( 5 )
Module 2: Relational Concepts
In this module you will be introduced to the concepts that are the fundamental pieces you need to know before you create your database. You will learn about the process of organising data in your database, establishing relationships within your database. You will learn about the constraints are involved in ensuring your database has relationships.
Topics List ( 5 )
Module 3: Creating Databases and Database Objects
In this module you will be introduced to the different types of data you can store in your database. You will learn about the different objects that make up your database. You will learn about creating database using statements and naming conventions.
Topics List ( 5 )
Module 4: Using DML Statements
In this module you will be introduced to DML or Data manipulation language. You will learn about the select statement been used to retrieve data from your database. You will learn about the different clause and functions you can place within your select statement. You will learn about editing your data in your database using Insert update and delete.
Topics List ( 4 )
Module 5: SQL Server Administration Fundamentals
In this module you will be introduced to Security in your Database. You will learn about security terminology and levels of security within a database. You will learn about applying levels of security to your database. You will learn about backing up your database and restoring form your backup.
Topics List ( 1 )
Module 6: Diploma in Databases and T-SQL - First Assessment
You must score 80% or more to pass this assessment.
Topics List ( 6 )
Module 7: Introducing Transact-SQL
In this module you will learn about what Transact-SQL is and what its used for. You will learn about querying your database using the select statement and the clauses you can include within a select statement. You will learn about the different datatypes that a database might hold. You will learn about NULL values in your database.
Topics List ( 4 )
Module 8: Querying Tables with SELECT
In this module you will learn about the select statement and further ways of refining your select statement. You will learn about removing duplicates from your query results. You will learn about sorting your query’s results using the Order by clause. You will learn about filtering your select statements search using predicates.
Topics List ( 9 )
Module 9: Querying Multiple Tables with Joins and Using Set Operators
In this module you will learn about the concepts and syntax of joins. You will learn about each of the different types of joins you can use in your queries and what each type does. You will learn about combining result of multiple queries using the Union operator. You will learn about Intersect and Except queries.
Topics List ( 6 )
Module 10: Using Functions and Aggregating Data
In this module you will learn about different functions you can include in your queries. You will learn about Scalar functions and what they do. You will learn about logical functions and how they work. You will also learn about window functions and aggregate functions and applying them to your queries. You will learn about filtering using the group by subclause and Having clause.
Topics List ( 11 )
Module 11: Working with Subqueries, Table Expressions and Data
In this module you will learn about Subqueries what they are and how they work. You will learn about the Apply operators and using them within your queries. You will learn about presenting your data with views and temporary tables. You will learn about table valued functions and derived tables, how they work and uses. You will also learn how pivot and unpivot your data, as well as the Grouping sets subclause of the group by clause.
Topics List ( 7 )
Module 12: Modifying Data and using T-SQL in Programming
In this module you will learn about how to insert data in to your database tables, and the constraints involved in inserting new data. You will learn about the update and delete functions and how to properly use them. You will learn about batches, comments and declaring variables. You will also learn about Conditional branching and looping within your queries.
Topics List ( 5 )
Module 13: T-SQL - Error Handling and Transactions
In this module you will learn about elements of a database engine errors. You will learn about how to handle errors as well as raise them. You will learn about use the try catch block if some code could cause an error. You will learn about transactions and how they work.
Topics List ( 1 )
Module 14: Diploma in Databases and T-SQL - Second Assessment
You must score 80% or more to pass this assessment.
Topics List ( 1 )
Module 15: Diploma in Databases and T-SQL - Final Assessment
You must score 80% or more to pass this assessment.
Course Features
  • Duration

    6-10 Hours

  • Publisher

    Channel 9

  • Video

    Yes

  • Audio

    Yes

  • Assessment

    Yes

  • Certification

    Yes

  • Price

    Free

  • Reward

    250 Pts

  • Responsive

    No

Reviews and Rate
This course has no reviews yet.
Tags