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
Testimonials (11)
Μου αρέσει αυτή η εκπαίδευση γιατί ήταν διαδραστική
Amalia - Banca Transilvania
Course - SQL Fundamentals
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Μου άρεσε πολύ ο ρυθμός της προπόνησης και οι ασκήσεις που δίνονται ανάμεσα στις επεξηγήσεις
Trana
Course - SQL in SQL Server
Machine Translated
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
Μου άρεσε η ισορροπία των διαλέξεων και των ασκήσεων. Όταν ήμουν κολλημένος, ο Λουκ ήταν πολύ καλός στο να με βοήθησε να κατανοήσω το πρόβλημα και να εργαστώ για λύσεις που είχαν πραγματικά θετικό αντίκτυπο στην κατανόησή μου.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Machine Translated
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
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
Μου άρεσε ο τρόπος που ο εκπαιδευτής εξήγησε τις πληροφορίες για τα θέματα και το γεγονός ότι έδινε προσοχή στις λεπτομέρειες, ώστε τα μαθήματα να είναι πολύ πρακτικά και λογικά.
Andreea
Course - Oracle SQL for beginners
Machine Translated
Οι ασκήσεις είναι διασκεδαστικές και τα θέματα εισήχθησαν όμορφα.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
Machine Translated