Trang chủ

IT Certifications

SQL

Master SQL Database and Java core (2023): from zero to hero

Master SQL Database and Java core (2023): from zero to hero

Loại khoá học: IT Certifications

Excel the core of relational databases and programming, and build a complete application from scratch.

50.000 VND

999.000 VND

Đầy Đủ Bài Giảng

Học Online Tiện Lợi

Kích Hoạt Nhanh 2-5 Phút

Thanh toán tự động

Được phép tải xuống

Mô tả

Become a SQL and Java Desktop App developer quick with this course!

If you're looking manage data, work with software backend, use Java or JavaFx to develop a Desktop app that uses database to display and manipulate data, this course is for you.

This course is intended to make you learn how to use the SQL language, create your databases, use (SQL + Java/Java FX) and develop the backend of desktop applications for the personal or market use.

You'll learn SQL skills which are applicable to any SQL based database, such as SQLite, MySQL, Oracle, Microsoft SQL Server and more. This course offers you challenges to put your gray mass into test to improve your understanding and create doubts which construct a developer. You'll be working with SQLite3 Database.

In this course you will learn what you need to become a beginner SQL with Java Desktop app developer , including:

The SQL syntax
Relate table data with SQL Joins
Write SQL Queries to retrieve data
Perform SQL CRUD(create, read, update and delete) operations
Write transctions
Design basic database schemas
Connect Java App to a SQL Database using JDBC
Deal with Java Exceptions due to the database operations
Use a ready JavaFx Desktop user interface and build the backend logic (SQL + Java)
Model Database Tables in form of Java Object
Techniques to develop UI Apps
And so much more!

In this course you will not be copying and pasting code you don't understand as many other tutorials, every piece of code is explained and you are in controll.

This course combines SQL and Java to build an App. Upon completion, you’ll be able to use databases, create java apps linked to databases and build Desktop applications. You’ll also be able to grow as a developer.

It's all! Enroll today and start learning SQL with Java to build your App!

Bạn sẽ học được gì

Yêu cầu

Nội dung khoá học

10 sections

Introduction to the course

2 lectures

Welcome to the Course

04:11

Q&A to support you

00:19

Developer Environment Setup

6 lectures

Overview of The Section: What You Should Know At The End

00:58

Overview of The Software Tool

01:19

Install and Setup of SQLite for Windows OS

07:11

Install and Setup of SQLite for Mac OS

02:24

Install and Setup of SQLite for Linux OS

02:09

Technical terminologies of Databases

13:06

Basics of SQLite

2 lectures

Source code of the projects

00:06

Best Tips

00:36

How Get Most Out of This Course

8 lectures

Overview of The Section

02:34

Introduction to SQLite - Part 1

13:42

Introductory SQL Quiz

3 questions

Introduction to SQLite - Part 2

13:44

Data Query in SQLite Database With SQL

15:03

SQLite Introduction to SQLite and Data Entry Quiz

2 questions

What You should know at the end

6 questions

Playing More With Data: Complex SQL Joins

17:55

SQL Joins, Order by, Queries and Views

3 lectures

Overview of The Section: What You Should Know At The End

01:19

SQL Wildcards in Queries and Views

12:09

SQL Final Challenge

13:07

Database Creation: JDBC in JAVA and SQLite

9 lectures

Overview of The Section: What You Should Know At The End

02:15

The JDBC and SQLite GUI Browser Tools

10:06

Installing JDK and Intellij Pt1

05:13

Installing JDK and Intellij Pt2

05:37

First Impressions of IntelliJ

06:02

Database Creation Using JDBC in Java

15:29

Common DB Operations Using JDBC: Insert, Update and Delete

18:25

The Method .executeQuery()

01:44

Constants and methods

20:57

Music Database

16 lectures

Overview of The Section: What You Should Know At The End

00:26

Music SQLite Database and Program Idealization

00:59

Music SQLite Database Creation (DataSource model)

