courseraIT и технологии

SQL for Any IT Professional: Unit 4

Курс от Pearson

Средний≈ 7 чАнглийский

О курсе

This course is for individuals who want to turn their data into useful insights and gain an advantage in today's data-focused world. You'll start by learning advanced query techniques, such as subqueries and compound queries, to make the most of your data. Then, you'll move on to creating and managing views, which will help you analyze data from different angles and improve query performance. You'll also learn about database management, including schema management and user privileges, to maintain data integrity and security. The course includes hands-on exercises with our database to reinforce your skills and prepare you for real-world applications. By the end, you'll be able to design, query, and manage databases effectively.

Навыки, которые вы освоите

Database Management SQL Data Integrity Relational Databases Database Design Database Development Data Access User Accounts Query Languages Databases Database Management Systems Data Analysis Data Manipulation Database Architecture and Administration

Программа курса

1 модулей · 29 учебных материалов

01Advanced Query Options and Database Security29 материалов

Create Advanced Queries to Get More out of Your Data

Learning objectivesВидео Understand subqueriesВидео Create subqueries to drill down furtherВидео Explore the concept of compound queriesВидео Use compound queries to merge data sets

Учитесь у экспертов

Pearson

Преподаватель курса

SQL for Any IT Professional: Unit 4

О курсе

Навыки, которые вы освоите

Программа курса

Create Advanced Queries to Get More out of Your Data

Учитесь у экспертов

Pearson

Create Views to Expand the Capability of Your Database

Manage Database Users and Security

Take Your SQL Journey to the Next Level

Summary