Instructed by Aviral Dhingra
Welcome to Tech Optimum's comprehensive course on SQL, RDBMS, and Databases. We start by introducing you to the fundamentals of Databases and SQL, including the core concept of Relational Database Management Systems (RDBMS), setting a strong foundation for you to understand the complex structures of data handling. Our course is designed to provide a hands-on approach to SQL, featuring PostgreSQL as our main RDBMS tool. We guide you from the basics of downloading and installing PostgreSQL to mastering its basic commands, ensuring you're well-equipped to interact with databases confidently.
As we dive deeper, we cover essential operations like creating databases and tables, inserting, updating, and deleting rows, understanding various data types, and the concept of primary keys, all crucial for database management. In addition, we'll provide you with the necessary skills to select, filter, and sort data, along with teaching you how to use different SQL operators. The course also features a section on importing and exporting external data, empowering you to work with various data sources.
Lesson 1: Introduction to Databases
Lesson 2: PostgreSQL Setup
Lesson 3: Creating a Database
Lesson 4: Importing & Exporting External Data
Lesson 5: Advanced SQL
Lesson 6: Database Design & Normalization
Lesson 7: SQL Functions & Stored Procedures
Tech Optimum is a 501c3 nonprofit commited to providing free and quality tech education. If you've benefited from our courses or you share in our mission of making tech education accessible to all, consider supporting us. Your donation, no matter the amount, will help us continue to deliver free and impactful educational content.