Bancos de dados relacionais e SQL
Master relational databases! Essential for learning any SQL language. Build a strong foundation for data management and querying.
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
SELECTandWHEREclauses to retrieve specific data. - Data Grouping: Learn to aggregate data using
GROUP BYandHAVINGclauses. - Joins: Master different types of joins –
INNER JOIN,LEFT JOIN,RIGHT JOIN, andCROSS 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!
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.