Learn Python, JavaScript, and Microsoft SQL for Data science

Learn Python, JavaScript, and Microsoft SQL for Data science

Course Overview

Become a trained professional from the safety and comfort of your own home by taking Learn Python, JavaScript, and Microsoft SQL for Data science . Whatever your situation and requirements, One Education can supply you with professional teaching, gained from industry experts, and brought to you for a great price with a limited-time discount.

One Education has been proud to produce an extensive range of best-selling courses, and Learn Python, JavaScript, and Microsoft SQL for Data science is one of our best offerings. It is crafted specially to promote easy learning at any location with an online device. Each topic has been separated into digestible portions that can be memorised and understood in the minimum of time. 

Teaching and training are more than just a job for the staff at One Education; we take pride in employing those who share our vision for e-learning and its importance in today’s society. To prove this, all learning materials for each course are available for at least one year after the initial purchase.  

All of our tutors and IT help desk personnel are available to answer any questions regarding your training or any technical difficulties. 

By completing Learn Python, JavaScript, and Microsoft SQL for Data science, you will have automatically earnt an e-certificate that is industry-recognised and will be a great addition to your competencies on your CV.

Whatever your reason for studying Learn Python, JavaScript, and Microsoft SQL for Data science, make the most of this opportunity from One Education and excel in your chosen field.

Please be aware that there are no hidden fees, no sudden exam charges, and no other kind of unexpected payments. All costs will be made very clear before you even attempt to sign up. 

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Learn Python, JavaScript, and Microsoft SQL for Data science is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

Course Curriculum

Section 01: JavaScript Introduction
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
Section 02: JavaScript Basics
Variables 00:13:00
Data Types 00:10:00
Numbers 00:06:00
Strings 00:06:00
String Formatting 00:05:00
Section 03: JavaScript Operators
Arithmetic operators 00:07:00
Assignment operators 00:03:00
Comparison operators 00:06:00
Logical operators 00:08:00
Section 04: JavaScript Conditional Statements
If-else statement 00:05:00
If-else-if statement 00:04:00
Section 05: JavaScript Control Flow Statements
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
Section 06: JavaScript Functions
Creating a Function 00:07:00
Function Call() 00:07:00
Function with parameters 00:05:00
Section 07: JavaScript Error Handling
Try-catch 00:05:00
Try-catch-finally 00:17:00
Section 08: JavaScript Client-Side Validations
On Submit Validation 00:09:00
Input Numeric Validation 00:12:00
Section 09: Python Introduction
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
Section 10: Python Basic
Variables 00:16:00
Data Types 00:13:00
Type Casting 00:07:00
User Inputs 00:08:00
Comments 00:04:00
Section 11: Python Strings
Strings 00:05:00
String Indexing 00:05:00
String Slicing 00:04:00
String Built-in Functions 00:09:00
Formatting String (Dynamic Data) 00:05:00
Section 12: Python Operators
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
Section 13: Python Data Structures
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
Section 14: Python Conditional Statements
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
Section 15: Python control flow statements
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
Section 16: Python core games
Guessing Game 00:07:00
Car Game 00:10:00
Section 17: Python functions
Creating a Function 00:03:00
Calling a Function 00:06:00
Function with Arguments 00:05:00
Section 18: Python args, KW args for Data Science
Args, Arbitary Arguments 00:04:00
kwargs, Arbitary Keyword Arguments 00:06:00
Section 19: Python project
Project Overview 00:03:00
ATM Realtime Project 00:13:00
Section 20: Python Object oriented programming [OOPs]
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
Section 21: Python Methods
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
Section 22: Python Class and Objects
Introduction to OOPs 00:05:00
Classes and Objects 00:08:00
Class Constructors 00:07:00
Section 23: Python Inheritance and Polymorphism
Introduction 00:04:00
Inheritance 00:13:00
Polymorphism 00:13:00
Assessment Test 00:03:00
Solution for Assessment Test 00:03:00
Section 24: Python Encapsulation and Abstraction
Introduction 00:03:00
Access Modifiers (public, protected, private) 00:20:00
Encapsulation 00:07:00
Abstraction 00:07:00
Section 25: Python OOPs Games
Dice Game 00:06:00
Card and Deck Game Playing 00:07:00
Section 26: Python Modules and Packages
PIP command installations 00:12:00
Modules 00:12:00
Built-in Modules 00:03:00
Packages 00:08:00
Reading CSV files 00:11:00
Section 27: Python Error Handling
Errors – Types of Errors 00:08:00
Try – Except Exceptions Handling 00:07:00
Try-Except-Finally Blocks 00:07:00
Section 28: Microsoft SQL[MS] Introduction
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
Section 29: MS SQL Statements
SQL statement basic 00:13:00
SELECT Statement 00:16:00
Column AS Statement 00:09:00
COUNT 00:10:00
Section 30: MS SQL Filtering Data
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
Section 31: MS SQL Functions
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
Section 32: MS SQL Joins
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
Section 33: MS SQL Advanced commands
Basic of Advanced SQL Commands 00:04:00
Timestamp 00:12:00
Extract from Timestamp 00:06:00
Mathematical Scalar Functions 00:11:00
String Functions 00:17:00
Sub Query 00:07:00
Section 34: MS SQL Structure and Keys
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
Section 35: MS SQL Queries
Insert query 00:06:00
Update query 00:08:00
Delete query 00:07:00
Section 36: MS SQL Structure queries
Alter Table 00:04:00
Drop Table 00:03:00
Section 37: MS SQL Constraints
Check Constraint 00:14:00
NOT NULL Constraint 00:12:00
UNIQUE Constraint 00:11:00
Section 38: MS SQL Backup and Restore
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
Order Your Certificate
Order Your Certificate Now 00:00:00

COPYRIGHT © 2022 One Education

Home Search Cart
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon