How to Import and Export Data in SQL Server (Hands-On Guide)
- 2 hours on-demand video
- 2 articles
- 6 downloadable resources
- 1 Practice Test
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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)
In this lecture, you will learn how you can import data in SQL Server, using the BULK INSERT T-SQL command.
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.
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.
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.
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.
- Basic SQL Server knowledge
- Basic Database Principles
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)
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
- 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