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
Insert, update, and delete data
- INSERT command
- Copy data from another table
- UPDATE command
- DELETE command
- TRUNCATE command
Transactions
- Commands COMMIT, ROLLBACK, and SAVEPOINT
DDL commands
- The main database objects
- Rules for naming objects
- Creating tables
- The data types available for columns
- DEFAULT option
- Option NULL and NOT NULL
Managing tables
- Referential integrity CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE
- Create a table by the query
- Delete a table DROP TABLE
- DESCRIBE command
Other schema objects
- Sequences
- Synonyms
- Views
Requirements
- Computer literacy
- Knowledge of any operating system
Testimonials
individual and patient approach to each question / problem and understandable explanation / translation / solution
Grzegorz Krzeczek
Possibility to ask questions, adjust the pace to the needs, focus on those elements that from the participants' point of view are the most interesting / needed / difficult.
Aleksandra Wójtowicz
Communicativeness, broad subject knowledge, openness to questions beyond the training program
Michał Woźny
practical
Andrzej Kozak
a lot of exercise
Łukasz Dziewiński
exercises
Mateusz Wilk
exercise.
Marzena Marciniak - Bakoma Sp. z o. o.
Exercises :).
Monika Lewalska - Bakoma Sp. z o. o.
Substantive and very easy transfer of information.
Piotr Polański - Bakoma Sp. z o. o.
way of conducting and the knowledge of the trainer and the method of its transfer.
Grzegorz Cimochowski - Zakłady Produkcyjno-Usługowe "PRAWDA" sp. z o.o.
Exercises :).
Katarzyna Gędziorowska - Bakoma Sp. z o. o.
Loose relationships, answering every question, dreaming of incomprehensible issues.
Bakoma Sp. z o. o.
I have no comments.
Bakoma Sp. z o. o.
The exercise
Federal Demographic Council
the exercises
Amna AlAli - Federal Demographic Council
The explanation are very clear and the exercises help understand better
Federal Demographic Council
Clear