• Home
  • Technology

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 queries
Language: English
All Levels

What 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

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

Meet your instructor

Sekhar Metla
Sekhar MetlaSr. Software Professional
Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passionate to teach every single real-time step that leads students as well as professionals to become successful and the vision to impart Good Quality Software Education to all I.T to aspirants make a strong bridge the gap between the software companies requirements and the beginners.