Name: IT Fundamentals - Learn Python, SQL, HTML, Java & Computing
Rating: 4.2 (44 reviews)

What you'll learn

Learn 5 main areas of IT; Procedural Programming, Object Oriented Programming, Databases, Web Pages and Computer Science
Learn to Program with coding in Python
Learn Databases and SQL
Learn Web Pages with HTML, CSS and PHP
Learn Mobile Apps with JAVA
Learn Computer Science

Requirements

A PC and the internet

Description

Are you up for a challenge, a real challenge? One where you can change your life and give yourself the job stability missing in other industries. Complete this course and set yourself on the path to a career in IT.

You'll learn how to code using the worlds most popular language; Python.

You'll learn how to manage databases using SQL, THE database language

Create Web pages in HTML with CSS and practice web development using PHP

Create mobile apps, in JAVA for Android mobile devices using Android Studio

Give yourself a thorough grounding in Computer Science and IT

By the end of this course, you'll know the key 5 skills for any career in IT.

Click the buy button today.

Who this course is for:

People who wish to begin a career in IT.
IT Beginners

7 sections • 140 lectures • 13h 53m total length

Preview02:42

Introduction to Python
02:24
Installing Python
05:35
Running IDLE
05:21
Installing IntelliJ IDEA
16:18
Preview11:05
Preview13:04
Preview12:17
Python Fundamentals - Dates Part 1
06:44
Python Fundamentals - Dates Part 2
09:59
Python Fundamentals - Modules
07:25
Python Fundamentals - Operators
15:18
Python Fundamentals - Coding Assignments
4 questions
Python Structures - Conditionals
08:12
Python Structures - Loops Part 1
09:01
Python Structures - Loops Part 2
07:30
Python Structures - Lists
13:22
Python Structures - Coding Assignment
1 question
Python Interface Step 01
10:00
Python Interface Step 02
10:30
Python Interface Step 03
06:56
Python Interface Step 04
06:32
Python Interface Step 05
06:13
Python Interface Step 06
05:11
Python Interface Step 07
06:42
Preview09:00
Python Interface - Coding Assignment
2 questions
Preview09:50
Python Input Output - Get Classes
10:16
Python Input Output - Get Try and Except
04:41
Python Input Output - Get HttpServer
10:10
Python Input Output - Write Text File
05:49
Python Input Output – Coding Assignment
2 questions
Well Done and Good Luck
00:51

Preview02:20
Preview03:55
SQL 01 Installing MySQL
11:04
SQL 02 WorkBench Overview
06:22
SQL 03 Create Table
11:14
SQL 04 Insert Into
06:55
Preview04:58
SQL 06 Filters 01
04:50
SQL 06 Filters 02
05:29
SQL 08 Update a Field
03:26
SQL 09 Delete From
04:12
SQL 10 String Functions
05:12
SQL 11 Numeric Function
04:41
SQL 12 Date Functions
05:00
SQL 13 Create Virus Removal Table
04:54
SQL 14 Insert and Like
05:42
SQL 15 Using IN
04:01
Preview04:08
SQL 17 Joins
06:23
SQL 18 Drop and Help
03:51
SQL – Coding Assignment
4 questions
Well Done and Good Luck!
01:14

Preview01:41
Web Pages - Overview
03:04
Web Pages - How Browsers Work
04:20
HTML Code - Writing HTML
03:18
HTML Code - 02 Code Editor
05:49
Preview04:41
HTML Code - 04 Help
01:34
HTML Code - 05 Content
07:37
HTML Code - 05b Content Formatting
05:30
HTML Code - 06 Tables 01
05:30
HTML Code - 07 Tables 02
05:43
HTML Code - 08 Tables 03 Content
04:31
HTML Code - 09 Tables 04 CSS
05:23
Preview07:55
HTML Code - 11 Formatting Inline Blocks
08:25
HTML\CSS – Coding Assignment
3 questions
FTP – Download Software
03:31
FTP – Set Up Software
03:29
FTP – Transfer Files
03:28
PHP - 01a Install PHP
06:50
PHP - 01b Test Install
04:16
PHP - 02 Configure php ini File
06:02
PHP - 03 Create Connection File
05:30
PHP - 04 Connect to Database
08:54
PHP - 05 A word about Editors
04:21
PHP - 06 Create Table
06:22
PHP - 07 Create Input Form
04:15
PHP - 08 Filter Query on Input Value
06:44
Well Done and Good Luck!
00:47

