Home IT Courses IT Programming SQL & ADO.Net Database Programming
SQL & ADO.Net Database Programming Print E-mail

SQL & ADO.Net Database Programming

Introduction

This is the third course in the Professional Certificate in .NET Development programme. This course provides students with the technical skills required to program a database solution by using SQL Server and ADO .NET

At the end of the course students will be able to:

  • describe the elements of SQL Server;
  • describe the conceptual basis of programming in Transact-SQL;
  • create and manage databases and their related components;
  • describe data-centric applications, ADO .NET architecture;
  • connect to SQL Server and other data sources;
  • perform connected database operations including executing SELECT commands,
  • database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database.

Prerequisites

Course Outline

Introduction to Transact-SQL

  • The Transact-SQL Programming Language
  • Types of Transact-SQL Statements
  • Transact-SQL Syntax Elements

     

Using Transact-SQL Querying Tools

  • SQL Query Analyzer
  • Using the Object Browser Tool in SQL Query Analyzer
  • Executing Transact-SQL Statements
  • Creating and Executing Transact-SQL Scripts

Retrieving Data

  • Retrieving Data by Using the SELECT Statement
  • Filtering Data
  • Formatting Result Sets
  • Retrieving Data and Manipulating Result Sets

Grouping and Summarising Data

  • Using Aggregate Functions
  • GROUP BY Fundamentals
  • Grouping and Summarising Data

     

Joining Multiple Tables

  • Using Aliases for Table Names
  • Combining Data from Multiple Tables
  • Combining Multiple Result Sets
  • Querying Multiple Tables

     

Modifying Data

  • Inserting Data
  • Deleting Data
  • Updating Data
  • Modifying Data

     

Implementing Stored Procedures

  • Creating, Executing, Modifying, and Dropping
  • Stored Procedures
  • Using Parameters in Stored Procedures

Connecting to Data Sources and Performing Connected Database Operations using ADO.NET

  • Understanding How VB .NET Uses a Database
  • Choosing a .NET Data Provider
  • Defining a Connection
  • Managing a Connection
  • Handling Connection Exceptions
  • Working in a Connected Environment
  • Building Command Objects
  • Working with Commands That Return a Single Value, Rows
  • Working with Commands That Do Not Return Rows