CST 363 Week 6

 

WELCOME TO WEEK 6

Learning Journal - SQL Web App

 This week, I learned a lot about database programming, programming languages, and database programming techniques. Techniques such as: 

1. Embedded SQL: this involves coding SQL statements directly in a program written in another language. The keywords EXEL SQL precede all SQL statements. 

2. Procedural SQL: this extends SQL Language with control flow statements, creating a new programming language.  

3. Application Programming Interface(API): this refers to a library of procedures or classes. that link an application programming language to a computer service, such as database, email, or web service. 



For this week's project, we implemented an API using MySQL Workbench for our database. I also learned about the Connection, Statement, ResultSet, PreparedStatement, and CallableStatement interfaces, along with their functionalities and functions. 

Comments

Popular posts from this blog

CST 300 Week 1

CST 300 Week 4

CST 300 Week 3