Best Bundle Of Html,Css, Javascript, Node Js, Npm, Json, Sql

HTML5 CSS3 , Front End & Back End Development, CSS Advance, Bootstrap, JavaScript, NodeJS, NPM, JSON, SQL, php

What you'll learn

HTML : Lay the foundation of your web development journey

CSS : Style you webpage using CSS. Learn basics to advance.

JavaScript: Learn basics of Javascript as well as advance concepts

Node JS: Learn the power of NodeJS, NPM, Working with modules and API. Learn basics to advance.

JSON : Learn and gain a comprehensive understanding of how JSON works.

SQL : Learn basics of Database MS SQL and how to interact database with Node JS. Learn SQL Commands.

Php : Learn basics of phpMyAdmin, create tables and insert data.

Requirements

No programming experience required, Only WILLINGNESS to learn is enough. I will start from absolute basic.

Description

•In this 16.5+ hours of course we are going to learn all important concepts of HTML, CSS JavaScript, Node JS, NPM, JSON, SQL basics and advanced concepts.Best suitable course for BEGINNERS.No prior knowledge is required, absolutely nothing.We will learn about –HTML Tags such as p tag, br tag, img tag, div tag, create ordered and unordered list, iframe tag, input tags, table tag and many more.We will learn how to add images and videos in our webpage, adding music audio files from internet and Youtube videos.We will learn to create multipage responsive website.We will learn to HOST our website for FREE using GITHUB.We will learn to style and decorate our webpage using CSS.We will learn to work with inline, internal and external CSS.We will learn tag based styling, Class based styling etc.We will learn about CSS Selectors and using multiple selectors and how to group selectors.We will see examples of element, class, id, attribute and universal selectors.We will learn CSS Box Model.We will work with Float property and make our web page responsive.We will see child/descendent selectors and example of chaining selectors.We will learn about CSS Positioning (Static, relative, fixed, absolute, sticky)We will learn about Pseudo classes (with img tag, with input fields and table styling)We will learn Display properties in CSS (None, Block, Inline, inline-block )We will learn how to create responsive web design.We will learn advanced CSS Concepts like Media Queries, CSS Flexbox and CSS Grid.We will learn to use Bootstrap and working with Bootstrap online and offline.All important basics of Javascript.hands-on examplesVariables, constants, datatypes in Javascript.Operators (Mathematics, Comparison, Ternary, Logical) in Javascript.Conditional Statements such as If else, switch case with examples.About Arrays in Javascript and various properties and methods.About Loops (For, While, Do While, For-of, For-in )About Javascript functions in detail.About Arrow function, Callback functionsAbout Objects in detail.About Object Constructor Function.About usage of THIS and NEW keywords.About error handling Try-Catch-Finally block.What is Node JS, Node JS BasicsNode js in-built modules and creating your own module.fs, http, OS and other in-built modules.working with NPM (Node package manager)using npm modules in your files.working with package.json file.What is JSON and how it works.What is SQL and how to work with SQL using Node.Creating database, creating table, inserting record, altering table etc.Important SQL Commands.Observing changes using php myadmin user interface.Disclaimer: I have designed this course based on best of my knowledge.All the best and Happy learning !!

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: HTML : Hypertext Markup Language

Lecture 2 Introduction Course Content

Lecture 3 Introduction Continued

Lecture 4 Download and install VS Code

Lecture 5 5- HTML History~Client Server Arch.

Lecture 6 6 - HTML Heading tags

Lecture 7 7- P tag, br tag, List tag, Nesting of list tag

Lecture 8 8- img tag, anchor tag, making images clickable

Lecture 9 9- Input tags, button

Lecture 10 10- Button, Div tag

Lecture 11 11- B tag, inspect browser, DOM, Image height~width

Lecture 12 12- Table tag

Lecture 13 13- Audio and Video files in html page

Lecture 14 14- Video Audio files from internet into our page, using iframe tag

