Introduction to SQL
SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professions to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases. Join this course if you are seeking to learn data skills to advance in your current field or pivot to a different field where you will interact with data.
In this SQL tutorial you will learn how to interact with the SQL server with the proper syntax, begin to use SQL commands and SQL databases, perform SQL queries, work with data types and database tables, and use
Upcoming start dates
- Self-paced Online
Who should attend?
This course is meant to teach the fundamentals of SQL to beginning learners with little to no prior experience.
- Introduction and History of SQL
- Installing PostgreSQL
- Basic SQL
- Comments & SQL Styles
- SQL Joins
- Aggregations & Subqueries
- Data Inspeciton and Converting Data
- String Manipulation
- Analytic Functions
- Variables and Temporary Sets
- Recursive Operations Using CTEs
- Pivoting Data
- Sample Database Installation
- 3 Final Exercises
- Putting It All Together!
Course delivery details
This course is offered through Davidson College, a partner institute of EdX.
3-5 hours per week
- Verified Track -$199
- Audit Track - Free
Certification / Credits
What you'll learn
- How to use a relational database
- How to query data and shape results
- How to write advanced queries and analytic functions
- How to create and modify data in tables
Contact this provider
edX For Business helps leading companies upskill their labor forces by making the world’s greatest educational resources available to learners across a wide variety of in-demand fields. edX For Business delivers high-quality corporate eLearning to train and engage your employees...