Next course begins April 1st

Introduction to SQL Programming

Our 5 day Introduction to SQL Programming course is ideal for beginners new to databases and SQL. In this course participants will gain a strong understanding of using SQL and thus gain the skills necessary to manipulate, analyse and visualise data from complex relational databases. 

What you'll learn

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 language (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.

Course Content

On the first day delegates will learn about the basic structure and history of relational databases. 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 Database Structures
  • Brief overview of typical databases: Microsoft Access and SQL Server
  • Introduction to SQL:
  • Overview of SQL (Structured Query Language)
  • 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
  • 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
  • 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
  • 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
  • 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

Upcoming Dates

LocationDatePrice
LagosApril 1st, 2024₦300,000

Delivery Methods

Classroom Training

Unlock your potential with our classroom training courses. Our portfolio of business intelligence training courses are delivered by BI experts across Africa.

Online Training

Our online trainings (live instructor-led) are delivered by certified instructors and are designed to replicate a classroom experience which enables full interactions.

Onsite Training

Our onsite training team allows us to bring our skills and expertise to you. Onsite courses are developed in conjunction with you, ensuring your expectations are exceeded.

1-to-1 Training

With our one-to-one training you’ll not only receive the undivided attention of the trainer, but one-to-one training allows you to tailor the training to your specific needs.

From ₦300,000

Certification

Refreshments

Training multiple people?

Empower your teams with business intelligence training courses delivered by subject matter experts.

Apply for Introduction to SQL Programming

Which date are you interested in?

Apply for Introduction to SQL Programming

Which date are you interested in?