Diploma in Databases and T-SQL

0
Certificate

Paid

Language

Level

Intermediate

Access

Free

Last updated on November 28, 2024 1:57 pm

Study the fundamental concepts of databases and learn about their structures by studying this free online course ‘Diploma in Databases and T-SQL’ from Alison.

Add your review

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.

What You Will Learn In This Free Course

  • Describe a database and give an exam…
  • List common database terms and expla…
  • Explain three forms of normalization…
  • Describe different data types. – Dis…
  • 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
  • Core Database Concepts

    Learn more about the fundamental concepts of database. You will be introduced to databases, SQL, DBMS and RDMS. You will also learn about SSQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases.

    Relational Concepts

    In this module, you will study the relational concepts of database. You will begin by studying Normalization and you will see how the various normal forms impact upon the organization of data in a database. You will also study referential integrity and constraints.

    Creating Databases and Database Objects

    Learn about what a datatype is and then learn about some of the categories of datatypes. You will also learn about unicode, implicit and explicit datatypes before moving onto database objects and DDL statements.

    Using DML Statements

    In this module, you will be learning about Data Manipulation Language and you will be introduced to the SELECT statement. You will learn the significance of this statement and its applications in database. The INSERT, UPDATE and DELETE statements will also be discussed.

    Sql Server Administration Fundamentals

    Study the fundamentals of Sql Server Administration Fundamentals and learn about Securables, Principals and Permissions. You will learn about the three-tiered approach to accessing content and about how Databases and Objects are secured.

    Diploma in Databases and T-SQL – First Assessment

    You must score 80% or more to pass this assessment.; Module

    Introducing Transact-SQL

    In this module, you will be introduced to Transact-SQL and you will learn about Structured Query Language, Data Manipulation Language, Data Definition Language and Data Control Language.; Module

    Querying Tables with Select

    In this module, you will learn how to query tables with select. You will look at removing duplicates and sorting as well as filtering and using predicates.; Module

    Querying Multiple Tables with Joins and Using Set Operators

    This module will introduce you to Joins and Queries, you will learn about how to use a join and the various types of joins that are used.; Module

    Using Functions and Aggregating Data

    This module will introduce you to various functions such as Scalar Functions and Logical Functions. You will also gain a greater understanding of GROUP BY and Filtering with HAVING.; Module

    Working with Subqueries, Table Expressions and Data

    This module will introduce you to Subqueries as well as showing you how certain table expressions work. You will also learn more about Grouping Sets and Pivoting Data.; Module

    Modifying Data and Using T-SQL in Programming

    In this module, you will learn more about the practicalities of working with data. You will learn about how to input data and also about how to update and delete data in a table. You will also study Batches, Comments and Variables and take a look at Conditional Branching and Looping.

    T-SQL – Error Handling and Transactions

    In this module, you will learn about Error Messages and Raising Errors. Following on from this, you will study how errors are caught and handled and you will learn about Transactions.; Module

    Diploma in Databases and T-SQL – Second Assessment

    You must score 80% or more to pass this assessment.; Module

    Course assessment

    ×

      Your Email (required)

      Report this page
      Diploma in Databases and T-SQL
      Diploma in Databases and T-SQL
      LiveTalent.org
      Logo
      Skip to content