FreeCoursesOnline Me Packtpub Com The Complete MySQL Developer Course - FCO

1. 01.Introduction to the course and MySQL/0101.Introduction.mp44.88MB
2. 01.Introduction to the course and MySQL/0102.Development environment overview.mp45.95MB
3. 01.Introduction to the course and MySQL/0103.Sign up for cloud based IDE for development.mp452.49MB
4. 02.Creating Databases and Introduction to Queries/0201.Power of Databases.mp47.19MB
5. 02.Creating Databases and Introduction to Queries/0202.Create a DatabaseSchema.mp419.74MB
6. 02.Creating Databases and Introduction to Queries/0203.Intro to tables and conventions used.mp419.39MB
7. 02.Creating Databases and Introduction to Queries/0204.Working with tables.mp433.76MB
8. 02.Creating Databases and Introduction to Queries/0205.Inserting rows of data.mp429.8MB
9. 02.Creating Databases and Introduction to Queries/0206.Select.mp411.12MB
10. 02.Creating Databases and Introduction to Queries/0207.Concat and substring.mp428.06MB
11. 02.Creating Databases and Introduction to Queries/0208.Homework challenge - bowling scores!.mp413.22MB
12. 02.Creating Databases and Introduction to Queries/0209.Solution - bowling score challenge.mp431.13MB
13. 02.Creating Databases and Introduction to Queries/0210.Alternate method of homework solution – script.mp417.34MB
14. 02.Creating Databases and Introduction to Queries/0211.MySQL, Oracle, SQL Server.mp413.12MB
15. 02.Creating Databases and Introduction to Queries/0212.Limit, order by and distinct.mp425.12MB
16. 02.Creating Databases and Introduction to Queries/0213.Count, like and group by.mp421.65MB
17. 02.Creating Databases and Introduction to Queries/0214.Min and max.mp419.59MB
18. 02.Creating Databases and Introduction to Queries/0215.Code challenge project - create a new report.mp435.31MB
19. 03.Logical operators and dates/0301.Data types in MySQL.mp421.82MB
20. 03.Logical operators and dates/0302.Where and not equal.mp417.52MB
21. 03.Logical operators and dates/0303.Comparison operators.mp419.97MB
22. 03.Logical operators and dates/0304.Or.mp48.82MB
23. 03.Logical operators and dates/0305.Null and blanks.mp424.33MB
24. 03.Logical operators and dates/0306.Case statements.mp412MB
25. 03.Logical operators and dates/0307.Dates and times.mp422.25MB
26. 03.Logical operators and dates/0308.Date, time and math.mp434.03MB
27. 03.Logical operators and dates/0309.Section 3 final project - Create a report on birthdays.mp467.43MB
28. 04.Update and delete rows/0401.Update.mp420.11MB
29. 04.Update and delete rows/0402.Update based on comparison.mp439.71MB
30. 04.Update and delete rows/0403.Delete.mp410.14MB
31. 05.Multiple tables and JOINS/0501.Primary keys, foreign keys.mp422.91MB
32. 05.Multiple tables and JOINS/0502.Data prep for joins.mp440.38MB
33. 05.Multiple tables and JOINS/0503.Joins and aliases.mp431.39MB
34. 05.Multiple tables and JOINS/0504.More about joins.mp444.18MB
35. 05.Multiple tables and JOINS/0505.Inner, Left, Outer, Right joins.mp417.26MB
36. 05.Multiple tables and JOINS/0506.Left outer joins.mp427.59MB
37. 05.Multiple tables and JOINS/0507.Fix a bad join challenge.mp417.33MB
38. 05.Multiple tables and JOINS/0508.Subselects.mp426.24MB
39. 05.Multiple tables and JOINS/0509.More subselects.mp427.18MB
40. 05.Multiple tables and JOINS/0510.Section 5 - Final Project Part 1.mp440.2MB
41. 05.Multiple tables and JOINS/0511.Section 5 - Final Project Part 2.mp416.91MB
42. 06.Web apps – Data collection from a survey/0601.Introduction to Web App Development.mp431.58MB
43. 06.Web apps – Data collection from a survey/0602.HTML and CSS.mp410.76MB
44. 06.Web apps – Data collection from a survey/0603.Start form collector project.mp441.31MB
45. 06.Web apps – Data collection from a survey/0604.Add styling to form.mp430.44MB
46. 06.Web apps – Data collection from a survey/0605.Create table.mp426.58MB
47. 06.Web apps – Data collection from a survey/0606.Config and other php.mp438.88MB
48. 06.Web apps – Data collection from a survey/0607.Complete receiver.mp456.15MB
49. 06.Web apps – Data collection from a survey/0608.Start SQL Functons.mp449.64MB
50. 06.Web apps – Data collection from a survey/0609.Preview and understand steps taken for web app.mp464.8MB
51. 06.Web apps – Data collection from a survey/0610.Add browser display.mp436.79MB
52. 06.Web apps – Data collection from a survey/0611.Project - Convert to poll!.mp418.83MB
53. 07.CRUD and PHP/0701.CRUD – Introduction.mp447.12MB
54. 07.CRUD and PHP/0702.Create action.mp458.51MB
55. 07.CRUD and PHP/0703.Read.mp438.4MB
56. 07.CRUD and PHP/0704.Update action.mp476.5MB
57. 07.CRUD and PHP/0705.Delete action.mp445.07MB
58. 08.Authentication with PHP and MySQL/0801.Introduction to authentication.mp437.29MB
59. 08.Authentication with PHP and MySQL/0802.Complete user sign-up.mp438.36MB
60. 08.Authentication with PHP and MySQL/0803.Login users.mp448.05MB
61. 08.Authentication with PHP and MySQL/0804.Enforce log in for app.mp430.26MB
62. 08.Authentication with PHP and MySQL/0805.Sessions.mp465.83MB
63. 09.Challenge section - Build a WebAdmin site/0901.Challenge section intro and get started.mp412.56MB
64. 09.Challenge section - Build a WebAdmin site/0902.Challenge section project day 2.mp45.81MB
65. 09.Challenge section - Build a WebAdmin site/0903.Project day 3, 4 and 5.mp49.49MB
66. 09.Challenge section - Build a WebAdmin site/0904.Project day 6, 7 and completion.mp46.56MB
67. 10.Deploy to production/1001.Deploy to production using a hosting service.mp45.35MB
68. 11.Stored Procedures and Scheduled jobs/1101.Thank you.mp43.14MB