SQL Server 2014 Development Essentials

Summary

In this chapter, you learned about the Transact-SQL DDL, DML, and DCL language elements. You also understood the purpose of SQL Server 2014 system databases. We then covered the purpose of database recovery models. We used the DDL language CREATE statement to create databases, schemas, and tables. We then used the DDL language ALTER statement to modify databases, schemas, and tables. We also used the DDL language DROP statement to delete databases, schemas, and tables. Finally, you learned how to set permissions on SQL Server objects using the DCL language GRANT, DENY, and REVOKE statements.