Essential Web Developer and SQL Skills For Beginners
- Description
- Curriculum
- FAQ
- Reviews
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 .
-
1IntroductionVideo lesson
-
2Core web development languagesVideo lesson
-
3Introduction to Text EditorsVideo lesson
-
4Installing ATOM Text EditorVideo lesson
-
5Installing Brackets Text EditorVideo lesson
-
6Installing SublimeText EditorVideo lesson
-
7Installing Visual studio codeVideo lesson
-
8Installing Web browsersVideo lesson
-
20What is HTMLVideo lesson
-
21Anatomy of an HTML ElementVideo lesson
-
22Basic structure of an HTML documentVideo lesson
-
23Create a basic HTML document structureVideo lesson
-
24Create a basic HTML document structure- Part 2Video lesson
-
25Create a basic HTML document structure -Part 3Video lesson
-
26The Source CodeVideo lesson
-
27HTML AttributesVideo lesson
-
28Marking UP TextVideo lesson
-
29Creating LinksVideo lesson
-
30HTML CommentsVideo lesson
-
31What is CSSVideo lesson
-
32Ways to apply CSSVideo lesson
-
33Styling multiple propertiesVideo lesson
-
34Styling multiple elementsVideo lesson
-
35Modifying CSSVideo lesson
-
36Basic CSS SelectorsVideo lesson
-
37CSS CommentsVideo lesson
-
38The Box ModelVideo lesson
-
39Margin and Padding PropertyVideo lesson
-
40Changing background colorVideo lesson
-
41The border PropertyVideo lesson
-
42Positioning and styling page titleVideo lesson
-
43CSS Display PropertyVideo lesson
-
44CSS Font PropertyVideo lesson
-
45Using Google FontsVideo lesson
-
46What is JavaScriptVideo lesson
-
47Where to place JavaScriptVideo lesson
-
48The developer consoleVideo lesson
-
49The SyntaxVideo lesson
-
50What are statementsVideo lesson
-
51ExpressionsVideo lesson
-
52Executing a programVideo lesson
-
53The OutputVideo lesson
-
54The InputVideo lesson
-
55What are variableVideo lesson
-
56Variable naming conventionVideo lesson
-
57ArraysVideo lesson
-
58Data TypesVideo lesson
-
59Mixing Data TypesVideo lesson
-
60OperatorsVideo lesson
-
61Arithmetic OperatorsVideo lesson
-
62Assignment OperatorsVideo lesson
-
63Operator PrecedenceVideo lesson
-
64String OperatorsVideo lesson
-
65Comparison OperatorsVideo lesson
-
66Logical OperatorsVideo lesson
-
67Conditional statementsVideo lesson
-
68FunctionsVideo lesson
-
69Javascript CommentsVideo lesson
-
70Linting ToolsVideo lesson
-
71EventsVideo lesson
-
72Adding image changer to webpageVideo lesson
-
73Fixing JSLINT error - Part 1Video lesson
-
74Fixing JSLINT error - Part 2Video lesson
-
75Adding welcome message to webpageVideo lesson
External Links May Contain Affiliate Links read more