課程簡介
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
最低要求
- Computer literacy
- Knowledge of any operating system
客戶評論 (9)
這個話題很有趣,培訓師非常友好,對這個主題有嫻熟的瞭解。
Jacqueline - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
機器翻譯
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
在培訓期間,所有模組都進行了非常詳細的討論 - 為期兩天的培訓 - 這是我最想要的。
Bernadetta - Urząd Komisji Nadzoru Finansowego
Course - SQL Advanced
機器翻譯
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Course - 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
Course - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
我很欣賞 Folio 的廣泛知識。 他不僅熟悉課程內容,而且還知道我們熟悉的語言的結構,以使示例對我們更有意義。 在間歇期間,他分享了他在培訓範圍之外的技術和解決方案的知識,以提供對我們在未來(和未來培訓)中可以使用的其他解決方案的見解。
Raphael - Markit Valuations Limited
Course - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
機器翻譯
the practices and the trainer notes