OUR COURSES




Become a Professional Web Developer Fundamentals of MySql and JavaScript

Become a Professional Web Developer Fundamentals of MySql and JavaScript

Duration 11 hr 15 mins

Languages en_US

Course Description

Learn to use the most popular programming languages, JavaScript, grasp the basic concepts of AngularJS and its main features and learn to make website creation, responsive and accessible apps easily with jQuery with this extensive course. Put your lessons in practical uses with functional examples. Most courses on web development walk you through the skills beginners need, but then require you to learn the skills that make you an employable web developer. This course is different. After you have learned the basics and built real projects for your portfolio, you can move on to hours and hours of continued training at the intermediate and advanced levels for each web development skill you've learned.

Challenge yourself and become a Professional Web Developer.

- Pick up a new programming language and be fluent in coding
- Learn how each language uses its code to program applications
- Know how to apply each language into your own projects
- Find out how each language compliments each other when developing a website

Course Objectives

1. Know how to use HTML tags and build with the most common ones.
2. Create CSS stylesheets that control your site design and set them up on your project site.
3. To learn the basic techniques of CSS and CSS3
4. Start programming with JavaScript
5. Create real life projects with JavaScript
6. Create Web Applications
7. Create Hybrid Apps for Android & iOS that use SDKs that implement Angular.js
8. Design a jQuery web application
9. Create interactive web applications across different platforms
10. To understand why, where and when PHP programming is used
11. Learn how MySQL works in the real world and how MySQL and PHP work together

Content

What Is MySQL? 
Installing MySQL 
Accessing the MySQL Monitor 
Using PHPmyAdmin 
Download Source Code
Deleting Databases 
Creating Tables 
Listing and Describing Tables 
Inserting Records 
Selecting Records 
Renaming Tables 
Auto Increment IDs 
Updating Records 
Deleting Records 
Limiting Records 
Ordering Records 
Joins 
Like Clause 
Counting Records 
Creating Databases 
Introduction to MySQLi 
Introduction to PHP Data Objects 
Getting Connected 
Basic Queries 
Getting Results 
Looping Through Results 
Getting Result Counts 
Variables in Queries 
SQL Injections 
Escaping Values 
Prepared Statements 
Introduction 
Creating a Test Database 
Basic Functionalities 
Adding More Functionalities 
Introduction 
Creating the Table 
Inserting Your Records 
Outputting the Data 
Introduction to JavaScript 
Script Tags 
Boxes 
Console 
Variables 
Undefined, typeof, NaN 
Concatination 
Comparison Operators 
Logical Operators 
Mathematical Operators 
Commenting 
Download Source Code
Arrays 
Array Prototype 
Looping Over Arrays 
Introduction to Objects 
Creating an Object 
Dates and Times 
Intervals 
Countdown: Example Application 
Callbacks 
Callback in Countdown 
DOM Elements 
Event Handlers 
Input Fields 
Creating Elements 
Styling Elements 
Query Selector 
Linting 
Minification