SitePoint
  • Premium
  • Library
  • Community
  • Jobs
  • Blog
LoginStart Free Trial

The home for developers

Track your course progress, manage projects, and find your dream job - all in one place.

Start Your Free Trial

7 Day Free Trial. Cancel Anytime.

SitePoint Premium

  • Access to 700+ courses
  • Publish articles on SitePoint
  • Daily curated jobs
  • Learning Paths
  • Discounts to dev tools
  • Library/
  • Text courses/
  • Learn SQL (using MySQL) in One Day and Learn It Well
Learn SQL (using MySQL) in One Day and Learn It Well

Learn SQL (using MySQL) in One Day and Learn It Well

SQL for Beginners with Hands-on Project


Course details

5.0∙3 Ratings2 reviews

Published
October 2018
Publisher
Learn Coding Fast
Chapters
16

About the course

The information era is upon us and the ability to organize and make sense of data has become an invaluable skill.

Have you been hearing about data, databases and SQL and wondering what it's all about? Or perhaps you have just gotten a new job and need to learn SQL fast.

This book is for you. You no longer have to feel lost and overwhelmed by all the fragmented tutorials online, nor do you have to waste your time and money learning SQL from lengthy books and expensive online courses.

The best way to learn SQL is by doing. This book provides examples for all concepts taught so that you can try out the different SQL commands yourself.

In addition, you'll be guided through a complete project at the end of the book that requires the application of all the concepts taught previously. Working through the project will not only give you an immense sense of achievement, it'll also help you retain the knowledge and master the language.

Ready to embark on your SQL learning journey? This book is for you.

Author

Jamie Chan

Jamie Chan

I am a tutor and freelance programmer by profession, and it is my passion to share the joy of programming with as many people as possible. My years of teaching has blessed me with the knack for turning complex programming concepts into simple terms. In my books, I take special efforts to ensure that even a complete novice to programming can understand and apply the concepts covered. Examples are carefully chosen to illustrate all concepts.

Course Outline

Chapter 1: Introduction
Chapter 2: Defining the Database
Chapter 3: Defining Tables
Chapter 4: Inserting, Updating and Deleting Data
Chapter 5: Selecting Data Part 1
Chapter 6: Selecting Data Part 2
Chapter 7: Selecting Data Part 3
Chapter 8: Views
Chapter 9: Triggers
Chapter 10: Variables and Stored Routines
Chapter 11: Control Flow Tools
Chapter 12: Cursors
Chapter 13: Project
Chapter 14: Appendix A: Tables for companyHR
Chapter 15: Appendix B: Tables for sportsDB
Chapter 16: Appendix C: Suggested Solution for Project

Reviews
5.0

3 total

3
0
0
0
0

Course details

5.0∙3 Ratings2 reviews

Published
October 2018
Publisher
Learn Coding Fast
Chapters
16

SitePoint

Stuff we do

  • Premium
  • Newsletters
  • Learning paths
  • Library
  • Forums

Contact

  • Contact us
  • FAQ
  • Publish your book
  • Write an article
  • Advertise

About

  • Our Story
  • Corporate Memberships
  • Start free trial
  • Login

Connect

  • RSS
  • Facebook
  • Twitter (X)
  • Instagram

Subscribe to our newsletter

Get the freshest news and resources for developers, designers and digital creators in your inbox each week

© 2000 – 2025 SitePoint Pty. Ltd.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Terms of usePrivacy policy