Tutorial: Introduction to MySQL Databases | YouAccel

Course Content
Course Summary
Course Files
Section 1: Introduction
Web Development Masterclass - Introduction - 03:05
Course Learning Objectives - 02:48
Locating Assessments and Course Files - 01:12
Section 3: The Web Development Process
Web Development Process Overview - 02:46
Section 11: CSS Development
Introduction to CSS - 03:31
Parts of a CSS Rule - 06:31
Types of CSS Rules - 02:55
CSS - Color Names and Codes - 02:17
CSS Classes and Spans - 05:44
CSS Divisions - DIVs - 02:53
CSS IDs - 05:54
CSS Margins - 03:53
CSS Padding - 02:12
CSS Text Properties - 08:29
CSS Font Properties - 03:00
CSS Borders - 02:19
CSS Backgrounds - 06:25
CSS Transparency - 02:53
CSS Text on Top of Images - 05:10
CSS Width and Height Properties - 06:04
CSS Display Properties - 02:10
CSS Static Positioning - 01:54
CSS Relative Positioning - 04:03
CSS Absolute Positioning - 02:12
CSS Fixed Positioning - 02:08
CSS Float Property - 02:23
CSS Clear Property - 01:09
CSS Z-Index - 01:40
CSS Styling Links - 02:01
CSS Tables - 02:16
CSS Project - Introduction - 01:23
CSS Project - CSS Rules - 05:36
CSS Project - Navigation Rules - 02:16
CSS Project - Responsive CSS - 02:37
CSS Project - Page Elements - 02:34
Section 15: Bootstrap Framework
Introduction to Bootstrap - 02:12
Embedding Bootstrap - 00:50
Bootstrap - Basic Page Structure - 05:29
Bootstrap Grid System - 05:32
Bootstrap Three Column Layouts - 02:24
Bootstrap Typography - 06:50
Bootstrap Tables - 03:00
Bootstrap Styling Images - 02:17
Bootstrap Jumbotron - 02:28
Bootstrap Wells - 00:59
Bootstrap Alerts - 02:25
Bootstrap Buttons - 07:12
Bootstrap Button Groups - 01:57
Bootstrap Justified Button Groups - 02:33
Bootstrap Glyphicons - 02:52
Bootstrap Badges and Labels - 03:13
Bootstrap Progress Bars - 02:54
Bootstrap Pagination - 02:24
Bootstrap Pager Pagination - 01:18
Bootstrap List Groups - 05:10
Bootstrap Panels - 02:33
Bootstrap Dropdown Menus - 04:37
Bootstrap Collapsibles - 03:24
Bootstrap Collapse Panel - 01:54
Bootstrap Collapse List Group - 00:57
Bootstrap Accordian - 05:01
Bootstrap Tab Menus - 04:47
Bootstrap Pill Menus - 03:13
Bootstrap Dynamic Tabs and Pills - 04:03
Bootstrap Navigation Bar - 06:24
Bootstrap Collapsible Navigation Bar - 03:31
Bootstrap Forms - Vertical and Inline - 03:36
Bootstrap Inputs - 04:28
Bootstrap Form Control States - 03:42
Bootstrap Input Sizing - 03:12
Bootstrap Carousel - 09:23
Bootstrap Modal - 04:02
Bootstrap Tooltip - 02:12
Bootstrap Popover - 02:52
Bootstrap Scrollspy - 05:41
Bootstrap Project - Themes Intro - 03:32
Bootstrap Project - File Overview - 02:15
Bootstrap Project - Script Overview - 08:47
Bootstrap Project - Script Overview Continued - 07:50
Section 13: JavaScript Development
JavaScript - Introduction - 05:42
JavaScript Placement - 02:10
External JavaScript - 01:50
JavaScript Output - 01:41
JavaScript InnerHTML - 01:03
JavaScript Commenting - 01:49
JavaScript Constants - 01:34
JavaScript Variables Introduction - 04:31
JavaScript Assignment Operator - 01:06
JavaScript Arithmetic Operations - 03:44
JavaScript Arithmetic Operations Continued - 03:46
JavaScript Operator Precedence - 00:58
JavaScript Data Types - 01:13
JavaScript Objects - 01:43
JavaScript Object Output - 01:23
JavaScript Strings - 03:12
JavaScript String Length - 00:41
JavaScript Special Characters - 01:19
JavaScript Random Numbers - 00:55
JavaScript Min and Max Function - 01:05
JavaScript Math Round Function - 01:38
JavaScript Arrays - 02:15
JavaScript Array Attributes - 01:28
JavaScript Arrays - Pop - Push - Shift - Unshift - 02:05
JavaScript Changing and Deleting Elements - 01:59
JavaScript Splicing an Array - 01:35
JavaScript Sorting an Array - 01:24
JavaScript Joining Arrays - 01:04
JavaScript Conditional Statements - 06:18
JavaScript Comparisons - 02:26
JavaScript Booleans - 01:21
JavaScript For Loops - 02:40
JavaScript For-In Loop - 00:47
JavaScript While Loops - 02:08
JavaScript Do-While Loop - 01:58
JavaScript Break and Continue - 01:14
JavaScript Functions - 01:54
JavaScript Events - 01:19
JavaScript Project 1 - BG Color Changer - 02:14
JavaScript Project 2 - Photo Gallery - 02:24
JavaScript Project 2 - Completion - 02:38
Section 14: jQuery Library
Introduction to jQuery - 01:31
Embedding jQuery - 00:52
jQuery Syntax and Selector Intro - 03:32
jQuery ID Selector - 01:36
jQuery Class Selector - 01:08
jQuery Other Selectors - 01:54
External jQuery File - 01:43
jQuery Events Intro - 02:05
jQuery Events - mouseenter and mouseleave - 02:07
jQuery Events - mousedown and mouseup - 01:14
jQuery Multiple Event Handlers - 01:31
jQuery Hiding-Showing - 02:09
jQuery Toggle - 01:24
jQuery Fade In-Out - 04:09
jQuery Fade Toggle - 01:27
jQuery Fade To - 01:19
jQuery Slide Down - 03:06
jQuery Slide Up - 00:58
jQuery Slide Toggle - 00:47
jQuery Animate - 03:30
jQuery Animate - Multiple Params - 00:58
jQuery Animate - Relative Values - 00:42
jQuery Animate - Queue Functionality - 01:59
jQuery Stop Method - 01:52
jQuery Callback Functions - 02:10
jQuery Chaining - 02:39
jQuery Draggables - 02:23
jQuery Accordian Menu - 03:18
jQuery Get Content - text and html - 02:42
jQuery Get Content - Val - 01:07
jQuery Get Content - attr - 01:08
jQuery Set Content - text - html - val - 02:49
jQuery Set Attributes - attr - 01:48
jQuery Append and Preprend - 02:33
jQuery - After and Before - 01:19
jQuery Remove and Empty - 01:32
jQuery Filter Remove - 01:47
jQuery Add Class - 02:17
jQuery Remove Class - 01:53
jQuery Toggle Class - 00:44
Section 16: PHP Development
PHP Introduction - 03:03
PHP Preparation - 02:56
PHP File Test - 02:21
PHP Syntax - 05:37
PHP Variables - 03:46
PHP Variable Scope - 03:15
PHP Global Keyword - 02:04
PHP Static Keyword - 01:45
PHP Echo vs Print - 04:02
PHP Data Types - 05:47
PHP Objects - 02:59
PHP Strings - 01:51
PHP Constants - 03:05
PHP Operators - 08:53
PHP Conditional Statements - 02:32
PHP ElseIf Statement - 03:11
PHP Switch Statement - 01:45
PHP While Loops - 04:35
PHP For Loops - 01:40
PHP Functions - 03:29
PHP Functions Continued - 01:50
PHP Arrays - 04:51
PHP Multidimensional Arrays - 01:59
PHP Sorting Arrays - 02:51
PHP Superglobal Variables - 02:10
PHP Forms Introduction - 04:06
PHP POST vs GET Basics - 05:25
PHP Form Output and Validation - 09:36
PHP Form Required Fields - 04:40
PHP Validation Continued - 01:46
Section 17: MySQL Database Integration
Introduction to MySQL Databases - 02:40
Introduction PhpMyAdmin - 02:36
PhpMyAdmin Interface Overview - 01:13
MySQL Security and Root Superuser - 05:03
MySQL Creating a Database and Table - 05:24
MySQL Creating a New User - 05:34
MySQL Database and Table Specific Privileges - 03:05
MySQL Modifying and Deleting a Table - 04:31
MySQL Modifying and Deleting a Database - 04:08
Introduction to SQL - 01:35
SQL Statements in PhpMyAdmin - 04:05
Connect to MySQL Database using PHP - 05:03
MySQL Database - Import Data - 01:43
SQL Select - 02:27
SQL Distinct Keyword - 01:45
SQL Where Clause - 01:40
SQL And Operator - 01:43
SQL Or Operator - 01:01
SQL Order By - 01:37
MySQL Insert Into - 06:29
MySQL Get Last ID - 01:27
MySQL Insert Multiple Records - 01:44
MySQL Prepared Statements - 02:45
MySQL Delete Records - 07:49
PHP Header Function - 01:17
PHP Isset - 02:35
MySQL Update Records - 07:07
Section 19: Development Project
Development Overview - 06:47
Project Setup - 03:20
Index Page Overview - 03:06
Home Page Mods - 04:36
About Page Mods - 07:33
Blog Page Mods - 08:05
MySQL Database Creation - 02:51
Creating a Registration Form - 07:48
Registration Status using JavaScript and AJAX - 07:55
PHP Validation - Encryption - Session - 10:43
Login Authentication - Part 1 - 01:40
Login Authentication - Part 2 - 05:41
Login Authentication - Part 3 - 02:53
Login Authentication - Part 4 - 03:18
Logout - Terminate Session - 03:07
Contact Page - Google Maps API - 05:35
Contact Form - AJAX Integration - 04:33
PHPMailer Installation - 02:46
PHP Form Validation and Email Transmission - 07:06
Production Server Migration - 10:45
Section 4: Planning a Website
Web Application Planning Overview - 04:37
Section 10: HTML Development
Introduction to HTML - 01:46
Basic Structure of a Web Page - 03:36
HTML Head Tags - 07:59
HTML Body Tag - 03:18
HTML Paragraph Spacing - 02:57
HTML Line Breaks - 02:04
HTML Non-Breaking Space - 02:38
HTML Header Tags - 01:58
HTML Text Formatting and Decoration - 05:15
HTML Inline Text Formatting - 02:05
HTML Unordered Lists - 02:36
HTML Ordered Lists - 02:40
HTML Image Insertion - 03:57
HTML Embedding Videos - 02:51
HTML Absolute vs. Relative File Referencing - 02:01
HTML Link Creation - 06:35
HTML Anchor Tags - 06:17
HTML Tables - 11:29
HTML Nested Tables - 06:27
HTML Merging Cells - 01:00
HTML Text Wrapping - 01:17
HTML Table Background Image - 01:12
HTML Table Cell Alignment - 00:40
HTML - Introduction to Forms - 03:30
HTML Form Tags and Attributes - 04:00
HTML Forms - Post vs. Get - 02:09
HTML Forms - Input Text Fields - 03:52
HTML Forms - Select Menus - 05:32
HTML Forms - Check Boxes and Radio Buttons - 05:44
HTML Forms - Text Areas and Buttons - 05:49
HTML Iframes - 04:04
HTML Project - Introduction - 01:41
HTML Project - Header - 03:33
HTML Project - Callout - 03:19
HTML Project - Image Insertion - 01:34
HTML Project - Text Insertion - 01:23
HTML Project - Links and Form - 03:28
HTML Project - Tabular Data - 02:24
HTML Project - Footer - 01:22
Section 5: Web Hosting and System Requirements
Web Hosting Packages Overview - 05:19
Shared Hosting - 04:37
Dedicated Hosting - 02:03
VPS Hosting - 01:24
Cloud Hosting and Case Study - 12:50
Section 2: How the Internet Works
The Internet Overview - 05:26
The HTTP Protocol - 03:34
The HTTPS Protocol - 03:12
The SMTP Protocol and Local Mail Delivery - 04:43
Outbound Mail Delivery - 02:08
Network Basics - LAN and WAN - 05:56
Network Ports and Firewalls - 05:01
Section 6: Domain Names
Introduction to Domain Names - 02:48
Domain Name Registrars - 02:41
Domain Registration - 02:35
Registration and Privacy Protection - 07:06
Control Panel Sign-In - 01:43
Auto-Renewal and Domain Lock - 02:23
Domain Forwarding - 02:18
Nameservers - 01:23
Update Registration Information - 01:15
Section 7: Testing Environment
Introduction to Testing Servers - 02:48
Installing WampServer - WAMP - 05:12
Installing MampServer - MAMP - 10:32
WampServer Menu - 05:19
Localhost File Test - 01:42
Section 8: Production Environment
Overview - 02:24
Cloud Hosting Registration - 03:54
Creating a Virtual Server - 03:10
Linode Settings and Configuration - 01:24
Deploying an Image - Ubuntu 14.04 LTS - 03:37
Linode Dashboard - 02:27
Remote Access - 02:30
Download PuTTY and PuTTYgen - Windows - 01:00
Launch Terminal - MAC - 00:29
Intro to Command Console - 02:09
Connecting with PuTTY - Windows - 02:01
Connecting with Terminal - MAC - 01:08
Maintenance Commands - 02:39
File and Directory Commands - 02:58
Installing LAMP Stack - 04:29
Server Host Name and Date - 03:08
Creating a User - Ubuntu - 02:56
Ubuntu SSH Authentication - Windows - 07:46
Ubuntu SSH Authentication - MAC - 07:57
Web Root Permissions - 04:06
Remote Dekstop Connection - 10:48
Installing Tight VNC Viewer - Windows - 03:28
Installing RealVNC Viewer - MAC - 02:44
Ubuntu Desktop Basics - 03:54
Disable Root and Password Access - 03:51
Re-sizing a Linode Server - 02:20
Creating Backups on Linode - 04:05
Changing Root Password through Linode - 00:34
Linode DNS Manager - 10:11
Amending GoDaddy Name Servers - 04:08
Section 9: FTP Setup
FTP Client Installation - 02:21
FileZilla Overview - 04:09
FileZilla Uploading - 03:20
FileZilla Interface Basics - 01:40
Section 18: XML l AJAX
Introduction to XML - 04:40
XML Basics - 04:23
XML Schema - 02:03
XML Parsing - 02:00
XML Parsing Continued - 03:58
Introduction to AJAX - 01:50
AJAX - Search Suggest Tutorial - 05:28
AJAX - Database Select Menu Tutorial - 09:18
Section 12: Document Object Model (DOM)
DOM Introduction - 03:12
DOM Manipulation - 01:18
Section 20: Google Apps for Work
Google Apps for Work - Introduction - 02:07
Google Apps for Work - Registration - 07:02
Google Apps for Work - Admin Console - 03:45

Sign In Sign Up

Web Development Masterclass

Enroll

Introduction to MySQL Databases

2024 © YouAccel

Home
About
Privacy
Terms
Contact

Home
Inbox