Module 1: Your first database 1. Introduction to relational databases 2. Attributes of relational databases 3. Query information_schema with SELECT 4. Tables: At the core of every database 5. CREATE your first few TABLEs 6. ADD a COLUMN with ALTER TABLE 7. Update your database as the structure changes 8. RENAME and DROP COLUMNs in affiliations 9. Migrate data with INSERT INTO SELECT DISTINCT 10. Delete tables with DROP TABLEModule 2: Enforce data consistency with attribute constraints 1. Better data quality with constraints 2. Types of database constraints 3. Conforming with data types 4. Type CASTs 5. Working with data types 6. Change types with ALTER COLUMN 7. Convert types USING a function 8. The not-null and unique constraints 9. Disallow NULL values with SET NOT NULL 10. What happens if you try to enter NULLs? 11. Make your columns UNIQUE with ADD CONSTRAINTModule 3: Uniquely identify records with key constraints 1. Keys and superkeys 2. Get to know SELECT COUNT DISTINCT 3. Identify keys with SELECT COUNT DISTINCT 4. Primary keys 5. Identify the primary key 6. ADD key CONSTRAINTs to the tables 7. Surrogate keys 8. Add a SERIAL surrogate key 9. CONCATenate columns to a surrogate key 10. Test your knowledge before advancingModule 4: Glue together tables with foreign keys 1. Model 1:N relationships with foreign keys 2. REFERENCE a table with a FOREIGN KEY 3. Explore foreign key constraints 4. JOIN tables linked by a foreign key 5. Model more complex relationships 6. Add foreign keys to the "affiliations" table 7. Populate the "professor_id" column 8. Drop "firstname" and "lastname" 9. Referential integrity 10. Referential integrity violations 11. Change the referential integrity behavior of a key 12. Roundup 13. Count affiliations per university 14. Join all the tables together

English

Indian rupee

Course Credibility

DataCamp is one of the best e-learning websites to learn to program in data analytics, and science renders the certificate. It excels at teaching the essential fundamentals and giving learners the toolbox to get started. It awards a certificate upon successful completion of the program. Industry subject matter experts train professionals with years of experience in the data science domain. It is renowned for collaborations with top companies, including Google and Intel, to help their employees train in this specialization.

Accrediation

Faculty Experience

Institution Reputataion (Tier-1,2,3/Top B School, Others)

Alumni Status to the Learner

Corporate Sponsors

Course Review

Flexibility- Self/Instructor paced

Pedagogy

This short-term course uses a self-paced online learning technique that encourages working professionals to study in a flexible schedule. It is for 4 hours, and the course curriculum is of intermediate level curated according to industry standards. The course curriculum is split into four modules. Further, the faculty of this course is a project lead for automated journalism at Swiss publisher Tamedia. Moreover, it is accessible both on desktop and mobile.

Industry Relevant Curriculum

Personalised or Dedicated Guidance and Mentoring

Discussion Forums / Instructor moderated

Course Accessibility- Mobile/Desktop

International Faculty

Hands-on training

Case Based Learning

Projects- Capstone, Industry-Simulation

Hands on training

Virtual Labs

Career impact

This self-paced course offers no placement guarantee, or internship opportunities but offers job assistance. It helps the freshers, professionals, and aspiring professionals from other non-technical backgrounds gain SQL skills that are valuable and relevant. The certification credibility adds value to the resume of the learners and helps grab the right job with a hike in salary. However, no mock sessions are conducted that help prepare for the interview.

Career Transition

CV & Interview Preparation

Job Impact

Pricing

The intermediate-level course is available on a subscription basis and is priced for ₹927, which is quite reasonable per industry standards. The benefits of this course, such as prestigious certification, subject matter expert faculty, and projects, explain the pricing. It also provides a discount to eligible learners. In the free version, learners get only access to the first chapter of the course and do not get the chance to earn certification.

Peer Average

Assessment

Assessments are an essential element of this self-paced short-duration program. It is a sort of theoretical training where working professionals learn by completing tasks. It allows learners to work on exercises that help gain practical knowledge. It includes 45 exercises and offers 13 videos to help learners understand all the core concepts. However, it does not include any comprehensive conventional exam.

Present/Absent

Project Based Grading

Assignments

Quizzes

