Sysbase

Reading Time: 2 minutes

Sybase course Syllabus

    Module 1: Introduction
    • DB Concepts
    • Transact – Structured Query Language (T-SQL)
    • Data Definition Language
    • Data Manipulation Language
    • Data Control Language
    • Identifiers
    • T-SQL Extensions

    Module 2: Data Definition Language (DDL)

    • CREATE
    • ALTER
    • DROP
    • SQL Constraints
    • Primary key
    • Foreign key
    • Unique
    • Not null
    • Check
    • Default
    • identity
    • Data types
    • Implicit conversions
    • Explicit conversions

    Module 3: Data Manipulation Language

    • Selecting data from table
    • Eliminating duplicates
    • Operators used
    • Comparison operators
    • Ranges
    • Lists
    • Where clause
    • Matching patterns
    • Aggregate functions
    • Organizing query results into groups
    • group by clause
    • having clause
    • null values and group by
    • aggregates with and without group by
    • Sorting query results
    • order by clause
    • Summarizing group of data (compute clause)
    • Combining queries
    • Union operator

    Module 4: Joins and Sub-queries

    • Joins
    • How joins works
    • How joins are processed
    • Types of Joins
    • Equi-joins and natural joins
    • Self joins
    • Inner and Outer joins
    • Inner joins
    • Left outer joins
    • Right outer joins
    • How null values affect joins
    • Which columns to join
    • Sub-queries
    • How sub-queries works
    • Restrictions
    • Sub-queries in update/insert/delete statement
    • Types of sub-queries
    • Correlated sub-queries

    Module 5: SQL Derived tables and views

    • What is a derived table
    • How SQL derived table works
    • Partitions
    • Views
    • How view works
    • Creating views
    • Retrieve and modify data through views
    • Dropping views

    Module 6: Indexes

    • How indexes works
    • Types of indexes
    • Clustered index
    • Non-clustered index
    • Differences
    • Creating indexes
    • Using clustered and non-clustered indexes
    • Index options
    • Defaults
    • Rules

    Module 7: Stored Procedures, Cursors and Triggers

    • Control flow Language
    • Local and Global variables
    • How SP works
    • Create and execute procedures
    • Return values from SP
    • System Stored procedures
    • Cursors
    • Triggers
    • Using triggers to maintain referential integrity

    Module 8: Transactions

    • How transaction works
    • Consistency
    • Recovery
    • Transactions and its usage
    • Transactions mode
    • Using transaction with SP, cursors