DDL Overview

• Sybase data types
• Listing object names and attributes
• Creating a table
• Creating a proxy table
• Altering a table
• Creating an index
• Clustered vs non-clustered indexes
• Creating a constraint
• Table partitioning
• Tables which span multiple segments
• Creating a stored procedure
• Object permissions
• Binding Rules
• Modifying a Column
• Moving an object

Transact SQL Primer

• Transact SQL: Numeric functions
• Transact SQL: String functions
• Transact SQL: Date functions
• Transact SQL: Date formats
• Transact SQL: Misc functions
• Transact SQL: Conditionals
• Transact SQL: Loop constructs
• Transact SQL: Cursors
• Transact SQL: Complex updates
• Transact SQL: Counting duplicate rows
• Transact SQL: Using temporary tables
• Transact SQL: Inner and Outer Joins
• Transact SQL: Isolation
• Transact SQL: Writing Reports
• Transact SQL: Case Statement
• Transact SQL: Custom query plans

Back to top page