learning path

Working With SQL — Beyond the Basics
Intermediate
5h 13m
984
4.6/5
Build hands-on tech skillsImprove theoretical and practical skills needed in real-world scenarios.
Stay focused, stay committedSupercharge your learning journey by enrolling, empowering you to stay focused, motivated, and achieve your goals with ease.
Earn a certificate of completionShow your skills and build your credibility when you include them in your resume and LinkedIn profile.

If you want to learn how to use the structured query language (SQL) to create, query, and manipulate data in relational databases then this learning path is for you. This collection of courses and labs will extend your practical knowledge of the topic. We go further into SQL functions before working through a practical scenario where we solve a business issue with SQL.

In Working with SQL we learn how to use SQL to alter and delete tables and how to use primary and foreign keys. We examine common joins between tables in a relational database. We then delve into inner, outer, left, and right joins before learning to manipulate data using the INSERT, UPDATE, and DELETE functions.

In the SQL Masterclass we go beyond the basics to empower you with the skills, how-to knowledge, and hands-on expertise to work through and solve complex business issues with SQL. We go deep and hands-on with transactions, subqueries, inline views, summarized queries, the EXISTS predicate, and set operations.

We then practice solving a real-world data scenario in Using SQL to Import and Validate Data from CSV Files.

Outline

  • Working with SQL
  • Work with Joins in SQL
  • SQL Master Class
  • Using SQL to Import and Validate Data from CSV Files
  • Knowledge Check: Working with SQL

Intended Audience

This learning path provides an ideal start for anyone wanting to progress with database management and data science.

Prerequisites

To get the most out of this learning path, you should have a basic understanding of compute concepts. 

Feedback

Please contact us at support@cloudacademy.com if you need help or guidance with this content. We welcome all questions, comments, and feedback.



Your certificate for this learning path
QA
This content is developed in partnership with QA
Learn more
About the Author
Avatar
Andrew Larkin
Head of Content
Students
190,252
Courses
81
Learning Paths
194

Andrew is fanatical about helping business teams gain the maximum ROI possible from adopting, using, and optimizing Public Cloud Services. Having built  70+ Cloud Academy courses, Andrew has helped over 50,000 students master cloud computing by sharing the skills and experiences he gained during 20+  years leading digital teams in code and consulting. Before joining Cloud Academy, Andrew worked for AWS and for AWS technology partners Ooyala and Adobe.

Covered Topics