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

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 07035368449 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 (Sturctured 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 Lekki, 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 07035368449

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

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

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 07035368449 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 (Sturctured 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 Lekki, 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 07035368449

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

Please what's the price for the course?