Lecture 15 15- HTML Boilerplate Code, Page Title

Lecture 16 16- Multipage Website

Lecture 17 17 - Github Repository Creation and Uploading files

Lecture 18 18 - Settings to Host Website for Free using GITHUB

Lecture 19 19 - Our website URL, HTML Conclusion

Section 3: CSS : Cascading Style Sheets

Lecture 20 20 -CSS Introduction

Lecture 21 21 - Inline CSS

Lecture 22 22- div tag,CSS box model, CSS Selectors

Lecture 23 23- Running Sample CSS code

Lecture 24 24- CSS Defining Div tags and class in our page

Lecture 25 25- Inline CSS and styling

Lecture 26 26- Tag based CSS styling

Lecture 27 27- Class Based styling continued, Comment tag

Lecture 28 28- Float property

Lecture 29 29 - id selector styling, using multiple selectors, priority order

Lecture 30 30 - Attribute Selector Examples

Lecture 31 31 - Universal Selector

Lecture 32 32 - Combining different selectors, Grouping Selectors

Lecture 33 33 - Child Selector, Descendent selector

Lecture 34 34- Chaining selectors example

Lecture 35 35- External CSS

Lecture 36 36- Positioning in CSS Static,Relative,Fixed,Absolute

Lecture 37 37- Sticky Positioning CSS

Lecture 38 38 - Toolbar Creation Example

Lecture 39 39- Toolbar contd. and Use of Pseudo Classes

Lecture 40 40- Pseudo Class with IMG tag

Lecture 41 41- Pseudo Class Table Styling

Lecture 42 42- Pseudo Class example Input fields

Lecture 43 43 - Display Property in CSS

Lecture 44 44- Responsive Web Design

Lecture 45 45 - Media Queries

Lecture 46 46- Flexbox CSS Container

Lecture 47 47- Flexbox CSS Items

Lecture 48 48- CSS Grid Intro and Container Properties

Lecture 49 49- CSS Grid Items Properties

Section 4: Additional Section BOOTSTRAP

Lecture 50 50- Bootstrap Introduction, using online

Lecture 51 51- Bootstrap using offline

Section 5: JS : Javascript

Lecture 52 Introduction

Lecture 53 53- JS Introduction and VS Code Installation

Lecture 54 54- Javascript Important Basics

Lecture 55 55- JS important points to remember

Lecture 56 56- Hello World !!

Lecture 57 57 - Variables and Constants

Lecture 58 58 - Primitive Types in JS

Lecture 59 59- Using typeof operator

Lecture 60 60 - More on data types, Difference between Null and undefined

Section 6: JS Operators

Lecture 61 61- Mathematics Operators

Lecture 62 62- Comparison Operators

Lecture 63 63- Ternary Operator

Lecture 64 64- Logical Operators

Lecture 65 65-Example - Swapping Variables

Section 7: JS : Conditional Statement

Lecture 66 66- Conditional Statment ~if-else Example

Lecture 67 67-switch-case Example

Lecture 68 68- if-else another example

Section 8: JS : Arrays

Lecture 69 69- Array introduction

Lecture 70 70- Adding elements in array, push(),unshift(),splice() methods

Lecture 71 71 - Removing elements from array, pop(),splice(),shift()

Lecture 72 72- split() & join() methods

Lecture 73 73- Concat, Sort and Reverse Methods

Lecture 74 74- toString() & fill() methods

Lecture 75 75- using isArray() function

Lecture 76 76-Multidimensional Array

Lecture 77 77- Using document.write

Lecture 78 78- Plan for the next Section

Section 9: JS : Loops

Lecture 79 79- Execute code using Node JS

Lecture 80 80- While Loop

Lecture 81 81-Example While Loop

Lecture 82 82- Do-While Loop

Lecture 83 83- FOR Loop

Lecture 84 84 - Example -FOR Loop with If-Else

Lecture 85 85 - Loop with Array, for-of loop

Lecture 86 86- For-in loop with Objects and Arrays

