Create a Database Table you own this product

prerequisites
Basic Understanding of .NET • Basic Understanding of Databases • Basic Knowledge of mySQL • Basic Knowledge of mySQL Workspace
skills learned
MySQL language
Ockert du Preez
2-4 hours per week · BEGINNER
Included with a Manning Online subscription
try now

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more

Look inside

Logistica Transport has grown, which means they need to replace their outdated desktop app with a brand new web app solution. In this liveProject, you’ll help them kick off this transformation by swapping their current Excel-based storage system for a mySQL database. You’ll need to create and install the database from scratch, as well as set up the necessary tables to handle the input and output streams of data. This database is a vital foundation for how Logistica’s web app will function.

This project is designed for learning purposes and is not a complete, production-ready application or solution.

project author

Ockert du Preez
Ockert J. du Preez has been in the coding industry for 20+ years and has written over 350 developer articles over the years detailing his programming quests and adventures. These can be found on CodeGuru, Developer.com, and Database Journal.

prerequisites

This liveProject is for anyone interested in learning the basics of MySQL.


TOOLS
  • Basics of T-SQL
  • Basics of MySQL Workbench
TECHNIQUES
  • Basics of databases
  • MySQL Language to create the necessary database objects that you’ll work with

features

Self-paced
You choose the schedule and decide how much time to invest as you build your project.
Project roadmap
Each project is divided into several achievable steps.
Get Help
While within the liveProject platform, get help from other participants and our expert mentors.
Compare with others
For each step, compare your deliverable to the solutions by the author and other participants.
book resources
Get full access to select books for 90 days. Permanent access to excerpts from Manning products are also included, as well as references to other resources.

related titles

choose your plan

pro

monthly
annual
$24.99
$249.99
only $20.83 per month
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Create a Database Table project for free

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Create a Database Table project for free