Basics of DBMS and MySQL for Data Analytics Full Course

Focused View

Mohammad Irshad kasana

5:29:10

166 View

1 - Introduction To Course

1 - Introduction to Course.mp4

01:13

2 - Introduction To Database Management System

2 - What is Database.mp4

02:58

3 - Introduction To Database Management System.mp4

10:37

4 - Degree and Cardinality of Relation.mp4

05:04

5 - Relationships in DBMS.mp4

05:35

6 - DBMS vs File Systems.mp4

01:18

7 - DBMS Architecture.mp4

02:51

3 - Relationships in DBMS

8 - Concepts of Keys in DBMS.mp4

08:59

9 - Referential Integrity.mp4

03:22

10 - Entity Relationship Model ER Model.mp4

04:02

4 - Normalization in DBMS

11 - Normalization in Database Management System.mp4

01:27

12 - Functional Dependency.mp4

04:03

13 - Closure Property.mp4

04:42

14 - First Normal Form 1NF.mp4

02:17

15 - Second Normal Form 2NF.mp4

03:49

16 - Third Normal Form 3NF.mp4

03:33

17 - BCNF 35NF.mp4

02:46

18 - Fourth Normal Form 4NF.mp4

01:47

19 - Fifth Normal Form 5NF.mp4

04:57

20 - Summary of Normalization Forms.mp4

03:11

21 - Normalization Practice Problem I.mp4

05:10

22 - Normalization Practice Problem II.mp4

04:24

5 - Joins In Database Management System

23 - Joins in DBMS.mp4

02:53

24 - Cross Join.mp4

01:37

25 - Natural Join.mp4

02:51

26 - Theta Conditional Join.mp4

03:22

27 - Equi Join.mp4

03:11

28 - Self Join.mp4

03:36

29 - Left Outer Join.mp4

01:53

30 - Right Outer Join.mp4

01:12

31 - Full Outer Join.mp4

02:40

6 - Introduction to Relational Algebra in Database

32 - Introduction to Relational Algebra.mp4

01:56

33 - Projection in Relational Algebra.mp4

00:23

34 - Selection in Relational Algebra.mp4

00:16

35 - Cross Product in Relational Algebra.mp4

00:15

36 - Set Difference in Relational Algebra.mp4

00:45

37 - Union Operator in Relational Algebra.mp4

00:30

38 - Division Operator in Relational Algebra.mp4

03:43

39 - Join Operator in Relational Algebra.mp4

00:30

40 - Relational Algebra Problem I.mp4

01:27

7 - MySQL

41 - Introduction To SQL.mp4

04:14

42 - Install MySQL Workbench.mp4

05:02

43 - Data Types in MySQL.mp4

03:20

44 - Command Prompt Interface.mp4

05:58

45 - Create Database In MySQL.mp4

03:34

46 - Create Table In MySQL.mp4

03:31

47 - Alter Table In MySQL.mp4

03:39

48 - Drop Table In MySQL.mp4

01:26

49 - Truncate Table In MySQL.mp4

01:50

50 - Rename Table In MySQL.mp4

01:31

51 - Difference Between Drop Truncate and Delete.mp4

01:43

52 - Insert Data Into Table using MySQL.mp4

05:18

53 - Update Data using MySQL.mp4

03:21

54 - Delete from Table using MySQL.mp4

01:54

55 - Commit Rollback and Save Point.mp4

06:12

56 - Primary Key Constraint.mp4

05:40

57 - Unique Key Constraint.mp4

02:01

58 - Not Null Key Constraint.mp4

00:33

59 - Check Key Constraint.mp4

02:26

60 - Foreign Key Constraints and Referential Integrity.mp4

06:49

61 - Select and Where Clause in MySQL.mp4

03:03

62 - Order By Clause in MySQL.mp4

02:38

63 - Group By Clause in MySQL.mp4

07:40

64 - Having Clause in MySQL.mp4

05:17

65 - Distinct Clause in MySQL.mp4

01:10

