The Introduction to SQL training course is designed to explore key concepts, techniques, and commands necessary for developers and system administrators to write effective queries against common Structured Query Language (SQL) databases, like MySQL.
The course begins with an introduction to SQL, database concepts, and MySQL. The course then dives into working with data and tables and then focuses on queries. The course concludes with an overview of SQL functions and how to write a Simple Java Database Connectivity (JDBC) application.
This course is not intended to be a DBA-level course; rather, it focuses on building a practical, hands-on knowledge for engineers writing queries to support application development.
Purpose
|
Learn the core concepts of SQL. |
Audience
|
Developers and system administrators with a desire to query SQL databases. |
Role
| Business Analyst - Data Engineer - Data Scientist - Project Manager - Software Developer - System Administrator - Technical Manager - Web Developer |
Skill Level
| Introduction |
Style
| Targeted Topic - Workshops |
Duration
| 3 Days |
Related Technologies
| SQL |
Productivity Objectives
- Describe the history of SQL, and current support in your database.
- List the databases and tables in your database.
- Create new databases, tables, and add data to tables.
- Query a table using variable select data.
- Order query results.
- Update and insert data into a table.
- Create inner and outer joins.