Create RESTful APIs using PHP, POSTMAN and MySQL: Secure API

Metla Sudha Sekhar

139 Lessons 17h 24m

12. CSS Classes

In this course, we will learn the basic tools that every Web developer needs to know. We will start from scratch by learning how to implement WEB API developmen...

Lesson assistant

Ask about what you’re watching

Subscriber benefit

See something confusing? Subscribe to ask the lesson assistant about it.

Ask about what’s on screen. The assistant uses the current video frame and available subtitles.
Get clear answers to up to 5 lesson questions each day.
Enrol in up to 4 included courses each month and learn while subscribed.
Save 75% on eligible courses outside the subscription.

Already subscribed? Sign in

No suggested offers right now

Continue through the course and check back later for relevant recommendations.

View Downloads

Course Content

0% Completed

Introduction

1. Introduction 3m 2. How to Ask Great Questions 2m 3. Introducing CSS 7m 4. Choosing Code Editor 4m 5. Installing Code Editor (Sublime Text) 4m 6. CSS Syntax 5m 7. Creating a First Page with CSS Style 13m 8. What is Source Code? 9m

CSS Basic

9. Inline CSS 6m 10. Internal CSS 6m 11. External CSS 10m 12. CSS Classes 10m 13. CSS IDs 7m 14. Colors 8m 15. Backgrounds 4m 16. Floating 9m 17. Positioning 6m 18. Margins 8m 19. Padding 4m 20. Borders 4m

CSS Intermediate

21. Styling Text 7m 22. Aligning Text 4m 23. Styling Links 11m 24. Font Family 8m 25. Font Styles 4m 26. Applying Google Fonts 8m 27. Box Model 9m 28. Icons 9m 29. Tables 16m 30. Navigation Menu 12m 31. Dropdowns 16m

CSS Advanced

32. Advanced Selectors 6m 33. Forms 17m 34. Website Layout 21m 35. Rounded Corners 8m 36. Color Keywords 6m 37. Animations 8m 38. Pseudo Classes 3m 39. Gradients 3m 40. Shadows 4m 41. Calculations 6m 42. Creating Responsive Pages 7m

CSS Expert

43. Button Styles 7m 44. Pagination 7m 45. Multiple Columns 6m 46. Image Reflection 3m 47. UI - UX Design 10m 48. Social Media Icons 8m 49. External CSS Style Adding 6m

Restful API Introduction

50. Section Introduction 3m 51. Installing XAMPP for PHP, MySQL and Apache 13m 52. Installing Code Editor(Visual Studio Code) 7m 53. Postman API Platform Installation 6m 54. Composer Installation 5m 55. Creating PHP Project on XAMPP 4m 56. Hello World Program 6m

Restful API Basic

57. What is PHP? 8m 58. What is Restful API? 6m 59. HTTP Request GET, POST, PUT or DELETE 9m 60. REST API Project Structure 7m

Project1: Restful API Authentication

61. Create Database and Tables 7m 62. Creating Project Forms and Folders 6m 63. Database Connection 13m 64. JSON Web Token Handler(JWT) 14m 65. Auth Middleware Token Validation 23m 66. Register Form 21m 67. Login Form 15m 68. User Token Authorization Check Form 13m

Project2: Restful API - MySQL

69. Create Database and Tables 7m 70. Adding Data to Table - Insert Query 4m 71. MySQL Select Query 6m 72. MySQL Update Query 4m 73. MySQL Delete Query 2m 74. Get Project 2 Source Code 3m 75. Create Database Connection 2m

Restful API - Web API Service

76. Create Items Class PHP File 5m 77. Create Method Form 5m 78. Creating Record Using Restful API 5m 79. Reading Method Form 3m 80. Reading Record Using Restful API 3m 81. Update Method Form 3m 82. Update Record Using Restful API 6m 83. Delete Method Form 2m 84. Delete Method Using Restful API 2m 85. Coding Exercise 1m 86. Solution For Coding Exercise 2m 87. SEO Friendly Request URLs of REST API 3m

MySQL Introduction

88. Overview of Databases 11m 89. MySQL Installation 16m 90. MySQL Workbench Installation 10m 91. Connecting to MySQL Using Console 9m

MySQL Basic

92. Overview of Challenges 4m 93. SQL Statements Basics 16m 94. SELECT Statement 10m 95. SELECT DISTINCT 5m 96. Column AS Statement 12m 97. COUNT Function 12m

MySQL Filtering Data

98. SELECT WHERE Clause – One 5m 99. SELECT WHERE Clause – Two 11m 100. ORDER BY 8m 101. LIMIT 9m 102. BETWEEN 12m 103. IN Operator 11m 104. LIKE and ILIKE 12m

MySQL Functions

105. Overview of GROUP BY 6m 106. Aggregation Function SUM() 9m 107. Aggregation MIN() and MAX() 6m 108. GROUP BY – One 10m 109. GROUP BY – Two 12m 110. HAVING Clause 6m

MySQL Joins

111. Overview Assessment 2m 112. Overview of JOINS 4m 113. Introduction to JOINS 5m 114. AS Statement Table 4m 115. INNER Join 19m 116. FULL Outer Join 12m 117. LEFT Outer Join 8m 118. RIGHT Join 8m 119. UNION 7m

MySQL Advanced Commands

120. Advanced SQL Commands 4m 121. Timestamps 13m 122. EXTRACT From Timestamp 10m 123. Mathematical Functions 12m 124. String Functions 23m 125. SUBQUERY 14m

MySQL Structure Creation

126. Database and Tables 7m 127. Data Types 11m 128. Primary Key and Foreign Key 6m 129. Create Table in SQL Script 14m

MySQL Data Queries

130. INSERT 11m 131. UPDATE 8m 132. DELETE 5m

MySQL Structure Queries

133. ALTER Table 10m 134. DROP Table 6m

MySQL Constraints

135. NOT NULL Constraint 8m 136. UNIQUE Constraint 10m

MySQL Backup and Restore

137. Overview of Databases and Tables 5m 138. Backup Database Using phpMyAdmin 13m 139. Restoring a Database 8m

Create RESTful APIs using PHP, POSTMAN and MySQL: Secure API

Ready for the next lesson?

12. CSS Classes

Ask about what you’re watching

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar