Relational Databases & SQL: Complete Guide for Developers 2024 Course For Free With Certification | Free Udemy Course | First 1000 Users for Free |

Relational Databases & SQL: Complete Guide for Developers

Learn Database Architecture, Data Modelling, MySQL, PostgreSQL with examples

What you'll learn

• Relational Databases
• Data Modelling
• Database Architecture
• SQL
• MySQL Server & MySQL Workbench
• PostgreSQL
• Database Normalization & Denormalization
• Database optimization
• Indexes in Databases
• JDBC
• DML
• DDL
• ORM/JPA
• Hibernate
• Spring Data JPA
• Spring JDBC

Course content

20 sections • 51 lectures • 14h 0m total length

Preview

04:10

Preview

03:16

Tips to Improve Your Course Taking Experience

00:44

Preview

24:56

Preview

22:58

MySQL: Overview & Installation (including Workbench Installation)

20:42

PostgreSQL: Overview & Installation (including pgAdmin installation)

16:46

Relational Databases: Basic Concepts

27:24

Create Schema & Table: Naming, Collation, Engines, Types, Column Properties

36:10

Referential Integrity: Foreign Key Constraint & Cascading Operations

21:34

Indexes in Databases

20:33

Database Normalization & Denormalization

32:38

SQL: General Overview & DDL

20:10

SQL: DML - CRUD Operations (SELECT, INSERT, UPDATE, DELETE)

29:08

JOIN Queries, UNION & Subqueries

15:00

Views, Triggers, Stored Procedures & Functions

30:36

MySQL Workbench: Administration

10:22

Database Modelling & Design: Conceptual, Logical and Physical Data Models

25:35

JDBC Overview: Establish connection with DB from Java App

20:22

Statement, PreparedStatement & CallableStatement

23:04

Transactions, Batch Updates and MetaData

20:53

SQL Homework: Task and Solution review

07:52

DAO (Data Access Object) Design Pattern

19:29

How to be prepared for the interview?

00:44

Part 1: JDBC & Databases - Questions and Answers

03:12

Part 2: Databases - Questions and Answers

06:33

Part 3: SQL - Questions and Answers

04:48

Part 4: SQL - Questions and Answers

09:29

Exam task review and solution

19:35

Introduction to JPA & ORM

14:03

First JPA Project: Entity, ID GenerationType, Composite Primary Keys, etc)

20:40

First JPA Project - Part 2: EntityManager, persistence.xml, Transactions in JPA

21:39

Operations with Entity (Create, Read, Update, Delete) & JPA Entity Lifecycle

19:25

Locking JPA: Optimistic & Pessimistic Locking

30:33

Relationships Between Entities

22:24

JPA Queries (Query, TypedQuery, NativeQuery, JPQL, Criteria API)

25:40

Caching in JPA/Hibernate

32:23

N+1: Problem and Solution

16:34

Part 1: ORM & Hibernate Interview - Questions and Answers

10:08

Part 2: ORM & Hibernate Interview - Questions and Answers

08:57

Part 3: JPA Interview - Questions and Answers

08:32

Part 4: JPA Interview - Questions and Answers

07:47

===== EXAM TASK: JPA & Hibernate =====

21:06

Intro to the Section

00:28

Spring Data & Spring Data JPA: Overview

13:49

Spring Data JPA: Practice

21:28

EXAM: Spring Data JPA - Online Shop

00:08

Spring JDBC: Overview

13:39

Spring JDBC: Practice

28:55

EXAM: Spring JDBC - Online Shop

00:08

Bonus lesson

02:51

Requirements

No specific prerequisites

Description

From this course, you can learn relational databases and SQL.

There are a lot of other courses on this topic. So, why would you choose exactly this course?  Here are just a few reasons:

- Coding examples

To learn to program is not enough just watching videos and reading books. You also need to have a lot of practice. In this training course, you will review multiple practical tasks and coding examples which will help you learn and understand Java better.

- Open source code

We hide nothing from our students! Including the source code for the home task solutions and source code of examples that were shared during the lesson. Having the source code you can just copy and paste it to run it on your local computer to understand how things work better.

You are allowed to use all source code examples for learning purposes. This helps significantly to configure the environment and make tests work, especially in case students didn't work with any testing framework in the past.

- Q&A support 

The significant difference between the online and offline learning process is the instructor's availability. If you are in one room with a tutor he always can help you to get understand the specific concept or to help fix your code on your computer.

In this course, we are supporting students with answers to any questions flagged in the Q&A section. In case there will be recurring questions - separate video lessons will be created to show how to address the issue.

So with this course you are not just getting video materials, code exercises, source code, access to the free mobile application without limits (which is still pretty cool, huh? :) ), but you also get tutor support and answers to your questions along with this course.

- Relevant knowledge

After our team investigated other Java courses on Udemy we realized that most of them have nothing in common with real life. The information which is shared there is very old and significantly out of date. For example, the instructor teaches a framework which is not been used already for 15 years. Or instructors do stress on the programming design which is not used anymore at all!

The instructor of this course is a consultant in a top-rated IT outsourcing company and helps to bring cutting-edge solutions in IT for all his clients. Feel free to check the LinkedIn page of the instructor and check skills endorsement. More than 19 thousand people across all over the world (BTW most of them are from the top 100 companies of the world) evaluated the skills of Andrii Piatakha.

With this course, you can be sure that you will spend your time learning the right things from one of the best IT consultants in the world.

- Free mobile App without limits for our students

Knowing Java is one skill. Be able to pass interviews in the company - that is another skill :) Nowadays a lot of companies use tests to select candidates on the first level of interview. We developed applications to practice skills specifically for such purposes.

In this course, we will provide you link to download our FREE mobile app for android. (soon it will be also available for iOS platforms)

The instructor of this course comes up with hundreds of tests that are used to test the knowledge of candidates. With this application, you will be well-prepared for the interview.

Also, only for our students - there is no limit on attempts to pass certification. In the course, we will tell you how to set up a special bonus code that will remove restrictions for our students inside the app.

- High concentration of useful material in each lesson

Sometimes you can notice that watching 5 minutes of our lesson is equivalent to watching another 30 minutes lesson.

This is because time spent for preparation for the lesson (script for the lesson, lesson structure) and video editing (to cut boring pieces of the lesson or time when the program loads) sometimes 10 times as much (sometimes even 20) as the final lesson duration after video editing.

Also, each topic is separated from another. In case some concept will be explained in the next lesson and you don't need to worry about understanding this in the scope of this lesson - the instructor will make an announcement when a specific topic will be covered.

Go and try it yourself! We will appreciate your feedback.

So don't wait! Take a look at the lessons' preview if you still have doubts!

Buy this course today, and you will get all updates for FREE!

For those who successfully passed this training course, or for students who were recognized for asking amazing questions, there is a special offer from the IT-Bulls company! The creator of this course is IT-Bulls company CEO and Founder. We are always in search of talents to run our amazing startups together with you. Probably you always dreamed about running your startup? In this course, you will be able to find the team who will teach you how to do that and (in particular cases) will be glad to help with implementation!

Hope you enjoy this course! And remember, we appreciate all your feedback! Your feedback will help us to become even better! Your feedback will help us to create to best Java course ever!

See you at the lessons! :)

Who this course is for:

• Database Engineers
• Software Developers
• Software Architects

Instructors

Andrii Piatakha

Founder and CEO in IT-Bulls, Founder of Learn-IT University

Andrii Piatakha

4.4 Instructor Rating

36,349 Reviews

955,013 Students

35 Courses

Founder and CEO in IT-Bulls. IT-Bulls is a consultancy company that promotes engineering excellence standards, holds audits of software projects, and provides private consultancy.

Creator of Learn-IT Online University and mobile application that help to get certified in different domains.

Tutor with 5+ years of experience. Key Java Tutor in outsourcing companies. Andrii helps to teach Java software engineers from zero till their first job assignment.

You can find courses in different areas. But one of his most popular courses "Java from Zero to First Job". The Java course is used to train people with zero programming knowledge to prepare them for real work in different companies.

When you are taking Andrii's courses you can be sure that you will learn the right things in the right way in the shortest possible amount of time.

All Andrii's courses are proven by time and success stories of the students.

Not all tutors were professional programmers in past. Huge engineering experience allowed Andrii to run his own IT company. During the teaching, Andrii focuses students' attention only on the most important things.

Feel free to check out Andrii's LinkedIn profile and especially confirmation of the skills. Already more than 1000+ professional engineers, managers, and software architects all over the World confirmed Andrii's skills in Java EE technologies stack.

Andrii spent a lot of time tutoring offline to understand students and key issues they face with during their education process. Detailed homeworks and practical experience - that's what help students to get knowledge.

IT-Bulls creates applications with students which allow people to pass internship and get more practical experience.

The best students managed to get their first job in IT-Bulls and now become leading engineers in the company!

So be prepared to become the best friend of IT-Bulls company.

Learn more about Andrii's career and skills in LinkedIn profile and follow Andrii on Instagram! 

This course includes:

13 hours on-demand video

13 articles

Access on mobile and TV

Full lifetime access

Certificate of completion

 Click Here To Apply