Aprenda Banco de Dados, SQL e Modelagem em 186 videoaulas
Learn SQL and database management! Master Oracle, Firebird, MySQL, PostgreSQL, and SQL Server. Includes database modeling.
Course Content
Aprenda Banco de Dados, SQL e Modelagem em 186 videoaulas is an intermediate-level Udemy course taught by Neri Neitzke. It runs 26h 51m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 428 reviews, with 2,048 students enrolled. It is a paid course, first published September 2015.
Explore a comprehensive course covering database management with 186 video lessons! Master essential skills for working with popular database systems including Oracle, Firebird, MySQL, PostgreSQL, and SQL Server. This course delves into SQL, the standard language for data manipulation, and database modeling techniques.
SQL Fundamentals:
- Database Creation: Learn to
create databaseand establish your data foundation. - Table Design: Understand
create tablewith a focus on avoiding data redundancy. - Data Insertion: Master
insert into tableto populate tables with values. - Data Retrieval: Utilize
selectstatements to effectively query data from tables. - Filtering with
where: Apply conditions to refine your searches. - Sorting with
order by: Organize query results for easy analysis. - Data Filtering with
like: Efficiently filter data based on patterns. - Logical Operators: Utilize operators like
=,>,>=,Between,In, andDistinctfor precise data selection. - Primary & Foreign Keys: Implement
primary key(simple and composite) andforeign keyconstraints for data integrity and relationships between tables. - Data Modification: Learn to
updateanddeletedata within tables. - Data Removal: Use
truncateto completely remove records from tables. - Aggregate Functions: Calculate
avg(average),count(record count),sum(total),min(minimum), andmax(maximum) values. - String Manipulation: Employ
upperandlowerfor case conversion and learn toconcatenatestrings across all 5 databases. - Indexing: Optimize query performance with
indexcreation. - Data Grouping: Aggregate data using
group by. - Data Union: Combine result sets using
unionandunion all. - Data Persistence: Understand
commitfor permanent data storage. - Auto-Increment: Automate ID generation with
auto incremento. - Triggers, Generators & Domains: Implement advanced database features with
Trigger,GeneratorandDomain,Check. - Data Restriction: Use
Havingto apply filtering conditions. - Multi-Table Queries: Learn to
joindata from multiple tables.
Database Modeling:
This section focuses on analyzing and modeling a complete database for course management. You'll learn to model data for students, teachers, classes, enrollments, and payments, utilizing specialized software tools. Gain practical skills in database design and structure.
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.