SQL: A Practical Introduction for Querying Databases

Aperçu

Title:

SQL:

A Practical Introduction for Querying Databases

Description:

Discover the pivotal role of SQL (Structured Query Language) in managing and manipulating data within databases globally. Ideal for future data engineers, data warehouse specialists, data analysts, data scientists, and business intelligence professionals, this course offers a thorough introduction to both fundamental and intermediate SQL techniques.

Students will engage in basic Create, Read, Update, and Delete (CRUD) operations using SQL commands such as CREATE, SELECT, INSERT, UPDATE, and DELETE. Progressing further, the course covers advanced data handling strategies including filtering, sorting, ordering, and data aggregation.

Participants will gain practical experience with SQL functions, sub-selects, nested queries, and join operations across multiple tables.

The curriculum also incorporates the use of VIEWS, transaction management, and the creation of stored procedures. Emphasizing a hands-on learning approach, the course includes numerous practical exercises using real database systems, tools, and datasets.

This includes creating a personal database instance in the cloud and executing SQL queries through structured labs.

By the conclusion of the course, participants will demonstrate their SQL competency in a comprehensive project, showcasing the skills applicable to various RDBMS such as MySQL, PostgreSQL, IBM Db2, Oracle, and SQL Server. Designed for beginners, no prior knowledge of databases, SQL, or programming is required, though basic data literacy is advantageous.

University:

Provider:

Coursera

Categories:

SQL Courses, Relational Databases Courses

---

Enseigné par

Rav Ahuja

---

Matières