₦airaland Forum

Progress your career today with a 5 Day Introduction to SQL Programming Course

19th - 23rd October 2020

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking an Introduction to SQL Progamming course. To enrol or register please call 08103382376 or email training@habanerodata.net



This 5 day hands on course is ideal for beginners new to databases and SQL programming language. The course will benefit anyone (technical & non-technical) who needs to understand and use SQL to manipulate a database.

The course will provide participants with the key concepts of databases and structured query lanaguage (SQL). Participants will learn how to read and write simple and complex SQL statements. Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL.

Audience: Business Analysts, Developers, IT Administrators, Sales Managers

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to databases and SQL (Structured Query Language)

On the first day delegates will learn about the basic structure and history of relational datbases. Delegates will then understand what SQL is and how it used with a relational database.

Overview of Relational Database Concepts
What is a relational database management system?
Databases! Why do we need them?
Relational Datbase Structures
Brief overview of typical databases: Microsoft Access and SQL Server
Introduction to SQL:
Overview of SQL (Stuructured Query Lanaguage)
Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
Building a database
Creating tables and columns
Building tables with CREATE TABLE
Altering tables with ALTER TABLE
How to add columns to existing tables
How to add a Primary Key
How to add a Foreign Key
Adding a Data Type to a Table
How to improve performance with Indexes
Selecting Data: The SELECT statement
Setting Criteria using WHERE Clause
Inserting into a Table: The INSERT Statement
Updating a Table: The UPDATE Statement
Modifying a Table structure with ALTER Statement
Deleting from a Table: The DELETE Statement
Removing a tables with DROP statement

Day 2

Manipulating Data

How to add Table Row with INSERT
How to change rows with UPDATE
How to remove row with DELETE
Filtering Data
Having Clause
Order By
Joining Database Tables
Overview of Table Joins
Table Aliasas
Inner Joins
Outer Joins
Self Joins
Other Joins
Cross Joins
Full Outer joins
Aggregation and Grouping
Summarizing and Grouping Data

Day 3

Functions, Subqueries and Aggregated Data

Overview of SQL Functions
Creating Functions
Working with Subqueries
SUM, AVG, MIN, MAX
Ways to count
Group By Clause
Filtering data using the Having Clause
Overview of Subqueries
Basic Subqueries
String Functions

Day 4

Understanding views & performing analytics with functions

Date and Time Functions
Text Functions
NULL Functions
Overview of Stored Procedures
Creating Stored Procedures
Passing Parameters
Basic Variables
Creating and Understanding Views
Understanding Triggers & Cursors
Creating Unions

Day 5

Transactions and Concurrency and Programmble Objects

Introduction to Transactions
Transaction Control
Controlling transactions with COMMIT command and ROLLBACK command
Using BEGIN TRANSACTION in SQL SERVER
Properties of Transactions
Locks and Blocking
Isolation Levels
Deadlocks
Variables
Cursors
Temporary Tables
Dynamic SQL
Error Handling

Your Trainer

Our international certified trainers are highly experienced SQL practitioners who have real-world expertise.
Key Information

I – All course material including a copy of Head First SQL book will be provided to all candidates.

II – All candidates will be guided on how to install Microsoft SQL Server

III – Training will be delivered via Microsoft Teams

For more information on our training, please enquire use the form above or call 08103382376

Course: ArcGIS Essentials
Date: 19th - 21st October 2020

Learn how to use ArcGIS from beginners to advanced techniques. Enter the word of spatial analysis with geographic information systems (GIS). In this course you will learn the basics of the industry leading software tool, ArcGIS during this 3 day online session.

Beginners to geographic information systems (GIS) will learn how to visualise, analyze, and interpret location information already present in their data. This course introduces GIS concepts, demonstrates GIS workflows in code and explores GIS resources.

For more information or to register call 08103382376 or email: training@habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

21st - 25th September 2020: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day online course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 2020.3

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days Online, 40 Academic Hours

For more information on our training, please call 08103383276 or visit www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

21st - 25th September 2020: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day online course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 2020.3

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days Online, 40 Academic Hours

For more information on our training, please call 08103383276 or visit www.habanerodata.net

Get the skills you need in a weekend!

Habanero Data Solutions offer online weekend courses for beginners new to data visualisation. We deliver 2 day (sat & sun) courses in Power BI, Qlikview and Tableau all delivered directly from the comfort of your home or premises via Zoom.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


For more details on our courses and prices or to register for our online sessions call 08103382376 or email: training@habanerodata.net

Our next sessions:

Power BI Essentials:
29th - 30th August 2020
5th - 6th September 2020

Tableau Essentials:
22nd - 23rd August 2020
29th - 30th August 2020

