This course will introduce you to SQL and teach you all the code you need to be able to start extracting data from a database. You DO NOT need a programming background or access to a database to be able to take this course. Beginners are welcome!
SQL is tremendously powerful and it is one of the BEST skills for finance and accounting. It is not just for data scientists! You will find SQL as a preferred job qualifications in jobs across business including FP&A, corporate finance, and accounting. SQL gives you the ability to organize, summarize, and extract any information from a database so you can use it in your analysis. This courses gives you the basic SQL language and will take your through real world examples. By the end of the course, you will be able to extract data and utilize the power of SQL!
Some key things you’ll learn:
- Key components of a database
- What is SQL, what it does, and how it links to databases
- Standard code outline for SQL (don’t be afraid of this!)
- How to summarize data
- Functions … Arithmetic and and more
We recommend taking our Intro to Data Analytics in conjunction with this course..
Format: 3-6 minute videos, quizzes, and a final exam
Category: Financial Tools & Software
Prerequisites: To get the most out of your analytics, you should have an intermediate knowledge of Excel (e.g. IF statements, VLOOKUP, COUNTIFS, etc.). However, we will not be using Excel in this course. If you are not comfortable with Excel, we recommend taking our Microsoft Excel Bootcamp.