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
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.
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.