facebook
favorite button
member since icon
Since March 2023
Instructor since March 2023
Web development - From practices to real world systems
course price icon
From 56.49 Fr /h
arrow icon
PHP is a Powerful Web Programming Language that works as server-client server architecture. As a Web Developer you will be able to develop and apply complex methods and other features to critically understand an entire process of web development, including the database designing, implementation and evaluation. From the syllabus you will be able to apply from simple tasks to more complete as well as work with MVC (Modelling, View and Controlling) architecture.

At the end, by analysing different use-cases, Students will be able to develop their own systems booking systems, e-shops, e-learning systems, and more.
Extra information
Please, get ready with your own laptop.
Location
location type icon
Online from United Kingdom
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Advanced
Duration
90 minutes
120 minutes
The class is taught in
English
Availability of a typical week
(GMT -05:00)
New York
at teacher icon
Online via webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Similar classes
arrow icon previousarrow icon next
verified badge
Brahim
Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views
verified badge
Farouk
This module is a crucial step for any web developer wishing to move from simple DOM manipulation to mastering modern frameworks. The objective is clear: to understand the "invisible foundations" of the language in order to write shorter, more readable code and, above all, be ready to code professionally in React.

🎯 Training Objectives

1- Demystify the modern syntax (ES6+) often used in React.
2- Increase efficiency by using the most powerful syntactic shortcuts.
3- Secure your code to avoid frequent bugs related to missing data.
4- Mastering asynchronicity to manage data calls (API).

📖 Detailed program content

The course is divided into 13 key concepts, illustrated by comparative examples (classic syntax vs. modern syntax) and concrete use cases in React:

1- Ease of writing: Use of Template Literals (`backticks`) for dynamic character strings and Shorthand property names to simplify the creation of objects.

2- Logic and Functions: Mastery of Arrow => Functions (arrow functions) and their implicit return, essential for React components and hooks.

Data manipulation:

1- Destructuring (decomposition) to properly extract data from objects and arrays (e.g., Props and States).

2- Rest & Spread Operators (...) to copy arrays or merge objects without modifying the original (concept of immutability).

Code robustness:

1- Managing default parameter values.

2- Advanced security with Optional Chaining (?.) and Nullish Coalescing (??) to prevent application crashes.

3- Functional Programming: Intensive use of array methods (.map(), .filter(), .reduce(), .find()) to transform data into user interfaces.

4- Architecture and Asynchronism: Code organization via modules (Import/Export) and API request management with Promises and Async/Await.

🛠️ Teaching method: "Learning by doing"

This course is not just about theory. It includes:

The "Interstellar Dashboard" Exercise: A 15-minute thematic case study where students manipulate data from space missions. This allows them to immediately apply destructuring, filtering, and asynchronicity to a real-world project.

The Interactive Quiz: A series of 10 questions designed to validate understanding of each concept before moving on. Each question presents real-world scenarios that developers will encounter in React.

🚀 Learner's result

By the end of this course, students will not only "know" JavaScript; they will understand why and how each syntax is used to build efficient React components. They will leave with a solid foundation to confidently tackle Hooks (useState, useEffect) and complex state management.

Format: Clean visual presentation, coloured syntax for code, and focus on readability.
message icon
Contact Hercilio
repeat students icon
1st lesson is backed
by our
Good-fit Instructor Guarantee
Similar classes
arrow icon previousarrow icon next
verified badge
Brahim
Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views
verified badge
Farouk
This module is a crucial step for any web developer wishing to move from simple DOM manipulation to mastering modern frameworks. The objective is clear: to understand the "invisible foundations" of the language in order to write shorter, more readable code and, above all, be ready to code professionally in React.

🎯 Training Objectives

1- Demystify the modern syntax (ES6+) often used in React.
2- Increase efficiency by using the most powerful syntactic shortcuts.
3- Secure your code to avoid frequent bugs related to missing data.
4- Mastering asynchronicity to manage data calls (API).

📖 Detailed program content

The course is divided into 13 key concepts, illustrated by comparative examples (classic syntax vs. modern syntax) and concrete use cases in React:

1- Ease of writing: Use of Template Literals (`backticks`) for dynamic character strings and Shorthand property names to simplify the creation of objects.

2- Logic and Functions: Mastery of Arrow => Functions (arrow functions) and their implicit return, essential for React components and hooks.

Data manipulation:

1- Destructuring (decomposition) to properly extract data from objects and arrays (e.g., Props and States).

2- Rest & Spread Operators (...) to copy arrays or merge objects without modifying the original (concept of immutability).

Code robustness:

1- Managing default parameter values.

2- Advanced security with Optional Chaining (?.) and Nullish Coalescing (??) to prevent application crashes.

3- Functional Programming: Intensive use of array methods (.map(), .filter(), .reduce(), .find()) to transform data into user interfaces.

4- Architecture and Asynchronism: Code organization via modules (Import/Export) and API request management with Promises and Async/Await.

🛠️ Teaching method: "Learning by doing"

This course is not just about theory. It includes:

The "Interstellar Dashboard" Exercise: A 15-minute thematic case study where students manipulate data from space missions. This allows them to immediately apply destructuring, filtering, and asynchronicity to a real-world project.

The Interactive Quiz: A series of 10 questions designed to validate understanding of each concept before moving on. Each question presents real-world scenarios that developers will encounter in React.

🚀 Learner's result

By the end of this course, students will not only "know" JavaScript; they will understand why and how each syntax is used to build efficient React components. They will leave with a solid foundation to confidently tackle Hooks (useState, useEffect) and complex state management.

Format: Clean visual presentation, coloured syntax for code, and focus on readability.
Good-fit Instructor Guarantee
favorite button
message icon
Contact Hercilio