Udemybeginnerpt

Bancos de dados relacionais e SQL

Master relational databases! Essential for learning any SQL language. Build a strong foundation for data management and querying.

4.5(4)
17students
5h 29m
Certificate
Leonardo Assuane Duarte
Leonardo Assuane DuarteMsc. em Ciências da Computação

Course Content

Bancos de dados relacionais e SQL is a beginner-level Udemy course taught by Leonardo Assuane Duarte. It runs 5h 29m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 4 reviews, with 17 students enrolled. It is a paid course, first published June 2020.

Explore the fundamentals of relational databases with this beginner-friendly course! Learn how to effectively organize and manage data using a powerful structure of tables, rows, and columns. This course provides a solid foundation in database concepts, making it easier to learn any SQL programming language.

We focus on core principles and the ISO standard, rather than a specific SQL dialect, ensuring a versatile understanding. You'll gain a strong grasp of database design and management, preparing you for advanced database applications.

Here's what you'll learn:

  • Relational Database Concepts: Understand the core principles behind relational database systems.
  • Database Creation: Learn how to create and structure your own databases.
  • Tables & Data Types: Master the creation of tables and the appropriate use of various data types.
  • Indexing & Performance Tuning: Discover techniques to optimize database performance with indexes.
  • Referential Integrity: Implement data integrity using primary keys, foreign keys, check constraints, unique constraints, and default values.
  • Data Selection & Filtering: Become proficient in using SELECT and WHERE clauses to retrieve specific data.
  • Data Grouping: Learn to aggregate data using GROUP BY and HAVING clauses.
  • Joins: Master different types of joins – INNER JOIN, LEFT JOIN, RIGHT JOIN, and CROSS JOIN – to combine data from multiple tables.
  • Subqueries: Utilize subqueries for complex data retrieval.
  • Data Modification: Learn to insert, update, and delete data efficiently.
  • Metadata Querying: Understand how to query database metadata.
  • Data Recovery Objects: Program objects like views, functions, stored procedures, and triggers for enhanced data access.
  • Advanced Techniques: Explore advanced database concepts and techniques.

Prerequisites: A foundational understanding of Programming Logic is required. This course serves as a crucial prerequisite for all programming courses, including other database courses offered by Escola Para.TI. Start your journey into the world of data management today!

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

Databricks Delta Lake + METABASE: visualização e dados

by MSc Grimaldo Lopes | + 60.000 alunos de Oliveira

5.0(19)
5h
beginner
5.0(42)
12h 46m
beginner
5.0(139)
3h 33m
beginner
5.0(4)
59m
all