Extracting Database Information: Business Coding Playbook

Learn how to consolidate your spreadsheets and other sources into one SQL Server database, create some code to query it for analysis, and how to ask for permission to someone else's database in this business coding playbook course.
Course info
Level
Beginner
Updated
Feb 26, 2018
Duration
2h 13m
Table of contents
Course Overview
Getting Orientated with a High-level Overview
Installing a Database Engine and Code Editor Locally or in the Cloud
Getting Data into a Database
Accessing an Organization’s Database
Connecting to a Database from Code
Querying the Database
Exporting Data to Disk from Code
Description
Course info
Level
Beginner
Updated
Feb 26, 2018
Duration
2h 13m
Description

As a business analyst or beginning software developer you may have struggled with getting access to someone else’s database. You might have wondered how to get all of your data sources into one database where you can then write some simple code to query, analyze, and export it for sharing or reporting. In this course, Extracting Database Information: Business Coding Playbook, you'll learn how to quickly clear obstacles in your path and gain the tools you need in order to access a SQL Server database from code. First, you'll learn about what it takes to connect to someone else’s database, and if you aren’t able to connect to it, how to request the appropriate backup. Next, you'll see how easy it is to combine data from spreadsheets, text files, and Microsoft Access databases into one SQL Server Database and how to still use your spreadsheet or Access database to work with that SQL Server database. Finally, you’ll gain just enough coding and querying skills to enable you to take your first steps towards analyzing data from code and exporting it back to disk. When you're finished with this course, you'll have the groundwork necessary to start working with SQL Server databases and will be ready to start learning more about how to query and analyze that data from code.

About the author
About the author

Rusty Divine is technical lead, presenter, and blogger who lives in Nebraska and works with a happy team of agile developers. Rusty specializes in .Net web applications for businesses and enjoys working with customers and stakeholders, coaching developers, and grilling gourmet burgers.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello, my name is Rusty Divine. Welcome to extracting database information, as a business coding playbook. This course is an introduction to working with a database from code. After watching it, you will be able to combine various data sources into one database that you will connect to from code, extract that data for analysis, and then export it to disc. Along the way, you'll find tips and tricks to clear some common road blocks. You do not need any experience working with databases or code before watching this course. It's designed for anyone interested in taking that first step to learning how to connect to a database and for anyone who has started their journey but has hit road blocks along the way. The playbook format of this course is designed to make each module and clip independent so that they can be watched in any order to help you find the answer you need quickly. This course will introduce you to using Visual Studio for writing code and SQL Server Management Studio for working with SQL server databases. You will learn how to install these tools on your machine and how to install them on a virtual machine in the cloud in case you cannot install the tools locally. I hope you enjoy this playbook course on extracting database information at Pluralsight. Be sure to check out the exercise files and the discussion area where you could ask any questions you would like for clarification on the topics covered in this course.

Getting Orientated with a High-level Overview
Welcome to this Pluralsight course for Extracting Database Information, a Business Coding Playbook. My name is Rusty Divine and I want to help you get started with connecting to databases from code. I'm glad you have started watching this course and I'm excited to introduce working with data from code to you. The first module will introduce you to some terms and concepts that you will encounter later in the course. It's intended as a high level overview to help you understand the context for the remaining modules. So let's get started.

Installing a Database Engine and Code Editor Locally or in the Cloud
In this module on installing a database engine and code editor, you will learn how to install SQL Server with Management Studio and Visual Studio on your Windows machine. If you do not have a Windows machine, or privileges to install these tools, or if you just want to experiment with the cloud, then check out the clips in this module where I will show you how to create a virtual machine in Microsoft Azure cloud, where you can install these tools and work with them through a remote desktop program.

Getting Data into a Database
Having data spread across various sources such as text files and spreadsheets makes it difficult to analyze and interpret that data. In this module on getting your data into a database you will learn how to import data from various sources into one SQL Server database, so that it's easier to work with.

Accessing an Organization’s Database
The data you would like to analyze might be managed by someone else, either within your organization or at a different location. In this module, you'll learn just enough about how sequel server security works to be comfortable asking for the appropriate access to the database you want to analyze. You should try to limit your access to just what you need, so that you don't accidentally affect the database and aren't someone they even need to worry about if something does go wrong. There are a few typical scenarios to cover for requesting access to a database. You may want to work with another organization's database but don't know how you can connect to their database from your network. In this scenario, you'll benefit from understanding how security between two networks is configured. The database itself might be managed by your organization, and you just need to request permission to read or write to the database. Some of the data may be sensitive and off limits to you, or there may be concerns about ensuring the data cannot be altered in any way. So you will need to understand how security within SQL server operates so that you can request the appropriate level of access. Sometimes an organization cannot grant you direct access to their database, but you may be able to compromise or request a backup of their database that you can then restore on your machine to complete your work. It's also a good practice to frequently backup your own database and know how to restore it in case of any data integrity problems. The remainder of this module delves deeper into each of these three scenarios to show you what you need to know when asking to access someone else's database.

Connecting to a Database from Code
Connecting to a database from code requires a connection string to provide the address and credentials to the database server. It sounds simple, but there are many variations on how to form that connection string depending on your database server and situation. In this module, you will learn how to make that connection from wherever you need to do it.

Querying the Database
Welcome to this module on querying the database where you'll be introduced to how to write queries to analyze the data in a database. After learning these basics, you'll be ready to try some queries out on your own and if you find you want to learn a little bit more about it, check out the Introduction to SQL course here on Pluralsight.