MySQL and SQL for Beginners
Learn to create and query databases using the free MySQL Server and Workbench
Watch Promo Enroll in Course
This course teaches you how to work with SQL and MySQL, the free industrial-strength database.
If you're interested in creating software that stores data in a central repository or you want to create dynamic websites, you'll almost certainly want to learn some SQL. This course teaches you everything from basic SQL to complex queries, transactions and stored procedures.
MySQL is one of the most popular databases currently in use in the world; second only to the incredibly secure and scalable Oracle. Probably the majority of websites in the world currently use MySQL to store their data, and learning SQL with MySQL will also make it easy to learn how to work with other databases.
Fortunately you can easily install MySQL on your computer at home -- even a laptop, and get started with this course right away!
Your Instructor
After working as a software developer and contractor for over 14 years for a whole bunch of companies including CSC, Proquest, SPSS and AT&T in the UK and Netherlands, I decided to work full-time as a private software trainer. I moved to the beautiful city of Budapest, where I turned Cave of Programming from just a bunch of articles into what you see today. I now live in Italy.
Course Curriculum
-
PreviewIntroducing MySQL (7:14)
-
PreviewInstalling MySQL and the Workbench (6:20)
-
PreviewUsing the Command Line (7:10)
-
PreviewCreating Tables (9:30)
-
PreviewMultiple Columns, int and Data Types (4:47)
-
PreviewNull Values and Not Null (8:25)
-
PreviewMysql Storage Engines and Configuration (13:04)
-
StartSQL Modes (13:43)
-
PreviewDeleting All the Data in a Table (4:24)
-
PreviewPrimary Keys (8:10)
-
PreviewAuto Increment (5:12)
-
PreviewNarrowing Down Select Statements (5:48)