The Complete SQL and MySQL Course - From Beginner to Expert

Focused View

Holczer Balazs

6:45:07

8 View

1 - Introduction

1 - Introduction.mp4

03:04

2 - Environment

2 - Installing SQL and MySQL on Windows.html

3 - Installing SQL and MySQL on Mac.html

3 - Databases Theory

1 - Databases Theory Quiz.html

4 - What are databases and database management systems DBMS.mp4

05:24

5 - The relational model.mp4

04:39

6 - Data structures behind database servers.mp4

07:47

7 - Procedural and nonprocedural languages.mp4

03:36

8 - Types of DBMS and database languages.mp4

04:39

4 - Table Manipulation

2 - Table Manipulation Quiz.html

9 - Data types.mp4

08:47

10 - Creating databases.mp4

03:32

11 - CODE creating databases.html

12 - Creating a table.mp4

04:18

13 - CODE creating database tables.html

14 - Inserting into a table.mp4

04:37

15 - Inserting multiple items in one statement.mp4

01:31

16 - CODE inserting into tables.html

17 - Delete row from a table.mp4

05:03

18 - CODE delete row.html

19 - Updating a row.mp4

02:22

20 - CODE updating rows.html

21 - Changing table structure.mp4

03:31

22 - CODE change table structure.html

23 - Drop tables.mp4

02:09

24 - What are primary keys.mp4

05:49

25 - The auto increment feature.mp4

04:29

26 - CODE auto incremented primary keys.html

27 - Enums.mp4

04:32

28 - Booleans.mp4

05:32

29 - Floating point numbers with decimals.mp4

05:23

30 - Dates.mp4

04:21

31 - Exercise.html

32 - Solution.mp4

05:49

33 - Chapter summary & source code.html

33 - tablemanipulation.pdf

5 - Basic SQL

3 - Basic SQL Quiz.html

34 - SQL dump the city and country tables.mp4

04:50

35 - SELECT.mp4

03:36

36 - WHERE.mp4

02:48

37 - IN.mp4

02:18

38 - BETWEEN.mp4

03:28

39 - NOT negation in SQL.mp4

02:08

40 - Logical operators.mp4

04:03

41 - Wildcards.mp4

03:27

42 - Functions.mp4

05:51

43 - ORDER BY.mp4

04:40

44 - Code order by.html

45 - GROUP BY.mp4

03:06

46 - CODE group by.html

47 - Exercise.html

48 - Solution.mp4

02:33

49 - HAVING.mp4

03:02

50 - Chapter summary & source code.html

50 - basicsql.pdf

6 - Multiple Tables

4 - Multiple Tables Quiz.html

51 - What is a foreign key.mp4

02:50

52 - Foreign key example.mp4

05:59

53 - CODE foreign keys.html

54 - How to handle changes when dealing with multiple tables.mp4

04:50

55 - Updating dependent tables example.mp4

07:57

56 - CODE updating tables.html

57 - Exercise.html

58 - Solution.html

7 - Database Normalization

5 - Database Normalization Quiz.html

59 - What is database normalization.mp4

03:43

60 - The first normal form.mp4

03:25

61 - The second normal form.mp4

04:30

62 - The third normal form.mp4

03:11

8 - Joining Multiple Tables

6 - Joining Tables Quiz.html

63 - Configuring the database tables PERSON and UNIVERSITY.mp4

02:55

64 - Inner join introduction.mp4

05:28

65 - Inner join example.mp4

04:28

66 - CODE inner join.html

67 - Left join introduction.mp4

03:29

68 - Left join example.mp4

02:15

69 - CODE left join.html

70 - Right join introduction.mp4

02:36

71 - Right join example.mp4

01:29

72 - CODE right join.html

73 - JOIN example number of cities.mp4

05:12

74 - CODE joining cities.html

75 - Exercise.html

76 - Solution.mp4

03:23

77 - Online SQL console.mp4

01:03

78 - JOIN example customers and orders.mp4

02:53

79 - JOIN example number of orders by customers.mp4

03:18

80 - JOIN example number of orders by country.mp4

02:05

81 - Chapter summary & source code.html

81 - JOIN.pdf

9 - Advanced SQL Subqueries

7 - Subqueries Quiz.html

82 - What are subqueries.mp4

07:10

83 - Noncorrelated scalar subquery.mp4

02:05

84 - CODE scalar subquery.html

85 - Noncorrelated multiplerow subquery.mp4

02:46

86 - CODE multiple row subquery.html

87 - Correlated subquery.mp4

02:50

88 - CODE correlated subquery.html

89 - Subqueries and joins.mp4

01:15

90 - Transforming subquery into join.mp4

03:04

91 - CODE subquery and join.html

92 - Chapter summary & source code.html

92 - subqueies.pdf

10 - Advanced SQL Transactions

8 - Transactions Quiz.html

93 - Transactions introduction locking.mp4

10:26

94 - Transactions introduction transactions.mp4

04:09

95 - What are the ACID principles.mp4

03:45

96 - Transaction example COMMIT.mp4

04:28

97 - CODE commit.html

98 - Transaction example ROLLBACK.mp4

02:33

99 - CODE rollback.html

100 - Transaction example SAVEPOINT.mp4

05:31

101 - CODE savepoint.html

102 - Chapter summary & source code.html

102 - transactions.pdf

