Introduction to SQL Programming

This 5 day hands on course is ideal for beginners new to databases and SQL programming language. Participants will learn the key concepts of databases and structured query lanaguage (SQL) and 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.

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

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 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 table 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 Aliases
• 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 and 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 and Cursors
• Creating Unions

Day 5 

Transactions and Concurrency and Programmable 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

Duration: 5 Days

Timeline and Delivery:

Our training courses are meticulously planned by Habanero Data Solutions and are designed in a manner geared towards maximum oefficiency. Your time is valuable and so is ours, so our goal is best to prepare you while taking up the least amount of your time possible. SQL Programming training will be conducted by one of our certified trainers. Daily Training lasts from 9am until 5pm.

Fee: 

SQL Programming fee is paid in naira per delegate. 

The fee includes certificates for participants. 

The payment shall be made within 7 days of receiving the invoice. 

We look forward to working with you to achieve your development needs and do feel free to let us know how we can work with your objectives.