Understand Database Connection Methods

Practice Labs Module
Difficulty
Intermediate

The "Understand Database Connection Methods" module provides you with the instructions and devices to develop your hands on skills in the following topics: Connecting & Importing a flat file to SQL Server 2012, Importing Data from an XML file to SQL database in SQL Server 2012, Creating Simple ASP.NET Web Forms to connect to SQL Database.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Understand Database Connection Methods module provides you with the instructions and devices to develop your hands on skills in the following topics:

  • Connecting & Importing a flat file to SQL Server 2012
  • Importing Data from an XML file to SQL database in SQL Server 2012
  • Creating Simple ASP.NET Web Forms to connect to SQL Database

Exercise 1 - Connecting and Importing a Flat File to SQL Server 2012

In this exercise, you will learn to connect & import a Flat file to SQL Server using SQL Server 2012.

Exercise 2 - Importing a XML file to SQL Server 2012

In this exercise, you will learn to export a SQL Table content to XML and also to import the XML data to SQL Table using SQL Server 2012.

Exercise 3- Creating ASP.NET Web Form to Connect AdventureWorks Database

In this exercise, you will learn to create Simple ASP.NET Web form and connect it with Adventure Works database to display order details of a particular product.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.