This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, entity-relationships and how data is structured in databases, and querying that data. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts. You will also learn how to execute the most useful query and table aggregation statements for business analysts, and practice using them with real databases.
No more waiting to get data! – Time to get your ownn!
1. Understanding Relational Databases
2. Querying a Single Table
3. Querying Multiple Tables
4. Business Analysis
Please RSVP. 60 seats are available in class.
JOIN OUR FACEBOOK GROUP:
1. Laptop Charged
2. Microsoft SQL Server – https://www.microsoft.com/en-us/download/details.aspx?id=52679
3. Download the AdventureWorks Database – https://msftdbprodsamples.codeplex.com/releases/view/125550