11 - Advanced SQL Views

9 - Views Quiz.html

103 - What are views.mp4

04:48

104 - Views example initialize database.mp4

01:38

105 - Views example create views.mp4

03:57

106 - CODE creating views.html

107 - Views example update views.mp4

02:59

108 - Views example dropping views.mp4

00:58

109 - CODE update and drop views.html

110 - Exercise.html

111 - Solution.html

112 - Chapter summary & source code.html

112 - views.pdf

12 - Advanced SQL Indexes And Constraints

10 - Indexes Quiz.html

113 - What are indexes.mp4

12:03

114 - Indexes example.mp4

04:37

115 - Constraints introduction.mp4

02:13

116 - Primary keys.mp4

03:08

117 - Unique constraints.mp4

02:56

118 - Check constraints.mp4

06:11

119 - What is bitmap indexing.mp4

10:31

13 - Data Structures Behind Databases

11 - Database Data Structures Quiz.html

120 - External memory and paging.mp4

07:35

121 - B tree data structures.mp4

07:43

122 - Using B trees.mp4

05:58

14 - Stored Procedures

12 - Stored Procedures Quiz.html

123 - What are stored procedures.mp4

05:40

124 - Creating our first stored procedure.mp4

05:23

125 - CODE first stored procedure.html

126 - Listing and removing stored procedures.mp4

03:02

127 - CODE listing and removing stored procedures.html

128 - Variables.mp4

04:39

129 - Exercise.html

130 - Solution.html

131 - Session variables.mp4

02:51

132 - Parameters.mp4

06:32

133 - CODE parameters.html

134 - Exercise.html

135 - Solution.html

136 - Conditional statements.mp4

07:41

137 - CODE conditional statements.html

138 - Loops.mp4

08:02

139 - ITERATE.mp4

02:27

140 - WHILE.mp4

04:00

141 - CODE loops.html

142 - Returning multiple values.mp4

03:50

143 - CODE returning multiple values.html

15 - Course Materials DOWNLOADS

144 - Course materials.html

144 - SQLandMySQL.zip

Description

Learn the Basics of Managing Data with SQL - Basics, Transactions, Views, Pages and Stored Procedures

What You'll Learn?

understand the basic concepts of databases
get a good grasp of SQL and MySQL queries
understand database management systems (DBMSs) and database languages
understand table manipulation
understand pages
understand views
understand strored procedures
understand the data structures (B trees and B+ trees) behind databases

Who is this for?

This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge

What You Need to Know?

Internet connection

More details

Description
In this course you can learn the fundamental basics of data management with SQL and MySQL. Learn everything that you will need to make queries with the most popular data manipulating programming language - SQL. This course is about SQL commands in the main. You will learn the basics of queries. Let's take a look at what you are going to learn in this course:
Section 1 - Setting up The Environment:
setting up the environment
installing MySQL server
Section 2 - Database Theory
what are databases?
what are database management systems (DBMSs)?
what are database languages?
the data structures (B-trees) behind databases
procedural and non-procedural programming languages
Section 3 - Creating and Manipulating Tables
basic data types (integers, floating point numbers and characters)
enums and dates
how to create databases?
how to insert and remove items?
how to update existing items or database tables?
Section 4 - Basic SQL
basic SQL and MySQLÂ commands
select, where and wildcards
logical operators
ORDERÂ BY and GROUP BYÂ commands
Section 5 - Multiple Tables
joining multiple database tables
inner join
left and right join
Section 6 - Database Normalization
what is database normalisation?
first normal form (NF1)
second normal formÂ (NF2)
third normal form (NF3)
Section 7 - Subqueries:
advanced SQL and MySQL
what are subqueries?
correlated and non-correlated subqueries
Section 8 - Transactions
what is database locking?
the ACID principles
COMMIT, ROLLBACK and SAVEPOINT
Section 9 - Views
what are views and why are they crucial?
creating views
updating views
dropping views
Section 10 - Indexes and Constraints
what are indexes and why to use them?
primary keys and foreign keys revisited
composite keys
what are constraints?
check constraints
unique constraints
default constraints
Section 11 - Data Structures Behind Databases
what are pages?
the basic concept of paging in operating systems
external memory and internal memory
B tree data structure
B+ tree data structure
Section 12 - Stored Procedures
what are stored procedures?
variables
loops
conditional statements
cursors
Learning the fundamentals of SQL and MySQL is a good choice and puts a powerful tool at your fingertips. SQL is easy to learn as well as it has excellent documentations.
The most important fact about SQL that it is used in almost every field from software engineering to financial analysis so understanding the concepts and basic language features can prove to be very marketable.
Thanks for joining the course, let's get started!
Who this course is for:
This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge

User Reviews

Rating

average 0

Total votes0

Focused display

My name is Balazs Holczer. I am from Budapest, Hungary. I am qualified as a physicist. At the moment I am working as a simulation engineer at a multinational company. I have been interested in algorithms and data structures and its implementations especially in Java since university. Later on I got acquainted with machine learning techniques, artificial intelligence, numerical methods and recipes such as solving differential equations, linear algebra, interpolation and extrapolation. These things may prove to be very very important in several fields: software engineering, research and development or investment banking. I have a special addiction to quantitative models such as the Black-Scholes model, or the Merton-model.Take a look at my website if you are interested in these topics!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.