Php – MySql

Η σύγχρονη αγορά εργασίας απαιτεί επαγγελματίες με ατομικές ικανότητες στον προγραμματισμό  με τις γλώσσες PHP – MySQL.

ΥΛΗ ΣΕΜΙΝΑΡΙΟΥ ΣΥΝΟΠΤΙΚΑ:

• PHP
  • PHP Language Structure
  • Getting Involved with the Code
  • The Building Blocks of PHP
  • Flow Control Functions in PHP
  • Working with Functions
  • Working with Arrays
  • Working with Objects
  • Working with Strings, Dates, and Time
  • Working with Forms
• MySQL
  • Understanding the Database Design Process
  • Learning Basic SQL Commands
  • Creating and Using a Database
  • Interacting with MySQL Using PHP

ΥΛΗ ΣΕΜΙΝΑΡΙΟΥ ΑΝΑΛΥΤΙΚΑ:

• PHP
  • Lecture 1.1 PHP LANGUAGE STRUCTURE
  • Lecture 1.2 The Building Blocks of PHP
  • Lecture 1.3 Flow Control Functions in PHP
  • Lecture 1.4 Working with Functions
  • Lecture 1.5 Working with Arrays
  • Lecture 1.6 Working with Objects
• GETTING INVOLVED WITH THE CODE
  • Lecture 2.1 Working with Strings, Dates, and Time
  • Lecture 2.2 Working with Forms
  • Lecture 2.3 Working with Cookies and User Sessions
  • Lecture 2.4 Working with Files and Directories
  • Lecture 2.5 Working with Images
• THE BUILDING BLOCKS OF PHP
  • Lecture 3.1 Variables
  • Lecture 3.2 Data Types
  • Lecture 3.3 Operators and Expressions
  • Lecture 3.4 Constants
  • Lecture 3.5 Summary
  • Lecture 3.6 Workshop
• FLOW CONTROL FUNCTIONS IN PHP
  • Lecture 4.1 Switching Flow
  • Lecture 4.2 Loops
  • Lecture 4.3 Code Blocks and Browser Output
  • Lecture 4.4 Workshop
  • Lecture 4.5 What Is a Function?
  • Lecture 4.6 Calling Functions
  • Lecture 4.7 Defining a Function
  • Lecture 4.8 Returning Values from User-Defined Functions
  • Lecture 4.9 Variable Scope
  • Lecture 4.10 Saving State Between Function Calls with the static Statement
  • Lecture 4.11 More About Arguments
  • Lecture 4.12 Testing for the Existence of a Function
  • Lecture 4.13 Workshop
• WORKING WITH ARRAYS
  • Lecture 5.1 What Are Arrays?
  • Lecture 5.2 Creating Arrays
  • Lecture 5.3 Some Array-Related Constructs and Functions
  • Lecture 5.4 Workshop
• WORKING WITH OBJECTS
  • Lecture 6.1 Creating an Object
  • Lecture 6.2 Object Inheritance
  • Lecture 6.3 Workshop
• WORKING WITH STRINGS, DATES, AND TIME
  • Lecture 7.1 Formatting Strings with PHP
  • Lecture 7.2 Investigating Strings in PHP
  • Lecture 7.3 Manipulating Strings with PHP
  • Lecture 7.4 Using Date and Time Functions in PHP
  • Lecture 7.5 Other String, Date, and Time Functions
• WORKING WITH FORMS
  • Lecture 8.1 Creating a Simple Input Form
  • Lecture 8.2 Accessing Form Input with User-Defined Arrays
  • Lecture 8.3 Combining HTML and PHP Code on a Single Page
  • Lecture 8.4 Using Hidden Fields to Save State
  • Lecture 8.5 Redirecting the User.
  • Lecture 8.6 Sending Mail on Form Submission
  • Lecture 8.7 Creating the Form
  • Lecture 8.8 Creating the Script to Send the Mail
  • Lecture 8.9 Working with File Uploads
  • Lecture 8.10 Workshop
• MYSQL
  • Lecture 9.1 UNDERSTANDING THE DATABASE DESIGN PROCESS
  • Lecture 9.2 The Importance of Good Database Design
  • Lecture 9.3 Types of Table Relationships
  • Lecture 9.4 Understanding Normalization
  • Lecture 9.5 Following the Design Process
• LEARNING BASIC SQL COMMANDS
  • Lecture 10.1 Learning the MySQL Data Types
  • Lecture 10.2 Learning the Table-Creation Syntax
  • Lecture 10.3 Using the INSERT Command
  • Lecture 10.4 Using the SELECT Command
  • Lecture 10.5 Using WHERE in Your Queries
  • Lecture 10.6 Selecting from Multiple Tables
  • Lecture 10.7 Using the UPDATE Command to Modify Records
  • Lecture 10.8 Using the REPLACE Command
  • Lecture 10.9 Using the DELETE Command
  • Lecture 10.10 Frequently Used String Functions in MySQL
  • Lecture 10.11 Using Date and Time Functions in MySQL
• INTERACTING WITH MYSQL USING PHP
  • Lecture 11.1 MySQL or MySQLi Functions?
  • Lecture 11.2 Connecting to MySQL with PHP
  • Lecture 11.3 Working with MySQL Data
  • Lecture 11.4 Creating and Selecting a Database
  • Lecture 11.5 Creating a Table
  • Lecture 11.6 Loading Data into a Table
  • Lecture 11.7 Retrieving Information from a Table
  • Lecture 11.8 Selecting All Data
  • Lecture 11.9 Selecting Particular Rows
  • Lecture 11.10 Selecting Particular Columns
  • Lecture 11.11 Sorting Rows
  • Lecture 11.12 Date Calculations
  • Lecture 11.13 Working with NULL Values
  • Lecture 11.14 Pattern Matching
  • Lecture 11.15 Counting Rows
  • Lecture 11.16 Using More Than one Table

CERTIFICATION:
Βεβαίωση Παρακολούθησης σε PDF
Προώθηση Βιογραφικού
Ύλη
Επιπλέον 3 ώρες για να αναλύσουμε τυχόν απορίες
Το Σεμινάριο επιδοτείται μέχρι και 100% από τον λογαριασμό ΛΑΕΚ (0,24%) του ΟΑΕΔ.

Ώρες Διεξαγωγής Σεμιναρίου:
Καθημερινά: 10:00-13:00, ή 13:00-16:00, ή 16:00-19:00 ή 19:00-22:00
Σάββατο: 10:00-13:00

Τώρα και με την online αγορά μπορείτε να εγγραφείτε και στο μάθημα που σας ενδιαφέρει!