-
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.
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.
Topics:- 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
Overview
