Introduction to Database Systems DBMS. MYSQL, POSTGRESQL, ORACLE, SQL SERVER, SQL-LITE [ CHAPTER 1]
KEY POINTS
1. Components of DBMS enviroment
2. Fuctions of DBMS
3. Advantages and Dsadvantages of DBMS
4. Database and DBMS
5. Database Users
6. ANS / SPARC Database Architecture
7. Schemas
8. DML, DDL, DCL
9. Schema and Instance
10. Mapping
RELATED VIDEO SERIES
PRACTICAL VIDEO SERIES: INTRODUCTION TO DATABASE SYSTEMS UNDER COMMAND LINE
FROM BEGGINER TO EXPERT
1. INTRODUCTION TO DATABASE SYSTEMS RDBMS
• DATABASE SYSTEMS DBMS INTRODUCTION TO...
2. INTRODUCTION TO DATABASE SYSTEMS (SCHEMA DEFINITION) PRACTICAL NO 1
• RELATIONAL DATABASE PROGRAMMING (SCHE...
3. INTRODUCTION TO DATABASE SYSTEMS (TABLE RELATION SHIP) PRACTICAL NO 2
• RELATIONAL DATABASE PROGRAMMING (TABL...
4. RELATIONSHIP AND FORCING REFERENTIAL INTERGRITY part 2
• NAMNA YA KUTENGENEZA RELATION SHIP KW...
5. INTRODUCTION TO DATABASE SYSTEMS (DATA ENTRY) PRACTICAL NO 3
PRACTICAL 3
• RELATIONAL DATABASE PROGRAMMING (DATA...
6. INTRODUCTION TO DATABASE SYSTEMS (DATA COMPUTATION USING TRIGGER) PRACTICAL NO 4
• RELATIONAL DATABASE PROGRAMMING (DATA...
7. INTRODUCTION TO DATABASE SYSTEMS (SCHEMA MODIFICATION) PRACTICAL NO 5 PART 1
MYSQL TABLE ADD, RENAME, DROP, DELETE, ALTER ,SET, UPDATE, schema modification part 5
• RELATIONAL DATABASE PROGRAMMING (SCHE...
8. INTRODUCTION TO DATABASE SYSTEMS (SCHEMA MODIFICATION) PRACTICAL NO 5 PART 2
• RELATIONAL DATABASE PROGRAMMING (DATA...
9. INTRODUCTION TO DATABASE SYSTEMS (DATA MANIPULATION) AND (DESCRIPTIVE FUNCTIONS) PRACTICAL NO 6
MYSQL DATABASE SELECT STATEMENT (count, sum, format, max, min, avg)
• RELATIONAL DATABASE PROGRAMMING (DATA...
10. INTRODUCTION TO DATABASE SYSTEMS (RELATIONAL AND COMPARISON OPERATORS) PRACTICAL NO 7
• RELATIONAL DATABASE PROGRAMMING (RELA...
11. INTRODUCTION TO DATABASE SYSTEMS ( DATA MODELS ) PRACTICAL NO 8
• RELATIONAL DATABASE PROGRAMMING ( DA...
12. INTRODUCTION TO DATABASE SYSTEMS (CREATING ERD) PRACTICAL NO 9
• RELATIONAL DATABASE PROGRAMMING (ER...
13. INTRODUCTION TO DATABASE SYSTEMS CREATING RELATIONAL SCHEMA PRACTICAL NO 10 PART 1
MYSQL DATABASE CREATING RELATIONAL SCHEMA FROM ERD (converting ERD to relational schema)
• RELATIONAL DATABASE PROGRAMMING REL...
14. INTRODUCTION TO DATABASE SYSTEMS PHYSICAL SCHEMA PRACTICAL NO 10 PART 2
• RELATIONAL DATABASE PROGRAMMING PHY...
OTHER PRACTICAL VIDEOZ
1. PART 1: DATABASE SERVER LOGIN VIA COMMAND LINE
• part 1 MYSQL DATABASE user management
2. PART 2: CREATING DATABASE, TABLES AND RELATION SHIP
• part 2 MYSQL DATABASE user management
3. PART 3: CREATING USERS
• part 2 MYSQL DATABASE user management
4. PART 4: GRANT PRIVILEGES TO USERS
• part 4 MYSQL DATABASE user management
5. PART 5: EACH USER LOGIN TO PERFORM GIVEN PRIVILEGES
• part 5 MYSQL DATABASE user management
6. PART 6: ALTER TABLE ADD CONSTRAINTS FOREIGN KEY
• part 6 MYSQL DATABASE user management
7. PART 7: GRANT USER PRIVILEGE TO A SPECIFIC TABLE COLUMN
• part 7 MYSQL DATABASE user management
8. CONVERT ERD TO PHYSICAL SCHEMA USING SQL STATEMENTS
• how to convert ER Diagram to Physica...
9. HOW TO DESIGN ERD WITH FULL EXPLANATION OTHER DATA MODELS
• how to Design ERD diagram for informa...
-----------------------
CONTACTS:
WhatsApp +255656848274
email: [email protected]