Complete SQL Mastery

Focused View

9:32:46

14 View

1 - What is SQL.mp4

03:24

2 - Installing MySQL on Mac.mp4

04:58

3 - Installing MySQL on Windows.mp4

05:20

4 - Creating the Databases.mp4

08:32

5 - The SELECT Statement.mp4

05:50

6 - The SELECT Clause.mp4

08:48

7 - The WHERE Clause.mp4

05:17

8 - The AND, OR and NOT Operators.mp4

06:52

9 - The IN Operator - Title.mp4

03:03

10 - The BETWEEN Operator - Title.mp4

02:12

11 - The LIKE Operator - Title.mp4

05:37

12 - The REGEXP Operator.mp4

09:21

13 - The IS NULL Operator.mp4

02:26

14 - The ORDER BY Clause.mp4

07:06

15 - The LIMIT Clause.mp4

03:26

16 - Inner Joins.mp4

08:26

17 - Joining Across Databases.mp4

02:47

18 - Self Joins.mp4

04:13

19 - Joining Multiple Tables.mp4

06:46

20 - Compound Join Conditions.mp4

03:41

21 - Implicit Join Syntax.mp4

02:20

22 - Outer Joins.mp4

06:27

23 - Outer Join Between Multiple Tables.mp4

06:18

24 - Self Outer Joins.mp4

02:12

25 - The USING Clause.mp4

05:22

26 - Natural Joins.mp4

01:21

27 - Cross Joins.mp4

03:14

28 - Unions.mp4

08:29

29 - Column Attributes.mp4

03:24

30 - Inserting a Row.mp4

05:46

31 - Inserting Multiple Rows.mp4

03:18

32 - Inserting Hierarchical Rows.mp4

05:53

33 - Creating a Copy of a Table.mp4

08:47

34 - Updating a Single Row.mp4

03:55

35 - Updating Multiple Rows.mp4

03:14

36 - Using Subqueries in Updates.mp4

05:37

37 - Deleting Rows.mp4

01:24

38 - Restoring the Databases.mp4

01:06

39 - Aggregate Functions.mp4

09:19

40 - The GROUP BY Clause - Title.mp4

07:21

41 - The HAVING Clause - Title.mp4

08:50

42 - The ROLLUP Operator - Title.mp4

05:05

43 - Introduction.mp4

01:28

44 - Subqueries.mp4

02:29

45 - The IN Operator.mp4

03:39

46 - Subqueries vs Joins.mp4

05:07

47 - The ALL Keyword.mp4

04:52

48 - The ANY Keyword.mp4

02:36

49 - Correlated Subqueries.mp4

05:36

50 - The EXISTS Operator.mp4

05:39

51 - Subqueries in the SELECT Clause.mp4

04:29

52 - Subqueries in the FROM Clause.mp4

02:58

53 - Numeric Functions.mp4

02:54

54 - String Functions.mp4

05:47

55 - Date Functions in MySQL.mp4

04:08

56 - Formatting Dates and Times.mp4

02:14

57 - Calculating Dates and Times.mp4

03:08

58 - The IFNULL and COALESCE Functions.mp4

03:29

59 - The IF Function.mp4

04:54

60 - The CASE Operator.mp4

05:23

61 - Creating Views.mp4

05:36

62 - Altering or Dropping Views.mp4

02:52

63 - Updatable Views.mp4

05:12

64 - THE WITH OPTION CHECK Clause.mp4

02:18

65 - Other Benefits of Views.mp4

02:37

66 - What are Stored Procedures.mp4

02:18

67 - Creating a Stored Procedure.mp4

05:34

68 - Creating Procedures Using MySQLWorkbench.mp4

01:21

69 - Dropping Stored Procedures.mp4

02:09

70 - Parameters.mp4

05:26

71 - Parameters with Default Value.mp4

08:18

72 - Parameter Validation.mp4

06:40

73 - Output Parameters.mp4

03:55

74 - Variables.mp4

04:33

75 - Functions.mp4

06:28

76 - Other Conventions.mp4

01:51

77 - Triggers.mp4

07:31

78 - Viewing Triggers.mp4

01:20

