-552x564.jpg "Basic SQL course for analysts and managers")
| We are
not going to describe this course for a long time. If you found it in a
search, most likely you understand what SQL is and how this course can be
useful to you. Let's outline the key points. The course was created for people who are not related to IT, but who in view of their activities in one way or another need to work with databases through SQL. A great emphasis in the course is made on practice. No gimmicks and marketing moves - look, repeat, have a question - ask. Just two hours of training and you are ready to start working in SQL. Who this course is for: The course is aimed at analysts, managers, data scientists who are just starting to learn SQL or are taking their first steps in learning it. The course uses Oracle SQL as the language to be learned. A significant part of the course material is devoted to SQL commands, which are equally applicable to other databases: Microsoft SQL Server, PostgreSQL, MySQL and others. What you will learn Install the necessary programs to work with Oracle and SQL database Learn the basic SQL data types, useful operators and functions Learn to do data selection, filtering and aggregation using SQL tools. You will be able to create, rename and delete tables in the database Learn how to insert data into a table, as well as update and delete data in a table. Learn to work with table joins in SQL (JOIN) Learn to work with sets in SQL You will be able to start working with SQL, applying the knowledge in practice. Course content 7 sections - 24 lectures - Total duration 2 hours 3 minutes
|