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 14m
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 14m
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.