Best Bundle Of Html,Css, Javascript, Node Js, Npm, Json, Sql
Published 12/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.17 GB | Duration: 16h 41m
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!