MySQL and JDBC

Faizan FirdousiFaizan Firdousi
1 min read

I am here to share what I have learned in the past few days.

I have ๐—น๐—ฒ๐—ฎ๐—ฟ๐—ป๐˜ ๐—ฏ๐—ฎ๐˜€๐—ถ๐—ฐ๐˜€ ๐—ผ๐—ณ ๐— ๐˜†๐—ฆ๐—ค๐—Ÿ:
-- How to run queries
-- Types of keys: primary, foreign, composite
-- How to perform CRUD (Create, Read, Update, Delete) operations
-- How to create a complex database with tables column relating to each other with foreign keys
-- Visualizing the rows and columns with PopSQL
-- MySQL statements like SELECT, UPDATE, ALTER, ORDER BY, LIMIT
-- Searching in a table
-- MySQL functions like COUNT(),SUM(),AVG()

๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป๐˜ ๐—๐——๐—•๐—– ๐—ฐ๐—ผ๐—ป๐—ฐ๐—ฒ๐—ฝ๐˜๐˜€ like:
-- How it works
-- DriverManager class that contains the four types of JDBC drivers-
JDBC-ODBC driver,Native-API driver,Network Protocol Driver,Thin Driver
-- The interfaces: Connection, Statement, SQLException
-- Learned how to set up JDBC with IntelliJ and MySQL
Looking forward to learning more JDBC and build something

0
Subscribe to my newsletter

Read articles from Faizan Firdousi directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Faizan Firdousi
Faizan Firdousi