DataCamp offers this online certification program to help professionals create relational databases. It helps professionals and freshers to advance their career trajectories. Moreover, it is achieved by teaching SQL database and relational databases skills. Furthermore, professionals learn to run ad hoc analyses on the new database by the end of this course. The curriculum is curated to industry standards. The prerequisites for enrolling in this program is completing the Introduction to SQL course. The course USPs are job assistance, instructor-moderated discussions and international faculty.

SQL is the most common way to query databases. Databases can also be used for other purposes. You can model many phenomena and their relationships. This will help you ensure your data is consistent and has a better structure. You will see this when you examine real data about questionable university affiliations. This will show you how databases can be used for your benefit column-by-column and table-by-table. You will learn how to create tables and relationships as well as how to maintain data integrity. You will also learn about constraints and other unique features.

Timo Grossenbacher

Introduction to Relational Databases in SQL by DataCamp is top course for Artificial Intelligence & Data Science. It is an Online course and is Paid

Introduction to Relational Databases in SQL | DataCamp

DataCamp

This course will show you how to create relational database. This is the best way to store data.

Introduction to Relational Databases in SQL

Module 1: Processing, Storing, and Organizing Data 1. OLTP and OLAP 2. OLAP vs. OLTP 3. Which is better? 4. Storing data 5. Name that data type! 6. Ordering ETL Tasks 7. Recommend a storage solution 8. Database design 9. Classifying data models 10. Deciding fact and dimension tables 11. Querying the dimensional modelModule 2: Database Schemas and Normalization 1. Star and snowflake schema 2. Running from star to snowflake 3. Adding foreign keys 4. Extending the book dimension 5. Normalized and denormalized databases 6. Querying the star schema 7. Querying the snowflake schema 8. Updating countries 9. Extending the snowflake schema 10. Normal forms 11. Converting to 1NF 12. Converting to 2NF 13. Converting to 3NFModule 3: Database Views 1. Database views 2. Tables vs. views 3. Viewing views 4. Creating and querying a view 5. Managing views 6. Creating a view from other views 7. Granting and revoking access 8. Updatable views 9. Redefining a view 10. Materialized views 11. Materialized versus non-materialized 12. Creating and refreshing a materialized view 13. Managing materialized viewsModule 4: Database Management 1. Database roles and access control 2. Create a role 3. GRANT privileges and ALTER attributes 4. Add a user role to a group role 5. Table partitioning 6. Reasons to partition 7. Partitioning and normalization 8. Creating vertical partitions 9. Creating horizontal partitions 10. Data integration 11. Data integration do's and dont's 12. Analyzing a data integration plan 13. Picking a Database Management System (DBMS) 14. SQL versus NoSQL 15. Choosing the right DBMS

A database is essential for high-performance applications. Before you begin building a house, it is important to think about where your data will be stored. This will save you time and reduce frustration later. It is easy to find and retrieve information from a well-designed database. When choosing a design, there are many factors to consider. This course will show you how to efficiently store, process, organize, and present data. This course will show you how to use normalization to organize data and how to present data using views. Learn how to manage your data. This knowledge can be applied to many datasets such as book sales, music reviews, car rentals, and car rentals.

Lis Sulmont

Database Design by DataCamp is top course for Information Technology. It is an Online course and is Paid

Database Design | DataCamp

Learn how to create SQL databases.

Database Design

Module 1: Chapter 1: Structure of PostgreSQL Databases 1. Creating a database 2. New database creation 3. Motivation for a new database 4. Creating tables 5. Name that table 6. Two tables and a foreign key connection 7. Creating schemas 8. User-level schemas 9. The public schema 10. Creating tables in existing schemasModule 2: Chapter 2: PostgreSQL Data Types 1. Introduction to PostgreSQL data types 2. Matching data representations and categories 3. Choosing data types at table creation 4. Defining text columns 5. Matching text types 6. SBA appeals table 7. Defining numeric data columns 8. Using integer types 9. Supporting an SBA marketing campaign 10. Defining boolean and temporal data columns 11. Revisiting the appeals table 12. Boolean defaults 13. Choosing data types representationsModule 3: Chapter 3: Database Normalization 1. The importance of data normalization 2. Reasons for normalizing databases 3. Reducing data redundancy 4. Improving object-to-data mapping 5. 1st Normal Form 6. Simplifying database records 7. Too much normalization 8. 2nd Normal Form 9. Designing a course table 10. Streamlining meal options 11. 3rd Normal Form 12. Identifying transitive dependencies 13. Table definitions for 3rd Normal Form 14. Working through the normalization processModule 4: Chapter 4: Access Control in PostgreSQL 1. Introduction to access control 2. Creating a new user 3. Updating user passwords 4. PostgreSQL access privileges 5. Granting user privileges 6. Using the granted privileges 7. Hierarchical access control 8. Working with users and groups 9. Schema privileges 10. Removing access 11. Removing user privileges 12. Rescinding group membership 13. Implementing access control for teams 14. Course wrap-up

