Plan du cours
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
Pré requis
- Computer literacy
- Knowledge of any operating system
Nos Clients témoignent (11)
La façon dont le formateur a tout démontré
Manveen - Tribal Grou[
Formation - Developing Applications with Oracle Application Express (APEX)
Traduction automatique
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Formation - Oracle SQL Language
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
Formation - Oracle 11g - SQL language for developers - Workshop
Apprendre certaines fonctionnalités
Henri Gobert - NSI IT Software & Services
Formation - Oracle 11g - Programming with PL / SQL II
Pendant la formation, tous les modules ont été couverts en détail - pendant deux jours de formation - et c'est ce qui m'intéressait le plus.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Formation - SQL Advanced
Traduction automatique
Lot of content and exactly the requested one.
Pascal - Diehl
Formation - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Formation - 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
Formation - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
J'ai apprécié l'étendue des connaissances de Folio. Non seulement il connaissait le contenu du cours, mais il connaissait aussi des constructions dans des langages qui nous étaient familiers afin de rendre les exemples plus significatifs pour nous. Pendant les intervalles, il a partagé sa connaissance des technologies et des solutions en dehors du cadre de la formation pour nous donner un aperçu d'autres solutions que nous pourrions utiliser à l'avenir (et lors de futures formations).
Raphael - Markit Valuations Limited
Formation - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
Traduction automatique
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Formation - ORACLE PL/SQL Fundamentals
Les exercices sont divertissants et les sujets sont bien introduits.
Adrian-Madalin Chirita - DB Global Technology SRL
Formation - Oracle SQL Advanced
Traduction automatique