Qlikview Essentials:
5th - 6th September 2020
12th - 13th September 2020


Habanero Data Solutions
Tel: 08103382376
Email: Training@habanerodata.net
Web: www.habanerodata.net

Get the skills you need in a weekend!

Habanero Data Solutions offer online weekend courses for beginners new to data visualisation. We deliver 2 day (sat & sun) courses in Power BI, Qlikview and Tableau all delivered directly from the comfort of your home or premises via Zoom.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


For more details on our courses and prices or to register for our online sessions call 08103382376 or email: training@habanerodata.net

Our next sessions:

Power BI Essentials:
29th - 30th August 2020
5th - 6th September 2020

Tableau Essentials:
22nd - 23rd August 2020
29th - 30th August 2020

Qlikview Essentials:
5th - 6th September 2020
12th - 13th September 2020


Habanero Data Solutions
Tel: 08103382376
Email: Training@habanerodata.net
Web: www.habanerodata.net

(Modify) (Quote) (Report) (Share)

Course: Power BI Essentials
Venue: Zoom
Date: 29th - 30th August 2020

Habanero Data Solutions deliver a 2 day Microsoft Power BI Essentials Course online designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses via Zoom:

29th - 30th August 2020

Develop and enhance your data skills with our Online Data Analytics and Business Intelligence training. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence and Data Analytics courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend people new to Data Science and Analytics but also Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.


Contact us today to register.

Phone: 08103382376
Email: training@habanerodata.net

Course: Power BI Essentials
Venue: Zoom
Date: 6th - 7th August 2020

Habanero Data Solutions deliver a 2 day Microsoft Power BI Essentials Course online designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses via Zoom:

6th - 7th August 2020

Course: Power BI Essentials
Venue: Zoom
Date: 6th - 7th August 2020

Habanero Data Solutions deliver a 2 day Microsoft Power BI Essentials Course online designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses via Zoom:

6th - 7th August 2020

Develop and enhance your data skills with our Online Data Analytics and Business Intelligence training. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence and Data Analytics courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.


Contact us today to register.

[b]Phone: [/b]08103382376
[b]Email: [/b]training@habanerodata.net

Master Power BI from the comfort of your own home

Course: Power BI Essentials
Venue: Zoom
Date: 6th - 7th August 2020

Habanero Data Solutions deliver a 2 day Microsoft Power BI Essentials Course online designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses via Zoom:

6th - 7th August 2020

Get the skills you need in a weekend!

Habanero Data Solutions offer online weekend courses for beginners new to data visualisation. We deliver 2 day (sat & sun) courses in Power BI, Qlikview and Tableau all delivered directly from the comfort of your home or premises via Zoom.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


For more details on our courses and prices or to register for our online sessions call 08103382376 or email: training@habanerodata.net

Our next sessions:

Power BI Essentials:
25th - 26th July 2020
1st - 2nd Aug 2020

Tableau Essentials:
4th - 5th July 2020
11th - 12th July 2020

Qlikview Essentials:
18th - 19th July 2020
25th - 26th July 2020


Habanero Data Solutions Ltd
Tel: 08103382376

Get the skills you need in a weekend!

Habanero Data Solutions offer online weekend courses for beginners new to data visualisation. We deliver 2 day (sat & sun) courses in Power BI, Qlikview and Tableau all delivered directly from the comfort of your home or premises via Zoom.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


For more details on our courses and prices or to register for our online sessions call 08103382376 or email: training@habanerodata.net

Our next sessions:

Power BI Essentials:
25th - 26th July 2020
1st - 2nd Aug 2020

Tableau Essentials:
4th - 5th July 2020
11th - 12th July 2020

Qlikview Essentials:
18th - 19th July 2020
25th - 26th July 2020


Habanero Data Solutions
Tel:08103382376

Master Power BI from the comfort of your own home

Power BI Essentials
Venue: Zoom
Date: 6th - 7th July 2020

Habanero Data Solutions deliver a 2 day Microsoft Power BI Essentials Course online designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses in Lagos:

6th - 7th July 2020

Master Power BI from the comfort of your own home

Power BI Essentials
Venue: Zoom
Date: 6th - 7th July 2020

Habanero Data Solutions deliver a 2 day Microsoft Power BI Essentials Course online designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses in Lagos:

6th - 7th July 2020

Master Power BI from the comfort of your own home

Power BI Essentials
Venue: Zoom
Date: 6th - 7th July 2020

Habanero Data Solutions deliver a 2 day Microsoft Power BI Essentials Course online designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses in Lagos:

6th - 7th July 2020

Master Power BI from the comfort of your own home

Power BI Essentials
Venue: Zoom

