Udemyintermediatept

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.

4.5(428)
2,048students
26h 51m
Certificate
Neri Neitzke
Neri NeitzkeProgramador

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 database and establish your data foundation.
  • Table Design: Understand create table with a focus on avoiding data redundancy.
  • Data Insertion: Master insert into table to populate tables with values.
  • Data Retrieval: Utilize select statements 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, and Distinct for precise data selection.
  • Primary & Foreign Keys: Implement primary key (simple and composite) and foreign key constraints for data integrity and relationships between tables.
  • Data Modification: Learn to update and delete data within tables.
  • Data Removal: Use truncate to completely remove records from tables.
  • Aggregate Functions: Calculate avg (average), count (record count), sum (total), min (minimum), and max (maximum) values.
  • String Manipulation: Employ upper and lower for case conversion and learn to concatenate strings across all 5 databases.
  • Indexing: Optimize query performance with index creation.
  • Data Grouping: Aggregate data using group by.
  • Data Union: Combine result sets using union and union all.
  • Data Persistence: Understand commit for permanent data storage.
  • Auto-Increment: Automate ID generation with auto incremento.
  • Triggers, Generators & Domains: Implement advanced database features with Trigger, Generator and Domain, Check.
  • Data Restriction: Use Having to apply filtering conditions.
  • Multi-Table Queries: Learn to join data 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.

$ 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.

Aprenda Internet Avançado

by Lauro Cesar Bagnoli Serrano

5.0(12)
1h 40m
all
5.0(5)
1h 31m
beginner

Elasticsearch e ORANGE Data Science - Descoberta de Dados

by MSc Grimaldo Lopes | + 60.000 alunos de Oliveira

5.0(77)
9h 32m
all
5.0(83)
9h 13m
all
5.0(16)
1h 26m
all