Course Details

Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures, Update database content with SQL and transaction handling, Retrieve data with filter conditions and from multiple tables using various types of join, Process data with row and aggregate functions, Creating and modifying tables, constraints and indexes, Modifying table contents, Retrieving data from tables, Applying conditions to filter retrieved rows, Joining multiple tables, Applying row and aggregate functions are some of the topics of this programme.