Diploma in Databases and T-SQL

About Course

  • This course begins by introduing 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 Manipulation Language. This includes how to use essential statements and the functions and clauses the 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.

This Diploma course is completely free with basic or no prior knowledge.

What I will learn?

  • Core Database Concepts
  • Relational COncepts
  • Creating Databases And Database Objects
  • Using DML Statements
  • SQL Server Administration Fundamentals
  • 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 TSQL in Programming
  • T-SQL Error Handling And Transactions
  • Assessment

Material Includes

  • Self-paced learning
  • Video tutorials
  • Unlimited access
  • Recognised certification

Course Detail

  • Hours : 10 Hours
  • Level : Beginner
  • Certification : Free

Platform : Alison