mcAfee-secured website

Course name Databases Courses MySQL: The Complete Developer Guide: MySQL: The Complete Developer Guide

MySQL: The Complete Developer Guide Video Course

MySQL: The Complete Developer Guide Video Course is developed by Databases Courses Professionals to help you pass the MySQL: The Complete Developer Guide exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass MySQL: The Complete Developer Guide exam.

Curriculum For This Course

  • 1. Introduction to the course and MySQL 2 Videos 00:12:25
    • Development environment overview 01:24
    • Sign up for cloud based IDE for development 10:38
  • 2. Creating Databases and Introduction to Queries 15 Videos 01:48:02
    • Power of Databases 01:44
    • Create a Database/Schema 06:52
    • Intro to tables and conventions used 04:35
    • Working with tables 12:43
    • Inserting rows of data 11:38
    • Select 02:47
    • Concat and substring 10:29
    • Homework challenge - bowling scores! 02:57
    • Solution - bowling score challenge 10:43
    • Alternate method of homework solution - script 03:51
    • MySQL, Oracle, SQL Server 03:12
    • Limit, order by and distinct 09:03
    • Count, like and group by 07:36
    • Min and max 06:30
    • Code challenge project - create a new report 10:49
  • 3. Logical operators and dates 9 Videos 01:11:30
    • Data types in MySQL 05:10
    • Where and not equal 05:09
    • Comparison operators 06:59
    • Or 01:55
    • Null and blanks 08:17
    • Case statements 03:17
    • Dates and times 06:26
    • Date, time and math 13:17
    • Section 3 final project - Create a report on birthdays 19:24
  • 4. Update and delete rows 3 Videos 00:18:49
    • Update 05:22
    • Update based on comparison 10:21
    • Delete 02:33
  • 5. Multiple tables and JOINS 11 Videos 01:27:17
    • Primary keys, foreign keys 05:33
    • Data prep for joins 10:56
    • Joins and aliases 08:11
    • More about joins 12:27
    • Inner, Left, Outer, Right joins 04:17
    • Left outer joins 07:47
    • Fix a bad join challenge 04:04
    • Subselects 06:43
    • More subselects 08:25
    • Section 5 - Final Project Part 1 12:28
    • Section 5 - Final Project Part 2 04:26
  • 6. Web apps - Data collection from a survey 11 Videos 01:50:56
    • Introduction to Web App Development 07:59
    • HTML and CSS 02:23
    • Start form collector project 13:18
    • Add styling to form 07:49
    • Create table 06:26
    • Config and other php 13:40
    • Complete receiver 15:09
    • Start SQL Functons 12:30
    • Preview and understand steps taken for web app 15:33
    • Add browser display 09:44
    • Project - Convert to poll! 04:28
  • 7. CRUD and PHP 5 Videos 01:14:12
    • CRUD - Introduction 14:38
    • Create action 17:01
    • Read 09:48
    • Update action 19:48
    • Delete action 12:03
  • 8. Authentication with PHP and MySQL 5 Videos 00:57:17
    • Introduction to authentication 09:58
    • Complete user sign-up 09:34
    • Login users 12:06
    • Enforce log in for app 07:38
    • Sessions 17:03
  • 9. Challenge section - Build a WebAdmin site 4 Videos 00:10:06
    • Challenge section intro and get started 03:43
    • Challenge section project day 2 01:26
    • Project day 3, 4 and 5 02:21
    • Project day 6, 7 and completion 01:51
  • 10. Deploy to production 1 Videos 00:01:58
    • Deploy to production using a hosting service 01:48
  • 11. Stored Procedures and Scheduled jobs 1 Videos 00:00:52
    • Thank you! 00:42