Habanero Data Solutions deliver a 2 day Microsoft Power BI Essentials Course online designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses in Lagos:

25th - 26th June 2020
16th - 17th July 2020

Get the skills you need in a weekend!

Habanero Data Solutions offer online weekend courses for beginners new to data visualisation. We deliver 2 day (sat & sun) courses in Power BI, Qlikview and Tableau all delivered directly from the comfort of your home or premises via Zoom.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


For more details on our courses and prices or to register for our online sessions call 08103382376 or email: training@habanerodata.net

Our next sessions:

Power BI Essentials:
6th - 7th June 2020
18th - 19th June 2020

Tableau Essentials:
13th - 14th June 2020
22nd - 26th June 2020

Qlikview Essentials:
15th - 19th June 2020
22nd - 26th June 2020


Habanero Data Solutions
Tel:08103382376

Get the skills you need in a weekend!

Habanero Data Solutions offer online weekend courses for beginners new to data visualisation. We deliver 2 day (sat & sun) courses in Power BI, Qlikview and Tableau all delivered directly from the comfort of your home or premises via Zoom.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


For more details on our courses and prices or to register for our online sessions call 08103382376 or email: training@habanerodata.net

Our next sessions:

Power BI Essentials:
6th - 7th June 2020
18th - 19th June 2020

Tableau Essentials:
13th - 14th June 2020
22nd - 26th June 2020

Qlikview Essentials:
15th - 19th June 2020
22nd - 26th June 2020


Habanero Data Solutions
Tel:08103382376

Develop and enhance your data skills with our Data Analytics and Business Intelligence training. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence and Data Analytics courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.


Contact us today to register.

Phone: 08103382376
Email: training@habanerodata.net
Web: www.habanerodata.net

Develop and enhance your data skills with our Data Analytics and Business Intelligence training. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence and Data Analytics courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.


Contact us today to register.

Phone: 08103382376
Email: training@habanerodata.net
Web: www.habanerodata.net

Get the skills you need in a weekend!

Habanero Data Solutions offer weekend courses to help data professionals and beginners new to the data science field to learn and develop data visualisation skills. We deliver 2 day (sat & sun) essentials courses in Power BI, Qlikview and Tableau in Abuja.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


Our next sessions:

Power BI Essentials:
6th - 7th June 2020
23th - 24th July 2020

Tableau Essentials:
16th-17th May 2020
13th - 14th June 2020

Qlikview Essentials:
30th - 31st May 2020
23th - 24th July 2020

For more details on our courses and prices or to enrol call 08103382376 or email: training@habanerodata.net

Get the skills you need in a weekend!

Habanero Data Solutions offer weekend courses to help data professionals and beginners new to the data science field to learn and develop data visualisation skills. We deliver 2 day (sat & sun) essentials courses in Power BI, Qlikview and Tableau in Abuja.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


Our next sessions:

Power BI Essentials:
23rd - 24th May 2020
6th - 7th June 2020

Tableau Essentials:
16th-17th May 2020
13th - 14th June 2020

Qlikview Essentials:
23rd - 24th May 2020
30th - 31st May 2020

For more details on our courses and prices or to enrol call 08103382376 or email: training@habanerodata.net

Power BI Essentials:

Habanero Data Solutions we deliver a 2 day Microsoft Power BI Essentials Course designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses in Lagos:

28th - 29th May 2020

Habanero Data Solutions we deliver a 2 day Microsoft Power BI Essentials Course designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses in Lagos:

28th - 29th May 2020

Get the skills you need in a weekend!

Habanero Data Solutions offer weekend courses to help data professionals and beginners new to the data science field to learn and develop data visualisation skills. We deliver 2 day (sat & sun) essentials courses in Power BI, Qlikview and Tableau in Lagos.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


Our next sessions:

Power BI Essentials:
23rd - 24th May 2020
6th - 7th June 2020

Tableau Essentials:
16th-17th May 2020
13th - 14th June 2020

Qlikview Essentials:
23rd - 24th May 2020
30th - 31st May 2020

For more details on our courses or to enrol call 08103382376 or email: training@habanerodata.net

Free no obligation demo of Power BI

Organizations are accumulating data at a faster pace than ever before. However, this data is only valuable when converted into information that can be easily digested by stakeholders. Sharing critical, easy-to-read pieces of information directly with stakeholders provides valuable insights that will empower you to transform your business.

We can help deploy and develop Power BI dashboards that display the current state of your business with visualisations that reflect KPIs from big strategic goals down to the measure of each department and employee.

Is your organisation interested in deploying or training in Power BI? Contact habanero Data Solutions for a free no obligation demo on 08103382376

Get the skills you need in a weekend!

