Advertisement
beginner levelDiploma in Databases and T-SQL
6-10hrs
diplomaIT
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.
read more
Diploma in Databases and T-SQL
Learn about the core concepts of database including the structure by studying this free Databases and T-SQL 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.
Course description
Course module
A short ad will play before each lesson.
Module 14 Lessons
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.
1.Learning Outcomes
Continue Learning
2.Core Database Concepts - Introduction
Continue Learning
3.SQL Server Management Studio
Continue Learning
4.Lesson Summary
Continue Learning
Module 25 Lessons
Relational Concepts
Module 35 Lessons
Creating Databases and Database Objects
Module 45 Lessons
Using DML Statements
Module 54 Lessons
Sql Server Administration Fundamentals
Module 61 Lessons
Diploma in Databases and T-SQL - First Assessment
Module 76 Lessons
Introducing Transact-SQL
Module 84 Lessons
Querying Tables with Select
Module 99 Lessons
Querying Multiple Tables with Joins and Using Set Operators
Module 106 Lessons
Using Functions and Aggregating Data
Module 1111 Lessons
Working with Subqueries, Table Expressions and Data
Module 127 Lessons
Modifying Data and Using T-SQL in Programming
Module 135 Lessons
T-SQL - Error Handling and Transactions
Module 141 Lessons
Diploma in Databases and T-SQL - Second Assessment
Module 151 Lessons
Course assessment
INSIGHTS
Latest Post
7 Best Low-Code/No-Code Development Courses for Beginners in 2025
Build apps, automate workflows, and launch your app within days. Master low-code/no-code development with these beginner-friendly courses.
Read More
10 Best Guitar Courses for Beginners in 2025
If you’re interested in learning the guitar, there’s a course for you. In this guide to the best guitar courses, there are several beginner courses to choose from, plus some specific styles to explore if you already know the basics.
The guitar is a popular and versatile musical instrument. It’s portable (especially the acoustic guitar), and you can play melodies or strumming both solo and in a band. It lends itself beautifully to many musical styles, from flamenco to classical, jazz, blues, fol
Read More
30 Hours of MATLAB Courses with Free Certificate
Guide to the MATLAB Academy platform, which offers 24 courses with a free certificate of completion.
Read More
FEATURED COLLECTION
Recommended Related Courses
Intermediate Level
Foundations of ITIL 4 for Service Management
3-4hrsdiplomasFREE
Start learning
Intermediate Level
CompTIA A+ 1000 - Part 2
6-10hrsdiplomasFREE
Start learning
Intermediate Level
Fundamentals of NIS2 Directive - EU Cybersecurity Enhancement
1.5-3hrsdiplomasFREE
Start learning
beginner level
Introduction to Electronic Document Management
3-4hrsdiplomasFREE
Start learning
beginner level
Introduction to CCTV Systems & AutoCAD Layouts
1.5-3hrsdiplomasFREE
Start learning
Intermediate Level
Diploma in ISO 27001:2022 - Information Security Management System (ISMS)
10-15hrsdiplomasFREE
Start learning
Advertisement
Build Your Career Toolkit
