Database Tables  «Prev  Next»

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:
  1. List the tools used to create a database
  2. Identify the permissions required to create, modify, or delete databases
  3. Describe elements of a basic database
  4. Issue Transact-SQL statements to create, modify, or delete databases

Glossary terms

This module introduced you to the following terms:
  1. database
  2. DBO
  3. hierarchy
  4. SA
  5. 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

SEMrush Software