English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 18 Hours | 18.0 GB
Master Database Theory & Application Using PostgreSQL – Preparation for Employment as a SQL Developer
Understanding relational databases is an essential skill for all developers.
Learning databases and database theory can be easy if you have the right teacher.
This university level course will give you a solid understanding of how databases work and how to use them. In the course, we will be using PostgreSQL which is one of the top two databases most demanded in industry.
This course will advance your skills as a developer.
This course is very practical and applicable. It focuses on teaching you skills you can use.
Presented with high-quality video lectures, this course will visually show you many great things about relational databases and PostgreSQL. This course is taught by two teachers. One of your teachers is a tenured professor in California. Your other teacher is a Professional Developer. Both of these teachers will be on screen, sharing their wisdom and knowledge with you.
This is just some of what you will learn in this course:
- Learn to succeed as a student
- Master database fundamentals
- Build a database for tracking movie rentals
- Understand schema, data hierarchy, and normalization
- Learn validation, data integrity, and ACID transactions
- Master using key fields and ensuring referential integrity
- Learn how to do SQL commands at the terminal and in code editors
- Solidify concepts with abundant hands on exercises which also have video solutions provided
- Acquire the ability to read PostgreSQL database documentation
- Learn how to install PostgreSQL on Windows, Linux, and Mac
- Master building databases, tables, and relationships between tables
- Master creating, reading, updating, inserting, and deleting records
- Gain the ability to do subqueries and aggregate functions
- Master using grouping, having, limit, fetch, and offset
- Learn how to use JSON inside SQL using PostgreSQL
- Master joins to query multiple sets
- Master filtering records in queries
- MASTER SQL & PostgreSQL!
This is an amazing course! This course will change your life. Being skilled at using relational databases and SQL will serve you and your career well. This course will increase your proficiency, productivity, and power as a programmer. You are going to love this course and it will forever change your life.
What you’ll learn
- The ultimate comprehensive course
- From beginning to advanced concepts
- Acquire the skills necessary to work with SQL and to work as a SQL developer
- Learn the fundamentals of databases, database architecture, and relationships
- Master the nuances of SQL commands including multiple table joins
- Gain the ability to use SQL at the terminal and in code editors
- Taught by a university professor
- Exclusive access to valuable code base
- Hands-on exercises with solutions
- Over 2.65 Million students taught
- Lifetime course access
- Learn at your own pace
- 100% satisfaction guaranteed
- Never expires – lifetime access – forever!
- This course is tried, tested, and proven
- Mobile friendly
Table of Contents
Getting started
1 Welcome
2 Credentials
3 Course resources
4 Course pathway
Learning tools
5 Success
6 Customization
7 Questions
8 Principles
9 Collaboration
10 Exercises
11 Anecdotes
Relational databases
12 Introduction
13 A puzzle
14 Implications
15 Discussing schema
Building a database
16 Customers table
17 Movies table
18 Rentals table
Ninja level 1
19 Hands-on exercise #1
20 Hands-on exercise #2
21 Hands-on exercise #3
22 Hands-on exercise #4
Principles
23 Schema
24 Data hierarchy
25 Normalization
26 Validation
27 Data integrity
28 Key field
29 Referential integrity
30 ACID transactions
31 Queries
Ninja level 2
32 Hands-on exercise #1
33 Hands-on exercise #2
34 Hands-on exercise #3
Coding fundamentals
35 Introduction
36 The terminal
37 Bash on windows
Bash fundamentals
38 Working with directories
39 Viewing directory details
40 Working with files
41 Removing items
42 Working with permissions
Environment variables
43 Introduction
44 Setting environment variables – mac, linux
45 Setting environment variables – windows
Ninja level 3
46 Hands-on exercise #1
47 Hands-on exercise #2
48 Hands-on exercise #3
49 Hands-on exercise #4
50 Hands-on exercise #5
Postgres
51 Documentation
52 Installing mac
53 Installing windows
54 Installing linux
55 Installing digital ocean
56 AWS discussion
Database and tables
57 All commands
58 Creating a database
59 Working with a database
60 Creating a table
61 Exploring data types
62 Drop a table
Ninja level 4
63 Hands-on exercise #1
64 Hands-on exercise #2
65 Hands-on exercise #3
Working with records
66 Review
67 Inserting records
68 Examples of inserting records
69 Constraints
70 Common constraints
Working with records II
71 Primary key, not null
72 Unique, references
73 Check
74 Dropping constraints
Working with records III
75 Transaction tables
76 Simple queries
Ninja level 5
77 Hands-on exercise #1
78 Hands-on exercise #2
79 Hands-on exercise #3
80 Hands-on exercise #4
81 Hands-on exercise #5
Postgres & editors
82 Introduction
83 VS Code – selecting the plugin
84 VS Code – using the plugin
85 Tracking code with github
86 Sublime – selecting the plugin
87 Sublime – using the plugin
88 Collaborating with github
Creating a database
89 Schema
90 Database and tables
91 Alter a table
92 Generating records
93 Inserting records
SELECT fundamentals
94 Specific fields
95 Distinct
96 Order by
97 Order by multiple
98 Naming results
99 Literal
100 Expressions
101 Concatenation
Ninja level 6
102 Hands-on exercise #1
103 Hands-on exercise #2
104 Hands-on exercise #3
105 Hands-on exercise #4
106 Hands-on exercise #5
107 Hands-on exercise #6
Amounts, dates, & time
108 Intro
109 Casting
110 Math
111 Time documentation
112 Time examples
Ninja level 7
113 Hands-on exercise #1
114 Hands-on exercise #2
115 Hands-on exercise #3
116 Hands-on exercise #4
JSON
117 JSON documentation
118 Accessing fields
119 JSON null and SQL null
120 Containment
121 Existence
Ninja level 8
122 Setup
123 Hands-on exercise #1
124 Hands-on exercise #2
125 Hands-on exercise #3
Filtering with where
126 Where
127 And or
128 More comparisons
129 Between
130 In
131 Like
132 Null
133 Not
Ninja level 9
134 Hands-on exercise #1
135 Hands-on exercise #2
136 Hands-on exercise #3
137 Hands-on exercise #4
138 Hands-on exercise #5
139 Hands-on exercise #6
140 Hands-on exercise #7
141 Hands-on exercise #8
Querying multiple sets
142 Introduction
143 Join
144 Left join
145 Right join
146 Full join
147 Except
148 Union
149 Cross
150 Join three tables
151 Natural
Ninja level 10
152 Hands-on exercise #1
153 Hands-on exercise #2
154 Hands-on exercise #3
155 Hands-on exercise #4
Ninja level 11
156 Hands-on exercise #1
157 Hands-on exercise #2
158 Hands-on exercise #3
159 Hands-on exercise #4
160 Hands-on exercise #5
Ninja level 12
161 Hands-on exercise #1
162 Hands-on exercise #2
163 Hands-on exercise #3
164 Hands-on exercise #4
Subqueries
165 Scalar field
166 Table list filtering
167 Daniel not liking it Q&A
Ninja level 13
168 Hands-on exercise #1
169 Hands-on exercise #2
170 Hands-on exercise #3
171 Hands-on exercise #4
172 Hands-on exercise #5
173 Hands-on exercise #6
174 Hands-on exercise #7
Aggregate functions
175 Introduction
176 Distinct count
177 Subquery value
178 Subquery filter
Ninja level 14
179 Hands-on exercise #1
180 Hands-on exercise #2
181 Hands-on exercise #3
Grouping & having
182 Introduction
183 Two+ values
184 Filtering results
Ninja level 15
185 Hands-on exercise #1
186 Hands-on exercise #2
187 Hands-on exercise #3
188 Hands-on exercise #4
189 Hands-on exercise #4 Bonus solution
Limit, fetch, offset
190 Limit
191 Fetch
192 Offset
193 Summary of select
Update
194 Documentation
195 Returning
196 Many fields
197 Many tables #1
198 Many tables #2
199 Many tables #3
200 Transactions
Delete
201 Documentation
202 Using
Ninja level 16
203 Hands-on exercise #1
204 Hands-on exercise #2
205 Hands-on exercise #3
206 Hands-on exercise #4
207 Hands-on exercise #5
Ninja level 17
208 Hands-on exercise #1
209 Hands-on exercise #2
210 Hands-on exercise #3
Farewell
211 Congratulations!
Resolve the captcha to access the links!