English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 14 Hours | 6.89 GB
A Computer Course on IT Fundamentals; Coding in Python, SQL Databases, Web Development, Mobile App & Computer Science
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.
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
Table of Contents
Introduction
1 Introduction
Python Programming
2 Introduction to Python
3 Installing Python
4 Running IDLE
5 Installing IntelliJ IDEA
6 Python Fundamentals – Numbers
7 Python Fundamentals – Strings
8 Python Fundamentals – Functions
9 Python Fundamentals – Dates Part 1
10 Python Fundamentals – Dates Part 2
11 Python Fundamentals – Modules
12 Python Fundamentals – Operators
13 Python Structures – Conditionals
14 Python Structures – Loops Part 1
15 Python Structures – Loops Part 2
16 Python Structures – Lists
17 Python Interface Step 01
18 Python Interface Step 02
19 Python Interface Step 03
20 Python Interface Step 04
21 Python Interface Step 05
22 Python Interface Step 06
23 Python Interface Step 07
24 Python Interface Step 08
25 Python Input Output – Read Text File
26 Python Input Output – Get Classes
27 Python Input Output – Get Try and Except
28 Python Input Output – Get HttpServer
29 Python Input Output – Write Text File
30 Well Done and Good Luck
Databases and SQL using MS SQL
31 SQL Introduction
32 SQL 00 About Databases
33 SQL 01 Installing MySQL
34 SQL 02 WorkBench Overview
35 SQL 03 Create Table
36 SQL 04 Insert Into
37 SQL 05 Select Statement
38 SQL 06 Filters 01
39 SQL 06 Filters 02
40 SQL 08 Update a Field
41 SQL 09 Delete From
42 SQL 10 String Functions
43 SQL 11 Numeric Function
44 SQL 12 Date Functions
45 SQL 13 Create Virus Removal Table
46 SQL 14 Insert and Like
47 SQL 15 Using IN
48 SQL 16 Sub Query
49 SQL 17 Joins
50 SQL 18 Drop and Help
51 Well Done and Good Luck!
Web Pages; HTML, FTP and PHP
52 Web Pages – Introduction
53 Web Pages – Overview
54 Web Pages – How Browsers Work
55 HTML Code – Writing HTML
56 HTML Code – 02 Code Editor
57 HTML Code – 03 Links
58 HTML Code – 04 Help
59 HTML Code – 05 Content
60 HTML Code – 05b Content Formatting
61 HTML Code – 06 Tables 01
62 HTML Code – 07 Tables 02
63 HTML Code – 08 Tables 03 Content
64 HTML Code – 09 Tables 04 CSS
65 HTML Code – 10 Inline Blocks
66 HTML Code – 11 Formatting Inline Blocks
67 FTP – Download Software
68 FTP – Set Up Software
69 FTP – Transfer Files
70 PHP – 01a Install PHP
71 PHP – 01b Test Install
72 PHP – 02 Configure php ini File
73 PHP – 03 Create Connection File
74 PHP – 04 Connect to Database
75 PHP – 05 A word about Editors
76 PHP – 06 Create Table
77 PHP – 07 Create Input Form
78 PHP – 08 Filter Query on Input Value
79 Well Done and Good Luck!
Phone App in Java using Android Studio
80 Phone App – 00 Introduction
81 Phone App – 01 Installing Android Studio
82 Phone App – 02 Create a Project
83 Phone App – 03 Overview of Android Studio
84 Phone App – 04 Run Hello World App
85 Phone App – 05 Oh no nothing works
86 Phone App – 06 Layout and Content
87 Phone App – 07 Linking and Toast
88 Phone App – 08 Button that Toast Text
89 Phone App – 09 Intend to go to Second Activity
90 Phone App – 10 Set Text in Second Activity
91 Phone App – 11 Create SQLite Database
92 Phone App – 12 Create DB Continued
93 Phone App – 13 Some Final Stuff
94 Phone App – 13b Tidy Up the Code
95 Phone App – 14 Set up the new EditText
96 Phone App – 15 Insert New Record
97 Phone App – 16 Deploying the App
98 Well Done and Good Luck!
General IT Computer Science, GUI’s and IT knowledge
99 General IT Intro
100 Fundamental IT Fundamentals
101 Computer Science – Booting up a PC
102 Computer Science – Device Drivers
103 Computer Science – Security
104 Computer Science – Network Handshake
105 Computer Science – Computer Bus
106 Computer Science – Secondary Storage
107 Computer Science – Bits and Bytes
108 Computer Science – How Hard Disks Work
109 Computer Science – USBs
110 Computing Fundamentals – The History of Computing
111 Computing Fundamentals – Babbage and Lovelace
112 Computing Fundamentals – Encryption & Security
113 Computing Fundamentals – NAT Firewalls
114 Computing Fundamentals – Programming is like Making Tea
115 Computing Fundamentals – Debugging Programs – Testing
116 Computing Fundamentals – Backing Up
117 Computing Fundamentals – Operating Systems
118 Computing Fundamentals – Application Software
119 GUIs – We learn about GUI’s
120 GUIs – We learn about pixels
121 GUIs – We learn about buttons
122 GUIs – We learn about peripherals
123 GUIs – Why design is important
124 Servers – We learn about Servers
125 Servers – Local Area Networks
126 Servers – Pinging a Server
127 Servers – Fail Over Servers
128 Servers – Core Routers
129 Computers Viruses – What are Computer Viruses
130 Computers Viruses – Virus Signatures
131 Computers Viruses – Space Filler Virus
132 Computers Viruses – A WORM Virus
133 Computers Viruses – Anatomy of a Virus Attack
134 Computers Viruses – Taking down Hackers
135 Computers Viruses – Keeping PCs Clean
136 General IT – Project Management
137 General IT – Programming Languages
138 General IT – Jobs in IT
139 General IT – Internet of Things
You’ve done it!
140 Well Done and Good Luck!
Resolve the captcha to access the links!