You may be familiar with databases or have experienced the benefits of using databases to organize your data. Perhaps you have always wanted to manage your database yourself but thought that only database administrators could. It's not! It is possible to learn the skills and knowledge necessary to create and manage your own PostgreSQL databases. You will learn about PostgreSQL database structure and PostgreSQL datatypes. Normalization of databases is also covered to ensure data storage efficiency and data loss prevention. These topics will be covered using data from the U.S. Small Business Administration in order to guide the lessons and provide context.

Darryl Reeves Ph.D

Creating PostgreSQL Databases by DataCamp is top course for Artificial Intelligence & Data Science. It is an Online course and is Paid

Creating PostgreSQL Databases | DataCamp

This course will show you how to create and manage your own PostgreSQL database.

Creating PostgreSQL Databases

Module 1: Bringing Together the Data 1. All about joins 2. Where are all the athletes from 3. Using different joins to explore athletes' regions 4. What about the weather 5. Subqueries and common table expressions (cte) 6. Filtering to freezing with a subquery 7. Where winter is white 8. Countries with subqueries or CTEs 9. Working with temporary tables 10. Canadians temp table 11. Analyze that temp tableModule 2: Minimizing Results and Decreasing the Load 1. What you write is not what SQL sees 2. Order of operations impact on query structure 3. Group by and aggregations 4. Count and count distinct 5. Filtering in the WHERE clause 6. OR versus IN with athletes 7. Data type filters 8. EXPLAIN the filter query plan step 9. Filtering while joining 10. Where to place a region filter 11. Filtering in the join, where, and select 12. Aggregating with different data granularities 13. Aggregate before joining tables 14. South African trendsModule 3: Using Database Designed Properties 1. Queries and tables and views, oh my 2. Data loading and storage 3. Finding the table type 4. Row-oriented storage and partitions 5. Row-oriented storage properties 6. Previewing a row-oriented table 7. Partitioning on location 8. Using and creating indexes 9. Finding the database indexes 10. Creating and using an index 11. Compare runtimes 12. Using column-oriented storage 13. Column-oriented storage properties 14. Using the information schemaModule 4: Assessing Query Performance 1. Query lifecycle and the planner 2. Exploring pg_tables 3. Basic EXPLAIN 4. Index scans 5. EXPLAIN the WHERE 6. A deeper dive into EXPLAIN 7. EXPLAIN parameters 8. Aggregating and sorting populations 9. Joining in the query plan 10. Query structure and query execution 11. Subqueries vs. CTEs 12. Why the difference? 13. Filtering impacts 14. Congratulations

Do you waste time answering slow questions? Are you hesitant to share your questions and experiences with other experts? This course will show you how to speed up your PostgreSQL. By exploring interconnected data like country climate, Olympic participation, and gross domestic product, you will learn how query performance can be affected by changing filtering methods. You will learn all about row-oriented databases and how they affect air quality. Your efficiency and ability with the SQL order or query planner will impress your colleagues.

Amy McCarty

Improving Query Performance in PostgreSQL by DataCamp is top course for Artificial Intelligence & Data Science. It is an Online course and is Paid

Improving Query Performance in PostgreSQL | DataCamp

How to speed up your PostgreSQL queries

Improving Query Performance in PostgreSQL

Gain the foundational skills you need to be a confident, high-earning SQL database administrator. In this track, you’ll learn how to create, manage, and optimize your PostgreSQL database. Through real-world exercises you’ll write and run real-code in your browser as you learn how to use T-SQL syntax, DML triggers, and improve query performance, making sure that your database can scale as your business needs grow.