السلام عليكم و رحمة الله و بركاته ... كيف الحال يا اخوان
و انا اتمشى فى الانترنت و قاعد اسوي بحث للمواقع لقيت هالموقع ... و هو عبارة عن دورات في جميع اللغات بس شكله ما هو مجاني المهم انا اعجبني التقسيم و الترتيب حقه و خصوصاً دورة MySQL حيث انه يشرح الاساسيات لمن لا يفهم القواعد و اساسياتهاو كذلك يشرح ال PHP
طالعوا و شوفوا و احكموا
>> هذي MySQL
http://apex.vtc.com/mysql.php
Getting Started
Welcome Demo
What You'll Need Demo
Database Basics
What Is A Database? Demo
RDBMSs Demo
Tables and Data Demo
SQL Basics
Finding Your Way About Demo
Creating a Database Demo
Creating a Table Demo
Column Types-String Demo
Column Types-Numeric Demo
Retrieving Data With Search Criteria Demo
Changing Existing Data Demo
Altering A Table Demo
Keys And Indexes Demo
Basics Syntax Recap Demo
Operators in MySQL
Arithmetic Operators
Numeric Comparison Operators
String Comparison Operators
Logical Operators
Bitwise Operators
Regular Expressions 1
Regular Expressions 2
Operators Syntax Recap
Querying Your Data
Sorting Retrieved Data
Specifying Numbers of Results
Joining Tables
More On Joining Tables
Data Aggregation
Queries Syntax Recap
More Complex SQL
Using Default Data
Date And Time 1
Date And Time 2
ENUM column type
SET column type
Using Variables
Conditional: IF()
Complex Syntax Recap
Good Practises
Using SQL batch files
Data Modeling
Normalization
Optimizations
Security
Users And Privileges
More About Users And Privileges
The 'mysql' Database
Encryption
Security Syntax Recap
Building A Database Application
Planning The Structure
Designing The Database
Creating The Database
Logging In And Out
Checking Videos In And Out
Searching For A Video
Adding A New Title
Signing Up A New Customer
Hiring And Firing Employees
Listing Debtors
>> و هذي PHP
http://apex.vtc.com/php.php
Concepts
What is PHP? Demo
Data Flow Demo
What You'll Need pt. 1 Demo
What You'll Need pt. 2 Demo
Scripting vs. Viewing Demo
Your First Script Demo
Absolute Basics
Embedding PHP within HTML Demo
Variables Demo
Operators Demo
More Complex Operators pt. 1 Demo
More complex Operators pt. 2 Demo
Making Choices
'If' and Conditional Operators Demo
Logical Operators Demo
Using 'Else' and 'Elseif' Demo
Multiple Choices: 'Switchcasebreak' Demo
The Concise Conditional: '?' : Demo
Loops and Control Structures
Repetition: The 'For' Loop
'While' and 'Do..While' Loops
Get Me Out Of Here! 'Break' and 'Exit'
Data
Introduction to Arrays
Referencing and Sorting Arrays
Associative Arrays pt. 1
Associative Arrays pt. 2
More About Arrays
Multidimensional Arrays
Joining Arrays and Splitting Strings
More String Manipulation
Replacing Text Within Strings
Introduction to Regular Expressions pt. 1
Introduction to Regular Expressions pt. 2
More About Regular Expressions
More About Regular Expressions pt. 2
Replacing Text Using Regular Expressions
Querying A Database
Our Sample MySQL Database
Connecting to the Database
Retrieving Data
Interacting With The User
A Simple HTML Form
A Simple PHP Search Script. pt. 1
A Simple PHP Search Script. pt. 2
Validating User Input
A Search Feature With Dynamic Options pt. 1
A Search Feature With Dynamic Options pt. 2
An HTML Form For User Feedback
Adding The Feedback to the Database pt. 1
Adding The Feedback to the Database pt. 2
Validating an Email Address
Uploading a File pt. 1
Uploading a File pt. 2
Intermediate Coding Techniques
Reusing Code: Functions pt. 1
Reusing Code: Functions pt. 2
Variable Scope
Calling By Value or By Reference
Variable Numbers of Arguments
Calling Functions Through Variables
Recursive Functions
Date and Time
Using External Code Resources
Error Capture: The Graceful Death pt. 1
Error Capture: The Graceful Death pt. 2
Error Capture: Custom Error Handlers pt. 1
Error Capture: Custom Error Handlers pt. 2
Sessions and Users
A Simple Login System
Sessions
Cookies
Logging a User In pt. 1
Logging a User In pt. 2
Logging Out
Registering a User pt. 1
Registering a User pt. 2
Objects
Classes And Objects
Properties and Methods pt. 1
Properties and Methods pt. 2
Constructor Functions
Inheritance pt. 1
Inheritance pt. 2
Polymorphism
Aggregation pt.1
Aggregation pt. 2
Building a Data-Driven Website
The Project: A Discussion Forum
Common Elements pt. 1
Common Elements pt. 2
Adapting the Login Page pt. 1
Adapting the Login Page pt. 2
Adapting the Registration Page
View all Threads pt. 1
View all Threads pt. 2
Viewing a Thread pt. 1
Viewing a Thread pt. 2
Making or Editing A Post pt. 1
Making or Editing A Post pt. 2
Deleting a Post or Thread
و شرايكم بالله ؟!!!!
لا و فيه عدة الدورات في جميع المجالات ... رح للموقع و شوف ...
http://apex.vtc.com
و السلام خير ختام ... اخوكم العارف
