Description
In this course, you will :
- Develop a thorough overview of the data science ecosystem, including major positions, sectors, and prospects for progress.
- Learn the fundamentals of Excel for business analytics, including basic worksheet operations and sophisticated formatting techniques.
- Set up and navigate MySQL with ease, laying the groundwork for successful database management and SQL operations.
- Learn SQL essentials, including data types and important operations, to guarantee efficient database construction and management.
Syllabus:
1. Career Insights in Data Science
- How to start your career in Data Science
- Opportunities for Freshers in Data Science
- Top Skills Required to become Data Scientist
2. Business Analytics with Excel
- Understanding the Ribbon
- What is Worksheet and Workbook
- Data Types in Excel
- Format Cells in Excel
- How to apply format painter in Excel
- References in Excel
- Relative Reference in Excel
- Absolute Reference in Excel
- Mixed Reference in Excel
- Business Analytics with Excel
3. Fundamentals of SQL
- How to Download MySQL
- Install MYSQL on Windows
- Drop Database in SQL
- Data Types in SQL
- Create Table in SQL
- CONSTRAINTS in SQL
- ALTER TABLE in SQL
- Drop Table in SQL
- Fundamentals of SQL