Create SQL Database Table From Excel Data for Your Personal Data Project

To all Data Analysts Enthusiasts, Data Scientists Beginners, and Business Intelligence Analysts, when you download an excel file from Kaggle for your personal learning projects, take it a step further, try to import the data to an MS SQL Server Database on your Local Machine.
In this video, I demonstrated
1. how to create a database in MS SQL Server for your Personal Projects
2. How to Create a Database Table from your Excel Data

Fix the ODBC Error with this video: https://youtu.be/brGq2by7DvA

Useful resources
Kaggle Data: https://www.kaggle.com/arashnic/imbalanced-data-practice?select=aug_train.csv
Setup SQL Server on your PC and Install Adventureworks Database: https://youtu.be/V9OFNuedmys
Understanding Adventureworks Database: https://youtu.be/AnfWWapSncY

SQL is one of the fastest-growing programming languages. It is widely used by Data Analyst, Data Scientist, Database Administrators, Backend Developers, etc..

As an aspiring Business Intelligence analyst and Data Analyst, you are often faced with data from different databases as against the conventional Excel files you learnt building visualization with.

You will need to demonstrate a very good knowledge of SQL as business questions will be answered not just through the drag and drops Power BI environment but by demonstrating an understanding which addresses where the data required to answer this question resides in the database, how to retrieve it, what format must it be to be fit for the analysis, etc..

This is why you need to learn Structured Query Language. Business questions beget Queries.

As a beginner or intermediate learner, this series of videos will help you learn SQL in a practical way.

#ssms #mssql #adventureworks #database