Java Database Basics – MySQL – July 2018

Spread the love

Java Database Basics - MySQL July 2018

12 July 2018

duration 5 weeks

give 9 credits

ABOUT COURSE

Databases are the standard way to use dynamic information in modern applications, making them an integral part of almost every application.
The basics of the database will introduce you to one of the most widely used open-source database management (DBMS), systems used in the development of modern information systems – MySQL. The course focuses on relational modeling, data modeling with ER charts (tables and relational links) and SQL language handling (data mining, selection, projection, joining, aggregation, grouping, modification, deletion and insertion). Fundamental knowledge about ACID transactions and transaction processing and practical tips for adjusting productivity are provided.
This course sets the basics of working with databases, making it easier to use them in real-world applications, and understanding concepts such as database transformation into object-oriented (ORM) modeling.

SKILLS, WHO YOU RECEIVED

Fundamental knowledge of Data Bases

Transaction management

Create Basic Back-End Architectures

Using of ACID models

Management of relations in DB

Using procedures and features

ABOUT COURSE

COURSE INTRODUCTION

DATABASES INTRODUCTION

EXERCISE: DATABASES INTRODUCTION

DATA DEFINITION AND DATATYPES

EXERCISE: DATA DEFINITION AND DATATYPES

BASIC CRUD

EXERCISE: BASIC CRUD

BUILT-IN FUNCTIONS

EXERCISE: BUILT -IN FUNCTIONS

DATA AGREGATION

EXERCISE: DATA AGGREGATION

TABLE RELATIONS

EXERCISE: TABLE RELATIONS

SUBQUERIES AND JOINS

EXERCISE: SUBQUERIES AND JOINS

FUNCTIONS,TRIGGERS AND TRANSACTIONS

EXERCISE: FUNCTIONS,TRIGGERS AND TRANSACTIONS

EXAM PREPARATION (LECTURE)

EXAM PREPARATION (STUDENTS)

EXAM PREPARATION (LECTURE)

PRACTICAL EXAM

TEACHERS

people-avatar
Simona Dimitrova

Simona is interested in programming during her secondary education. He continued his training in Software Foundation, and soon he was also a trainer. He studied the Java profession.

people-avatar
Nikolai Petrov

Nikolai is a software engineer with interests in web development and web technologies. He has worked with PHP, HTML, CSS, JavaScript and other technologies. He has taught robotics, programming and web technologies at Software Foundation and other programming and technology schools.