- HOME
- PRODUCTS
- SERVICES
- Implementation of Galvanize Software
- Information Technology Audit (IT Audit)
- Revenue Income Assurance
- Security Audit, Vulnerability Assessment Penetration Testing
- Information Systems Security
- Information Systems Audit and Control
- Development and Implementation of BCP/DRP
- CISA, CISM, CRISC, TOGAF AND CISSP Preparation
- .
- TRAINING
- PARTNERS
- CALENDER
- CONTACT US
MENU
- HOME
- PRODUCTS
-
SERVICES
- Implementation of Galvanize Software
- Information Technology Audit (IT Audit)
- Revenue Income Assurance
- Security Audit, Vulnerability Assessment Penetration Testing
- Information Systems Security
- Information Systems Audit and Control
- Development and Implementation of BCP/DRP
- CISA, CISM, CRISC, TOGAF AND CISSP Preparation
- TRAINING
- PARTNERS
- CONTACT US
Structured Query Language(SQL)
+ Basic to intermediate level
STRUCTURED QUERY LANGUANGE(SQL)
+ Basic to intermediate level
Focus And Features:
Designed for beginner to intermediate level users, this 3-day course introduces you to SQL and database concepts. You will learn key data analysis concepts and the basics of database management systems.
Examples used in class will illustrate how understanding and querying databases can add value to your compliance efforts and audits. On completion of the course the participants will be able to use SQL effectively to interrogate and analyze data.
Focus And Features:
Designed for beginner to intermediate level users, this 3-day course introduces you to SQL and database concepts. You will learn key data analysis concepts and the basics of database management systems.
Examples used in class will illustrate how understanding and querying databases can add value to your compliance efforts and audits. On completion of the course the participants will be able to use SQL effectively to interrogate and analyze data.
Learning Objectives
This course will benefit participants in the following areas:
• Improve understanding of data concepts
• Understand database management systems
• Understanding database normalization
• Understanding data structures and Data
dictionary
• Usage of database queries and functions.
• Building and understanding database logic.
• Developing problem solving mentality.
Learning Objectives
This course will benefit participants in the following areas:
• Improve understanding of data concepts
• Understand database management systems
• Understanding database normalization
• Understanding data structures and Data
dictionary
• Usage of database queries and functions.
• Building and understanding database logic.
• Developing problem solving mentality.
What you will learn
Session 1: RELATIONAL DATABASE CONCEPTS
• What is a Relational Database?
• Relational Database Structures
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Data Types
• The Data Dictionary
Session 2: RETRIEVING DATA WITH THE SELECT
STATEMENT
• The Select Statement
• The Select and From Clauses
• Conditions and the Where Clause
• Other Conditional Operators
• Logical Operators
• The Order By Clause
• Column Aliases
• Arithmetic Operations
• Precedence of Operators
Session 3: AGGREGATE FUNCTIONS
Session 4: JOINING TABLES
• Overview of Table Joins
• Inner Joins
• Table Aliases
• Outer Joins
Session 5: BASIC SUBQUERIES AND SET OPERATORS
• Overview of Subqueries
• Basic Subqueries
• Set Operators
What you will learn
Session 1: RELATIONAL DATABASE CONCEPTS
• What is a Relational Database?
• Relational Database Structures
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Data Types
• The Data Dictionary
Session 2: RETRIEVING DATA WITH THE SELECT STATEMENT
• The Select Statement
• The Select and From Clauses
• Conditions and the Where Clause
• Other Conditional Operators
• Logical Operators
• The Order By Clause
• Column Aliases
• Arithmetic Operations
• Precedence of Operators
Session 3: AGGREGATE FUNCTIONS
Session 4: JOINING TABLES
• Overview of Table Joins
• Inner Joins
• Table Aliases
• Outer Joins
Session 5: BASIC SUBQUERIES AND SET OPERATORS
• Overview of Subqueries
• Basic Subqueries
• Set Operators
Who?
Data analytics specialists or senior auditors
What?
5-Day training course in a classroom style setting
Who?
Data analytics specialists or senior auditors
What?
5-Day training course in a classroom style setting
Explore
Ghana Address
info@rhythexconsultingghana.com
No. 9 Samora Machel Road Asylum
Down, Accra – Ghana
Tel: +23332231305, +233243301313
Lagos Address
info@rhythexconsulting.com
39A Sura Mogaji Street, Off Coker Road, Ilupeju, Lagos, Nigeria
Tel: +234 (0) 816 436 2696
Abuja Address
info@rhythexconsulting.com
Plot 624, James Agwu Onoja Street,
Block 1, Flat 2, Wuye District, Abuja.
Tel: 08179444443, 08038553466
Contact Us: 
