Introduction to SQL and relational databases
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Recommended experience
Recommended experience
What you'll learn
Basic concepts of databases and relational databases such as table, record, field, relation, primary key or secondary key.
Use of the SELECT command with the WHERE clause and various tools such as IN, BETWEEN or LIKE to query databases using string and range patterns.
The SQL commands for creating, changing and deleting tables and databases: CREATE, ALTER and DROP and to modify tables: INSERT, UPDATE and DELETE.
How to group, summarize and sort with ORDER BY, GROUP BY, SUM, AVG, MAX or MIN and how to make queries from several tables with JOIN and UNION
Skills you'll gain
Details to know
See how employees at top companies are mastering in-demand skills
There are 5 modules in this course
In the modern business landscape, information represents the most valuable resource for organizations, with the majority of this critical data housed within digital relational database systems.
The overwhelming majority of database management platforms currently deployed across industries rely on SQL as their primary language for data manipulation and retrieval operations. As a globally recognized standard, SQL empowers users to execute sophisticated data analysis and aggregation operations through an intuitive command structure that maximizes efficiency. For professionals pursuing careers in data analytics, software development, or any field requiring database interaction capabilities, SQL proficiency serves as a fundamental prerequisite. This comprehensive course will guide you through essential database management principles while providing hands-on experience with SQL implementation. Beginning with fundamental data retrieval techniques from single tables, you'll progress to advanced multi-table operations that enable comprehensive data analysis—all practiced using our cloud-based SQL simulation environment throughout your learning journey.
What's included
1 reading7 assignments5 plugins
1 reading•Total 2 minutes
- Download course slides•2 minutes
7 assignments•Total 50 minutes
- Module Exam •30 minutes
- Database Basics•2 minutes
- relational databases•2 minutes
- Relationships between tables in relational databases•2 minutes
- Database Management Systems (DBMS)•2 minutes
- SQL language•2 minutes
- Test exam week 1•10 minutes
5 plugins•Total 44 minutes
- Database Basics•10 minutes
- relational databases•10 minutes
- Relationships between tables in relational databases•10 minutes
- Database Management Systems (DBMS)•6 minutes
- SQL language•8 minutes
What's included
7 readings9 assignments7 plugins
7 readings•Total 100 minutes
- Generalities exercise•5 minutes
- Select command•10 minutes
- Limit, Distinct(), Count() exercises•10 minutes
- Data types exercises•10 minutes
- Create, Drop, Alter exercises•30 minutes
- Insert, Update, Delete exercises•20 minutes
- Indexes, Views, and Stored Procedures exercises•15 minutes
9 assignments•Total 104 minutes
- Module Exam•60 minutes
- Generalities exercise•2 minutes
- Select command exercises•2 minutes
- Limit, Distinct(), Count() exercises•2 minutes
- Data types exercises•2 minutes
- Create, Drop, Alter exercises•2 minutes
- Insert, Update, Delete exercises•2 minutes
- Indexes, Views, and Stored Procedures exercises•2 minutes
- Test exam week 2•30 minutes
7 plugins•Total 74 minutes
- Generalities•12 minutes
- Select command•10 minutes
- Limit, Distinct(), Count()•7 minutes
- Data types•15 minutes
- Create, Drop, Alter•12 minutes
- Insert, Update, Delete•8 minutes
- Indexes, Views, and Stored Procedures•10 minutes
What's included
7 readings9 assignments7 plugins
7 readings•Total 130 minutes
- Select with string patterns, ranges, and sets exercises•30 minutes
- Order result sets with ORDER BY exercises•10 minutes
- Grouping result sets with GROUP BY exercises•15 minutes
- SELECT CASE exercises•15 minutes
- Aggregate and per-row functions exercises•20 minutes
- Integrated date and time exercises•30 minutes
- Subqueries and nested SELECTs exercises•10 minutes
9 assignments•Total 179 minutes
- Module exam•120 minutes
- Select with string patterns, ranges, and sets exercises•2 minutes
- Order result sets with ORDER BY exercises•2 minutes
- Grouping result sets with GROUP BY exercises•2 minutes
- SELECT CASE exercises•2 minutes
- Aggregate and per-row functions exercises•2 minutes
- Integrated date and time functions exercises•2 minutes
- Subqueries and nested SELECTs exercises•2 minutes
- Test exam week 3•45 minutes
7 plugins•Total 56 minutes
- Select with string patterns, ranges, and sets•8 minutes
- Order result sets with ORDER BY•5 minutes
- Grouping result sets with GROUP BY•5 minutes
- SELECT CASE•5 minutes
- Aggregate and per-row functions•10 minutes
- Integrated date and time functions•15 minutes
- Subqueries and nested SELECTs•8 minutes
What's included
3 readings5 assignments3 plugins
3 readings•Total 50 minutes
- Implicit JOIN and JOIN types exercises•10 minutes
- INNER, LEFT, RIGHT and OUTER JOIN exercises•20 minutes
- SELECT UNION exercises•20 minutes
5 assignments•Total 186 minutes
- Module exam•120 minutes
- Implicit JOIN and JOIN types exercises•2 minutes
- INNER, LEFT, RIGHT and OUTER JOIN exercises•2 minutes
- SELECT UNION exercises•2 minutes
- Test exam week 4•60 minutes
3 plugins•Total 36 minutes
- Implicit JOIN and JOIN types•15 minutes
- INNER, LEFT, RIGHT and OUTER JOIN•15 minutes
- SELECT UNION•6 minutes
What's included
1 reading5 assignments3 plugins
1 reading•Total 60 minutes
- Advanced multi-table queries exercises•60 minutes
5 assignments•Total 204 minutes
- Module exam•120 minutes
- Advanced multi-table queries exercises•20 minutes
- SQL injection attacks•2 minutes
- SQL Clients•2 minutes
- Test exam week 5•60 minutes
3 plugins•Total 33 minutes
- Advanced multi-table queries•15 minutes
- SQL injection attacks•10 minutes
- SQL Clients•8 minutes
Instructor
Explore more from Data Management
- Status: Free Trial
- Status: Free Trial
Course
- Status: Free TrialI
Illinois Tech
Course
- Status: Free Trial
Course
Why people choose Coursera for their career
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,