MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Up and Running with MySQL Development

Course Summary

Get a simple introduction to MySQL, the world's most popular open-source database.       


  • +

    Course Syllabus

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


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

3 - 4 hours / week

This course is listed under Open Source and Data & Information Management Community

Related Posts:

MySQL

 

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top