79 - Dropping Triggers.mp4

00:52

80 - Using Triggers for Auditing.mp4

04:52

81 - Events.mp4

04:33

82 - Viewing, Dropping and Altering Events.mp4

02:04

83 - Transactions.mp4

02:44

84 - Creating Transactions.mp4

05:11

85 - Concurrency and Lockign.mp4

04:07

86 - Concurrency Problems.mp4

07:25

87 - Transaction Isolation Levels.mp4

05:42

88 - READ UNCOMMITTED Isolation Level.mp4

03:26

89 - READ COMMITTED Isolation Level.mp4

03:01

90 - REPEATABLE READ Isolation Level.mp4

03:29

91 - SERIALIZABLE Isolation Level.mp4

02:18

92 - Deadlocks.mp4

06:11

93 - Introduction.mp4

00:43

94 - String Types.mp4

02:25

95 - Integer Types.mp4

02:52

96 - Fixed-point and Floating-point Types.mp4

01:42

97 - Boolean Types.mp4

00:46

98 - Enum and Set Types.mp4

03:36

99 - Date and Time Types.mp4

00:44

100 - Blob Types.mp4

01:17

101 - JSON Type.mp4

10:24

102 - Introduction.mp4

01:25

103 - Data Modelling.mp4

02:26

104 - Conceptual Models.mp4

04:34

105 - Logical Models.mp4

07:24

106 - Physical Models.mp4

06:27

107 - Primary Keys.mp4

03:23

108 - Foreign Keys.mp4

05:48

109 - Foreign Key Constraints.mp4

05:22

110 - Normalization.mp4

01:24

111 - NF- First Normal Form.mp4

02:42

112 - Link Tables.mp4

04:01

113 - NF- Second Normal Form.mp4

06:32

114 - NF- Third Normal Form.mp4

01:43

115 - My Pragmatic Advice.mp4

02:55

116 - Don t Model the Universe.mp4

04:24

117 - Forward Engineering a Model.mp4

02:35

118 - Synchronizing a Model with a Database.mp4

04:48

119 - Reverse Engineering a Database.mp4

03:11

120 - Project- Flight Booking System.mp4

00:23

121 - Solution- Conceptual Model.mp4

08:00

122 - Solution- Logical Model.mp4

09:03

123 - Project - Video Rental Application.mp4

01:05

124 - Solution- Conceptual Model.mp4

06:59

125 - Solution- Logical Model.mp4

08:29

126 - Creating and Dropping Databases.mp4

01:41

127 - Creating Tables.mp4

03:13

128 - Altering Tables.mp4

02:56

129 - Creating Relationships.mp4

04:47

130 - Altering Primary and Foreign Key Constraints.mp4

02:10

131 - Character Sets and Collations.mp4

06:29

132 - Storage Engines.mp4

02:27

Complete SQL Mastery.txt

code.zip

Description

Everything you need to design and query databases in one course

What You'll Learn?

Understand the fundamentals of relational databases and SQL Master the SQL syntax and commonly used SQL commands Query and retrieve data from single and multiple database tables Use filtering, sorting, and aggregating techniques to manipulate data Create and modify database tables, views, and indexes Implement data integrity constraints and ensure data consistency Perform advanced SQL operations, such as subqueries and joins Write efficient and optimized SQL queries for improved performance Design databases effectively, including database schema and normalization principles Secure your databases

Who is this for?

Anyone who wants to learn to design and query relational databases Computer science students who want to better understand SQL Anyone pursuing a job in back-end development, database administration or data science SQL developers who want to brush up on their SQL skills

More details

The course covers everything you need to know in detail, so donâ€™t worry if youâ€™re a complete novice. You donâ€™t even need to know what a database is! For those with some development and database experience, you can jump in at the relevant module that fits your current level, as the course is designed sequentially.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

MySQL

Oracle SQL

Microsoft SQL

CodewithMosh

View courses CodewithMosh

Engaging courses, focused on developing practical skills to fast track your career. Carefully designed real-world examples & exercises. Access on Mobile & TV. Downloadable. Lifetime Access. Highlights: Offering Fun And Engaging Lessons, Providing Comprehensive Courses.