SQL Programming

Rationale

With this workshop, you will acquire some seriously marketable programming skills! You can't consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company's biggest asset is their data. All databases require the language SQL to store and retrieve data.

Course Methodology

This workshop would be a complete hands-on learning where by the participants are exposed to the fundamentals of Oracle SQL syntax. It is a complete requirements if you are planning to  forge ahead in your career. As part of the requirements for this course, participants are expected  to have  Oracle database installed on their PC .

Course Objectives

This course offers you an introduction to Oracle Database  database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects.

Target Audience

Business Analysts, Developers, IT Administrators, Sales Managers

Course Outline

Database Basics

•         Overview of Relational Database Concepts
•         What is a relational database management system?
•         Databases! Why do we need them?
•         Data Modeling and Design
•         Relational Database Structures
•         Brief overview of typical databases: Microsoft Access and SQL Server
•         Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
•         Building a database

Single Table Queries

•         Retrieving Data using the SELECT Clause
•         Using the WHERE Clause in Query
•         Using Operators in the WHERE Clause
•         Combining WHERE, AND,& OR WITH OPERATORS
•         Query Filtering Continued BETWEEN,IN and NULL
•         Query Filtering Conditions & Operator Precedence
•         Ordering , Concatenating& Aliasing Query Results 

Single Row Functions

•         Single Row Function Using The Dual Table
•         Using Functions in Where and Character Based
•         Numeric and Date Data types single row functions
•         Conversion single row function and Date formatting
•         More Date functions
•         Conclusion of Single row functions & NULL/NULLIF functions

Grouping Functions

•         Grouping Functions MIN,MAX,AVG,COUNT
•         GROUP BY Clause & HVING Clause

Multi-Table Queries and Joins

•         SELECT within SELECT(Subqueries)
•         Relating Tables Together Using JOINS
•         Joins Continued INNER & OUTER Joins
•         Correlated Subqueries with EXIST & NOT

Creating, Altering and Updating Objects using SQL

•         Creating Your own Tables& Design
•         Inserting Data into our Table
•         Create Table with a Primary key Constraint
•         Using ALTER to modify the table structure
•         Create Table with SELECT+UPDATE Data
•         Primary and Foreign Keys
•         DELETE, TRUNCATE, DROP COMMANDS
•         Working With Database Index
•         System Tables, Pseudo Columns& Deleting Duplicates
•         Views and Other Objects and Commands
•         Granting and Revoking Privileges