Simple play icon Course
Skills Expanded

Extracting Database Information: Business Coding Playbook

by Rusty Divine

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.

What you'll learn

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.

Table of contents

Course Overview

About the author

Rusty Divine is a technical lead who cultivates a fun and friendly environment for his agile team where it is safe to make mistakes and continually learn. Rusty specializes in .Net web applications for businesses and enjoys working with customers and stakeholders, coaching developers, and helping manage projects. Rusty has a scientist's training and curiosity with a degree in Geology that took him to Antarctica to study climate change for a season. Rusty also enjoys cooking and one day will crea... more

Ready to upskill? Get started