Course Outline
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
Requirements
- Computer literacy
- Knowledge of any operating system
Getuigenissen (10)
Henri Gobert - NSI IT Software & Services
Cursus - Oracle 11g - Programming with PL / SQL II
De manier waarop de trainer alles demonstreerde
Manveen - Tribal Grou[
Cursus - Developing Applications with Oracle Application Express (APEX)
Machine Translated
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Cursus - Oracle SQL Language
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
Cursus - Oracle 11g - SQL language for developers - Workshop
Tijdens de training werden alle modules tot in detail besproken - voor twee dagen training - en dit was wat ik het liefste wilde.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Cursus - SQL Advanced
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
Cursus - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Cursus - 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
Cursus - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
Ik waardeerde de brede kennis van Folio. Hij was niet alleen bekend met de inhoud van de cursus, maar hij kende ook constructies in talen die we kenden om voorbeelden betekenisvoller voor ons te maken. Tijdens intervallen deelde hij zijn kennis van technologieën en oplossingen buiten het trainingsbereik om inzicht te geven in andere oplossingen die we in de toekomst (en toekomstige trainingen) zouden kunnen gebruiken.
Raphael - Markit Valuations Limited
Cursus - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
Machine Translated
the practices and the trainer notes