0
Views
SQL for beginners: from scratch to Oracle certificate - course RUB 1,350. from Stepik, training 158 lessons, Date: October 29, 2023.
Miscellaneous / / December 06, 2023
Hello friends!
I created this course based on numerous requests from students, because these days SQL is needed almost everywhere. Many people work with information, and it must be processed somehow.
So, who is my video course intended for?
The course is perfect for super beginners who have no idea what SQL is.
And also the course will undoubtedly be appreciated by people who already have some idea of SQL. Believe me, you will definitely learn a lot of new things, regardless of your existing knowledge.
And a very, very nice bonus of this course. It will fully prepare you to take the Oracle exam. The certificate of this organization is recognized throughout the world and proves your qualifications. And it often plays a significant role in employment.
The most important thing is that you absolutely do not need to use additional literature to prepare for the exam. Everything you need to know is already in this video course.
The methodology and structure of the course are such that I explain all the topics using simple examples that are understandable even to beginners.
And, of course, the course contains a lot of practical material. After all, SQL is primarily a practice. After each group of interrelated topics, I assign homework that you will have to do on your own, and we will check it in the next lesson.
I also pay special attention to feedback. I am always willing to communicate with my students and answer their questions.
All you need to know to successfully study in this course is only 7th grade level mathematics and NOTHING else.
See you soon friends and happy studying!
Zaur Tregulov
3
courseHi all! My name is Zaur Tregulov. I graduated from the Faculty of Cybernetics and have been programming for over 9 years. But the most important thing is that I started teaching much earlier.
Hi all! My name is Zaur Tregulov. I graduated from the Faculty of Cybernetics and have been programming for over 9 years. But the most important thing is that I started teaching much earlier. Already during my student years, I taught mathematics to schoolchildren and prepared them for entering universities. It was then that the basic principles of my teaching methodology were formed: 1) everything should be explained using simple examples (most often from life) 2) the material must be explained completely (without any gaps) And it is this technique that allows my students to understand the whole essence of what is being studied subject. I am sure that the courses will bring you a lot of benefit, and you will be satisfied with them. Happy learning!
Timur Tregulov
3
courseI am working on distance learning methods that make learning English easier.
I have been teaching for 18 of my 38 years. I started this activity while studying in the first year of the Faculty of Philology (English Language and Literature). I have experience in private and corporate teaching of English, Conversation Club, conducting oral and written translations. Since May 2014, I have been a certified specialist in the field of Communications from the London School of Business and Finance.
Introduction to SQL
1. Introduction to the course
2. Installing SQL Developer for everyone and Data Base for Windows 64-bit
3. Installing Data Base for everyone
4. Databases, tables, normalization
5. Introduction to HR scheme
6. SQL commands
7. Data types and the concept of NULL
8. DESCRIBE command
9. Homework analysis
Introduction to SELECT
1. Our first SELECT
2. DISTINCT operator
3. Some rules and tips
4. Expressions in SELECT LIST part 1
5. Expressions in SELECT LIST part 2, ALIAS
6. Table DUAL, Operator q
7. Homework analysis
Selection, operators, ORDER BY
1. Selection, WHERE (
2. Mathematical Comparison Operators
3. BETWEEN, IN, IS NULL
4. LIKE
5. AND
6. OR
7. NOT
8. Operator priority
9. ORDER BY part 1
10. ORDER BY part 2
11. Homework analysis
SINGLE-ROW functions
1. Types of functions
2. LOWER
3. UPPER
4. INITCAP
5. CONCAT
6. LENGTH
7. LPAD and RPAD
8. TRIM
9. INSTR
10. SUBSTR
11. REPLACE
12. ROUND (for number)
13. TRUNC (for number)
14. MOD
15. Introduction to DATE Functions
16. SYSDATE
17. MONTHS_BETWEEN
18. ADD_MONTHS
19. NEXT_DAY
20. LAST_DAY
21. ROUND (for date)
22. TRUNC (for date)
23. Homework analysis
CONVERSION, GENERAL and CONDITIONAL functions
1. Introduction to CONVERSION functions
2. TO_CHAR (for number)
3. TO_CHAR (for date)
4. TO_DATE
5. TO_NUMBER
6. Nested single-row functions
7. NVL
8. NVL2
9. NULLIF
10. COALESCE
11. DECODE
12. Simple CASE
13. Searched CASE
14. Homework analysis
GROUP functions, ORDER BY, HAVING
1. Introduction to GROUP functions
2. COUNT
3. SUM
4. AVG
5. MAX and MIN
6. Introduction to GROUP BY
7. GROUP BY part 1
8. GROUP BY part 2
9. HAVING
10. Nested group functions
11. Homework analysis
JOIN (join)
1. Introduction to JOIN
2. NATURAL JOIN
3. JOIN USING
4. JOIN ON (/lesson/695705?unit=695512)
5. Examples for joining more than 2 tables
6. NONEQUIJOIN
7. SELF JOIN
8. Introduction to OUTER JOIN
9. LEFT OUTER JOIN
10. RIGHT OUTER JOIN
11. FULL OUTER JOIN
12. CROSS JOIN
13. Oracle JOIN syntax
14. Homework analysis
SUBQUERY (subquery)
1. Introduction to SUBQUERY
2. SINGLE-ROW SUBQUERY
3. MULTIPLE-ROW SUBQUERY
4. CORRELATED SUBQUERY
5. Examples for subqueries
6. Homework analysis
SET operators (set operators)
1. Introduction to SET Operators
2. UNION ALL
3. UNION
4. INTERSECT
5. MINUS
6. Examples on SET operators
7. Homework analysis
DML commands
1. Introduction to DML
2. Simple INSERT (/lesson/695730?unit=695537)
3. INSERT using functions
4. INSERT using SUBQUERY
5. INSERT into multiple tables
6. Errors when using DML
7. Simple UPDATE
8. UPDATE using SUBQUERY
9. Simple DELETE
10. DELETE using SUBQUERY
11. MERGE
12. ACID principles
13. Introduction to Transactions
14. COMMIT
15. ROLLBACK
16. SAVEPOINT
17. AUTOCOMMIT
18. SELECT FOR UPDATE
19. Homework analysis
DDL part 1. Working with tables
1. Database Objects
2. USER and SCHEMA concepts
3. Rules for naming objects and the concept of NAMESPACE (/lesson/695750?unit=695557)
4. Data Types (Advanced)
5. Easily create tables CREATE TABLE
6. Creating tables using SUBQUERY
7. Changing tables ALTER TABLE
8. Emptying TRUNCATE TABLE tables
9. Dropping tables DROP TABLE
10. Homework analysis
DDL part 2. Concepts of CONSTRAINT and INDEX
1. Introduction to CONSTRAINT
2. UNIQUE CONSTRAINT
3. NOT NULL CONSTRAINT (/lesson/695760?unit=695567)
4. PRIMARY KEY CONSTRAINT
5. FOREIGN KEY CONSTRAINT
6. ON DELETE options for FOREIGN KEY
7. CHECK CONSTRAINT
8. Introduction to INDEX
9. INDEX B-TREE part 1 (/lesson/695766?unit=695573)
10. INDEX B-TREE part 2
11. INDEX BITMAP
12. Homework analysis
DDL part 3. VIEW, SYNONYM, SEQUENCE
1. Introduction to VIEW
2. Simple and Complex VIEW
3. Creating CREATE VIEW (/lesson/695772?unit=695579)
4. Changing ALTER VIEW and deleting DROP VIEW
5. SYNONYM
6. Introduction to SEQUENCE
7. Working with SEQUENCE part 1
8. Working with SEQUENCE part 2
9. Homework analysis
Miscellaneous
1. SINGLE AMPERSAND SUBSTITUTION (&) (/lesson/695779?unit=695586)
2. DOUBLE AMPERSAND SUBSTITUTION (&&)
3. DEFINE and UNDEFINE
4. VERIFY
5. Homework analysis
6. Registration for the exam
Subscribe
YOU MIGHT ALSO LIKE
-
-
-
19/12/2019