Curs SQL Programming

Durata curs: 40 ore
Format: Online - Live cu instructor sau la sediul clientului
Pretul include: diploma de participare si suportul de curs, in format electronic
Pretul nu include TVA.

De ce sa alegeti cursurile noastre?

Experienta de peste 28 de ani in domeniul instruirii profesionale.
Traineri certificati national si international.
Flexibilitate: cursuri online sau la sediul clientului, oriunde in tara.
Discount-uri negociabile pentru volume mari.
Cursurile pot fi personalizate in functie de nevoile companiei si pot fi desfasurate online sau la sediul beneficiarului.
Solicitati o oferta personalizata, pentru angajatii companiei dumneavoastra! EMAIL  office@promanagement.ro

Plan De Curs

1.Oracle database concepts
•Database terminology
•Database Management System
•Database system types
•Database software
2.Oracle database design
•System analysis
•Database design requirements
•Data modeling
•Understand relational structures
•Basic data relationship, ERD
•Normalization
•Relational paradigm
•Introducing SQL
•Set-oriented vs procedural languages
•SQL standards
•SQL commands
•SQL commonly-used client tools
•Demonstration schemas
3.Basic SQL Statements
•Basic syntax of SQL SELECT statements
•Choosing columns; column aliases
•Concatenation operator
•SQL arithmetic operators
•Operator precedence and parenthesis
•Importance of nulls and retrieval: third-value logic
•Pseudo-columns and ‘dual’ table
•Data dictionary
4.Limiting rows retrieved - why we do it?
•Comparison conditions
•Using logical conditions
•LIKE/REGEXP_LIKE for pattern matching conditions
•Using BETWEEN, IN and EXISTS conditions
•Removing duplicates from the result set (DISTINCT)
•Sorting data using ORDER BY clause
5.Table Joins -Joining data from multiple tables
•How the Optimizer executes join statements
•Join types
•Set operators
6.Nested SQL queries-Using Subqueries
•Type of subqueries; need for using them
•Scalar subqueries
•Nested and correlated subqueries/Subquery unnesting
•Inline views and factored subqueries
•Hierarchical queries
7.SQL functions (part I)
•SQL functions overview
•Character functions, returning number values
•Character functions, returning character values
•Nested functions
•Number functions
•Date functions; date & time calculations
•Timestamp functions
•NULL related functions
•Conditional retrieval functions
•Datatype conversion functions
•Other functions
8.SQL functions (part II)
•SQL multi-row functions considerations
•SQL multi-row functions
•Concept of grouping data
•GROUP BY clause
•Row group exclusion: HAVING clause
•Nested aggregate functions
•Other SQL multi-row functions
•SQL clauses: all together now
9.Oracle analytical functions
•Overview of SQL for analysis and reporting
•Analytical function types
•Concepts for analytical functions
•Anatomy of analytical functions
•Categories of analytical functions
•Usual analytical functions
•Other analytical functions