How to Import and Export Data in SQL Server Databases
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
- Preview02:33
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, 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
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
Instructor
Artemakis is a Senior SQL Server and Software Architect and a former Microsoft Data Platform MVP (awarded for 9 consecutive years). He has over 20 years of experience and he has taught thousands of people to efficiently work with SQL Server, Data Access/Entity Framework, Azure, .NET/C#, Programming and more, via his video tutorials, blog and guest articles, public speaking, eBooks and online courses.
Artemakis published hundreds of articles and videos that explain in simple words, how to perform complex technical tasks and he really enjoys the interaction with the technical communities.
Besides his regular blogging activities, Artemakis is also a guest author on many prestigious online technology journals.
Moreover, he currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).
Artemakis, really enjoys sharing hands-on knowledge on a large set of technology topics, and thus helping his fellow tech community members, to easily start using these great technologies. To this end, he is really looking forward to seeing you in his online courses on Udemy!