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 (65218 courses)

updated 03/01/2022

2,379 views

claim ownership

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

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

Load all results

Add this course to your bookmark

Correlated course

Software Guru99 1644 views

SAP Training for beginners FREE

This tutorial compares centralized and de-centralized information systems with the help of a scenario.

School Khan_academy 5996 views

Geometry - Khan Academy FREE

Videos on geometry. Basic understanding of Algebra I necessary. After this, you'll be ready for Trigonometry. Geometry on Khan Academy: We are surrounded by space. And that space contains lots of t

University Getsmarter

Oxford Leading Professional Service Firms Programme Paid Course

Drive your firm and your career to the next level with the skills to achieve winning performance, growth, and innovation.

University Iversity 1004 views

Employability Skills FREE

Are you an international student or graduate planning to embark on a career in Germany? That’s great! Germany is among the most attractive destinations for inter ...

Internet Notion2 6360 views

How to Make a Website FREE

NOTE: techatom.com is not up yet. I hope to have it up soon and when I do get it up I will host high quality quicktime versions of all my videos. ------------ This is part 1 of a tutorial on how to

University Getsmarter

Harvard VPAL CRISPR: Gene-editing Applications Paid Course

Investigate the potential of CRISPR and learn to make informed and responsible decisions when investing in the technology.

Videogames Gamingbits 5869 views

How to Use Remote Play With Your Playstation 3 and PSP FREE

This video shows how to connect your PSP (firmware 3.80) to your PS3 (firmware 2.10), using a Private Network. Much easier than before!

School Khan_academy 7818 views

Calculus - Khan Academy FREE

Topics covered in the first two or three semesters of college calculus. Everything from limits to derivatives to integrals to vector calculus. About Khan Academy: Khan Academy offers practice exerc

University Getsmarter

CAM Communicating for Influence and Impact Paid Course

Learn persuasive communication skills to influence meaningful change at all levels of your organisation.

University Getsmarter

MIT Sloan Pricing: Using Data to Improve Pricing Performance Paid Course

Learn to assess sales data and price elasticity to improve your company's pricing strategy.

Web Stats

Community: 17,019 users
Active courses: 74,474
Lessons: 2,066,701
Data: 74 GB
Online: 73 users

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

Lessons

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 ...

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 ...