66 - MySQL Functions.mp4

06:22

67 - Logical Operator in MySQL.mp4

05:17

68 - SQL Joins using MySQL.mp4

09:41

69 - Set Operators in MySQL.mp4

06:21

70 - Subqueries in MySQL.mp4

05:07

71 - All and ANY keyword in MySQL.mp4

02:36

72 - BETWEEN and IN keywords in MySQL.mp4

02:18

73 - LIKE in MySQL.mp4

02:00

74 - EXISTS in MySQL.mp4

04:29

75 - EXISTS and IN with Subqueries in MySQL.mp4

06:59

76 - SQL Practice Problem I.mp4

07:49

77 - SQL Practice Problem II.mp4

07:55

78 - SQL Practice Problem III.mp4

01:44

79 - SQL Practice Problem IV.mp4

04:33

8 - Transactions in Database Management System

80 - Transactions in DBMS.mp4

06:46

81 - Conflicts in Transaction.mp4

06:45

82 - Recoverable and NonRecoverable Schedule.mp4

02:20

83 - Schedules.mp4

03:07

84 - Conflict Equivalent.mp4

02:13

9 - Serializability

85 - Serializability.mp4

01:28

86 - Conflict Serializability.mp4

06:08

87 - View Serializability.mp4

02:12

88 - Concurrency Control Protocol.mp4

14:05

Description

A Comprehensive Course for all students

What You'll Learn?

Basic Concepts of Database Management
Learn complete MySQL Practically
Learn Complete DBMS with coding skills
Solve Problems based on DBMS Normalization and SQL subqueries
Relational Algebra and Joins
Transactions and serializability

Who is this for?

All those people who want to learn Database Management Skills

Freshman and Freshwomen who want to start their big dat and data science journey

All students who are pursuing degrees and preparing for competitive exams

More details

Description
Welcome to our DBMS and SQL course, the only online teaching platform that starts with the basics of introducing key concepts of DBMS normalization and takes you all the way up to SQL coding, practice problems, and much more. Whether you're a beginner or an experienced professional, our program has everything you need to master the concepts of database management systems and MySQL.
Our engaging animations and smart illustrations make the learning experience qualitative, easier to understand, and more attractive. We believe that learning should be fun and exciting, which is why we've designed our course to be both engaging and informative.
There's no better time to learn DBMS than today, with the rise of big data and the increasing importance of data-driven decision-making. The demand for skilled database management professionals is higher than ever, and our course will provide you with the skills and knowledge necessary to succeed in this field.
Throughout the course, we won't just learn thoroughly, but we will also understand the concepts and processes. We'll write SQL code in MySQL Workbench and solve DB practice problems, so you'll gain the necessary level of confidence to pass any placement exam or competitive test with flying colors.
Upon completion of the course, you'll receive a certificate that you can showcase to potential employers, demonstrating your expertise in DBMS and SQL. Don't wait any longer to take your career to the next level. Join us today and start your journey towards becoming a skilled database management professional. Thank you for choosing our program!
Who this course is for:
All those people who want to learn Database Management Skills
Freshman and Freshwomen who want to start their big dat and data science journey
All students who are pursuing degrees and preparing for competitive exams

User Reviews

Rating

average 0

Total votes0

Focused display

Looking for a Udemy instructor who can take you to the next level in various online learning programs? Look no further! I'm a highly skilled Android Developer with a strong background in Kotlin language and a track record of success. I'm Two Times GATE qualified and a win in the prestigious SIH competition, I'm the real deal.But that's not all. I'm also a passionate soccer player and fan, bringing the same drive and dedication to the field that I do to my work. And as if that weren't enough, I'm also a published researcher with a paper currently under review.With my extensive knowledge and experience, I'm the perfect choice to guide you through the intricacies of DBMS and MySQL, Sofware Engineering Computer Graphics. Whether you're a beginner or an experienced pro, I can help you take your skills to the next level. So why wait? Sign up for my course today and start building the future you've always dreamed of!

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.