16:05

Data Query With Java: Artists

15:33

Column Index and Order By for Artists

10:37

DB Browser and SQL

06:33

Method: Query Albums by Artist

26:04

Method: Query Artists for Song Pt1

07:01

Method: Query Artists for Song Pt2

11:34

Method: Query Artists for Song Pt3

05:18

The ResultSet Metadata

07:28

The getCount() function and Views

13:37

Query the View and Song Loop method

16:54

Dealing With SQL Injection Attacks and Prepared Statements

11:02

Transactions Pt1

05:56

Transactions Pt2

07:08

Music DB With Transactions and Prepared Statements

3 lectures

Records: artist, albums and songs Insertion and Prepared Statements Constants

12:14

Inserting The Pack: artist, albums and songs, Prepared Statements and Transactio

20:13

Testing The Insertion

12:46

JDBC With Graphical User Interface Java Program

21 lectures

Getting Started

13:52

Feature: Display Artists

19:13

Feature: Display Albums for an Artist Pt1

10:23

Feature: Display Albums for an Artist Pt2

08:30

Feature: Display Artists Amount of Record

04:30

Feature: Query Artists

07:40

Progress Bar

06:38

Update Artists

16:03

Display Albums and Amount of Records

16:24

Feature: Query and Update Albums

14:41

Feature: Display Songs

10:27

Feature: Query and Update Songs

07:58

Feature: Display Artist for a Song

11:28

Feature: Display Artists for a Song

14:09

Feature: Display Details for a Song

15:14

Hiding UI Elements and Creating the View at start

04:41

Feature: Add Artist, Album and Song Pt1

08:53

Feature: Add Artist, Album and Song Pt2

25:39

Validation

05:44

Error or Warning GUI Messages

19:23

Refactor

25:55

Conclusion

1 lectures

You Reached The End!!!

00:22

Đánh giá của học viên

Chưa có đánh giá

Course Rating

5

0%

4

0%

3

0%

2

0%

1

0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Email

Nội dung

Khoá học liên quan

Node.js - The Complete RESTful API Masterclass (2024)

Node.js - The Complete RESTful API Masterclass (2024)

Full Stack Web & Mobile App Development | Mern Stack Project

Full Stack Web & Mobile App Development | Mern Stack Project

Complete C# Unity Game Developer 2D

Complete C# Unity Game Developer 2D

Little Adventurer: Learn to make a 3D action game with Godot

Little Adventurer: Learn to make a 3D action game with Godot

The Complete JavaScript Course 2024: From Zero to Expert!

The Complete JavaScript Course 2024: From Zero to Expert!

Selenium WebDriver with Java -Basics to Advanced+Frameworks

Selenium WebDriver with Java -Basics to Advanced+Frameworks

Flutter Bloc cho Mobile, Web, PC - Tôi chọn bạn

Flutter Bloc cho Mobile, Web, PC - Tôi chọn bạn

Prometheus | The Complete Hands-On for Monitoring & Alerting

Prometheus | The Complete Hands-On for Monitoring & Alerting

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

The Complete Oracle SQL Bootcamp (2024)

The Complete Oracle SQL Bootcamp (2024)

Electron From Scratch: Build Desktop Apps With JavaScript

Electron From Scratch: Build Desktop Apps With JavaScript

Building Recommender Systems with Machine Learning and AI

Building Recommender Systems with Machine Learning and AI

ROS For Beginners (ROS Noetic, Melodic, Kinetic)

ROS For Beginners (ROS Noetic, Melodic, Kinetic)

Complete C# Unity Game Developer 3D

Complete C# Unity Game Developer 3D

Spring Framework 6: Beginner to Guru

Spring Framework 6: Beginner to Guru

Flutter &Firebase: Uber-Like Multi-Vendor Shop App with Chat

Flutter &Firebase: Uber-Like Multi-Vendor Shop App with Chat

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi