0
Views
SQL developer - free course from Skillbox, training, Date: November 29, 2023.
Miscellaneous / / December 05, 2023
For those new to programming
Become familiar with the SQL language and understand how databases work. Learn to manage data and work with SQL analytical functions. Develop your first corporate service and prepare for the start of a successful programming career.
Technical support specialists
Learn to optimize SQL queries and automate routine tasks using PL/SQL. With your new skills, you can qualify for a higher salary or move into a position as a database developer.
Junior developers
SQL skills are one of the key skills for any programmer. You will become familiar with the PL/SQL dialect, learn how to write complex queries and design reliable databases. Expand your range of skills and be able to take on more expensive projects.
Has been developing databases for more than 6 years. Works on creating data pipelines, data processing services and web services for reporting at Tochka Bank.
Introduction
Learn what databases are and why they are needed. Learn to create your own data structures, install an Oracle server. Get introduced to the Oracle Apex tool and use it to create applications and visualize data.
First steps in SQL
Explore advanced Apex capabilities, become familiar with basic SQL statements, and write your first database queries.
Aggregate functions
Learn to summarize data, calculate the average, and determine the number of rows using the functions sum, avg, count, and more.
Aggregate functions by analytical cuts
Continue exploring functions: learn how to calculate minimum and maximum values, group and filter data using the functions max, min, distinct, having and more.
Analytical functions
Get acquainted with analytical functions using row_number() and lead/lag as examples. You will be able to apply analytical functions by group and select data from the “window”.
Data merging
Learn to combine and subtract data sets, join tables, and enrich data.
Joining tables
Learn how to join multiple tables and work with normalized views of data.
Data types
Learn what data types exist, when to use them, and how to convert them.
Database Objects
Get acquainted with database objects, learn how to distribute data into roles, create schemas and present data in a user-friendly form.
Changing data
You will learn how to create, change, delete data or cancel an action if you accidentally deleted something unnecessary.
Partitioning and Query Plan
Learn how to break a large table into manageable sections and learn how to work with the data inside them. Become familiar with the Oracle optimizer and be able to check and modify your query plan.
The simplest blocks
You will understand the procedural extension of PL/SQL, learn how to write anonymous blocks and display information on the screen. Become familiar with if/else branch statements and write your first anonymous branch block.
Cycles
You will learn how to record and store information in variables, how to automate routine work, and learn how to work with for and while loops.
Types of PL/SQL objects
Learn to create and call procedures and functions, pass and receive parameters, and create packages.
Using PL/SQL
Understand system and user exceptions and learn how to handle them. Learn how to work with cursors and work around DDL startup errors.
PL/SQL tables
Learn to add and transform data into collections and work with pipeline functions. Learn how to process large data objects (CLOBs).
FatikhovSZ
08.10.2022 G.
Review
The learning goal has been achieved - knowledge and skills have been acquired
Advantages: Accessible and understandable material with excellent presentation. Disadvantages: The wording of some tasks is not entirely clear. My main job is not related to programming, but The realities of today for the successful development of a specialist require knowledge of at least the simplest skills in programming. But in my case, programming is the predominant skill to solve my...
V
Verlite
05.06.2022 G.
Review
The first confident step in acquiring new skills
Advantages: Nice interface of the platform, easy to navigate, very responsive curators, always prompt and helpful they will help, there is a schedule on what days the curator works and will be able to give an answer, the videos clearly explain complex things. Disadvantages: none found. I took a SQL developer course. Considering that I have been familiar with SQL for several years, my expectations were low. Nevertheless, the course from Skillbox was pleasantly...
K
kopalych74
26.12.2020 G.
Review
SQL Developer Course SkillBox
Advantages: Clear presentation of material “without water”, everything to the point. Pre-recorded course. Disadvantages: Oracle Apex was clearly superfluous. Completed the SQL developer course at SkillBox. The course is not bad. I liked the fact that it was pre-recorded. There are no technical difficulties, as during online courses, constant distraction of the lecturer with all sorts of questions in the chat, and the fact that lessons last a maximum of 15 minutes. The course will help...
Subscribe
YOU MIGHT ALSO LIKE
-
-
-
14/03/2022