Lecture 87 87- Break and Continue

Section 10: JS : Functions

Lecture 88 88- Functions Declaration, Function Expression, Anonymous Function

Lecture 89 89- Function Parameters and Arguments

Lecture 90 90- Using alert with Function

Lecture 91 91- Using Return keyword

Lecture 92 92- Example Of Using Return Keyword with Condition Check

Lecture 93 93- Arguments object in JS

Lecture 94 94- Global vs Local Variable scope

Lecture 95 95- Immediately invoked function

Lecture 96 96- Rest Operator

Lecture 97 97- Arrow Functions

Lecture 98 98- Datatype conversion methods

Lecture 99 99- For Each Method with Arrow Function

Lecture 100 100- Callback Functions, Passing a function as an argument to other function

Lecture 101 101 - Callback Function another example

Section 11: JS : Objects

Lecture 102 102- Objects Introduction

Lecture 103 103- Objects - working with square brackets notation

Lecture 104 104- For-In loop with Objects

Lecture 105 105 - Using functions with object and nesting of objects, OOP

Lecture 106 106 - More about Objects and Methods

Lecture 107 107 -using THIS keyword and accessing another object

Lecture 108 108- Combining two or more objects

Lecture 109 109- Math Object

Lecture 110 110 - Example - Using Math Object Random Number Method

Lecture 111 111- Using NEW keyword

Lecture 112 112-Date Object

Lecture 113 113- Using Getter and Setter

Lecture 114 114- Object ConstructorFunction

Lecture 115 115- Functions are Objects, Prototype Intro

Section 12: JS : Miscellaneous

Lecture 116 116 - Hoisting in JS

Lecture 117 117 - Strict Mode 'Use Strict'

Lecture 118 118 - Using TRY CATCH Block- Error Handling

Lecture 119 119 - Congratulations on Completing JS Course

Section 13: NODE JS

Lecture 120 120 - Node JS Intro and Upcoming Sections Plan

Lecture 121 121- Node JS Intro and Installation

Lecture 122 122- REPL in Node

Lecture 123 123- Create Server using Node

Lecture 124 124- Modules in JS, Sync and Async

Lecture 125 125- fs module Sync

Lecture 126 126- fs module Async

Lecture 127 127 - OS Module

Lecture 128 128- http module

Lecture 129 129- using nodemon

Lecture 130 130 - Defining Routing for multiple pages

Lecture 131 131- Displaying HTML page response from server

Lecture 132 132 - Creating Own Module

Lecture 133 133- using npm module

Lecture 134 134 - QR Code generation using NPM example

Lecture 135 135- import and require

Section 14: Node JS : JSON & APIs

Lecture 136 136- Complete JSON

Lecture 137 137- APIs , Exposing JSON Data

Lecture 138 138- Call External API usnig Request

Lecture 139 139- using AXIOS to call external API

Lecture 140 140- Events Module

Section 15: SQL (Structured Query Language) with NODE JS

Lecture 141 141- Introduction and prerequisites

Lecture 142 142 - npm install mysql

Lecture 143 143 - Creating Connection

Lecture 144 144- Database Creation

Lecture 145 145 - Create a Table

Lecture 146 146- Drop a Table

Lecture 147 147 - Alter Table

Lecture 148 148- Insert Data Into Table

Lecture 149 149- Inserting Multiple Records in table

Lecture 150 150- SELECT Queries to fetch data from table

Lecture 151 151 - WHERE, AND, OR in SQL

Lecture 152 152- Update Set, Min, MAx

Lecture 153 153 -Alter and Update table

Lecture 154 154 - Group By in SQL with NODE

Lecture 155 155 - SQL Joins with Node

Lecture 156 156 - SQL Delete & Drop

Section 16: Conclusion

Lecture 157 157. Conclusion

Beginners, Developers, Programming Enthusiasts, Coders,Software consultants/ engineers,Anyone who wants to learn basics of coding!