Diploma in Databases and T-SQL - Revised
Learn about the core concepts of database including the structure by studying this free Databases and T-SQL course.
Description
This course begins by discussing the fundamental concepts of a database. You will be introduced to databases, SQL, DBMS, and RDMS. You will also learn about SQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases. You will study the relational concepts of a database, datatype and its categories, the Data Manipulation Language and the SELECT statement, and the fundamentals of SQL Server Administration.
You will then look into Transact-SQL. SQL stands for Structured Query Language, and is generally used as a standard across the industry for interrogating databases. Transact-SQL, on the other hand, is Microsoft's implementation of SQL syntax which is the same as standard SQL with a few Microsoft specific twists, used for Microsoft's database products. You will also learn how to use functions and aggregate data, work with subqueries, modify data and use T-SQL in programming, handle error and transactions, and more!
Learn more about databases and the use of T-SQL to create queries for retrieving data from databases with this free online course. It will greatly enhance your computer programming skills and keep you ahead of your peers. You will not only learn the key components of a database structure but learn administrative tasks that you can perform on a database, from security to dealing with errors. These are highly valuable skills so make sure to check out this course now!
Modules
Core Database Concepts
-
Core Database Concepts - Learning Outcomes
-
Core Database Concepts - Introduction
-
SQL Server Management Studio
-
Core Database Concepts - Lesson Summary
Relational Concepts
-
Relational Concepts - Learning Outcomes
-
Normalization
-
Referential Integrity
-
Constraints
-
Relational Concepts - Lesson Summary
Creating Databases and Database Objects
-
Creating Databases and Database Objects - Learning Outcomes
-
Datatypes
-
Database Objects
-
DDL Statements
-
Creating Databases and Database Objects - Lesson Summary
Using DML Statements
-
Using DmL Statements - Learning Outcomes
-
SELECT Statement
-
SELECT Statement Demonstration
-
INSERT, UPDATE and DELETE Statements
-
Using DmL Statements- Lesson Summary
Sql Server Administration Fundamentals
-
Sql Server Administration Fundamentals - Learning Outcomes
-
Securing Databases and Objects
-
Database Backups and Restores
-
Sql Server Administration Fundamentals - Lesson Summary
Diploma in Databases and T-SQL - First Assessment
Introducing Transact-SQL
-
Introducing Transact-SQL - Learning Outcomes
-
Introducing Transact-SQL - Course Introduction
-
Introduction to Transact-SQL
-
The SELECT Statement
-
Data Types and Working with NULL
-
Introducing Transact-SQL - Lesson Summary
Querying Tables with Select
-
Querying Tables with Select - Learning Outcomes
-
Removing Duplicates and Sorting
-
Filtering and Using Predicates
-
Querying Tables with Select - Lesson Summary
Querying Multiple Tables with Joins and Using Set Operators
-
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
-
Querying Multiple Tables with Joins and Using Set Operators - Lesson Summary
Using Functions and Aggregating Data
-
Using Functions and Aggregating Data - Learning Outcomes
-
Scalar Functions
-
Logical Functions
-
Window and Aggregate Functions
-
Group By and Filtering with Having
-
Using Functions and Aggregating Data - Lesson Summary
Working with Subqueries, Table Expressions and Data
-
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
-
Working with Subqueries, Table Expressions and Data - Lesson Summary
Modifying Data and Using T-SQL in Programming
-
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
-
Modifying Data and Using T-SQL in Programming - Lesson Summary
T-SQL - Error Handling and Transactions
-
T-SQL - Error Handling and Transactions - Learning Outcomes
-
Error Message and Raising Errors
-
Catching and Handling Errors
-
Transactions
-
T-SQL - Error Handling and Transactions - Lesson Summary
Diploma in Databases and T-SQL - Second Assessment
Course assessment
Learning Outcomes
After studying module one you should 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
- 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
Certification
All Alison courses are free to enrol, study and complete. To successfully complete this Diploma course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Diploma course, you have the option to acquire an official Diploma, which is a great way to share your achievement with the world. Your Alison Diploma is:
Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning
Alison offers 3 types of Diplomas for completed Diploma courses:
Digital Diploma - a downloadable Diploma in PDF format, immediately available to you when you complete your purchase
Diploma - a physical version of your officially branded and security-marked Diploma, posted to you with FREE shipping
Framed Diploma - a physical version of your officially branded and security-marked Diploma in a stylish frame, posted to you with FREE shipping
All Diplomas are available to purchase through the Alison Shop. For more information on purchasing Alison Diplomas, please visit our FAQs. If you decide not to purchase your Alison Diploma, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Diploma pricing, please visit our Pricing Page.