Lesson 13

SQL Server Databases Conclusion

In this module, you learned the basic Transact-SQL syntax required to create, modify, and delete a SQL Server 2022 database. Having completed this module, you should be able to:

List the tools used to create a database
Identify the permissions required to create, modify, or delete databases
Describe elements of a basic database
Issue Transact-SQL statements to create, modify, or delete databases

Glossary terms

This module introduced you to the following terms:

database
DBO
hierarchy
SA
transaction log

In the next module, we will investigate column attributes for a SQL Server table.
Question: Do you have any questions or comments about Transact-SQL?

SQL Server Databases - Quiz

Before moving on to the next module, click the Quiz link below to check your knowledge of the material covered in this module with a short, multiple-choice quiz.
SQL Server Databases - Quiz