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
I worked as a professional developer for 14 years for several different companies including Proquest, CSC and AT&T before going full-time as a course creator. I currently live in Italy, although as a native Brit you get to enjoy (or put up with!) my British English accent while following your chosen courses.
In my spare time I like to write science fiction, often in cafes, and I'm a fan of old books.
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)