How to Import and Export Data in SQL Server (Hands-On Guide)
4.3 (9 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
46 students enrolled

How to Import and Export Data in SQL Server (Hands-On Guide)

Learn how to import and export data in SQL Server, via all the available built-in tools such as SSIS, BCP and more!
4.3 (9 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
46 students enrolled
Last updated 4/2020
English
English [Auto]
Current price: $47.99 Original price: $79.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 2 articles
  • 6 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to import data in SQL Server using the Import Flat File Wizard in SSMS
  • How to import data in SQL Server using the BULK INSERT T-SQL Statement
  • How to import data in SQL Server using the OPENROWSET function
  • How to import and export data in SQL Server using the Import and Export Wizard
  • How to import and export data in SQL Server using the BCP Utility
  • How to import and export data in SQL Server using SQL Server Integration Services (SSIS)
Course content
Expand all 22 lectures 01:53:52
+ Introduction
1 lecture 02:33

This is the introduction to the course. We will talk about how this course is structured and what will you learn after completing this course.

Preview 02:33
+ Sample Database with Data
1 lecture 03:39

In this lecture we will create our sample database, against which we will be performing all data import/export operations for this course.

Preview 03:39
+ Data Import and Export Methods
6 lectures 41:20

In this lecture, you will learn how you can import flat files in SQL Server, by using the Flat File Wizard in SQL Server Management Studio.

Using the Import Flat File Wizard in SSMS
04:49

In this lecture, you will learn how you can import data in SQL Server, using the BULK INSERT T-SQL command.

Preview 04:46

In this lecture, you will learn how you can import data in SQL Server, using the OPENROWSET function.

Using the OPENROWSET Function
04:08

In this lecture, you will learn how you can import and export data in SQL Server, using the Import and Export Wizard in SQL Server Management Studio.

Using the SQL Server Import and Export Wizard
10:09

In this lecture, you will learn how you can import and export data in SQL Server, using the BCP utility.

Using the BCP Utility
05:27

In this lecture, you will learn how you can import and export data in SQL Server, using SQL Server Integration Services (SSIS).

Using SQL Server Integration Services (SSIS)
12:01
+ Data Import and Export Troubleshooting Tips (New)
3 lectures 09:20

In this ongoing section, you will be learning about common error messages in SQL Server that have to do with data import/export and related operations, as well as ways to resolve such errors.

About this Section
00:11

When importing data into a SQL Server table, if a column’s size is less than the size of the corresponding column in the record that is being imported, then you will get this truncation error. This lecture discusses that and via a demo you will learn how you can resolve such issues.

String or binary data would be truncated
06:26

When trying to directly, or indirectly (i.e. during a data import) convert a column of the data type “varchar” to float, under certain circumstances, you might get this error message. This lecture discusses that, and via a demo you will see how you can resolve such issues.

Error converting data type varchar to float
02:43
+ Special Topics
9 lectures 52:17

A few words about the addition of this new section (Special Topics).

About Special Topics
00:13

Via this live demonstration, you will learn how to install SQL Server and apply basic configuration.

How to Install SQL Server
11:54

In this special topic, via live demonstrations, you will learn how you can connect to SQL Server using SQL Server Management Studio (SSMS).

Connecting to SQL Server via SSMS
01:53

In this special topic, you will learn via live demonstrations, how you can create databases and other objects in SQL Server using SSMS.

Creating a Database and Other Objects in SQL Server
09:04

In this lecture, via live demonstrations, you will learn how you can run queries against SQL Server using SSMS, and how you can script procedures to T-SQL.

Running Queries in SQL Server and Scripting Procedures to T-SQL
07:10

In this special topic, via live demonstrations, you will learn how you work with SQL Server, using Azure Data Studio.

Working with SQL Server using Azure Data Studio
03:57

Before SQL Server 2019, if you would like to store characters in SQL Server using Unicode, you could achieve this by using the nvarchar and ntext data types. In this lecture and demo, you will learn about Unicode support in pre-SQL Server 2019 versions.

Using Unicode in SQL Server
03:47

UTF-8 support in SQL Server 2019 and later, makes things much simpler and more efficient, when it comes to storing UTF-8 Unicode characters (i.e. via a data import process) to tables. In this lecture and demo, we will learn more about this feature and see how it simplifies data import operations in SQL Server that have to do with UTF-8 Unicode data.

UTF-8 Support in SQL Server
03:09

Since the 2017 release, SQL Server supports not only Windows OS, but also a variety of Linux distributions such as: RedHat/CentOS, SuSE, Ubuntu, as well as Docket containers. Since I plan to add a new section regarding data import/export in SQL Server on Linux, via this special topic, we will see how we can install the latest version of SQL Server on CentOS Linux.

How to Install SQL Server on CentOS Linux
11:10
+ Wrap-Up
1 lecture 01:02

This lecture, is a recap on what we've learned in this course.

What we’ve Learned in this Course
01:02

Test what you've learned in this course by taking this practice test!

How to Import and Export Data in SQL Server
10 questions
+ Learning More
1 lecture 03:40

Bonus lecture.

Bonus Lecture
03:40
Requirements
  • Basic SQL Server knowledge
  • Basic Database Principles
Description

This course will teach you how to import and export data in SQL Server, using all the available built-in tools. 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

Who this course is for:
  • Beginner or intermediate SQL Server Developers and DBAs
  • Software developers who work with SQL Server
  • Data Professionals who work with SQL Server
  • Technology enthusiasts that want to learn more about SQL Server