Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 7 Minute(s)
Language
English
Taught by
Dave Hollingworth
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Master SQL Fundamentals Quickly and Effectively with MySQL
Learn the fundamentals of databases and SQL, from scratch, step-by-step. In this hands-on course, you’ll learn everything from the basics of SQL syntax to advanced query techniques. You'll do this with practical examples, quizzes, and coding exercises.
Learn and Master SQL Fundamentals Quickly Using One of the World's Most Popular Database Management Systems
What you'll learn:
Set up and configure MySQL on your computer
Understand core database concepts
Create and manage databases
Write SQL to insert, edit and delete data
Create simple queries to extract data from a database
Write complex queries using JOINs, GROUP BY, and subqueries
Optimise your queries for better performance
Learn SQL fundamentals from scratch using MySQL
SQL is one of the most in-demand skills you could learn. In this hands-on course, you'll learn the basics of databases and SQL syntax, through to advanced query techniques. You'll do this quickly by learning with practical examples, and reinforcing them with quizzes and in-browser coding exercises. We'll do this using MySQL - one of the world's most popular and database systems.
Starting from first principles, you'll learn what databases are and how they are used.
Then you'll learn what SQL is, and how it's used to interact with relational databases like MySQL.
At all stages practical examples are used, which you're encouraged to experiment with yourself.
You'll learn how to create and manage databases, at all times using best practices for doing so.
Then you'll learn the SQL to manage data inside databases - inserting new data and editing and deleting existing data.
Following this you'll learn the basics of how to get data from a database, then more advanced queries, including best practices and how to optimise them.
Why Take This Course?
No prior experience required - perfect for beginners
Clear, step-by-step lessons with practical examples
Build real skills you can use at work or in freelance projects
Lifetime access to course materials
Hands-on content and downloadable resources
Certificate of Completion to showcase your new skills
Course Content
- 16 section(s)
- 94 lecture(s)
- Section 1 Introduction
- Section 2 Software Installation and Setup
- Section 3 Creating Databases and Tables Using the Command-Line Client
- Section 4 Creating Databases and Tables Using a GUI
- Section 5 SQL Scripts
- Section 6 Inserting Data into a Table
- Section 7 Enforcing Data Integrity with Constraints
- Section 8 Selecting Data: The Basics
- Section 9 Selecting Data: Expressions, Functions and Subqueries
- Section 10 Updating and Deleting Data
- Section 11 Primary Keys and Linking Tables using Foreign Keys
- Section 12 Joins: Selecting Data from Multiple Tables
- Section 13 Selecting Data: Aggregate Functions and Groups
- Section 14 Ordering Results and Using Indexes
- Section 15 Different Types of Relationships
- Section 16 Conclusion
What You’ll Learn
- The basics of what databases are and why we use them
- Use SQL to save data to a database
- How to create your own databases or use existing ones
- Use SQL to extract data from a database in many different ways
- Use SQL to create and modify databases in MySQL
- SQL best practices
Skills covered in this course
Reviews
-
JJunrong Li
Clear, concise, high level, and sufficient explaination. Dave is a genius in programming teaching!
-
CChristian Lee
clear and concise. lots of stopping and starting whilst you type on the command line.
-
YYao Sewovon
I'm seeing myself being successful through this course. even though it seems a little bit fast for my first time.
-
NNatallia Sullivan
So far so good, easy to follow and interesting to learn
