Essential Web Developer and SQL Skills For Beginners

Learn Practical Skills Used By Professionals

4.30 (49 reviews)
Udemy
platform
English
language
Web Development
category
Essential Web Developer and SQL Skills For Beginners
18,303
students
17 hours
content
Jun 2021
last update
$49.99
regular price

What you will learn

Build Web Applications

Build a calculator

Build a digital clock

Build a todoList

Build an interactive quiz app

Create HTML Document

Mark Up Text

Create Links

ways to apply CSS

Style multiple elements

Change background color

Where to place JavaScript

Use developer Console

Create Variables

Use conditional statements

Create Arrays

Use various data types

Create functions

Use various operators

Understand what SQL is used for

Understand basic database concepts

Install PostgreSQL Server

Load Sample database

Perform basic CRUD Operations

Perform Table Joins

Use various SQL operators

Use Aggregate Functions

Description

Web development and SQL knowledge is a must-have 21st century skill. The ability to read,write,and understand code  as well as interacting and querying databases has never been more-important,useful,or lucrative as  it is today.Computer code has forever changed our lives .

Some people can't even make it through the day without interacting with something built with code.

If you're ready to learn the magic behind web and app development

and interacting with databases  but don't  know a style sheet from a string , this course is

the perfect place to start.Explore the basics of HTML,CSS,JavaScript and SQL.


Requirements

  • Computer

  • Internet


What You Will Learn

HTML

  • Anatomy of an HTML Element

  • Creating HTML Document

  • HTML Attributes

  • Marking Up Text

  • Creating Links

CSS

  • ways to apply CSS

  • styling multiple elements

  • The Box Model

  • Margin and Padding Property

  • changing Background Color

JavaScript

  • Where to place JavaScript

  • Using developer Console

  • Statements

  • Expressions

  • Variables

  • Arrays

  • Data Types

  • Conditional Statements

  • Operators

  • Functions

  • Events


Building Web Applications Projects

  • Build a calculator

  • Build a digital clock

  • Build a todoList

  • Build an interactive quiz app


SQL

  • Database Concepts

  • Installing PostgreSQL

  • loading sample database

  • Filtering data

  • Sorting data

  • Querying data

  • Removing duplicate records

  • Table Joins

  • CRUD Operations

  • Using Operators

  • Aggregate Functions



By the end of this course you would have acquired enough skills to get creative building web based applications and interacting with databases .







Content

Introduction and Professional Web Developer Tools

Introduction
Core web development languages
Introduction to Text Editors
Installing ATOM Text Editor
Installing Brackets Text Editor
Installing SublimeText Editor
Installing Visual studio code
Installing Web browsers

Online Web Development Playgrounds

Introduction
Codepen
JSBIN
JS Fiddle
Dabblet
Liveweave
Plunker

Planning a web project

Introduction
Sketching your design
Creating files and folders
Choosing your assets

Building a webpage content with: HTML

What is HTML
Anatomy of an HTML Element
Basic structure of an HTML document
Create a basic HTML document structure
Create a basic HTML document structure- Part 2
Create a basic HTML document structure -Part 3
The Source Code
HTML Attributes
Marking UP Text
Creating Links
HTML Comments

Styling a webpage with - CSS

What is CSS
Ways to apply CSS
Styling multiple properties
Styling multiple elements
Modifying CSS
Basic CSS Selectors
CSS Comments
The Box Model
Margin and Padding Property
Changing background color
The border Property
Positioning and styling page title
CSS Display Property
CSS Font Property
Using Google Fonts

Adding interaction with - JavaScript

What is JavaScript
Where to place JavaScript
The developer console
The Syntax
What are statements
Expressions
Executing a program
The Output
The Input
What are variable
Variable naming convention
Arrays
Data Types
Mixing Data Types
Operators
Arithmetic Operators
Assignment Operators
Operator Precedence
String Operators
Comparison Operators
Logical Operators
Conditional statements
Functions
Javascript Comments
Linting Tools
Events
Adding image changer to webpage
Fixing JSLINT error - Part 1
Fixing JSLINT error - Part 2
Adding welcome message to webpage

Web App Project: Build a Calculator

Overview
What we will build
Creating directories and files
Creating the structure
Styling the app
Adding interaction

Web App Project: Build a Clock

Overview
What we will create
Creating project directory and files
Creating the structure
Styling the app
Adding functionality

Web App Project: Build TodoList

Overview
What we will create
Creating directory and files
Creating the project structure
Adding Styling
Adding functionality
Adding functionalty- Part2

Web App Project: Create Interative Quiz

Overview
What we will create
Creating project directory and files
Creating the project structure
Add CSS
Adding Functionality - Part 1
Adding Functionality - Part 2

Introduction to SQL

What is SQL
Database Concepts
What is PostgreSQL
Who is using PostgreSQL
Minimum PostgreSQL Installation Requirements
Installation Versions (Please Read)
Installing PostgreSQL 10
Connecting to a PostgreSQL Database
Download and Load Sample Database
Download PostgreSQL 9.6
Install PostgreSQL 9.6 on Windows
Verify PostgreSQL 9.6 Installation
Install PostgreSQL 9.6 on Mac OS X
Connecting to PostgreSQL 9.6 Database
Load sample database on PostgreSQL 9.6

SQL Fundamentals

Data Types
Unique Constraint
Filtering Data
Retrieve All Data From A Table
Retrieving Data From A Column
Removing Duplicate Records
Sorting Data
The ORDER BY Clause
Grouping Data
The HAVING clause
Truncating a Table
Using Stored Procedures

C R U D Operations

Introduction
Create Table statement
SELECT statement
UPDATE statement
DELETE statement
INSERT statement
Subquery

SQL Operators

Comparison Operators
BETWEEN Operators
NOT BETWEEN Operators
LIKE Operators
NOT Operators
OR Operators
AND Operators
Combining OR | AND Operators
IN Operators
UNION OPerators
UNION ALL Operators
INTERSECT Operators
EXCEPT Operators

SQL Table Joins

Introduction
INNER Joins
LEFT Join
FULL OUTER Join
CROSS Join
NATURAL Join

Aggregate Functions

Introduction
AVG Function
COUNT Function
MAX Function
MIN Function
SUM Function

Coupons

DateDiscountStatus
1/1/2021100% OFF
expired

Charts

Price

Essential Web Developer and SQL Skills For Beginners - Price chart

Rating

Essential Web Developer and SQL Skills For Beginners - Ratings chart

Enrollment distribution

Essential Web Developer and SQL Skills For Beginners - Distribution chart
1953990
udemy ID
10/8/2018
course created date
6/29/2019
course indexed date
Bot
course submited by