Course Includes
- Recorded Lessons: 139
- Recorded Hours: 18
- Duration: 18 days (Avg)
Course Features
- Access on mobile
- TDP Assessment Test
- 5 Jobs Available
Top Skills Covered
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 | 18:00 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
45 Courses
13+ Lesson
1260 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.