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

1) Course Outline

2) Join Our Online Classroom!

3) Exercise: Meet Your Classmates and Instructor

4) The Big Data Breach At Keiko Corp

5) Monthly Coding Challenges, Free Resources and Guides

6) What Is a Database?

7) I Didn't Learn Anything, Try Again...

8) Database Management System (DBMS)

9) Exercise: Building Amazon

10) Exercise: Building Amazon 2

11) 5 Types Of Databases

12) Exercise: What Is A Database?

13) Section Review

14) SQL Playground

15) What Is SQL?

16) What Is A Query?

17) Exercise: Setting Up Your First Database

18) Imperative vs Declarative

19) History of SQL

20) Optional: History of SQL Deep Dive

21) Exercises: The Select Statement

22) SQL Standards

23) What Is A Database? Revisited

24) Database Oriented Approach

25) Exercise: SQL Starter Quiz

26) Database Models

27) Hierarchical And Networking Model

28) Relational Model

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

30) Relational Model Revisited

31) Tables

32) Columns

33) Rows

34) Primary And Foreign Keys

35) OLTP vs OLAP

36) Exercise: OLTP vs OLAP

37) Exercise: Relational Model Quiz

38) Endorsements On LinkedIN

39) Why PostgreSQL

40) Environment Tooling

41) Having Trouble Registering A Serial Key For ValentinaDB?

42) SQL Tooling Alternatives

43) Command Line 101

44) Getting Help With The Setup

45) WINDOWS Setup

46) Optional: Setting Up Windows For Command Line

47) MAC Setup

48) MAC Commandline tools

49) LINUX Setup

50) Importing The Databases

51) Exercise: Imposter Syndrome

52) Query Along

53) Starting With Query

54) Exercise: Simple Queries

55) Changing Column Names in a SELECT Query

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

57) What Is A Function In SQL?

58) Aggregate Functions

59) Exercise: Aggregate Functions

60) Commenting Your Queries

61) Common SELECT Mistakes

62) Filtering Data

63) AND and OR

64) Exercise: Filtering Data

65) The NOT Keyword

66) Exercise: The Where Clause

67) Comparison Operators

68) Exercise: Comparison Operators

69) Logical Operators

70) Operator Precedence

71) Operator Precedence 2

72) Operator Precedence Extra

73) Exercise: Operator Precedence

74) Checking For NULL Values

75) IS Keyword

76) NULL Coalescing

77) Exercise: Null Value Coalescing

78) 3 Valued Logic

79) Exercise: 3 Valued Logic

80) BETWEEN + AND

81) Exercise: BETWEEN + AND

82) IN Keyword

83) Exercise: IN Keyword

84) LIKE

85) Exercise: Like Keyword

86) Dates And Timezones

87) Setting Up Timezones

88) How Do We Format Date And Time?

89) Timestamps

90) Date Functions

91) Date Difference And Casting

92) Age Calculation

93) Extracting Information

94) Intervals

95) Exercise: Date and Timestamp

96) DISTINCT

97) Exercise: Distinct Keyword

98) Sorting Data

99) Exercise Sorting Data

100) Multi Table SELECT