
Learn the basics of SQL to query and modify data across databases. Explore how to retrieve information from multiple tables and build a foundation for programming or data reporting.
Learn to use db browser for SQLite to write and run SQL statements, explore a simple SQLite database offline, and view the SQL log and results.
Learn how databases organize data into tables of fields and records, and how SQL uses statements, clauses, keywords, predicates, and expressions to query and manipulate data, ending with a semicolon.
Combine multiple criteria using and, or, and parentheses to refine sql queries. Apply like patterns for partial matches and use limit and offset to control result sets.
Apply subqueries with inner and outer selects to refine data, using max quiz points and cross-table lookups like finding a state abbreviation from states before filtering people.
Explore transforming data in SQL using functions like lower, upper, substr, replace, and cast, and learn how to alias columns for clearer output.
Learn to add, modify, and remove data in a database table using insert, update, and delete, with practical examples on the people table and essential where clauses.
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations.
In this course you'll learn the core concepts of the SQL programming language. You'll learn how to use SQL to store, query, and manipulate data.
Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data.
We'll then show you the basics of creating tables and selecting data in various different ways.
You'll learn important concepts associated with relational databases. You will run SQL commands to create database tables and define data element types..
By the end of this course you should have a good understanding of the SQL programming language.