دانلود دانلود فیلم های آموزشی MySQL

The Developer · 6 بهمن، ۱۳۹۱

با سلام / در این تاپیک فیلم های آموزشی MySQL به صورت زبان اصلی یا فارسی قرار میگیره تا دوستان بهره کافی رو ببرند

موفق باشید

The Developer · 6 بهمن، ۱۳۹۱

نام آموزش: Lynda – PHP with MySQL Essential Training

استاد: Kevin Skoglund

سطح: مقدماتی

مدت: 11 ساعت و سه دقیقه

تاریخ انتشار: Jun 26, 2007

سر فصل ها:

Introduction
Introduction (updated)

Using the exercise files

1. PHP Overview

What is PHP?

History

Why choose PHP?

Installation overview

2. Mac Installation

Installing on Mac 10.4 (Tiger) (updated)

Installing on Mac 10.5 (Leopard) (updated)

Configuring

The text editor

phpMyAdmin

3. Windows Installation

Installing

Configuring

The text editor

4. First Steps

Viewing PHP configuration information

Embedding PHP

”Hello World!”

The operational trail

Inserting comments

5. Exploring Data Types

Variables

Strings

String functions

Numbers pt. 1: Integers

Numbers pt. 2: Floating points

Arrays

Array functions

Booleans and NULL

Type switching and casting

Constants

6. Control Structures Pt. 1: Logical Expressions

If statements

Else and elseif statements

Logical operators

Switch statements

7. Control Structures Pt. 2: Loops

While loops

For loops

Foreach loops

Continue

Break

Understanding array pointers

8. User-Defined Functions

Defining functions

Using functions

Returning values from a function

Setting global variables

Setting default values

9. Debugging

Debugging and troubleshooting

10. Building Web Pages

Links and URLs

Using GET values

Encoding GET values

Encoding for HTML

Building forms

Setting cookies

Establishing sessions

Headers and page redirection

Including and requiring pages

11. MySQL Basics

MySQL introduction

Creating a database in MySQL

Populating a MySQL database

phpMyAdmin

Connecting to MySQL with PHP

Accessing data in MySQL with PHP

12. Building a Content Management System

Blueprinting your application

Building the CMS database

Understanding relational databases

Establishing your work area

Creating your first page

Making page assets reusable

Connecting your site to a database

Building dynamic navigation

Refactoring the navigation

Adding links to your navigation

Determining which page is selected

Displaying HTML based on the selection

13. Application CRUD

Finding a subject in the database

Finding a page in the database

Creating a page for a new subject

Creating a subject entry form

Adding subjects

Escaping values for MySQL

Form validation

Additional form validation

Editing a subject

Using single-page submission

Updating a subject in the database

Sending form results as messages

Deleting a subject

CRUD review and assignment

CRUD assignment results

14. Building the Public Area

The public appearance

Navigation in the public context

Functions in the public context

Creating a default subject behavior

Text encoding and transforming

15. Regulating Page Access

User access overview

Encryption

Creating a login system

Checking authorization

Using sessions to maintain login status

Creating a logout page

Conclusion

Goodbye

دانلود:

برای مشاهده این محتوا لطفاً ثبت نام کنید یا وارد شوید.

The Developer · 8 بهمن، ۱۳۹۱

نام آموزش:

Lynda – PHP with MySQL Beyond the Basics

استاد: Kevin Skoglund

سطح: متوسط

مدت: 10 ساعت و 27 دقیقه

تاریخ انتشار: Mar 25, 2009

سرفصل ها:

Introduction
Welcome

Using the exercise files

1. Installation and Project Setup

PHP and MySQL installation

Project setup

2. Intermediate PHP Techniques

Using variable variables

Applying more array functions

Building dates and times: Epoch/Unix

Formatting dates and times: Strings and SQL

Setting server and request variables

Establishing global and static variable scope

Making a reference assignment

Using references as function arguments

Using references as function return values

3. Introduction to Object-Oriented Programming (OOP)

Introducing the concept and basics of OOP

Defining classes

Defining class methods

Instantiating a class

Referencing an instance

Defining class properties

4. OOP in Practice

Understanding class inheritance

Setting access modifiers

Using setters and getters

Working with the static modifier

Reviewing the scope resolution operator

Referencing the Parent class

Using constructors and destructors

Cloning objects

Comparing objects

5. Photo Gallery Project Setup

Overview of the project

Creating project and asset directories

Creating a MySQL database

6. Foundations of an OOP Project

Creating the MySQL Database class

Adding queries to the MySQL Database class

Using the database object

How OOP is an improvement

Creating a User class

Instantiating user objects

Revising find methods to instantiate

Autoload: The undeclared object safety net

Creating the Session class

Logging in using the Session class

Initializing files and path constants

Using path content for layout

Late static binding

7. Working with Files and Directories

File system basics

Understanding file permissions

Setting file permissions

PHP permissions

Accessing files

Writing to files

Deleting files

Moving the file pointer

Reading files

Examining file details

Working with directories

Viewing directory content

Creating a log file: Assignment

Creating a log file: Solution

8. Uploading Files

Configuring PHP for file uploads

Sending files as form data

