در این آموزش تصویری با توسعه MySQL آشنا می شوید. در این دوره کار با انواع داده ها در MySQL ، ایجاد پایگاه داده و جدول ، خواندن و اضافه کردن داده ها ، مرتب سازی داده ها و کار با دستورات CREATE TABLE ، SELECT ، TRUNCATE ، GROUP BY را می آموزید.

این دوره آموزشی محصول موسسه Lynda است.

سرفصل های دوره:

  • کار با MySQL
  • مبانی پایگاه داده
  • کار با پایگاه های داده در مقابل صفحات گسترده
  • کار با پایگاه داده های رابطه ای
  • مبانی MySQL
  • ساخت پایگاه داده و جدول،
  • نحوه حذف و اضافه سطر و ستون
  • بررسی انواع داده در MySQL
  • کار با مقدار NULL
  • نحوه ایجاد و تغییر جداول
  • نحوه ایجاد یک پایگاه داده
  • ایجاد جدول با CREATE TABLE
  • خواندن از یک جدول با دستور SELECT
  • اضافه کردن داده ها به جدول با دستور INSERT
  • اصلاح داده ها در یک جدول
  • کار با دستور TRUNCATE
  • کار با کوئری ها
  • کار با توابع
  • کار با توابع رشته ای
  • نحوه مرتب کردن داده ها با دستور GROUP BY
  • نحوه اضافه کردن اطلاعات
  • نحوه استفاده از INNER JOIN
  • نحوه استفاده از OUTER JOIN
  • نحوه گزارش گیری از برنامه
  • نحوه تست و اشکال زدایی برنامه
  • و…

عنوان دوره: Lynda Up and Running with MySQL Development
سطح: مقدماتی
مدت زمان: 2 ساعت و 57 دقیقه
نویسنده: Sheeri Cabral


Lynda Up and Running with MySQL Development

Sheeri Cabral
2h 57m

Get a simple introduction to MySQL'without the overhead. Sheeri K. Cabral introduces the vocabulary and tools for MySQL, the world's most popular open-source database that powers everything from your neighbor's blog to Internet giants like Facebook. The goal of this course is to get you interacting with data and understanding just why databases are better. Most of the work is done at the command line, as Sheeri teaches you how to create a new database, build tables, read and edit database records, and use functions to query data. She also issues a series of challenges along the way that allow you to test your skills and compare your results with hers.
Topics include:
Exploring MySQL data types
Creating a database
Creating tables
Reading and adding data
Using date and number functions
Sorting results
Inserting and replacing records
Joining tables

5m 18s
What you should know before watching this course
Easy ways to play with MySQL
3m 5s
Using the exercise files
1. Database Basics
21m 4s
Databases vs. spreadsheets
4m 55s
Relational databases vs. flat files
3m 4s
Normalizing databases
7m 5s
Common database acronyms
6m 0s
2. MySQL Basics
36m 28s
Understanding MySQL terminology: Database, table, row, column, and field
3m 7s
Finding information about your database with SHOW
5m 48s
Exploring MySQL data types
9m 7s
NULL values
5m 44s
Understanding declarative language
3m 3s
Challenge: Explore the built-in databases
Solution: Explore the built-in databases
8m 40s
3. Creating and Changing Tables
47m 16s
Creating a database
5m 20s
Exploring table creation with SHOW CREATE TABLE
6m 16s
Creating and altering a table with CREATE and ALTER
3m 52s
Reading from a table with SELECT
2m 49s
Adding data to a table with INSERT
4m 27s
Additional INSERT methods
5m 49s
Modifying data in a table with UPDATE
2m 17s
Additional UPDATE methods
4m 44s
Removing rows from a table with DELETE and TRUNCATE
4m 4s
Challenge: Build the address book database
1m 32s
Solution: Build the address book database
6m 6s
4. More Advanced Querying
31m 52s
Basic functions
4m 30s
Date and number functions
5m 4s
String functions
5m 33s
Comparing strings and numbers with operators
5m 49s
Arranging items with GROUP BY clauses
2m 55s
Sorting results
3m 53s
Challenge: Using date and string functions
Solution: Using date and string functions
3m 30s
5. Inserting and Replacing Records
17m 37s
Updating values if they already exist with INSERT...ON DUPLICATE KEY UPDATE
5m 34s
Replacing information with the REPLACE statement
3m 53s
Ignoring values if they already exist with INSERT IGNORE
2m 39s
Challenge: Adding new information, even if it already exists
Solution: Adding new information, even if it already exists
4m 55s
6. Joining Tables
17m 23s
Joining tables with matching fields using INNER JOIN
5m 5s
Joining tables regardless of matching data using OUTER JOIN
3m 37s
Challenge: Creating reports with JOIN
1m 10s
Solution: Creating reports with JOIN
7m 31s
Next steps