Creating Databases and Database Objects | Lesson Summary

We offer unlimited learning for free. Be a part of our mission.

If you've ever been grateful for your free courses, now is the moment to pass it forward. Every contribution, big or small, helps us keep education free for all.

Continue Learning for Free

Contribute Now

Support us in our mission to keep education free for all.

Pick Your Contribution Amount.

$1

Support 30 learners globally

$5

Support 150 learners globally

$

Support:

Select Contribution Method

Contribution Amount$2

Select Payment Method

Credit/Debit Card

PayPal

Thank you for being part of our mission!

Your contribution has made a difference to learners across the globe.

Continue Learning

Module 1: Creating Databases and Database Objects

Module 1: Core Database Concepts

Core Database Concepts - Learning Outcomes

Core Database Concepts - Introduction

SQL Server Management Studio

Core Database Concepts - Lesson Summary

Module 2: Relational Concepts

Relational Concepts - Learning Outcomes

Normalization

Referential Integrity

Constraints

Relational Concepts - Lesson Summary

Module 3: Creating Databases and Database Objects

Creating Databases and Database Objects - Learning Outcomes

Datatypes

Database Objects

DDL Statements

Creating Databases and Database Objects - Lesson Summary

Module 4: Using DML Statements

Using DmL Statements - Learning Outcomes

SELECT Statement

SELECT Statement Demonstration

Using DmL Statements- Lesson Summary

INSERT, UPDATE and DELETE Statements

Module 5: Sql Server Administration Fundamentals

Sql Server Administration Fundamentals - Learning Outcomes

Securing Databases and Objects

Database Backups and Restores

Sql Server Administration Fundamentals - Lesson Summary

Module 6: Diploma in Databases and T-SQL - First Assessment

Diploma in Databases and T-SQL - First Assessment

Module 7: 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

Module 8: Querying Tables with Select

Querying Tables with Select - Learning Outcomes

Removing Duplicates and Sorting

Filtering and Using Predicates

Querying Tables with Select - Lesson Summary

Module 9: 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

Cross Joins

Self Joins

Union Queries

Intersect Queries and Except Queries

Querying Multiple Tables with Joins and Using Set Operators - Lesson Summary

Outer Joins

Module 10: 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

Module 11: 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

Module 12: 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

Education should be...
free and accessible.