• 08082263768
  • https://sgdatanet.ng/
  • Mon - Fri: 8:00 - 16:00
Facebook Twitter Google-plus Instagram Youtube

SQL Programming

APPLY NOW
  • 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
  • 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
  • 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
  • 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

Who We Are

Who We Are We are South Gate Datanet, Nigeria’s most awarded ICT institute.

Recent Post

Categories

Copyright © 2019 | All Rights Reserved

Uni Education by Shark Themes

Please Fill Up This Form