Habanero Data Solutions offer weekend courses to help data professionals and beginners new to the data science field to learn and develop data visualisation skills. We deliver 2 day (sat & sun) essentials courses in Power BI, Qlikview and Tableau in Lagos.

Data visualization is becoming more commonplace every day with the popularity across companies acrosss Nigeria.

When you complete any of our courses you will have the skills and knowledge of data visualization needed to build visually-appealing, impactful, and effective charts in the data visualization software tools.


Our next sessions:

Power BI Essentials:
23rd - 24th May 2020
6th - 7th June 2020

Tableau Essentials:
16th-17th May 2020
13th - 14th June 2020

Qlikview Essentials:
23rd - 24th May 2020
30th - 31st May 2020

For more details on our courses or to enrol call 08103382376 or email: training@habanerodata.net

Progress your career today with a 5 Day Introduction to SQL Programming Course

22nd - 26th June 2020

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking an Introduction to SQL Progamming course. To enrol or register please call 08103382376 or email training@habanerodata.net



This 5 day hands on course is ideal for beginners new to databases and SQL programming language. The course will benefit anyone (technical & non-technical) who needs to understand and use SQL to manipulate a database.

The course will provide participants with the key concepts of databases and structured query lanaguage (SQL). Participants will learn how to read and write simple and complex SQL statements. Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL.

Audience: Business Analysts, Developers, IT Administrators, Sales Managers

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to databases and SQL (Structured Query Language)

On the first day delegates will learn about the basic structure and history of relational datbases. Delegates will then understand what SQL is and how it used with a relational database.

Overview of Relational Database Concepts
What is a relational database management system?
Databases! Why do we need them?
Relational Datbase Structures
Brief overview of typical databases: Microsoft Access and SQL Server
Introduction to SQL:
Overview of SQL (Stuructured Query Lanaguage)
Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
Building a database
Creating tables and columns
Building tables with CREATE TABLE
Altering tables with ALTER TABLE
How to add columns to existing tables
How to add a Primary Key
How to add a Foreign Key
Adding a Data Type to a Table
How to improve performance with Indexes
Selecting Data: The SELECT statement
Setting Criteria using WHERE Clause
Inserting into a Table: The INSERT Statement
Updating a Table: The UPDATE Statement
Modifying a Table structure with ALTER Statement
Deleting from a Table: The DELETE Statement
Removing a tables with DROP statement

Day 2

Manipulating Data

How to add Table Row with INSERT
How to change rows with UPDATE
How to remove row with DELETE
Filtering Data
Having Clause
Order By
Joining Database Tables
Overview of Table Joins
Table Aliasas
Inner Joins
Outer Joins
Self Joins
Other Joins
Cross Joins
Full Outer joins
Aggregation and Grouping
Summarizing and Grouping Data

Day 3

Functions, Subqueries and Aggregated Data

Overview of SQL Functions
Creating Functions
Working with Subqueries
SUM, AVG, MIN, MAX
Ways to count
Group By Clause
Filtering data using the Having Clause
Overview of Subqueries
Basic Subqueries
String Functions

Day 4

Understanding views & performing analytics with functions

Date and Time Functions
Text Functions
NULL Functions
Overview of Stored Procedures
Creating Stored Procedures
Passing Parameters
Basic Variables
Creating and Understanding Views
Understanding Triggers & Cursors
Creating Unions

Day 5

Transactions and Concurrency and Programmble Objects

Introduction to Transactions
Transaction Control
Controlling transactions with COMMIT command and ROLLBACK command
Using BEGIN TRANSACTION in SQL SERVER
Properties of Transactions
Locks and Blocking
Isolation Levels
Deadlocks
Variables
Cursors
Temporary Tables
Dynamic SQL
Error Handling

Your Trainer

Our international certified trainers are highly experienced SQL practitioners who have real-world expertise.
Key Information

I – All course material including a copy of Head First SQL book will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed Microsoft SQL Server 2016.

III – Our training venue is based in Ikeja, Lagos (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire use the form above or call 08103382376

Habanero Data Solutions we deliver a 2 day Microsoft Power BI Essentials Course designed to give participants a good understanding of data analysis with Power BI. During the course you'll get a comprehensive overview of all the features and functions that will enable you to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI mobile apps.

Our consultants are expert trainers who will guide you into mastering this data visualisation tool.

Power BI users have a range of potential careers including data analysts, business analysts, data scientists.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Training Includes course materials, completion certificate & refreshments

Register for a place on this course by calling 08103382376 or email:training@habanerodata.net
Course details: https://www.habanerodata.net/courses/powerbi/

Next available courses in Lagos:

28th - 29th May 2020

25th - 29th May 2020: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 2020.1

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

For more information on our training, please call 08103383276 or visit www.habanerodata.net