PROFESSIONAL COURSES complete sql databases bootcamp zero to mastery 5/5 (1)

Complete SQL and Databases Bootcamp: Zero to Mastery [2022] 89.99 €

URL

HTML code

author Udemy (65217 courses)

updated 03/01/2022

2,666 views

claim ownership

Master SQL, Database Management & Design and learn to work with databases like PostgreSQL, MySQL + more. With Exercises!

Lessons
1) Course Outline 42 views link to external resource
2) Join Our Online Classroom! 34 views link to external resource
3) Exercise: Meet Your Classmates and Instructor 35 views link to external resource
4) The Big Data Breach At Keiko Corp 66 views link to external resource
5) Monthly Coding Challenges, Free Resources and Guides 35 views link to external resource
6) What Is a Database? 44 views link to external resource
7) I Didn't Learn Anything, Try Again... 39 views link to external resource
8) Database Management System (DBMS) 28 views link to external resource
9) Exercise: Building Amazon 32 views link to external resource
10) Exercise: Building Amazon 2 29 views link to external resource
11) 5 Types Of Databases 30 views link to external resource
12) Exercise: What Is A Database? 19 views link to external resource
13) Section Review 30 views link to external resource
14) SQL Playground 20 views link to external resource
15) What Is SQL? 18 views link to external resource
16) What Is A Query? 21 views link to external resource
17) Exercise: Setting Up Your First Database 20 views link to external resource
18) Imperative vs Declarative 33 views link to external resource
19) History of SQL 25 views link to external resource
20) Optional: History of SQL Deep Dive 24 views link to external resource
21) Exercises: The Select Statement 23 views link to external resource
22) SQL Standards 35 views link to external resource
23) What Is A Database? Revisited 22 views link to external resource
24) Database Oriented Approach 28 views link to external resource
25) Exercise: SQL Starter Quiz 30 views link to external resource
26) Database Models 41 views link to external resource
27) Hierarchical And Networking Model 28 views link to external resource
28) Relational Model 30 views link to external resource
29) DBMS Revisited It's funny how the 12 Rules of Codd are actually 13 because it starts counting at 0, this is a classic computer science thing to do! Reason being is one of the types of data we use to store lists ... 21 views link to external resource
30) Relational Model Revisited 32 views link to external resource
31) Tables 25 views link to external resource
32) Columns 27 views link to external resource
33) Rows 42 views link to external resource
34) Primary And Foreign Keys 40 views link to external resource
35) OLTP vs OLAP 19 views link to external resource
36) Exercise: OLTP vs OLAP 18 views link to external resource
37) Exercise: Relational Model Quiz 28 views link to external resource
38) Endorsements On LinkedIN 24 views link to external resource
39) Why PostgreSQL 42 views link to external resource
40) Environment Tooling 27 views link to external resource
41) Having Trouble Registering A Serial Key For ValentinaDB? 17 views link to external resource
42) SQL Tooling Alternatives 26 views link to external resource
43) Command Line 101 17 views link to external resource
44) Getting Help With The Setup 25 views link to external resource
45) WINDOWS Setup 38 views link to external resource
46) Optional: Setting Up Windows For Command Line 22 views link to external resource
47) MAC Setup 48 views link to external resource
48) MAC Commandline tools 52 views link to external resource
49) LINUX Setup 19 views link to external resource
50) Importing The Databases 31 views link to external resource
51) Exercise: Imposter Syndrome 20 views link to external resource
52) Query Along 19 views link to external resource
53) Starting With Query 23 views link to external resource
54) Exercise: Simple Queries 20 views link to external resource
55) Changing Column Names in a SELECT Query 41 views link to external resource
56) Concat Function In this video we'll learn all about the CONCAT function and how we can make our data look prettier when querying. Often you can have 20 or 30 columns in a table and even when you select only the ... 23 views link to external resource
57) What Is A Function In SQL? 17 views link to external resource
58) Aggregate Functions 27 views link to external resource
59) Exercise: Aggregate Functions 19 views link to external resource
60) Commenting Your Queries 24 views link to external resource
61) Common SELECT Mistakes 33 views link to external resource
62) Filtering Data 14 views link to external resource
63) AND and OR 28 views link to external resource
64) Exercise: Filtering Data 22 views link to external resource
65) The NOT Keyword 19 views link to external resource
66) Exercise: The Where Clause 20 views link to external resource
67) Comparison Operators 16 views link to external resource
68) Exercise: Comparison Operators 18 views link to external resource
69) Logical Operators 19 views link to external resource
70) Operator Precedence 14 views link to external resource
71) Operator Precedence 2 24 views link to external resource
72) Operator Precedence Extra 14 views link to external resource
73) Exercise: Operator Precedence 17 views link to external resource
74) Checking For NULL Values 19 views link to external resource
75) IS Keyword 26 views link to external resource
76) NULL Coalescing 20 views link to external resource
77) Exercise: Null Value Coalescing 15 views link to external resource
78) 3 Valued Logic 27 views link to external resource
79) Exercise: 3 Valued Logic 33 views link to external resource
80) BETWEEN + AND 17 views link to external resource
81) Exercise: BETWEEN + AND 24 views link to external resource
82) IN Keyword 22 views link to external resource
83) Exercise: IN Keyword 26 views link to external resource
84) LIKE 37 views link to external resource
85) Exercise: Like Keyword 25 views link to external resource
86) Dates And Timezones 20 views link to external resource
87) Setting Up Timezones 14 views link to external resource
88) How Do We Format Date And Time? 15 views link to external resource
89) Timestamps 44 views link to external resource
90) Date Functions 28 views link to external resource
91) Date Difference And Casting 18 views link to external resource
92) Age Calculation 27 views link to external resource
93) Extracting Information 21 views link to external resource
94) Intervals 19 views link to external resource
95) Exercise: Date and Timestamp 20 views link to external resource
96) DISTINCT 17 views link to external resource
97) Exercise: Distinct Keyword 25 views link to external resource
98) Sorting Data 81 views link to external resource
99) Exercise Sorting Data 17 views link to external resource
100) Multi Table SELECT 20 views link to external resource