Database Technology - SQL Essentials for Database Building

Focused View

Dr. Kowsigan Mohan

7:37:36

6 View

1. Introduction to Database Management System

1. Introduction to Database Management System.mp4

09:26

2. Characteristics of Database Management System

1. Characteristics of Database Management System.mp4

10:57

3. Actors and Workers

1. Actors and Workers.mp4

06:29

4. Types of Database Model

1. Types of Database Model.mp4

09:35

5. Three Schema Architecture

1. Three Schema Architecture.mp4

08:45

6. Key and Non Key Attributes

1. Key and Non Key Attributes.mp4

10:29

7. Types of Data modelling

1. Types of Data modelling.mp4

09:35

8. Phases of Database Design

1. Phases of Database Design.mp4

06:46

9. ER MODEL Notations Part 1

1. ER MODEL Notations Part 1.mp4

06:05

10. ER MODEL Notations Part 2

1. ER MODEL Notations Part 2.mp4

07:16

11. ER MODEL Notations Part 3

1. ER MODEL Notations Part 3.mp4

04:32

12. ER MODEL Notations Part 4

1. ER MODEL Notations Part 4.mp4

06:41

13. Relational Model Notation

1. Relational Model Notation.mp4

06:46

14. Relational Algebra Part 1

1. Relational Algebra Part 1.mp4

11:01

15. Relational Algebra Part 2

1. Relational Algebra Part 2.mp4

09:46

16. Relational Calculus

1. Relational Calculus.mp4

14:51

17. Aggregate functions in SQL

1. Aggregate functions in SQL.mp4

11:25

18. Stored Procedures Part 1

1. Stored Procedures Part 1.mp4

10:00

19. Stored Procedures Part 2

1. Stored Procedures Part 2.mp4

07:14

20. Stored Procedures Part 3

1. Stored Procedures Part 3.mp4

08:31

21. sql introduction

1. sql introduction.mp4

02:00

22. DDL Part 1

1. DDL Part 1.mp4

06:41

23. DDL Part 2

1. DDL Part 2.mp4

08:49

24. DDL Part 3

1. DDL Part 3.mp4

02:52

25. DML Part 1

1. DML Part 1.mp4

10:11

26. DML Part 2

1. DML Part 2.mp4

06:07

27. DQL

1. DQL.mp4

07:22

28. ALTER Query Processing

1. ALTER Query Processing.mp4

12:28

29. add drop rename Query Processing

1. add drop rename Query Processing.mp4

10:06

30. compound search conditions

1. compound search conditions.mp4

09:08

31. compound search conditions part 2

1. compound search conditions.mp4

06:56

32. Null and Not Null Query Processing

1. Null and Not Null Query Processing.mp4

05:45

33. SQL hands on Part 1

1. SQL.mp4

05:54

34. SQL hands on Part 2

1. SQL.mp4

11:44

35. SQL hands on Part3

1. SQL.mp4

05:17

36. SQL hands on Part4

1. SQL.mp4

05:09

37. SQL hands on Part5

1. SQL.mp4

04:47

38. SQL hands on Part6

1. SQL.mp4

12:05

39. SQL hands on Part7

1. SQL.mp4

05:44

40. SQL hands on Part8

1. SQL.mp4

06:58

41. SQL hands on Part9

1. SQL.mp4

09:30

42. SQL hands on Part10

1. SQL.mp4

10:55

43. SQL hands on Part 11

1. SQL.mp4

08:18

44. SQL hands on Part 12

1. SQL.mp4

09:34

45. SQL hands on Part 13

1. SQL.mp4

11:28

46. SQL Hands on Part 14

1. SQL.mp4

16:47

47. SQL Hands on Part 15

1. SQL.mp4

12:47

48. SQL Hands on Part 16

1. SQL.mp4

07:17

49. SQL Hands on Part 17

1. SQL.mp4

06:28

50. SQL Hands on Part 18

1. SQL.mp4

06:39

51. SQL Hands on Part 19

1. SQL.mp4

05:57

52. SQL Hands on Part 20

1. SQL.mp4

05:24

53. SQL Hands on Part 21

1. SQL.mp4

04:39

54. SQL Hands on Part 22

1. SQL.mp4

05:42

55. SQL Hands on Part 23

1. SQL.mp4

13:58

Description

Database Design, Relational Algebra, Calculus and Querying

What You'll Learn?

Understand the fundamentals of Database Management Systems, schema and languages
Conceive the database design process through Entity Relational model and Relational Model
Understand the fundamentals of Relational algebra, calculus and query processing
Familiarize the queries using Structured Query Language (SQL)

Who is this for?

Beginners

What You Need to Know?

Basic Computer Science Knowledge

More details

Description
In current business world, Database plays a vital role in managing the information of any environment. Day by Day data grows enormously for all the environments. At the same time, it is necessary to decide what are all the data required in the future for the environment. In this regard, it is essential for each and every environment to maintain a Database Management System in order to maintain their own databases. The Database Management System is a computerized system allows the users to create and manage a database. A Database Management System enables the user to define, construct, manipulate and share databases among several users and applications The Database management system has various advantage over traditional file processing approach such as Single repository maintains data, User access through queries, transactions and application programs, structure of data files is stored in the DBMS catalog separately from the access programs. The Database Management System further explored as Relational Database Management System. Here Data is viewed as existing in two dimensional tables known as relations. Various Database Management System technologies are used to perform operations on databases. In our course, Structured Query Language (SQL) will be explored to perform the operations in database as it is more popular in the Database world.
Who this course is for:
Beginners

User Reviews

Rating

average 0

Total votes0

Focused display

Dr M Kowsigan working as an Associate Professor in the Department of Computing Technologies, SRM Institute of Science and Technology, has about 15+ years of teaching experience. He received his Bachelor of Technology in Information Technology from Anna University, Master of Technology in Information Technology from Anna University, Master of Business Administration in Human Resource Management from Bharathiyar University Coimbatore and Doctor of Philosophy in Computer Science & Engineering in Anna University, Chennai. He has published around 45 research papers in referred international Journals. His most of the research papers comes under theoretical computer science. He has completed 2 consultancy projects. His area of research includes Theoretical Computer Science, Compiler Design, Distributed Computing, Big Data Technologies, IoT etc.

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.