Database Foundations: Intro to Databases
Offered By: LinkedIn Learning
Course Description
Overview
Learn the basics of building databases in a platform agnostic way so you can continue on to other platforms later. Explore database setup, servers, GUIs, tables, objects, and more.
Syllabus
Introduction
- An introduction to database foundations
- What you should know
- Using the exercise files
- What is a database?
- Storing data efficiently
- Relational database management systems
- The client-server model
- Purpose of the playground
- Install Docker
- Database server containers
- RDBMS command-line interfaces
- Challenge: Create a server container
- Solution: Create a server container
- Management interfaces
- Install Azure Data Studio
- Connect to a database server
- Explore the server’s contents
- Create a database
- Challenge: Create a database
- Solution: Create a database
- Structured Query Language
- Organize a database with schemas
- Table columns
- Create tables
- Alter tables
- Reserved keywords
- Challenge: Create a table
- Solution: Create a table
- Table rows
- Add records
- Update and delete records
- Saving and using SQL scripts
- Challenge: Add data to a table
- Solution: Add data to a table
- Querying data
- Return data with SELECT and FROM
- Filter rows with WHERE
- Sort values with ORDER BY
- Combine data with JOIN
- Limiting the number of rows returned
- Display column aliases with AS
- Mathematical operations
- Use built-in functions
- Aggregate data with GROUP BY
- Filtering groups with HAVING
- Challenge: Query data
- Solution: Query data
- Next steps
Taught by
Adam Wilbert
Related Courses
Datenmanagement mit SQLopenHPI Programming Cloud Services for Android Handheld Systems
Vanderbilt University via Coursera Getting and Cleaning Data
Johns Hopkins University via Coursera Ruby مدخل إلى برمجة مواقع الإنترنت باستخدام لغة
Rwaq (رواق) MongoDB for .NET Developers
MongoDB University