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

Post a Comment

Popular posts from this blog

CST 489 Week 14

  WELCOME TO WEEK 14 Learning Journal -  What project milestones did you accomplish this week?  This week, I implemented the reminder button functionality in DynamiCode. When users click the reminder button, they are redirected to a Google Calendar form with the title, description, and date already pre-filled. From there, they can choose to make it an all-day event or set a specific time. I also added a saved link for each reminder so users can easily access their scheduled event directly through that link. In addition, I wrote and refined the script for the three slides I will be presenting in our final video: the intro/ problem slide , and the solution slide . I focused on clearly explaining the problem we’re addressing, how DynamiCode uses spaced repetition, and how our approach differs from traditional methods, while still fitting within the 6-minute time limit. What is your plan for next week? Next week, I plan to record my sections of the presentation (intro, pr...
Read more

CST 489 Week 16

Image
  WELCOME TO MY FINAL WEEK OF CS ONLINE  Learning Journal -       These two years have gone by much faster than I ever expected. When I first started the program, I thought it would feel very long and challenging, but instead it passed quickly and was a genuinely rewarding experience. I enjoyed every class in its own way, some more than others, but overall I am very grateful for everything I learned and the skills I gained throughout the CS Online program. I hope to continue building on these skills and use them to create meaningful projects in the future.      Looking back, I can clearly see my growth, not only technically but also personally. I have gained much more confidence in my abilities and in myself. Coming up with ideas feels easier now, and although I am still nervous, I feel ready to take on interviews and new challenges ahead. My future plans include continuing my education and pursuing a master’s degree; the next step is decidi...
Read more

CST 489 Week 10

Image
  WELCOME TO WEEK 10 Learning Journal -  What project milestones did you accomplish this week? This week I continued working on the front end and added the remaining components needed for the Home page. The Home page had the most information, so it took the longest. I only need one modal to finish up the Calendar, Home, and Login pages.  What is your plan for next week? My plan for next week is to figure out what features will be accessible inside the modal after we meet with our mentor. They suggested changes, but we are not completely sure which direction to take yet. After resolving this, we will move into integrating the back end with the front end. Once I finish the remaining front-end work, I plan to help with the integration. What challenges, if any, are you currently facing in project development? Do you need instructor assistance? Some challenges this week included making the layout look good on mobile screens and adjusting component dimensions so the UI did...
Read more