MySQL is the world’s most popular open source database. According to DB-Engines, MySQL ranks as the second-most-popular database

MySQL is the world’s most popular open source database. According to DB-Engines, MySQL ranks as the second-most-popular database

1. Data base with Mysql Nalaka Senanayake

2. Course outline 1.Introduction to DBMS: DATA & Information, database Data Base, Management System, Relational Data Base Management System (RDBMS),database server, Application of DBMS in job fields, Software used for DBMS

3. Course outline 2.MYSQL Basics Downloading MySQL, Installation, Verifying MySQL Installation 3.RDBMS Terminology Database, Table Column Row (tuple), Redundancy Primary Key Foreign Key, Compound Key Index Referential Integrity

4. Course outline 4.Types of database model Hierarchical database model, Relational model, Network model, Object-oriented database model, Entity-relationship model.

5. Course outline 5.Entity Relationship (ER) Diagram RE diagram, ER Diagrams symbols Rectangles, Ellipses, Diamonds, Lines Primary key, Double Ellipses, Attributes, Simple attribute, Composite attribute, Derived attribute, Multivalued attribute, Relationships (Cardinality)One-to-One Relationships, One-to-Many Relationships, Many to One Relationships, Many-to-Many Relationships

6. Course outline 6.Introduction to SQL, Classification of SQL, Data Definition Language (DDL), Creating database using DDL ,Creating table ,Alter table ,Inserting and deleting attributes, Adding and deleting ,foreign key and primary key ,Drop tables, Drop databases

7. Course outline 7.Data Manipulation Language (DML) Inserting, Modifying, Retrieving, Updating, Deleting, Select Query Extracting rows and columns from single table, Extracting rows and columns from multiple tables, Use Arithmetic operators, (+, -, *,/ ) Use Arithmetic Functions ABS (), MOD (), POWER (), ROUND() Use of wild card characters Like, *, _, % ,Grouping, Order by, Joins , Update Query , Delete Query

8. Course outline 8.Normalization Need for normalization, Levels of normalization, Zero normal form, First normal form, second normal form, Third normal form.   9.Jobs available in this fields Data Analyst, Database Developer, Database Administrator Data Scientist, SQL Server Developer