IN India Bachelor's Degree
SQL and Database Management
Design tables, write queries that scale and keep data honest.
What the course covers
8 modules, 32 topics. Open any one to see what sits inside it.
-
- 1.1 What a Database Is and Why It Matters
- 1.2 File Systems vs Database Systems
- 1.3 The Relational Model
- 1.4 DBMS Architecture and Components
-
- 2.1 Entities, Attributes and Relationships
- 2.2 ER Diagrams
- 2.3 Keys: Primary, Foreign and Candidate
- 2.4 Normalisation and Normal Forms
-
- 3.1 SQL Language Categories
- 3.2 Creating Databases and Tables
- 3.3 Data Types and Constraints
- 3.4 SELECT, WHERE and Sorting
-
- 4.1 INSERT, UPDATE and DELETE
- 4.2 Filtering with Operators and Patterns
- 4.3 Handling NULL Values
- 4.4 Altering and Dropping Structures
-
- 5.1 Understanding Joins
- 5.2 Inner, Outer, Cross and Self Joins
- 5.3 Subqueries and Nested Queries
- 5.4 Set Operations: UNION, INTERSECT, EXCEPT
-
- 6.1 Aggregate Functions
- 6.2 GROUP BY and HAVING
- 6.3 Built-in Functions: String, Date and Numeric
- 6.4 Views and Common Table Expressions
-
- 7.1 Indexes and Query Performance
- 7.2 Transactions and ACID Properties
- 7.3 Stored Procedures and Functions
- 7.4 Triggers and Data Integrity Rules
-
- 8.1 Users, Roles and Permissions
- 8.2 Backup, Restore and Recovery
- 8.3 Database Security Practices
- 8.4 NoSQL and Modern Data Stores
What you will be able to do
By the end of this course you will be able to explain and apply:
- What a Database Is and Why It Matters
- Entities, Attributes and Relationships
- SQL Language Categories
- INSERT, UPDATE and DELETE
- Aggregate Functions
- Users, Roles and Permissions
Why take it
Who it is for
Designed for
- Bachelor's Degree students in India
- Studying: BCA, B.Sc. Computer Science, B.Sc. IT, B.Tech CSE/IT, B.Sc. Data Science
- Recent graduates strengthening a CV
- Anyone working in this field without a formal qualification
What you need
- No prior course needed
- A phone, tablet or computer
- About two hours in total
- Each of the five courses stands alone
Questions
-
About two hours in total — eight modules of roughly fifteen minutes. You can do it in one sitting or spread it across a week. Your place is saved either way.
-
No. There is no prerequisite course and no software to install. A phone, tablet or computer with an internet connection is enough.
-
Yes. This course is placed at Bachelor's Degree for India, and the content is written for that level. If you are at a different stage, change your level at the top of the page and the courses will change with it.
-
A certificate for the course, carrying an ID that your college or an employer can check on our verification page. You keep access to the material afterwards.
-
Yes — ₹450 for this course on its own, or ₹1,450 for all five in this set, which works out cheaper if you want more than one.
-
There is a short quiz at the end of each module so you can check what stuck. It is not timed and you can retake it.
-
Change your country using the picker at the top. Level names, degree names and prices all switch to that country, and the courses adjust to its education system.
Wording shown for India. Pick a different country at the top and the terms, currency and programme names change with it.