พื้นฐานการใช้งาน SQL เพื่อจัดการข้อมูล

SQL is, fundamentally a programming language designed for accessing, modifying and extracting information from relational databases. ‘An Introductory Guide to SQL’, this course is suited to anyone familiar with computing who is interested in learning how to read and manipulate data stored in a relational database and learn how to communicate with relational databases through SQL. By the end of this course, you should be able to recognize and explain the Structured Query Language (SQL)

and be able to read and write SQL commands.

Executing a Simple Query

• Connect to the SQL Database
• Query a Database
• Save a Query
• Modify and Execute a Saved Query

Performing a Conditional Search

• Search Using One or More Conditions
• Search for a Range of Values and NULL Values
• Search Data Based on Patterns

Working with Functions

• Perform Date Calculations
• Calculate Data Using Aggregate Functions
• Manipulate String Values

Organizing Data

• Sort Data
• Rank Data
• Group Data
• Filter Grouped Data
• Summarize Grouped Data
• Use PIVOT and UNPIVOT Operators

Retrieving Data from Multiple Tables

• Retrieve Data by Joining Tables
• Combine the Results of Two Queries
• Compare the Results of Two Queries
• Retrieve Data by Joining Tables

Web Developer & Database Administrator

JavaScript Skill