English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3h 21m | 615 MB
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.
Table of Contents
1 An introduction to database foundations
2 What you should know
3 Using the exercise files
4 What is a database
5 Storing data efficiently
6 Relational database management systems
7 The client-server model
8 Purpose of the playground
9 Install Docker
10 Database server containers
11 RDBMS command-line interfaces
12 Challenge Create a server container
13 Solution Create a server container
14 Management interfaces
15 Install Azure Data Studio
16 Connect to a database server
17 Explore the server’s contents
18 Create a database
19 Challenge Create a database
20 Solution Create a database
21 Structured Query Language
22 Organize a database with schemas
23 Table columns
24 Create tables
25 Alter tables
26 Reserved keywords
27 Challenge Create a table
28 Solution Create a table
29 Table rows
30 Add records
31 Update and delete records
32 Saving and using SQL scripts
33 Challenge Add data to a table
34 Solution Add data to a table
35 Querying data
36 Return data with SELECT and FROM
37 Filter rows with WHERE
38 Sort values with ORDER BY
39 Combine data with JOIN
40 Limiting the number of rows returned
41 Display column aliases with AS
42 Mathematical operations
43 Use built-in functions
44 Aggregate data with GROUP BY
45 Filtering groups with HAVING
46 Challenge Query data
47 Solution Query data
48 Next steps
Resolve the captcha to access the links!