Diploma in Databases and T-SQL

Provided by:
0/10 stars
based on  0 reviews
Provided by:
Cost FREE , Add a Verified Certificate for €21
Start Date On demand

Course Details

Cost

FREE,
Add a Verified Certificate for €21

Upcoming Schedule

  • On demand

Course Provider

Alison online courses
Welcome to ALISON – a three million-strong, global online learning community, filled with free, high-quality resources to help you develop essential, certified workplace skills. ALISON was founded in 2007 by global leader and innovator Mike Feerick. Our mission at ALISON is simple: to enable you, wherever you are in the world, to learn and get certified – at your own pace – using our free, interactive, multimedia. There are 600 free courses for you to choose from: * Finan...
Welcome to ALISON – a three million-strong, global online learning community, filled with free, high-quality resources to help you develop essential, certified workplace skills. ALISON was founded in 2007 by global leader and innovator Mike Feerick. Our mission at ALISON is simple: to enable you, wherever you are in the world, to learn and get certified – at your own pace – using our free, interactive, multimedia. There are 600 free courses for you to choose from: * Financial & Economic Literacy * Digital Literacy & IT Skills * Diploma Courses * Health Literacy * Health & Safety (Irish Legislation Only) ALISON is for anyone taking their first step to a new job, and for everyone taking their next step to a better job. ALISON is as individual as you are. Our materials will help you to develop your creativity, confidence and competence for work, and to be as contented and productive as you can be in the world of work. Every course is standards-based and certified. That means bragging rights with family and friends, an edge in your first job or new job, and inspiration to be all you can be. So now get ready for a bright new future!

Provider Subject Specialization
Humanities
Business & Management
17 reviews

Course Description

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...

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.

Diploma in Databases and T-SQL course image
Reviews 0/10 stars
0 Reviews for Diploma in Databases and T-SQL

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

No reviews yet. Be the first!

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.