Scribd
Upload
30 views2 pages

Roadmap para Estudar SQL

The document outlines a comprehensive roadmap for studying SQL, divided into three levels: basic, intermediate, and advanced. It covers essential topics such as database design, queries, constraints, joins, and advanced functions. Each section provides a structured approach to mastering SQL concepts and techniques.

Uploaded by

Rico Silva
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
30 views2 pages

Roadmap para Estudar SQL

The document outlines a comprehensive roadmap for studying SQL, divided into three levels: basic, intermediate, and advanced. It covers essential topics such as database design, queries, constraints, joins, and advanced functions. Each section provides a structured approach to mastering SQL concepts and techniques.

Uploaded by

Rico Silva
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Roadmap para estudar SQL

Aprenda o básico do SQL


- Relational Database Management System (RDBMS)
- Database design - Entity Relationship Diagram (ERD)
- Primary key
- Foreign key
- Data Types
- Operators
- Expressions
- Create Database
- Drop Database
- Select Database
- Create Table
- Drop Table
- Insert Query
- Select Query
- Where Clause
- AND & OR Clauses
- Update Query
- Delete Query
- Like Clause
- Top Clause
- Order By
- Group By
- Distinct Keyword
- Sorting Results
Aprenda SQL Intermediário
- Constraints
- Table joins
- NULL values
- Alias syntax
- Indexes
- Alter Command
- Truncate Table
- Using Views
- Having clause
- Transactions
- Wildcards
- Date functions
- Temporary tables
- Clone tables
- Using Sequences
- Handling duplicates
- Injection

Aprenda SQL Avançado


- Subqueries
- Set operations (UNION, UNION ALL, INTERSECT, MINUS)
- GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS)
- Window functions
- PARTITION BY
- Recursive Queries

You might also like