Explore

How to Import and Export Data in SQL Server Databases

2 hours on-demand video

$ 9.99

Save Course

Go to Course

Brief Introduction

Learn how to import and export data in SQL Server via all the available built-in tools such as SSIS and more

Description

This course will teach you how to import and export data in SQL Server, using all the available built-in tools, such as: SQL Server Integration Services (SSIS), BCP, SSMS tools and more. Besides the lectures, the course provides step-by-step hands-on guides, on how to efficiently work with SQL Server, with regards to importing and exporting data.

WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

"Great course! Explanations are given in simple language. Very useful examples and live demos."
"thank you it was great and useful"

MORE ABOUT THE COURSE:

SQL Server is one of the world's leading data platforms. It allows you to store, organize and retrieve data, as well as transform raw data into useful knowledge. One of the major functions that every database developer and administrator need to know, is how to import and export data in SQL Server.

Via video lectures and step-by-step guides and live demonstrations, with this course, you will learn how to efficiently perform data import and export operations in SQL Server.

AFTER THE COURSE:

You will know about all the available built-in methods and tools in SQL Server, that enable you to perform data import and export operations.
You will know how to import and export data in SQL Server:
- Using the Import Flat File Wizard in SSMS
- Using the BULK INSERT T-SQL Statement
- Using the OPENROWSET Function
- Using the SQL Server Import and Export Wizard
- Using the BCP Utility
- Using SQL Server Integration Services (SSIS)

PREREQUISITES

Basic knowledge of SQL Server and Databases

THIS COURSE CONTAINS/OFFERS:

2 hours of high-quality video
Step by step live demonstrations and guides, that will help you get started with the built-in data import and export techniques and tools in SQL Server
Downloadable resources with useful information and links
A major practice test in the end of the course
Ability to ask the instructor questions via the Q&A section
Certificate on course completion

Requirements

Requirements
Basic SQL Server knowledge
Basic Database Principles

Recommended for you

SQL Server SSAS (Multidimensional MDX) - an Introduction

Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool). Exam 70-768 Reviews: " -- Lakeside David-Debo...

Save Course

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today! SQL is the programming language used to get data in and out of databases....

Save Course

70-462: SQL Server Database Administration (DBA)

Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462. Please note: Microsoft has withdrawn the 70-462 exam....

Save Course