English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 9.5 Hours | 0.99 GB
MySQL: Learn how to build Reports and work with Databases for Web Applications using MySQL and PHP
Novice to professional database developer in 4 weeks!
Establish the strongest possible foundation in database development by learning how to use MySQL – the most popular open source database in the world – write queries, create reports at will, build web applications, incorporate MySQL as the database layer – make your development dreams a reality by taking this course and putting a check mark next to your growing development skillset.
Database development with MySQL is one of the most fundamental skills that a technology professional needs to thrive in today’s workplace. This course gives you that skill. You’ll start with the absolute basics of installing and creating databases and work your way through building web applications with MySQL as the database, by the end of this course you’ll be able to apply what you have learnt and do virtually anything you want with databases.
Regardless of whether you have experience with flashy new frameworks which try (and fail) to abstract the core of database queries, understanding and having the ability to manipulate these abstractions at will is fundamental to becoming a professional developer – which learning MySQL accomplishes!
This course has it all –
- Setting up MySQL, working with online IDE’s
- Creating Databases and Queries
- Using logical operators, manipulating tables/rows/data
- Learning how joins work and using them at will
- Building web applications with PHP, HTML and CSS along with MySQL as the database layer
- Performing CRUD and authentication from web applications
- Creating admin features and deploying to production
- Responsive support in Q & A and FREE LIVE HELP chatline!
Table of Contents
Introduction to the course and MySQL
1 Introduction
2 Introduce yourself and learn how to get FREE LIVE HELP
3 Development environment overview
4 Sign up for cloud based IDE for development
5 Sign up for cloud based IDE – Text lecture
Creating Databases and Introduction to Queries
6 Power of Databases
7 Create a DatabaseSchema
8 Create a DatabaseSchema – Text lecture
9 Intro to tables and conventions used
10 Working with tables
11 Working with tables – Text lecture
12 Inserting rows of data
13 Inserting rows of data – Text lecture
14 Select
15 Select – Text lecture
16 Concat and substring
17 Concat and substring – Text lecture
18 Homework challenge – bowling scores
19 Homework challenge – Text version
20 Solution – bowling score challenge
21 Solution – Text
22 Alternate method of homework solution – script
23 Alternate method of running queries – script – Text version
24 MySQL Oracle SQL Server
25 Limit order by and distinct
26 Limit order by and distinct – Text lecture
27 Count like and group by
28 Count like and group by – Text lecture
29 Min and max
30 Min and max – Text lecture
31 Code challenge project – create a new report
32 Code challenge project – Text version
Logical operators and dates
33 Data types in MySQL
34 Data types in MySQL – Text lecture
35 Where and not equal
36 Where and not equal – Text lecture
37 Comparison operators
38 Comparison operators – Text lecture
39 Or
40 Or – Text lecture
41 Null and blanks
42 Null and blanks – Text lecture
43 Case statements
44 Case statements – Text lecture
45 Dates and times
46 Dates and times – Text lecture
47 Date time and math
48 Date time and math – Text lecture
49 Section 3 final project – Create a report on birthdays
50 Text solution to final project on birthday reporting
Update and delete rows
51 Update
52 Update – Text lecture
53 Update based on comparison
54 Update based on comparison – Text lecture
55 Delete
56 Delete – Text lecture
Multiple tables and JOINS
57 Primary keys foreign keys
58 Primary and foreign keys – Text lecture
59 Data prep for joins
60 Data prep for joins – Text lecture
61 Joins and aliases
62 Joins and aliases – Text lecture
63 More about joins
64 More about joins – Text lecture
65 Inner Left Outer Right joins
66 Inner Left Outer and Right joins – Text lecture
67 Left outer joins
68 Left outer joins – Text lecture
69 Fix a bad join challenge
70 Fix a bad join challenge – Text lecture
71 Subselects
72 Subselects – Text lecture
73 More subselects
74 More subselects – Text lecture
75 Section 5 – Final Project Part 1
76 Final Project Part 1 – Text solution
77 Section 5 – Final Project Part 2
78 Final Project Part 2 – Text solution
Web apps – Data collection from a survey
79 Introduction to Web App Development
80 HTML and CSS
81 HTML and CSS – Text lecture
82 Start form collector project
83 Project start – Text lecture
84 Add styling to form
85 Add styling to form – Text follow-up
86 Create table
87 Create table – Text follow-up
88 Config and other php
89 Config and other php – Text follow-up
90 Complete receiver
91 Complete receiver – Text follow-up
92 Start SQL Functons
93 Start SQL Functions – Text lecture
94 Preview and understand steps taken for web app
95 Preview of web app – Text follow-up
96 Add browser display
97 Add browser display – Text follow-up
98 Project – Convert to poll
99 Project – Solution text
CRUD and PHP
100 CRUD – Introduction
101 CRUD – Intro – Text follow-up
102 Create action
103 Create action – Text lecture
104 Read
105 Read – Text lecture
106 Update action
107 Update action – Text lecture
108 Delete action
109 Delete action – Text lecture
Authentication with PHP and MySQL
110 Introduction to authentication
111 Intro to authentication – Text lecture
112 Complete user sign-up
113 Complete user sign-up – Text lecture
114 Login users
115 Login users – Text lecture
116 Enforce log in for app
117 Enforce log in – Text lecture
118 Sessions
119 Sessions – Text lecture
Challenge section – Build a WebAdmin site
120 Challenge section intro and get started
121 Challenge section intro – text reference
122 Challenge section project day 2
123 Project day 3 4 and 5
124 Project day 6 7 and completion
Deploy to production
125 Deploy to production using a hosting service
126 Deploy to production – Text lecture
Database permissions
127 Database permissions section doc
Stored Procedures and Scheduled jobs
128 Stored Procedures and Scheduled jobs section doc
129 Thank you
Resolve the captcha to access the links!