Introduction to Databases and SQL
SQL fundamentals using database creation, data manipulation, and querying techniques, understanding relationships and efficient data management practices.
SQL fundamentals using database creation, data manipulation, and querying techniques, understanding relationships and efficient data management practices.
This comprehensive course from the Raspberry Pi Foundation introduces students to database fundamentals and SQL programming. Participants learn essential database concepts, including primary keys and table relationships, while mastering SQL for data manipulation and searching. The course progresses from basic database concepts to advanced topics like table joins and data grouping, providing hands-on experience with real database operations. Students gain practical skills in comparing databases with spreadsheets, creating SQL statements, and managing multi-table relationships.
3.4
(6 ratings)
Instructors:
English
English
Powered by
What you'll learn
Master fundamental database concepts and terminology
Create and execute SQL queries for data retrieval and manipulation
Understand the differences between databases and spreadsheets
Implement table relationships and primary keys
Perform multi-table searches using SQL joins
Apply filters and grouping to analyze data effectively
Skills you'll gain
This course includes:
PreRecorded video
Graded assignments, exams
Access on Mobile, Tablet, Desktop
Limited Access access
Shareable certificate
Closed caption
Get a Completion Certificate
Share your certificate with prospective employers and your professional network on LinkedIn.
Created by
Provided by
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 8 modules in this course
This course provides a comprehensive introduction to databases and SQL programming. Students learn fundamental database concepts, including table relationships and primary keys, while developing practical skills in SQL query writing and data manipulation. The curriculum covers essential topics from basic database operations to advanced concepts like multi-table joins and data grouping, ensuring a solid foundation in database management.
What are databases used for?
Module 1 · 1 Hours to complete
Why use a database or a spreadsheet?
Module 2 · 1 Hours to complete
Create SQL statements to search a database
Module 3 · 1 Hours to complete
The role of primary keys
Module 4 · 1 Hours to complete
Add data using SQL statements
Module 5 · 1 Hours to complete
Apply relationships to tables within a database
Module 6 · 1 Hours to complete
Use joins to search across multiple tables
Module 7 · 1 Hours to complete
Group data in a database
Module 8 · 1 Hours to complete
Fee Structure
Instructors
2 Courses
Making Technology Fun and Accessible: A Tech Educator's Journey
Martin O'Hanlon, a passionate advocate for creative technology education, has made significant contributions as a Senior Learning Manager at the Raspberry Pi Foundation, where he dedicated himself to making technology learning engaging and accessible. With a robust background as an IT systems designer and developer in the industry, O'Hanlon combined his technical expertise with his belief that understanding technology should be an exciting and creative journey rather than a mundane task. His professional trajectory showcases a transition from creating practical technological solutions to empowering others to understand and interact with the digital world around them, emphasizing the importance of making technical education both meaningful and enjoyable.
5 Courses
EdTech Pioneer: From Classroom to Digital Learning Innovation
Matt Hogan, a Learning Manager at the Raspberry Pi Foundation, brings over two decades of teaching experience to transform computer science education through innovative digital platforms. His significant contributions to projects like Ada Computer Science and various online courses reflect his unwavering commitment to making educational technology accessible to all learners. Drawing from his extensive classroom experience, Hogan focuses on developing comprehensive educational content that bridges the gap between traditional teaching methods and modern technology, while maintaining his passion for EdTech and ensuring that computer science education reaches and inspires young minds regardless of their background or circumstances
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
3.4 course rating
6 ratings
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.