Inspecting uploaded files

Uploading errors

Moving uploaded files

9. Completing the User Class

Remaining user CRUD

Creating users

Updating users

Deleting users

Abstracting the database table name

Abstracting the attributes

Finding the database attributes

10. The Photograph Class

Starting the Photograph class

Coding the Photograph class

Saving photographs

Uploading photographs

Listing photographs

Storing messages in the Session class

Deleting photographs

Displaying photographs in the public area

11. The Comment Class

Creating the Comment class

Building the comment form

Listing comments

Reviewing comments in the staff area

12. Pagination

Understanding the concepts behind pagination

Using LIMIT, OFFSET, and COUNT

Finding the pagination variables

Using the Pagination class

Paginating photographs

Using pagination links

13. Sending Emails

Configuring PHP for email

Sending email with mail()

Using headers

Reviewing SMTP

Using PHPMailer

Building notification for new comments

14. Templating and Code Organization

Using MVC architecture

Simple templating

Using the Smarty PHP templating engine

Building PHP libraries and frameworks

Conclusion

Goodbye

Appendix: PHP Installation and Configuration Assistance

Installing on Mac 10.4 (Tiger)

Installing on Mac 10.5 (Leopard)

Configuring a Mac

The text editor on Mac

phpMyAdmin installation on Mac

Installing on Windows

Configuring on Windows

The text editor on Windows

MySQL basics: phpMyAdmin

دانلود:

برای مشاهده این محتوا لطفاً ثبت نام کنید یا وارد شوید.

The Developer · 12 بهمن، ۱۳۹۱

نام آموزش: Lynda – Foundations of Programming: Databases

استاد: Simon Allardice

سطح: مناسب برای همه

مدت: 3 ساعت و 11 دقیقه

تاریخ انتشار: Jan 25, 2013

سرفصل ها

Introduction
Welcome

What you need to know

1. Understanding Databases

What are databases?

Exploring databases and database management systems

2. Database Fundamentals

The features of a relational database

Exploring unique values and primary keys

Defining table relationships

Describing many-to-many relationships

Transactions and the ACID test

Introduction to Structured Query Language (SQL)

3. Database Modeling: Tables

Introduction to database modeling

Planning your database

Identifying columns and selecting data types

Choosing primary keys

Using composite keys

4. Database Modeling: Relationships

Creating relationships

Defining one-to-many relationships

Exploring one-to-one relationships

Exploring many-to-many relationships

Understanding relationship rules and referential integrity

5. Database Modeling: Optimization

Understanding normalization

First normal form

Second normal form

Third normal form

Database denormalization

6. Database Modeling: Querying

Creating SQL queries

Creating the WHERE clause

Sorting query results

Using aggregate functions

Joining tables

Inserting, updating, and deleting

The data definition language

7. Database Modeling: Indexing and Optimization

Understanding indexes

Understanding write conflicts

Understanding stored procedures and injection attacks

8. Database Options

Desktop databases

Relational database management systems

Object-based and XML-based databases

NoSQL databases

Conclusion

Final thoughts

دانلود

برای مشاهده این محتوا لطفاً ثبت نام کنید یا وارد شوید.

na3k · 14 بهمن، ۱۳۹۱

سلام

ممنون بخاطر زحمتهایی که واسه سایت میکشی!

فقط اگه ممکنه و فیلم آموزش ( Lynda – Foundations of Programming: Databases ) رو داری یه جایی آپلودش کن که بهش دسترسی داشته باشیم

اخه لینکت مشکل داشت .

( ممنون میشم دوباره آپلودش کنی یا یه لینک جدید بزاری آخه خیلی لازمش دارم )

بازم مرسی

The Developer · 14 بهمن، ۱۳۹۱

سلام
ممنون بخاطر زحمتهایی که واسه سایت میکشی!

فقط اگه ممکنه و فیلم آموزش ( Lynda – Foundations of Programming: Databases ) رو داری یه جایی آپلودش کن که بهش دسترسی داشته باشیم

اخه لینکت مشکل داشت .

( ممنون میشم دوباره آپلودش کنی یا یه لینک جدید بزاری آخه خیلی لازمش دارم )

بازم مرسی

لینک های جدید در 8 بخش:

برای مشاهده این محتوا لطفاً ثبت نام کنید یا وارد شوید.

موفق باشید

mushtaq · 28 خرداد، ۱۳۹۲

Admin

Thanks for your awesome website

Here is a little problem that's that the download links doesn't work :ws52:for (Lynda – PHP with MySQL Essential Training basics) could you please update the links so we can access and download

Thank you

ورود

دانلود دانلود فیلم های آموزشی MySQL

ارسال های توصیه شده

The Developer 5,478

لینک به دیدگاه

The Developer 5,478

لینک به دیدگاه

The Developer 5,478

لینک به دیدگاه

The Developer 5,478

لینک به دیدگاه

na3k 11

لینک به دیدگاه

The Developer 5,478

لینک به دیدگاه

mushtaq 10

لینک به دیدگاه

به گفتگو بپیوندید

سایت نواندیشان

انجمن نواندیشان

فعالیت ها

جریان فعالیت های من

کسب درآمد کنید