Hvala što ste poslali upit! Jedan od naših članova tima će vas uskoro kontaktirati.
Hvala što ste poslali rezervaciju! Jedan od naših članova tima će vas uskoro kontaktirati.
Trajanje 14 sati
Sadržaj kursa
Revision of SQL Fundamentals
- Refresher on SELECT, WHERE, and GROUP BY
- Overview of various JOIN types
- Clarification of query execution sequences
Data Manipulation Operations
- INSERT INTO statements
- UPDATE and DELETE operations
- Managing transactions with BEGIN, COMMIT, and ROLLBACK
Complex Joins and Set Logic
- FULL OUTER JOIN implementations
- Using UNION, INTERSECT, and EXCEPT
- Applying SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries into FROM clauses
- Utilizing CTEs (Common Table Expressions)
Application of Window Functions
- Using ROW_NUMBER, RANK, and DENSE_RANK
- Leveraging PARTITION BY and ORDER BY
- Employing LEAD and LAG functions
Data Typing and Functional Operations
- Handling string and date functions
- Using CASE and IF logic
- Managing type conversions and null values
Optimizing Query Performance
- Analyzing the role of indexes
- Interpreting EXPLAIN outputs
- Adhering to best practices for efficient query design
Conclusion and Future Pathways
Uslovi
- Osnovno znanje SQL SELECT upita
- Iskustvo u filtriranju, sortiranju i jednostavnim spajanjima (joins)
- Razumevanje koncepta relacionih baza podataka
Publika
- Analitičari podataka
- Razvojni programeri koji rade sa SQL bazama podataka
- Profesionalci za poslovnu inteligenciju
Iskustva korisnika (1)
Potrebno mi je više samostalnog učenja i vežbi da bih usavršio svoje veštine
Alvin Wilta - PT LENTERA DANA NUSANTARA
Kurs - SQL Intermediate
Mašinski prevedeno
