Data Science for Beginners: Your Step-by-Step Guide To Start

Name: Data Science for Beginners: Your Step-by-Step Guide To Start
Rating: 4.3 (547 reviews)

Mastering Excel & MySQL with Board Infinity: For Aspiring Data Scientists: Diving Deep into Spreadsheets & Databases

Created byBoard Infinity

Last updated 8/2023

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.

Course content

3 sections • 22 lectures • 1h 58m total length

How to start your career in Data Science4:59
This course presents an in-depth introduction into how you can launch a career in the rapidly growing field of Data Science. The rise in data-oriented positions has sparked interest amongst budding professionals to augment their skills and knowledge across multiple sectors such as logistics, business intelligence, machine learning, data architecture, and notably, data science.
Data science, a critical domain witnessing substantial growth, has opened up numerous career avenues for professionals adept at coding, analytics, maths, statistics, and data visualization.
The attractiveness of a career in data science is not only limited to its current demand but also its widespread application across various sectors such as retail, government, banking, media and communications, transportation, healthcare, and education, making it a promising career choice for many.
Opportunities for Freshers in Data Science3:40
In this video, we'll explore how to launch a successful career in Data Science. According to a report by analyticsindiamag.com, there were 97,000 data science and analytics job openings in India in 2019, a number that's expected to rise.
The Economic Times predicts that by 2022, job opportunities in the field of data science will surge to nearly 200,000. As the influence of Data Science grows, so too does its capacity to inform strategic, data-led decision-making across industries.
Industries such as Banking, Financial Services, Insurance (BFSI), Energy, Pharma, and E-Commerce are seeing a tremendous uptick in demand for data scientists, as reported by DQIndia. Indeed, Data Science has been dubbed the "Sexiest Job of this Century".
With such promising growth, it's no surprise that there are ample opportunities for newcomers in the field of data science.
Top Skills Required to become Data Scientist10:45
This video provides insights into the Essential Abilities Needed to Pursue a Career in Data Science.
Data Scientists are the mainstay in the organization who handle and scrutinize vast quantities of both organized and disorganized data. Their role marries the disciplines of mathematics, statistics, and computer science to decipher the complexities of massive data and employ this information in forging business strategies.
The duties of a Data Scientist encompass data collection, processing, modelling, and interpretation using a diverse range of tools, from advanced technology to evolving industry trends, with the ultimate aim of crafting actionable strategies. Moreover, they ensure the integrity and comprehensiveness of the data by thoroughly cleaning and validating it.

Section Overview : Business Analytics with Excel0:19
Understanding the Ribbon7:25
In this lecture, we will be understanding the fundamentals of Excel and introducing the ribbon in Ms-Excel.
So what is Excel?
Excel is a spreadsheet application developed and published by Microsoft. It is part of the Microsoft Office suite of productivity software.
The ribbon provides shortcuts to commands in Excel. A command is an action that the user performs.
An example of a command is creating a new document, printing a document, etc. We will also understand the different options present in the ribbon tabs.
What is Worksheet and Workbook8:17
In this lecture, we will be understanding the fundamentals of Excel and learning about the various data types present in Excel. What is Excel? Excel is a spreadsheet application developed and published by Microsoft. It is part of the Microsoft Office suite of productivity software.
So what are data types?
A data type is an attribute associated with a piece of data that tells a computer system how to interpret its value. We will be learning in detail about the different data types in Excel such as whole number, decimal number, text, date, currency, and true/false.
Data Types in Excel6:37
In this lecture, we will be understanding the fundamentals of Excel and learning about the various data types present in Excel. What is Excel? Excel is a spreadsheet application developed and published by Microsoft. It is part of the Microsoft Office suite of productivity software.
So what are data types?
A data type is an attribute associated with a piece of data that tells a computer system how to interpret its value. We will be learning in detail about the different data types in Excel such as whole number, decimal number, text, date, currency, and true/false.
Format Cells in Excel8:27
How to apply format painter in Excel5:51
References in Excel4:49
Relative Reference in Excel4:31
Absolute Reference in Excel5:24
Mixed Reference in Excel9:41
Business Analytics with Excel

Section Overview: Fundamentals of SQL0:50
How to Download MySQL3:54
In this lecture, we are going to learn how to download MySQL. We will cover the step by step procedure to download MySQL.
Download the MySQL installer from (works for Windows, Linux, and Mac).
Install MYSQL on Windows4:12
In this lecture, we are going to learn how to install MySQL in Windows. We will cover the step by step installation process of MySQL in Windows.
For additional step-by-step instructions, visit MySQL Server Configuration with MySQL Installer.
Drop Database in SQL2:52
In this lecture, we are going to learn about Drop Database in SQL. We will have an overview of Drop Database, understand its need, learn its syntax, take an example and an exercise to get a wholesome understanding of the topic.
The Drop Database command is used to drop/delete an existing database in SQL.
The syntax to drop a database is “DROP DATABASE ”. The drop database command can delete the database in an instant. This is why we should use it carefully.
Data Types in SQL8:10
In this lecture, we are going to learn about data types in SQL. We will have an overview of the most common data types, learn different categories of data types, and take an example to get a wholesome understanding of the topic.
The data type of a column defines the type of value the column can hold.
For example, integer, date, time, character, etc., are the different data types.
Every column in a database table should have a data type. We should decide the column's data type while the table is being created.
Create Table in SQL5:01
In this lecture, we are going to learn about tables in SQL. We will cover the overview of creating a table, understand the need for creating a table, learn its syntax, take an example and an exercise to get a wholesome understanding of the topic.
Tables are the database objects used to hold the data in a relational manner.
A database table has a specific number of columns, but it can have multiple rows. To create a new table in SQL, we use the “CREATE TABLE” statement.
CONSTRAINTS in SQL4:35
In this lecture, we are going to learn about constraints in SQL.
We will learn about different constraints, understand their need, learn the syntax for different constraints, and take an example to get a wholesome understanding of the topic.
SQL constraints are used to specify different rules for the data in a table. The constraints to be specified can be table level or column level.
The different types of constraints in SQL are: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT, and CREATE INDEX.
ALTER TABLE in SQL5:06
In this lecture, we are going to learn about the Alter Table. We will cover the overview of alter table, understand the need for alter table, learn its syntax, take some examples and do an exercise to get a wholesome understanding of the topic.
The “ALTER TABLE” statement is used to add, modify, or delete columns in an existing table. It can also be used to add or drop different constraints in an existing table.
Drop Table in SQL3:03
In this lecture, we are going to learn about Drop Table in SQL. We will have an overview of Drop Table , understand its need, learn its syntax, take an example and an exercise to get a wholesome understanding of the topic.
The Drop Table command is used to drop/delete an existing table from the database. The syntax to drop a table is “DROP TABLE table\_name”.
The drop table command can delete a table in an instant. This is why we should use it carefully.
Fundamentals of SQL

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

Data Science for Beginners: Your Step-by-Step Guide To Start

What you'll learn

Explore related topics

Course content

Career Insights in Data Science3 lectures • 19min

Business Analytics with Excel10 lectures • 1hr 1min

Fundamentals of SQL9 lectures • 38min

Requirements

Description

Who this course is for: