Course Highlights
Python is a general-purpose programming language that is widely used in data science. It is known for its simplicity, readability, and versatility. In this Python, JavaScript, and Microsoft SQL for Data science course, you will learn the basics of Python, including variables, data types, operators, conditional statements, control flow statements, functions and error handling. You will also learn how to use Python for data science tasks such as cleaning, analysis and visualization.
JavaScript is a scripting language. It is primarily used for front-end web development. However, it also can be used for data science tasks such as data visualization and data analysis.
In this course, you will learn the basics of JavaScript, including variables, data types, operators, conditional statements, control flow statements, functions, and error handling. You will also learn how to use JavaScript for data science tasks such as data cleaning and data visualization.
Microsoft SQL is a relational database management system (RDBMS) that stores, manages, and retrieves data. It is one of the most popular RDBMSs in the world.
In this course, you will learn the basics of Microsoft SQL, including SQL statements, data manipulation statements, data query statements, and data definition statements. You will also learn to use Microsoft SQL to create, read, update, and delete data from a database.
Learning outcome
- Understand the foundational principles of JavaScript, Python, and Microsoft SQL.
- Develop proficiency in Python’s Object Oriented Programming and its applications.
- Craft and execute advanced MS SQL queries and commands.
- Write JavaScript code to create and manipulate web pages
- Use Python for data science tasks such as data cleaning, analysis, and visualization
- Query and manage data using Microsoft SQL
- Develop and design data science solutions
Course media
Why should I take this course?
- Comprehensive coverage of three primary data science languages.
- Tailored curriculum to ensure step-by-step progression.
- Future-proof your skills in an ever-evolving tech landscape.
- Position yourself as a versatile coder in the job market.
- Transform raw data into insightful conclusions effectively.
Career Path
- Data Scientist
- Data Analyst
- Machine Learning Engineer
- Business Intelligence Analyst
- Software Engineer
- Web Developer
Requirements
- No prior programming experience is required
- Access to a computer with an internet connection
- A willingness to learn and practice
Course Curriculum
-
Introduction
00:03:00 -
How to ask great questions
00:01:00
-
Installing Code Editor
00:04:00
-
What is JavaScript
00:09:00
-
Hello World Program
00:14:00
-
Getting Output
00:11:00
-
Internal JavaScript
00:13:00
-
External JavaScript
00:09:00
-
Inline JavaScript
00:04:00
-
Async and defer
00:06:00
-
Variables
00:13:00
-
Data Types
00:10:00
-
Numbers
00:06:00
-
Strings
00:06:00
-
String Formatting
00:05:00
-
Arithmetic operators
00:07:00
-
Assignment operators
00:03:00
-
Comparison operators
00:06:00
-
Logical operators
00:08:00
-
If-else statement
00:05:00
-
If-else-if statement
00:04:00
-
While loop
00:09:00
-
Do-while loop
00:02:00
-
For loop
00:08:00
-
Coding Exercise
00:02:00
-
Solution for Coding Exercise
00:02:00
-
Creating a Function
00:07:00
-
Function Call()
00:07:00
-
Function with parameters
00:05:00
-
Try-catch
00:05:00
-
Try-catch-finally
00:17:00
-
On Submit Validation
00:09:00
-
Input Numeric Validation
00:12:00
-
Introduction to Python
00:02:00
-
Python vs. Other Languages
00:04:00
-
Why Its Popular
00:04:00
-
Command Line Basics
00:07:00
-
Python Installation (Step By Step)
00:06:00
-
PyCharm IDE Installation
00:08:00
-
Getting Start PyCharm IDE
00:05:00
-
First Python Hello World Program
00:07:00
-
Variables
00:16:00
-
Data Types
00:13:00
-
Type Casting
00:07:00
-
User Inputs
00:08:00
-
Comments
00:04:00
-
Strings
00:05:00
-
String Indexing
00:05:00
-
String Slicing
00:04:00
-
String Built-in Functions
00:04:00
-
Formatting String (Dynamic Data)
00:05:00
-
Arithmetic Operators
00:08:00
-
Assignment Operators
00:05:00
-
Comparison Operators
00:05:00
-
Logical Operators
00:02:00
-
AND Operator
00:04:00
-
OR Operator
00:02:00
-
NOT Operator
00:03:00
-
Booleans
00:02:00
-
Arrays in Earlier
00:02:00
-
Lists
00:06:00
-
Add List Items
00:03:00
-
Remove List Items
00:01:00
-
Sort Lists
00:03:00
-
Join Lists
00:08:00
-
Tuples
00:08:00
-
Update tuples
00:07:00
-
Join tuples
00:02:00
-
Dictionaries
00:06:00
-
Add Dictionary Items
00:04:00
-
Remove Dictionary Items
00:03:00
-
Nested Dictionaries
00:04:00
-
Sets
00:04:00
-
Add Set Items
00:03:00
-
Remove Set Items
00:01:00
-
Join Set Items
00:04:00
-
If Statement
00:03:00
-
If-else Statement
00:04:00
-
If-elif-else Statement
00:04:00
-
If Statement Coding Exercise
00:05:00
-
Flow Charts
00:06:00
-
While Loops Statement
00:10:00
-
For Loops Statement
00:06:00
-
The range() Function
00:04:00
-
Nested Loops
00:03:00
-
2D List using Nested Loop
00:04:00
-
Guessing Game
00:07:00
-
Car Game
00:10:00
-
Creating a Function
00:03:00
-
Calling a Function
00:06:00
-
Function with Arguments
00:05:00
-
Args, Arbitary Arguments
00:04:00
-
kwargs, Arbitary Keyword Arguments
00:06:00
-
Project Overview
00:03:00
-
ATM Realtime Project
00:13:00
-
Introduction to Class
00:07:00
-
Create a Class
00:09:00
-
Calling a Class Object
00:08:00
-
Class Parameters – Objects
00:05:00
-
Access Modifiers(theory)
00:10:00
-
Introduction to methods
00:06:00
-
Create a method
00:07:00
-
Method with parameters
00:12:00
-
Method default parameter
00:06:00
-
Multiple parameters
00:05:00
-
Method return keyword
00:04:00
-
Method Over loading
00:05:00
-
Introduction to OOPs
00:05:00
-
Classes and Objects
00:08:00
-
Class Constructors
00:07:00
-
Introduction
00:04:00
-
Inheritance
00:13:00
-
Polymorphism
00:13:00
-
Assessment Test
00:03:00
-
Solution for Assessment Test
00:03:00
-
Introduction
00:03:00
-
Access Modifiers (public, protected, private)
00:20:00
-
Encapsulation
00:07:00
-
Abstraction
00:07:00
-
Dice Game
00:06:00
-
Card and Deck Game Playing
00:07:00
-
PIP command installations
00:12:00
-
Modules
00:12:00
-
Built-in Modules
00:03:00
-
Packages
00:08:00
-
Reading CSV files
00:12:00
-
Errors – Types of Errors
00:08:00
-
Try – Except Exceptions Handling
00:07:00
-
Try-Except-Finally Blocks
00:07:00
-
Introduction
00:04:00
-
Overview of Databases
00:09:00
-
MSSQL Installation
00:27:00
-
MSSQL SSMS Installation
00:08:00
-
Connecting to MS-SQL (Windows Authentication)
00:05:00
-
Connecting to MS-SQL (SQL Server Authentication)
00:06:00
-
SQL statement basic
00:13:00
-
SELECT Statement
00:16:00
-
SELECT DISTINCT
00:17:00
-
Column AS Statement
00:09:00
-
COUNT
00:10:00
-
SELECT WHERE Clause – One
00:05:00
-
SELECT WHERE Clause – Two
00:12:00
-
ORDER BY
00:10:00
-
TOP in MSSQL
00:06:00
-
BETWEEN
00:13:00
-
IN Operator – Condition
00:08:00
-
LIKE
00:13:00
-
Overview of GROUP BY
00:08:00
-
Aggregation Function – SUM()
00:12:00
-
Aggregation Function – MIN()-MAX()
00:08:00
-
GROUP BY – One(theory)
00:11:00
-
GROUP BY – Two(practical)
00:14:00
-
HAVING
00:15:00
-
Overview of JOINS
00:07:00
-
Introduction to JOINS
00:07:00
-
AS Statement
00:04:00
-
INNER Join
00:12:00
-
Full Outer Join
00:07:00
-
Left Outer Join
00:06:00
-
Right Outer Join
00:08:00
-
Union
00:07:00
-
Basic of Advanced SQL Commands
00:04:00
-
Timestamp
00:12:00
-
Extract from Timestamp
00:08:00
-
Mathematical Scalar Functions
00:11:00
-
String Functions
00:17:00
-
Sub Query
00:07:00
-
Basic of Database and Tables
00:10:00
-
Data Types
00:11:00
-
Select Datatype on SSMS
00:05:00
-
How to set Primary Key
00:06:00
-
How to set Foreign Key
00:12:00
-
Create Table using SQL Script
00:07:00
-
Insert query
00:06:00
-
Update query
00:08:00
-
Delete query
00:07:00
-
Alter Table
00:04:00
-
Drop Table
00:03:00
-
Check Constraint
00:14:00
-
NOT NULL Constraint
00:12:00
-
UNIQUE Constraint
00:11:00
-
Overview of Database and Tables
00:04:00
-
Creating a Database backup using SSMS
00:11:00
-
Restoring a Database from backup using SSMS
00:08:00
£25.00
This course includes:
-
Duration:22 hours, 6 minutes
-
Access:1 Year
-
Units:184
Want to get everything for £149
Take Lifetime Pack
