Includes
-
Duration: 18 days
-
Chapters: 139
-
Total Hours: 17:26
Features
Full lifetime access
Access on mobile
Assignments
Certificate of Completion
Overview
Course Description
Build dynamic database-backed Restful web APIs.. Use CSS, PHP, MySQL to build web services JWT and CRUD applications.
Requirements
- Basic coding needed(optional). You will learn everything you need to know
- No software is required in advance of the course (all software used in the course is free)
- No pre-knowledge is required - you will learn from basic on APIs
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 APIs development with CSS, Restful APIs Coding and MySQL; Explore this course for rest api tutorial to learn creating restful apis using different programming languages,
Learning to code CSS, Restful APIs Coding and MySQL database is The first step to Coding you need to learn to succeed in web development, it is easy to learn and understand our online CSS design, Secure Restful APIs PHP Coding and MySQL Training course is designed for you with the complete steps to require learn Complete Developer topics. Mr. Sekhar Metla [MCP - Microsoft Certified Professional] will explain to you even complex topics to simplify and teach you that even beginners can easily understand with real-time examples.
This Development course is without a doubt the most comprehensive API development course available online. Even if you have zero programming experience with API, this course will take you from beginner to mastery. Here's why:
The course is taught by the lead instructor having 20+ years of professional experience.
Become a Web Developer with just ONE course. Developers complete courses for web design, and development with front-end design, coding, and database queries!
The course has been updated to be trending technology ready and you'll be learning the latest tools and technologies used at large companies such as Apple, Facebook, Google, and Netflix.
The curriculum was developed over a period of four years, with comprehensive student testing and feedback on who is working and applying these coding examples.
We've taught many students how to code and many have gone on to change their lives by becoming professional developers or starting their own tech startups.
We'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a web developer.
The course includes HD video tutorials and builds your programming knowledge while making real-world websites and web apps.
Learn from real-world experts
Throughout this comprehensive course, we cover a massive amount of tools and technologies, including:
CSS Styles
- Front-End Web Development
- Client-side style code
- Internal CSS
- External CSS
- Box Model
- Forms
- Cards
- Responsive
- Layout design
- Colors
- Fonts
- Form beautification
- and more..
Restful APIs Coding
- Real-world projects
- Source-Code
- POSTMAN app
- GET
- POST
- PUT
- DELETE
- Secure REST APIs
- JSON Web Tokens and Oauth
- Login Form
- Registration Form
- Authorization
- Code Development
- Web Design
- CRUD functions
- and more..
MySQL
- Installation
- Database
- Tables
- SQL functions
- SQL statements
- SQL operators
- SQL joins
- SQL advanced
- Timestamp
- Filtering data
- Analyzing data
- Grouping data
- Constraints
- Reports
- Backup and Restore
and more..
By the end of this course, you will be fluent in programming and ready to make any website you can dream of.
Sign up today, and look forward to:
- HD Video Lectures
- Code Challenges and Coding Exercises
- Beautiful Real-World dynamic Projects
About Your Instructor
Sekhar Metla is a software engineer with 20+ years of professional experience. He is the author of several online-selling courses with more than 40,000+ students in many countries. He has a Master of Science in Computer Applications in Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.
What are you waiting join now to start learning how to make your own APIs Developer Career TODAY :)
Who this course is for:
- Beginner Restful APIs, PHP coding, MySQL and CSS developers curious about APIs development
- Anyone who wants to generate new income streams
- Anyone who wants to build Secure Restful web APIs
- Anyone who wants to become financially independent
- Anyone who wants to start their own business or become freelance
- Anyone who wants to become a API stack web developer
- Build dynamic database-backed Restful web APIs.. Use CSS, PHP, MySQL to build web services JWT and CRUD applications.
Explore related course by author
Learn HTML JavaScript Restful API from scratch
Restful API Web Services with PHP and MySQL
What you'll learn
- Build coding for Secure Restful APIs
- Create dynamic database web applications for your business needs
- Master client-end design using CSS3, back-end development Restful API, PHP coding with MySQL
- Create fully function web APIs apps using PHP Coding, MySQL and CSS
- You will learn to apply 2 real world projects example source code
- Get a job as a junior web API developer
- Start their own online business by creating Mobile Web API services
- Apply JSON Object, RestFul API, MySQL and CSS3 on real-world web service tasks
- Identify the requirements on Project to write APIs for your apps and projects
Requirements
- Basic coding needed(optional). You will learn everything you need to know
- No software is required in advance of the course (all software used in the course is free)
- No pre-knowledge is required - you will learn from basic on APIs
Course Content
139 Lessons | 17:26 Total hours
CSS Introduction
-
101 Introduction 00:02:43 -
104 How to ask a great questions 00:01:21
-
201 Introduction CSS 00:06:02
-
202 Choosing Code Editor 00:03:28
-
203 Installing Code Editor (Sublime Text) 00:03:49
-
204 CSS Syntax 00:05:00
-
205 Creating a first page with CSS Style 00:12:30
-
Source Code 00:08:47
CSS Basic
-
206 Inline CSS 00:05:57
-
207 Internal CSS 00:05:23
-
208 External CSS 00:09:56
-
209 CSS Classes 00:09:24
-
210 CSS IDs 00:06:15
-
211 Colors 00:08:01
-
212 Backgrounds 00:03:35
-
213 Floating 00:08:38
-
214 Positioning 00:05:53
-
215 Margins 00:07:03
-
216 Padding 00:03:52
-
217 Borders 00:03:17
CSS Intermediate
-
218 Styling Text 00:06:34
-
219 Aligning Text 00:03:58
-
220 Styling Links 00:10:03
-
221 Font Family 00:07:06
-
222 Font Styles 00:03:15
-
223 Applying Google Fonts 00:07:06
-
224 Box Model 00:08:50
-
225 Icons 00:08:43
-
226 Tables 00:15:54
-
227 Navigation-Menu 00:11:12
-
228 Dropdowns 00:15:21
CSS Advanced
-
229 Advanced Selectors 00:05:01
-
230 Forms 00:16:34
-
231 Website Layout 00:20:53
-
232 Rounded Corners 00:08:00
-
233 Color Keywords 00:05:45
-
234 Animations 00:07:33
-
235 Pseudo Classes 00:03:00
-
236 Gradients 00:02:52
-
237 Shadows 00:03:29
-
238 Calculations 00:05:14
-
239 Creating Responsive Page 00:06:12
CSS Expert
-
240 Button Styles 00:06:04
-
241 Pagination 00:06:56
-
242 Multiple Columns 00:05:43
-
243 Image Reflection 00:02:41
-
244 UI - UX Design 00:09:11
-
245 Social Media Icons 00:07:55
-
246 External CSS Style adding 00:05:51
Restful API Introduction
-
501 Section Introduction 00:02:05
-
502 Installing XAMPP for PHP, MySQL and Apache 00:12:06
-
503 Installing Code Editor(Visual Studio Code) 00:06:33
-
504 Postman API platform installation 00:05:36
-
505 Composer installation 00:04:06
-
506 Creating PHP Project on XAMPP 00:03:27
-
507 Hello World Program 00:05:46
Restful API Basic
-
508 What is PHP 00:08:00
-
509 What is Restful API 00:05:24
-
510 HTTP request GET, POST, PUT or DELETE 00:08:02
-
511 REST API project structure 00:06:14
Project1: Restful API Authentication
-
512 Create Database and table 00:06:01
-
513 Creating Project forms and folders 00:05:04
-
514 Database Connection 00:12:57
-
515 JSON Web Token Handler(JWT) 00:13:58
-
516 Auth Middleware Token Validation 00:22:42
-
517 Register form 00:20:17
-
518 Login form 00:14:11
-
519 User Token Authorization check form 00:12:11
Project2: Restful API - MySQL
-
520 Create Database and table 00:06:11
-
521 Adding Data to table - insert query 00:03:10
-
522 MySQL Select query 00:05:35
-
523 MySQL Update query 00:03:52
-
524 MySQL Delete query 00:01:56
-
525 Get Project2 Source Code 00:02:26
-
526 Create Database Connection 00:01:53
Restful API – Web API Services
-
527 Create Items Class PHP File 00:04:26
-
528 Create Method form 00:04:18
-
529 Creating Record Using Restful API 00:04:25
-
530 Reading Method form 00:02:10
-
531 Reading Record Using Restful API 00:02:46
-
532 Update Method form 00:02:45
-
533 Update Record Using Restful API 00:05:05
-
534 Delete Method form 00:01:38
-
535 Delete Method Using Restful API 00:01:53
-
536 Coding Exercise 00:00:50
-
537 Solution for Coding Exercise 00:01:33
-
538 SEO friendly Request URLs of REST API 00:02:14
MYSQL introduction
-
1003 Overview of Databases 00:10:24
-
1004 MySQL Installation 00:15:50
-
1005 MySQL Workbench Installation 00:09:04
-
1006 Connecting to MySQL using Console 00:09:00
MySQL basic
-
1007 Overview of Challenges 00:03:43
-
1008 SQL Statement Basic 00:15:31
-
1009 SELECT Statement 00:09:19
-
1010 SELECT DISTINCT 00:04:51
-
1011 Column AS Statement 00:11:43
-
1012 COUNT function 00:11:03
MySQL filtering data
-
1013 SELECT WHERE Clause – One 00:04:36
-
1014 SELECT WHERE Clause – Two 00:10:41
-
1015 ORDER BY 00:07:41
-
1016 LIMIT 00:08:35
-
1017 BETWEEN 00:11:18
-
1018 IN Operator 00:10:40
-
1019 LIKE and ILIKE 00:11:11
MySQL functions
-
1020 Overview of GROUP BY 00:05:39
-
1021 Aggregation function SUM() 00:08:52
-
1022 Aggregation MIN() and MAX() 00:05:30
-
1023 GROUP BY - One 00:09:13
-
1024 GROUP BY – Two 00:11:46
-
1025 HAVING Clause 00:05:05
MySQL joins
-
1026 Overview Assessment 00:01:59
-
1027 Overview of JOINS 00:03:36
-
1028 Introduction to JOINS 00:04:01
-
1029 AS Statement table 00:03:04
-
1030 INNER JOIN 00:18:30
-
1031 FULL Outer Join 00:11:11
-
1032 LEFT Outer JOIN 00:07:54
-
1033 RIGHT JOIN 00:07:45
-
1034 Union 00:06:44
MySQL advanced commands
-
1035 Advanced SQL Commands 00:03:38
-
1036 Timestamps 00:12:22
-
1037 EXTRACT from timestamp 00:09:59
-
1038 Mathematical Functions 00:11:39
-
1039 String Functions 00:22:15
-
1040 SUBQUERY 00:13:25
MySQL structure creation
-
1041 Database and Tables 00:06:09
-
1042 Data Types 00:10:30
-
1043 Primary key and Foreign key 00:05:33
-
1044 Create Table in SQL Script 00:13:12
MySQL data queries
-
1045 Insert 00:10:47
-
1046 Update 00:08:35
-
1047 Delete 00:04:08
MySQL structure queries
-
1048 Alter Table 00:09:30
-
1049 Drop Table 00:05:21
MySQL constraints
-
1050 NOT NULL Constraint 00:07:54
-
1051 UNIQUE Constraint 00:09:14
MySQL backup and restore
-
1052 Overview of Databases and Tables 00:04:50
-
1053 Backup database using phpMyAdmin 00:12:28
-
1054 Restoring a Database 00:07:03
About the instructor
Sekhar Metla
Instructor
32 Courses
13+ Lesson
768 Students enrolled
Sekhar Metla is a software engineer with 15 years of professional experience. He is the author of several best-selling TeacherDada courses with more than 26,000+ students in 192 countries. He has a Master of Science in Computer Applications as Software Engineering and is also Microsoft Certified Professional. His students describe him as passionate, pragmatic, and motivational in his teaching.