Courses

Description

Learn how to build websites from scratch using HTML & CSS in a completely practical way. No previous coding experience required!

My name is Paul A and I will be leading you through the course. I began my journey as a coder and developer from self-thought concepts and later completed a number of online courses with reputable coding institutes. I have been a coder and a developer over the past 3 years designing web apps, blogs, social networking sites, android apps, multiple back-end modules and  websites for clients. Currently I am a freelancer and also a developer.

This course is for beginners trying to learn HTML & CSS practically, without having to go through unnecessary technical details. By the end of this course, you will be able to build a simple neat website using these languages & make the website go live.

You will begin by learning basic HTML and some simple CSS properties. And then deeper concepts of both these languages simultaneously. This learning process is more effective than learning HTML completely and then beginning with CSS. It also helps you stay motivated throughout the course, along with enough real-life practical activities and exercises at every step.

In the last section, we will use all this knowledge to build a complete website. I will take you through the whole process step-by-step.

The ideal student for this course is someone with a very basic knowledge of computers wanting to design simple websites. Most of the courses found online are too elaborate for beginners. It's easy to get bogged down with so much content. Here, you'll only learn the most essential and most used concepts.

HTML is everywhere and it's most important and first to begin with than ever.   Its not only for web developers, having knowledge of HTML and how it works is beneficial in most careers.   

HyperText Markup Language, commonly abbreviated as HTML, is the standard markup language used to create web pages. Along with CSS, and JavaScript, HTML is a cornerstone technology used to create web pages as well as to create user interfaces for mobile and web applications.

Every website you visit at a basic level is constructed with HTML and CSS. So these two languages are the first and most essential languages you will want to learn and begin with for web development..

I firmly believe it is important to understand the core concepts to any language. And so this course will stress concepts first and foremost.

In this HTML and CSS Tutorial for Beginners course, you will learn how to make high-quality, well structured and thoroughly impressive web sites. You will also gain a strong understanding of CSS concepts that will allow you to code your website exactly the way you want it to look. So in every sense this is a comprehensive HTML and CSS course. This HTML and CSS Tutorial for Beginners is perfect for both beginners and web designers who want to freshen up their skills.

Watch hours of engaging video lectures, and study all the code examples that will be provided. With this course, you will become fully competent in HTML and master beginning web site design!

There are not many requirements for this course. You just need to have a laptop or a desktop with a decent internet connection, and a good learning attitude.

Take a look at the course curriculum & preview the course. I look forward to see you inside.

Requirements

• A computer with internet connection

• A good learning attitude

• Available for lessons

• Basics of computer usage, like saving a file, creating a folder or using an application

• Knowledge of browsing the internet

• A web browser and code editor (Installation of both  of these is covered in the course)

Who this course is for:

• Absolute beginners with no knowledge in coding

• Anyone who wants to learn HTML and CSS

• Anyone willing to learn HTML & CSS practically without having to go through unnecessary technical terms or jargons

• This course is for someone who wants to learn HTML & CSS to build simple websites.

• Someone who has tried learning these languages, but failed to do so because most courses available for these topics are too elaborate - they give up thinking it's too hard for them

What I will become after course:

• Build websites, blogs, e-commerce stores, portfolios

• Publish and manage your own website for free

• Design interface of applications

What you will learn:

• Introduction to HTML

• HTML Structure

• First Web Page

• Line breaks, spacing, and comments

• Ordered and Unordered lists

• Tables

• Creating a web link

• Creating links within same web page

• Adding a image to a web page

• Resizing and sizing images

• Nested elements

• One-line text box

• Add label to text box

• Multi-line text box

• Radio buttons

• Checkbox

• Number input box

• Drop-down list

• Date and numbers

• Attributes

• The meta element

• Escape characters

• Bold and italic elements

• Iframe element

• Sup and Sub elements

• Title and Alt attribute

• Audio element

• Audio Element attributes

• Video element

• Doctype

• HTML Lesson headings paragraphs

• HTML Lesson HTML Hyperlinks

• HTML Lesson Images

• HTML Lesson lists

• Source Code of Course

• HTML Lesson divs spans

• HTML Lesson HTML5 elements

• HTML Lesson CSS navbar

• HTML Lesson Styling Create webpage

CSS lectures • 3hr 39min

CSS Graphics lectures • 21min

CSS Layout lectures • 1hr 35min

Extra lessons lectures • 12min

• Course Resources

• Completed Website Source Code

• HTML Practice Quiz

Couple with real life practical exercises and projects at every lesson

Description

Learn Python, a programming language with a wide variety of well-paying jobs in many fields, including data science and web development. 

It is relatively easy to learn when compared to pretty much any other programming language since most of the time, using Python to do something will take less lines of code than with another programming language.

Python is commonly used for developing websites and software, mobile and desktop applications, task automation, data analysis,  machine learning and data visualization

In this course, you will be taught the fundamentals of Python through video lectures, quizzes, review exercises, and programming challenges.

Who this course is for:

• People interested in programming who have no prior programming experience

• Newer Python programmers who need a refresher on Python

• Students taking a Python class in school who want a supplementary learning resource

• Programming hobbyists

• Anyone else who is interested in learning Python

• This course is NOT for experienced Python programmers

Requirements

• A computer

• Access to the internet

• An interest in learning Python

• High level of proficiency in English because of the technical language used in some of the lecture videos

• Basic math knowledge: addition, subtraction, multiplication, division, knowledge of types of numbers such as integers and decimal numbers, exponentiation, etc.

