MySQL and JDBC
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
Subscribe to my newsletter
Read articles from Faizan Firdousi directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by