Programa del Curso
Relational database models
- The structure of a relational database
- Connection types of tables
- The normalization and denormalization database
- Relational Operators
Download the data
- Rules for writing SQL queries
- The syntax for the SELECT
- Selecting all columns
- Inquiries from arithmetic operations
- Aliases columns
- Literals
- Concatenation operator
Limiting results
- The WHERE clause
- Comparison operators
- LIKE Condition
- Prerequisite BETWEEN ... AND
- IS NULL condition
- Condition IN
- Boolean operators AND, OR and NOT
- Many of the conditions in the WHERE clause
- The order of the operators.
- DISTINCT clause
Sorting Data
- The ORDER BY clause
- Sorting by multiple columns or expressions
SQL functions
- The differences between the functions of one and multilines
- Features text, numeric, date,
- Explicit and implicit conversion
- Conversion functions
- Nesting functions
- Viewing the performance of the functions - dual table
- Getting the current date function SYSDATE
- Handling of NULL values
Aggregating data using the grouping
- Grouping functions
- How grouping functions treat NULL values
- Create groups of data - the GROUP BY clause
- Grouping multiple columns
- Limiting the function result grouping - the HAVING clause
Retrieving data from multiple tables
- Types of connectors
- The use NATURAL JOIN
- Aliases tables
- Joins in the WHERE clause
- INNER JOIN Inner join
- External Merge LEFT, RIGHT, FULL OUTER JOIN
- Cartesian product
Subqueries
- Place subqueries in the SELECT command
- Subqueries single and multi-lineage
- Operators Subqueries single-line
- Features grouping in subquery
- Operators Subqueries multi-IN, ALL, ANY
- How NULL values are treated in subqueries
Operators collective
- UNION operator
- UNION ALL operator
- INTERSECT operator
- MINUS operator
Requerimientos
- Computer literacy
- Knowledge of any operating system
Testimonios (9)
La forma en que el entrenador demostró todo
Manveen - Tribal Grou[
Curso - Developing Applications with Oracle Application Express (APEX)
Traducción Automática
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Curso - Oracle SQL Language
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
Curso - Oracle 11g - SQL language for developers - Workshop
Durante la capacitación, todos los módulos se discutieron con gran detalle, durante dos días de capacitación, y esto era lo que más deseaba.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Curso - SQL Advanced
Traducción Automática
Lot of content and exactly the requested one.
Pascal - Diehl
Curso - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Curso - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
I liked that he had actual know how of when to use each technology, that's valuable.
Radu Mazilu - eMAG IT Research
Curso - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
Aprecié la amplia gama de conocimientos de Folio. No solo estaba familiarizado con el contenido del curso, sino que también conocía las construcciones en idiomas con los que estábamos familiarizados para hacer que los ejemplos fueran más significativos para nosotros. Durante los intervalos, compartió su conocimiento de tecnologías y soluciones fuera del alcance de la capacitación para proporcionar información sobre otras soluciones que podríamos usar en el futuro (y en futuras capacitaciones).
Raphael - Markit Valuations Limited
Curso - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
Traducción Automática
the practices and the trainer notes