Database Foundations: Intro to Databases

Focused View

Adam Wilbert

3:24:08

82 View

01 - Introduction

01 - An introduction to database foundations.mp4

00:57

02 - What you should know.mp4

00:35

03 - Using the exercise files.mp4

00:46

02 - 1. Database Core Concepts

01 - What is a database.mp4

03:40

02 - Storing data efficiently.mp4

03:07

03 - Relational database management systems.mp4

04:34

04 - The client-server model.mp4

04:53

03 - 2. Set Up a Database Playground

01 - Purpose of the playground.mp4

03:48

02 - Install Docker.mp4

05:25

03 - Database server containers.mp4

07:40

04 - Local installation alternatives to Docker.mp4

03:29

05 - RDBMS command-line interfaces.mp4

08:09

06 - Challenge Create a server container.mp4

01:22

07 - Solution Create a server container.mp4

07:29

04 - 3. Graphical Interfaces

01 - Management interfaces.mp4

03:55

02 - Install Azure Data Studio.mp4

04:56

03 - Connect to a database server.mp4

07:29

04 - Explore the servers contents.mp4

02:53

05 - Create a database.mp4

06:04

06 - Challenge Create a database.mp4

00:49

07 - Solution Create a database.mp4

04:10

05 - 4. Create Table Objects

01 - Structured Query Language.mp4

04:09

02 - Organize a database with schemas.mp4

06:04

03 - Table columns.mp4

03:41

04 - Create tables.mp4

08:43

05 - Alter tables.mp4

04:16

06 - Reserved keywords.mp4

03:01

07 - Challenge Create a table.mp4

00:43

08 - Solution Create a table.mp4

04:35

06 - 5. Add Data to a Table

01 - Table rows.mp4

03:07

02 - Add records.mp4

05:49

03 - Update and delete records.mp4

03:26

04 - Saving and using SQL scripts.mp4

06:22

05 - Challenge Add data to a table.mp4

01:07

06 - Solution Add data to a table.mp4

05:55

07 - 6. Retrieve Information

01 - Querying data.mp4

02:45

02 - Return data with SELECT and FROM.mp4

06:36

03 - Filter rows with WHERE.mp4

04:04

04 - Sort values with ORDER BY.mp4

02:43

05 - Combine data with JOIN.mp4

04:46

06 - Limiting the number of rows returned.mp4

03:35

08 - 7. Manipulate Data

01 - Display column aliases with AS.mp4

04:59

02 - Mathematical operations.mp4

03:20

03 - Use built-in functions.mp4

05:51

04 - Aggregate data with GROUP BY.mp4

03:34

05 - Filtering groups with HAVING.mp4

03:13

06 - Challenge Query data.mp4

01:03

07 - Solution Query data.mp4

09:39

09 - Conclusion

01 - Next steps.mp4

00:52

Description

What is a database? How can you build one? Do you want to learn more? In this course, database expert Adam Wilbert shows you how to set up container-based servers, connect a management GUI, and start building a database for your valuable data. You don’t need to come with any specific prior knowledge or have any specific software pre-installed. This course’s content is applicable to learners on any operating system. Learn about how to set up a database playground, how to include a user-friendly graphical interface, how to create table objects, how to add data to a table, and how to retrieve and manipulate data. The course includes exercise files so that learners can practice executing the same commands shown on screen. At the conclusion of the course, Adam shares some ideas for continuing your learning journey.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.