-
Onboard
For Tech Teams
- Reduce initial time to productivity.
- Increase employee tenure.
- Plug-and-play into HR onboarding and career pathing programs.
- Customize for ad-hoc and cohort-based hiring approaches.
-
Upskill
For Tech Teams
- Upgrade and round out developer skills.
- Tailor to tech stack and specific project.
- Help teams, business units, centers of excellence and corporate tech universities.
-
Reskill
For Tech Teams
- Offer bootcamps to give employees a running start.
- Create immersive and cadenced learning journeys with guaranteed results.
- Supplement limited in-house L&D resources with all-inclusive programs to meet specific business goals.
-
Design
For Tech Teams
- Uplevel your existing tech learning framework.
- Extend HR efforts to provide growth opportunities within the organization.
- Prepare your team for an upcoming tech transformation.
Get your team started on a custom learning journey today!
Our Boulder, CO-based learning experts are ready to help!
Course Summary
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.
- 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.
Request Information
Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.

If you are not completely satisfied with your training class, we'll give you your money back.




about our training
-
Real-World Content
Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
-
Expert Practitioners
Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
-
Experiential Learning
More coding than lecture, coupled with architectural and design discussions.
-
Fully Customized
One-size-fits-all doesn't apply to training teams. That's where we come in!
What You'll Learn
In the Introduction to SQL training course, you'll learn:
- Introduction to SQL
- What is SQL?
- How does SQL differ based on database vendor?
- Current SQL American National Standards Institute (ANSI) Standards
- Functionality supported by SQL
- Database Concepts
- Core database terminologies
- Database design process
- Overview of Database Normalization
- Introduction to MySQL
- Downloading & Installing MySQL
- Configuring MySQL
- Basic MySQL administration
- Connecting to MySQL
- Working with Tables
- Quick introduction to SELECT
- Creating tables and columns
- Identifying current tables and databases
- Working with tables using CREATE, ALTER, DROP TABLE
- Loading a database tables from a data file
- Creating data integrity through relationships (primary keys, foreign key constraints, etc.)
- Understanding indexes
- Working with Data
- Adding data using INSERT
- Modifying data using UPDATE
- Deleting data with DELETE
- Understanding transactions and impacts of transactions on data manipulation
- Simple Data Querying
- Review of SELECT concepts
- SELECTing rows of data
- SELECTing columns of data
- Filtering SELECT using WHERE
- Ordering results using ORDER BY
- Grouping results using GROUP BY
- Complex Data Querying
- Understanding a join
- Querying related rows using INNER JOIN
- Including non-matched rows with OUTER JOIN
- Unions
- Handling JOIN results
- SQL Functions
- Math functions: count, avg, sum, round, etc.
- Character functions: ucase, lcase, etc.
- Time functions: now, date, etc.
- Other functions
- Writing a Simple JDBC Application
- What is JDBC?
- Configuring Java to support JDBC
- Writing a simple database query application
Real-world content
Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
Expert Practitioners
Industry experts that bring their battle scars into the classroom.
Experiential Learning
More coding than lecture, coupled with architectural and design discussions.
Fully Customized
One-size-fits-all doesn't apply to training teams. That's where we come in!

Elite Instructor Program
We recently launched our internal Elite Instructor Program. The community driven instructor program is designed to support instructors in transforming students’ lives by consistently showing a world-class level of engagement, ability, and teaching prowess. Reach out today to learn more about our instructors.
Customized Technical Learning Solutions to Help Attract and Retain Talented Developers
Let DI help you design solutions to onboard, upskill or reskill your software development organization. Fully customized. 100% guaranteed.
DevelopIntelligence leads technical and software development learning programs for Fortune 500 companies. We provide learning solutions for hundreds of thousands of engineers for over 250 global brands.



“I appreciated the instructor’s technique of writing live code examples rather than using fixed slide decks to present the material.”
VMwareAbout Us
LET’S DISCUSS
DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.
Resources
Thank you for everyone who joined us this past year to hear about our proven methods of attracting and retaining tech talent.

- Boulder, Colorado Headquarters: 980 W. Dillon Road, Louisville, CO 80027
© 2013 - 2022 DevelopIntelligence LLC - Privacy Policy