11 sections • 112 lectures 

Expand all sections

Introduction2 lectures • 10min

• Python and Pycharm Installation

• Setup and First Project

Python Basics14 lectures • 20min

• Variables and Assignment

• Basic Data Types

• Variables and Assignment Exercises

• Variables and Assignment Exercises Solution

• Comments and Math Operators

• Comments and Math Operators Quiz

• 5 questions

• Comments and Math Operators Review Exercises

• Comments and Math Operators Review Exercise Solution

• print()

• print() exercises

• print() exercises solutions

• More On Floats

• More On Floats Quiz

• 2 questions

• Programming Challenge: Grocery Store Purchase

• Grocery Store Purchase Solution with integers

• Grocery Store Purchase Solution with round()

Strings Part 1 15 lectures • 24min

• strings

• Strings Exercises

• Strings Exercises Solution

• type() and str()

• Escape Sequences

• type(), str(), and escape sequences exercises

• type(), str(), and escape sequences exercises solution

• Programming Challenge: Asterisk Triangle

• Asterisk Triangle Solution

• input()

• int() and float()

• 04:42

• int() exercise

• int() exercise solution(s)

functions14 lectures • 28min

• functions

• function with no parameters exercise

• function with no parameters exercise solution

• function with 1 parameter exercise

• function with 1 parameter exercise solution

• Programming Challenge: Volume of a Rectangular Prism

• Volume of a Rectangular Prism Solution

• Programming Challenge: Celsius to Fahrenheit

• Celsius to Fahrenheit Solution with integers

• Celsius to Fahrenheit Solution with round()

• importing modules

• Programming Challenge: Miles Per Gallon

• Miles Per Gallon Solution

• variable scope

• variable scope quiz

• 5 questions

flow control10 lectures • 30min

introduction to loops15 lectures • 13min

strings part 212 lectures • 32min

lists10 lectures • 46min

dictionaries14 lectures • 35min

tuples3 lectures • 13min

sets3 lectures • 14min

Description

SQL is THE most important query language you can learn!

It's used by many popular relational database management systems like MySQL . But it's also used by data analysis and big data frameworks and tools like Apache Spark.

Hence knowing SQL opens up an endless amount of opportunities and jobs - no matter if you're going to work with relational databases or if you're becoming a data scientist, knowing SQL will be key!

SQL is a standardized language and therefore learning SQL will help you apply it in all kinds of contexts. Nonetheless, different database systems also support different aspects of SQL or bring their own variations of the SQL language. Therefore, this course dives into SQL by exploring all key features at the example of the two most popular database systems: MySQL and PostgreSQL. All query and command examples are shown for both database systems, ensuring that you feel comfortable working with SQL in either environment!

This course will enable you to write your own (simple or complex) SQL queries, create basic or advanced databases and table structures and work with data of different shape and complexity!

In detail, you will learn:

• What exactly SQL is and how the core syntax looks like

• How to write SQL commands

• How to install MySQL & PostgreSQL as well as various clients

• How to create and structure database tables

• Which data types you may use and when to use which data type

• How to perform CRUD operations: Create, Read, Update & Delete Data

• How to insert data into tables

• How to query and filter data

• Why you should split data across multiple tables (and how to do that)

• How to join (merge) data into combined result sets

• How to write basic and more complex queries

• How to aggregate and group data

• How to use built-in database functions to work with numbers, text or dates

• How to optimize databases with indexes

• And much, much more!

Explore the full course curriculum to get a thorough overview of the course content and watch the free preview section to learn how this course will help you!

We'd love to welcome you on board of this course and explore SQL together with you!

Requirements

• No Prior Knowledge Needed

• For those with some development and database experience, you can jump in at the relevant module that fits your current level, as the course is designed sequentially.

Who this course is for:

• Become an SQL all-rounder who’s a valuable asset to any company that hires developers or database specialists.

• SQL really is everywhere. When you log in to pretty much any web app, your data is retrieved from a database using SQL queries. We live in a big data society and SQL is powering it. This means there’s a huge demand for SQL developers and data scientists with SQL skills.

• Oh, and when you have a huge demand for a specialist skill this means one thing - big salaries!

• The latest research shows that the average salary for an SQL developer is more than $84,000 per year. Not bad, especially when you consider that in a recent analysis of 25k developer job listings, over 35% specifically request SQL skills.

• In fact, SQL is now the second most popular programming language, second only to JavaScript. All in all, it’s pretty clear that now is definitely the right time to get your SQL game on!

Data Manipulation13 lectures • 50min

• What is Database

• Preview03:24

• Installing MySQL On Mac

• Installing MySQL On Windows

• Relational Databases

• The Course Databases and brief Introduction

• Select Statement

• Create Statement

• Insert Statement

• Alter Table Statement

• Update Statement

• Delete Statement

• Constraints

• Summary

• QUIZ

Queries And Operators13 lectures • 30min

• Select

• AS keyword

• Distinct

• Where Clause

• Like Operator

• Null Operators

• Between Operator

• AND Operator

• OR Operator

• Order By clause

• LIMIT clause

• Case Statement

• Summary

• QUIZ

• 10 questions

Aggregate Functions10 lectures • 18min

• Introduction

• Count Function

• SUM Function

• MAX & MIN

• AVG

• ROUND

• GROUP BY Part1

• GROUP BY Part2

• HAVING

• Summary

• QUIZ

• 10 questions