0
Views
SQL Basics - course 900 rub. from Shultais education, training 2.5 months, date November 28, 2023.
Miscellaneous / / November 30, 2023
You choose the day, place and time of your SQL training. To get started, all you need is a computer and Internet access.
You can take breaks if you are on vacation or have a busy time at work. Learn at your own pace, no deadlines or fees.
SQL training on real business problems from banking and finance, online trading, insurance, CRM systems and Internet portals.
By the end of the SQL course, you will be fluent in extracting data and making analytical queries. Help your business or accelerate your career.
Personal feedback within 24 hours. The teacher or mentors will answer all your questions in detail and help you solve your assignments.
The course consists of short but detailed online video lessons on SQL with reinforcement tasks. No fluff, boring lectures or long webinars, only useful, concentrated content.
Tasks are performed on a special SQL simulator, which not only checks the query, but also gives hints.
The SQL online course is suitable for beginner developers, marketers, and analysts. The program is designed for a wide audience and does not require any prior skills.
WEB DEVELOPER
Learn to write efficient SQL queries and design reliable databases.
Good websites don't work without databases.
MARKETOLIST
Learn to extract data for reports without the help of developers. You will be able to analyze user behavior and marketing indicators.
ANALYTICS
Learn to get information directly from databases without programmers. Master data processing and analysis tools.
SQL is a language for programs to communicate with databases. The ability to write queries in SQL is one of the key skills of modern programmers, as well as analysts, product specialists and Internet marketers. Every serious interview or test contains questions about databases and SQL.
Learning SQL greatly increases the device's chance of working.
COURSE PROGRAM
A rich program with short video lessons and a lot of practice.
Learn SQL from scratch using MySQL, one of the most popular databases, as an example.
Simple SQL queries
9 lessons, 26 tasks
Get familiar with the SQL language and write your first database queries.
Learn to filter and sort data.
Master the LIMIT, FETCH, OFFSET and TOP constructs.
Learn how to install MySQL and connect to the database.
Find out how the client interacts with the server.
Add, change, delete
3 lessons, 20 tasks
Learn to add new records to tables, as well as change and delete existing data.
Creating tables
10 lessons, 37 tasks
Learn to create tables from scratch to suit your business requirements.
Learn how to choose the best data types for your columns.
Learn about NULL and TRUE, as well as inserting default values.
Indexes
4 lessons, 20 tasks
Learn what a primary key and AUTO_INCREMENT are.
Learn to create regular indexes to speed up SELECT queries. Learn about unique indexes for data control.
Changing tables
3 lessons, 13 tasks
Learn to change the structure of tables: add new ones
and remove irrelevant columns.
Learn how to change data types in existing fields.
Search text
2 lessons, 12 tasks
Learn to search text data using a pattern.
Explore full text search to find relevant data.
Secondary functions
4 lessons, 23 tasks
Learn to modify text data.
Get to know mathematical functions.
Learn how to convert date and time into a convenient form.
You will practice filtering information using functions.
Grouping data
3 lessons, 17 tasks
Learn to group and aggregate data according to different criteria.
Build your first summary reports.
Learn how to calculate quantity and sum, as well as average, minimum and minimum values.
Learn a new way to filter information - HAVING.
Multi-table queries
13 lessons, 76 tasks
Learn to combine data from multiple tables.
Become familiar with the concept of links and relationships between tables.
Learn what a foreign key is and how to ensure data integrity.
Master the JOIN and UNION constructs.
Nested Queries
6 lessons, 17 tasks
Learn to use nested queries to retrieve data.
Get to know the operators EXISTS, IN, ANY, ALL.
Learn how to use nested queries to insert data.
Subscribe
YOU MIGHT ALSO LIKE
