2. Database Object Management using DDL
2.1 Construct and analyze queries that create, alter, and drop tables
• Create, alter, and drop tables by using proper ANSI SQL syntax; NULL and
NOT NULL
2.2 Construct and analyze queries that create, alter, and drop views • Create, alter, and drop views by using proper ANSI SQL syntax; purpose of views
2.3 Construct and analyze stored procedures and functions • Input and output parameters, return values, purpose of stored procedures
2.4 Given a scenario, choose between clustered and non-clustered indexes • When to use clustered vs. non-clustered indexes, syntax for creating indexes
2.2 Construct and analyze queries that create, alter, and drop views • Create, alter, and drop views by using proper ANSI SQL syntax; purpose of views
2.3 Construct and analyze stored procedures and functions • Input and output parameters, return values, purpose of stored procedures
2.4 Given a scenario, choose between clustered and non-clustered indexes • When to use clustered vs. non-clustered indexes, syntax for creating indexes
CREATE TABLE (Transact-SQL).pdf