By Sekhar Metla, Sr. Software Professional
Learn Python + JavaScript + Microsoft SQL for Data science
Learn Python and JavaScript how to use it to analyze, visualize and present data using Microsoft SQL queriesWhat you will learn
- Build coding for webapps
- Get a job as a junior web developer
- Create your own stunning, layouts for awesome websites
- Start their own online business
- Master client-end development using JavaScript, back-end development Python and Microsoft SQL
- Add Client-Side Web Page interactions using JavaScript
- Apply JavaScript, Python for data science and Microsoft SQL database queries on real-world tasks
- Create fully function web apps using Python, MSSQL and JavaScript
Course description
In this course, we will learn the basic tools that every Web developer needs to know. We will start from the scratch by learning how to implement modern web development with JavaScript, Python and Microsoft SQL. Learn to code JavaScript, Python and Microsoft SQL is The first step to Coding you need to learn to succeed in web development, it is easy to learn and understand our online JavaScript, Python and Microsoft SQL Training course is designed for you with the complete steps to require learn Complete Developer topics. Mr. Sekhar Metla MCP - Microsoft Certified Professional will explain to you even complex topics to simplify and teach you even beginners can easily understand with real-time examples. At this Development course is without a doubt the most comprehensive web development course available online. Even if you have zero programming experience, this course will take you from beginner to mastery. Here's why: The course is taught by the lead instructor having 20+ years of professional experience. Become a Full-Stack Web Developer with just ONE course. Python, JavaScript and Microsoft SQL database The course has been updated to be trending technology ready and you'll be learning the latest tools and technologies used at large companies such as Microsoft, Apple, Facebook, Google and Netflix. The curriculum was developed over a period of four years, with comprehensive student testing and feedback who are working and applying these coding examples. We've taught many students how to code and many have gone on to change their lives by becoming professional developers or starting their own tech startup. We'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a web developer.
Throughout this comprehensive course, we cover a massive amount of tools and technologies, including: Front-End Web Development JavaScript Client-side code Validations
Coding
Python Variables Data types Statements Control flow statements Code Development Web Design Functions Object oriented programming [OOPs] Class Methods Inheritance Polymorphism CRUD functions Error Handling Microsoft SQL Tables SQL Functions Operators Queries DDL / DML commands Filtering Data Joins Reports
By the end of this course, you will be fluently programming and be ready to make any website you can dream of.
Requirements
- No programming experience needed. You will learn everything you need to know
- No software is required in advance of the course (all software used in the course is free)
- No pre-knowledge is required - you will learn from basic
Related Skills
Course overview - 182
Section 1: JavaScript Introduction
How to ask great questions
Installing Code Editor
What is JavaScript
Hello World Program
Getting Output
Internal JavaScript
External JavaScript
Inline JavaScript
Async and defer
Section 2: JavaScript Basics
Data Types
Numbers
Strings
String Formatting
Section 3: JavaScript Operators
Assignment operators
Comparison operators
Logical operators
Section 4: JavaScript Conditional Statements
If-else-if statement
Section 5: JavaScript Control Flow Statements
Do-while loop
For loop
Section 6: JavaScript Functions
Function Call()
Function with parameters
Section 7: JavaScript Error Handling
Try-catch-finally
Section 8: JavaScript Client-Side Validations
Input Numeric Validation
Section 9: Python Introduction
Python vs. Other Languages
Why Its Popular
Command Line Basics
Python Installation (Step By Step)
PyCharm IDE Installation
Getting Start PyCharm IDE
First Python Hello World Program
Section 10: Python Basic
Data Types
Type Casting
User Inputs
Comments
Section 11: Python Strings
String Indexing
String Slicing
String Built-in Functions
Formatting String (Dynamic Data)
Section 12: Python Operators
Assignment Operators
Comparison Operators
Logical Operators
AND Operator
OR Operator
NOT Operator
Booleans
Section 13: Python Data Structures
Lists
Add List Items
Remove List Items
Sort Lists
Join Lists
Tuples
Update tuples
Join tuples
Dictionaries
Add Dictionary Items
Remove Dictionary Items
Nested Dictionaries
Sets
Add Set Items
Remove Set Items
Join Set Items
Section 14: Python Conditional Statements
If-else Statement
If-elif-else Statement
If Statement Coding Exercise
Section 15: Python control flow statements
While Loops Statement
For Loops Statement
The range() Function
Nested Loops
2D List using Nested Loop
Section 16: Python core games
Car Game
Section 17: Python functions
Calling a Function
Function with Arguments
Section 18: Python args, KW args for Data Science
kwargs, Arbitary Keyword Arguments
Section 19: Python project
ATM Realtime Project
Section 20: Python Object oriented programming [OOPs]
Create a Class
Calling a Class Object
Class Parameters - Objects
Access Modifiers(theory)
Section 21: Python Methods
Create a method
Method with parameters
Method default parameter
Multiple parameters
Method return keyword
Method Over loading
Section 22: Python Class and Objects
Classes and Objects
Class Constructors
Section 23: Python Inheritance and Polymorphism
Inheritance
Polymorphism
Assessment Test
Solution for Assessment Test
Section 24: Python Encapsulation and Abstraction
Access Modifiers (public, protected, private)
Encapsulation
Abstraction
Section 25: Python OOPs Games
Card and Deck Game Playing
Section 26: Python Modules and Packages
Modules
Built-in Modules
Packages
Reading CSV files
Section 27: Python Error Handling
Try - Except Exceptions Handling
Try-Except-Finally Blocks
Section 28: Microsoft SQL[MS] Introduction
Overview of Databases
MSSQL Installation
MSSQL SSMS Installation
Connecting to MS-SQL (Windows Authentication)
Connecting to MS-SQL (SQL Server Authentication)
Section 29: MS SQL Statements
SELECT Statement
SELECT DISTINCT
Column AS Statement
COUNT
Section 30: MS SQL Filtering Data
SELECT WHERE Clause – Two
ORDER BY
TOP in MSSQL
BETWEEN
IN Operator - Condition
LIKE
Section 31: MS SQL Functions
Aggregation Function – SUM()
Aggregation Function – MIN()-MAX()
GROUP BY – One(theory)
GROUP BY – Two(practical)
HAVING
Section 32: MS SQL Joins
Introduction to JOINS
AS Statement
INNER Join
Full Outer Join
Left Outer Join
Right Outer Join
Union
Section 33: MS SQL Advanced commands
Timestamp
Extract from Timestamp
Mathematical Scalar Functions
String Functions
Sub Query
Section 34: MS SQL Structure and Keys
Data Types
Select Datatype on SSMS
How to set Primary Key
How to set Foreign Key
Create Table using SQL Script
Section 35: MS SQL Queries
Update query
Delete query
Section 36: MS SQL Structure queries
Drop Table
Section 37: MS SQL Constraints
NOT NULL Constraint
UNIQUE Constraint
Section 38: MS SQL Backup and Restore
Creating a Database backup using SSMS
Restoring a Database from backup using SSMS