Engineering and Technology
Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.
Learn how to effectively create and manage your own databases with the PostgreSQL Create Database Function. This comprehensive course is designed to empower individuals with the skills and knowledge necessary to take control of their database management. Starting with the basics, you will explore the structure of PostgreSQL databases, including databases, tables, and schemas, and how they fit into the PostgreSQL object hierarchy. Additionally, you will gain a deep understanding of PostgreSQL data types, such as text, numeric, temporal, and boolean data, and learn when to use each type appropriately. Furthermore, you will delve into the concept of database normalization, which plays a crucial role in maintaining data integrity and reducing duplication. By implementing normalization techniques, you will enhance data consistency and organization within your databases. To ensure a practical learning experience, this course incorporates real data from the U.S. Small Business Administration (SBA), providing context and relevance to the concepts covered. Lastly, you will explore PostgreSQL access control, equipping you with the knowledge to safeguard your databases from unauthorized access. Upon completion of this PostgreSQL training, you will have the confidence and expertise to independently create and manage your own databases using PostgreSQL.
by DataCamp
Learn how to create a PostgreSQL database and explore the structure, data types, and how to normaliz...
by DataCamp
Ensure data consistency by learning how to use transactions and handle errors in concurrent environm...
by DataCamp
Dashboards are a must-have in a data-driven world. Increase your impact on business performance with...
by DataCamp
Learn to create interactive dashboards with R using the powerful shinydashboard package. Create dyna...
by DataCamp
Create and share your own R Packages!
by DataCamp
Use Seaborn's sophisticated visualization tools to make beautiful, informative visualizations with e...
by DataCamp
Level up your data science skills by creating visualizations using Matplotlib and manipulating DataF...
by DataCamp
Learn how to build interactive and insight-rich dashboards with Dash and Plotly.
by DataCamp
In this interactive course, you’ll learn how to use functions for your Tableau calculations and when...
by DataCamp
Learn to use facets, coordinate systems and statistics in ggplot2 to create meaningful explanatory p...