SQL Training Overview

SQL is a powerful data manipulation language. This course will help you understand the basic concepts of relational databases, write SQL subqueries, combine multiple queries into a single query and report aggregated data using group functions. Run data manipulation statements (DML), create indexes and constraints. Some of the date-time functions are also covered.

• Retrieving data with the SQL SELECT Statement
• Introducing the SQL SELECT Statement
• SQL Expressions and Operators
• Restricting and Sorting Data
• The WHERE clause, Comparison Operators
• Boolean Operators , Precedence Rules
• Single-Row Functions
• Types of Functions
• Using Character Case Conversion & Manipulation Functions
• Using Numeric Functions, Working with Dates & Using Date Functions
• Using Conversion Functions and Conditional Expressions
• Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using the Group Functions
• Using the Group Functions, Grouping by Multiple Columns
• The NATURAL JOIN Clause
• Displaying Data from Multiple Tables
• Joining Tables Using SQL
• Inner versus Outer Joins ,Outer joins, full outer joins
• Using Subqueries to Solve Problems
• Use of a Subquery Result Set for Comparison Purposes
• Generate a Table from Which to SELECT
• Using the Set Operators
• Sets and Venn Diagrams
• Union all operator, union operator
• intersect operator , minus operator
• Manipulating Data (DML)
• Insert, Update, Delete, Merge, Truncate
• Using DDL Statements to Create and Manage Tables
• Creating Tables, Drop Tables
• Creating Other Schema Objects
• CREATE VIEW, ALTER VIEW
• Creating and Using Indexes, Modifying and Dropping Indexes