CST 363 - Week 8

1. While taking CST 363, I learned how to write real SQL queries with joins, subqueries, and views and got a lot of hands-on experience with it using the MySQL Workbench during our labs and homework assignments.

2. We learned how to design a database using ER diagrams and normalization also through the workbench.

3. I got hands-on with MongoDB and saw how it’s different from SQL, plus how to connect databases to simple web apps and got experience doing that through the command prompt/ terminal.

Comments

Post a Comment

Popular posts from this blog

Week 4 - Educational & Career Goals, ETS Readiness, and Learning Reflections

Part One: Educational Goals My goal in the CS program is to develop a good foundation in software development which specifically includes front-end and back-end technology. I also want to get a really good understanding of algorithms and develop problem solving skills. Programming languages are another important part of this plan. In fact, that is the essence of CS. I’ve done C++, Python, Java, Javascript and other languages, but want to revise them all again and this time create a nice portfolio utilizing some of the languages. The next goal is to hopefully land internships or full-time entry jobs to get real-world experience. All this is while attaining my bachelors. Part Two: Career Goals I want to start now in terms of career goals meaning that I want to start getting experience as soon as possible. This means I have to get into an entry level job and build from there. Something attainable can be taking courses on UI/UX design and get a career related to that. As I get used to that...
Read more

Week 2 - Learning Strategies | Time Management | Project Management | Previous Capstones | Week Summary

Image
Learning Strategies Top 3 Study Skills I'm Good At: Following the SQ3R method: Survey | Question | Read | Recite   |   Review I didn't even know I followed this until I examined myself with it.  Minimizing Distractions While Studying: I’m good at selecting quiet, distraction-free environments like my study room at the corner of my house so not many people walk by throughout the day allowing me to focus deeply on the material. Looking for main ideas in paragraphs and extracting key details. Top 3 Areas I Need to Improve On: Creating/Following a Schedule:  I am not good at creating a schedule and even worse at following it. I'll try it for a day but then things pop up and I get inconsistent. I feel like I can't keep a good schedule when studying formally like school. However, this class is training us like we are working a job. Therefore, it is getting easier to follow a schedule as if we are needing to meet deadlines so I am enjoying it.  Time...
Read more

Week 5 - Team Comments, Capstone Ideas, Weekly Journal, Industry Expert Interview

Image
  Part One: Team Comments  Comment for Jian:  Jian's Week 4 Journal Comment for Noah:  Noah's Week 4 Journal   Part Two: Capstone Ideas 1. User-friendly appointment booking system for small businesses - Many small businesses have a hard time with inefficient and difficult scheduling systems. This project would create a simple, mobile-friendly appointment booking system with features like automatic reminders and calendar, significantly improving customer experience and reducing no-shows.  2. Smart navigation system or app for public spaces - Many people struggle with navigating crowded places like malls, airports, or large events. This project would create a user-friendly mobile app that provides real-time navigation indoors, showing the least crowded paths based on foot traffic data. It could also include accessibility-friendly routes for users with disabilities, improving overall user experience and convenience. 3. AI-powered smart form auto...
Read more