Data is one of the most critical assets of any business. Data needs a database to store and process data quickly. SQL is a language used for a database to query data. In this introductory course, you'll learn the basics of the SQL language and the relational databases. You'll start by learning about the relational model and relational model concepts and constraints. By the end of this course, you will have learned and used the five basic SQL statements, some advanced SQL syntax, and join statements. This isn't your typical textbook introduction. You're not just learning through lectures. At the end of each module there are assignments, hands-on exercises, review questions, and also a final exam. Successfully completing this course earns you a certificate. So let's get started!
Overview
Syllabus
- Module 1 -SQL and Relational Databases 101
- Introduction to SQL and Relational Databases
- Information and Data Models
- Types of Relationships
- Mapping Entities to Tables
- Relational Model Concepts
- Module 2 - Relational Model Constraints and Data Objects
- Relational Model Constraints Introduction
- Relational Model Constraints Advanced
- Module 3 - Data Definition Language (DDL) and Data Manipulation Language (DML)
- CREATE TABLE statement
- INSERT statement
- SELECT statement
- UPDATE and DELETE statements
- Module 4 - Advanced SQL
- String Patterns, Ranges, and Sets
- Sorting Result Sets
- Grouping Result Sets
- Module 5 - Working with multiple tables
- Join Overview
- Inner Join
- Outer Join
Tags
Related Courses
Related articles
Reviews
4.0 rating, based on 4 Class Central reviews
-
Weerayut Suksathan @WeerayutThis is a good course for learning About SQL language or re-skilled. How to learning coding SQL. Of course this is course is free from IBM and get certificates when you pass exams -
Priyanka RohidaInformative sessions for a beginner!
The content is delivered in a clear and structured manner, ensuring even those with no prior experience can grasp the concepts comfortably. Hands-on exercises and practical examples provide real-world context, boosting understanding. While catering to beginners, the course could benefit from more advanced topics for comprehensive learning.
Must try! -
Priyanshi Mathavadiyai was very help full course for me clear my basic fundamentals and create batter image of my future planing . thanks to classcentral to give me wonder full access
