- Mastering Excel & MySQL with Board Infinity: For Aspiring Data Scientists: Diving Deep into Spreadsheets & Databases
- Free tutorial
- Rating: 4.1 out of 54.1 (143 ratings)
- 8,149 students
- 1hr 57min of on-demand video
- Created by Board Infinity
- English
What you’ll learn
- Acquire a comprehensive understanding of the data science landscape, including key roles, industries, and opportunities for career advancement.
- Master the core functionalities of Excel for business analytics, from basic worksheet operations to advanced formatting techniques.
- Set up and navigate MySQL proficiently, laying the groundwork for effective database management and SQL operations.
- Delve deep into SQL fundamentals, mastering data types and essential commands to ensure efficient database creation and management
Requirements
- The only prerequisite is that you should have the passion to learn. You can enroll in this Data Science course even if you don’t have any coding knowledge.
Description
This course, brought to you by Board Infinity, is meticulously designed to ensure a smooth learning journey for beginners in data science. We have carefully sequenced the sections to provide a natural progression from understanding the career landscape of data science to hands-on practical training on fundamental tools such as Excel and SQL.
As students progress through the course, they will gain confidence in navigating Excel, the world’s most popular spreadsheet software, and be able to leverage it for various business analytics tasks. By mastering the core features such as formatting cells, applying the format painter, and understanding the various types of references, learners will be equipped to handle and analyze data effectively.
The concluding section offers learners an immersion into SQL, the ubiquitous language used for interacting with databases. Participants will gain firsthand experience in installing MySQL, creating and managing databases, working with different data types, and enforcing constraints on tables.
On the whole, this course serves as a stepping stone for those who aspire to start their journey in data science. It equips learners with the necessary foundation and skills to confidently explore more complex topics and techniques in the future, opening a gateway to exciting career opportunities in the dynamic field of data science. The course promises a blend of theoretical knowledge and hands-on experience to ensure that learners are well-prepared to enter the world of data science.
Who this course is for:
- This Data Science course is for students and early career professionals irrespective of their academic backgrounds. No technical or coding background is required for this Data Science course
Show less
Course content
3 sections • 22 lectures • 1h 58m total lengthCollapse all sections
Career Insights in Data Science3 lectures • 19min
- How to start your career in Data Science04:59
- Opportunities for Freshers in Data Science03:40
- Top Skills Required to become Data Scientist10:45
Business Analytics with Excel10 lectures • 1hr 1min
- Section Overview : Business Analytics with Excel00:19
- Understanding the Ribbon07:25
- What is Worksheet and Workbook08:17
- Data Types in Excel06:37
- Format Cells in Excel08:27
- How to apply format painter in Excel05:51
- References in Excel04:49
- Relative Reference in Excel04:31
- Absolute Reference in Excel05:24
- Mixed Reference in Excel09:41
- Business Analytics with Excel5 questions
Fundamentals of SQL9 lectures • 38min
- Section Overview: Fundamentals of SQL00:50
- How to Download MySQL03:54
- Install MYSQL on Windows04:12
- Drop Database in SQL02:52
- Data Types in SQL08:10
- Create Table in SQL05:01
- CONSTRAINTS in SQL04:35
- ALTER TABLE in SQL05:06
- Drop Table in SQL03:03
- Fundamentals of SQL5 questions