Preview02:22
Phone App - 01 Installing Android Studio
06:54
Phone App - 02 Create a Project
04:35
Phone App - 03 Overview of Android Studio
11:34
Phone App - 04 Run Hello World App
04:01
Phone App - 05 Oh no nothing works
06:11
Preview08:24
Phone App - 07 Linking and Toast
10:08
Phone App - 08 Button that Toast Text
04:48
Preview07:26
Phone App - 10 Set Text in Second Activity
07:45
Phone App - 11 Create SQLite Database
08:58
Phone App - 12 Create DB Continued
09:30
Phone App - 13 Some Final Stuff
07:44
Phone App - 13b Tidy Up the Code
04:56
Phone App - 14 Set up the new EditText
06:15
Phone App - 15 Insert New Record
12:03
Phone App - 16 Deploying the App
03:24
Java – Coding Assignment
2 questions
Well Done and Good Luck!
00:42

Preview01:47
Fundamental IT Fundamentals
13:36
Preview03:45
Computer Science - Device Drivers
02:46
Computer Science - Security
06:30
Computer Science - Network Handshake
05:16
Computer Science - Computer Bus
04:00
Computer Science - Secondary Storage
04:20
Computer Science - Bits and Bytes
04:59
Preview04:48
Computer Science - USBs
03:11
Computer Science Quiz
2 questions
Computing Fundamentals - The History of Computing
08:18
Computing Fundamentals - Babbage and Lovelace
04:03
Computing Fundamentals - Encryption & Security
04:31
Preview04:49
Computing Fundamentals - Programming is like Making Tea
05:07
Computing Fundamentals - Debugging Programs - Testing
07:50
Computing Fundamentals - Backing Up
08:49
Preview04:52
Computing Fundamentals - Application Software
04:01
Computing Fundamentals Assignment
3 questions
GUIs - We learn about GUI's
05:00
GUIs - We learn about pixels
08:24
GUIs - We learn about buttons
02:01
GUIs - We learn about peripherals
05:19
GUIs - Why design is important
01:52
User Interfaces Assignment
3 questions
Servers - We learn about Servers
04:48
Preview04:30
Servers - Pinging a Server
01:58
Servers - Fail Over Servers
02:46
Servers - Core Routers
04:38
Servers Assignment
1 question
Computers Viruses - What are Computer Viruses?
05:15
Computers Viruses - Virus Signatures
05:10
Computers Viruses - Space Filler Virus
01:15
Computers Viruses - A WORM Virus
02:22
Computers Viruses - Anatomy of a Virus Attack
03:18
Computers Viruses - Taking down Hackers
06:19
Computers Viruses - Keeping PCs Clean
03:21
Computer Virus Assignment
1 question
General IT - Project Management
08:59
General IT - Programming Languages
04:05
Preview06:10
General IT - Internet of Things
06:42
General IT Assignment
3 questions

Tom Carter

Instructional Designer

4.2 Instructor Rating
61 Reviews
394 Students
2 Courses

Born and raised in the UK, I have traveled all over the world running corporate training courses. I've been a programmer, web developer and a creator of e-Learning for more than 25 years. In that time I have received numerous awards for my courses

It has always been my desire to create e-Learning that is enjoyable as well as instructive. I hope my courses are as fun for those being trained as it was for me making it.

It is my belief that people like stories and I endeavor to transport the learner into the world of the subject matter. Where, I believe, they will have a more entertaining and educational experience.

IT Fundamentals - Learn Python, SQL, HTML, Java & Computing

What you'll learn

Requirements

Description

Who this course is for:

Course content

Introduction1 lecture • 3min

Python Programming29 lectures • 4hr 6min

Databases and SQL using MS SQL21 lectures • 1hr 50min

Web Pages; HTML, FTP and PHP28 lectures • 2hr 20min

Phone App in Java using Android Studio19 lectures • 2hr 8min

General IT Computer Science, GUI's and IT knowledge41 lectures • 3hr 22min

You've done it!1 lecture • 1min

Instructor