“SQL Basics” Courses

Description

The course is designed for beginner data analysts, SQL developers, analysts, financiers, accountants, statisticians who are interested in working with databases, expanding the scope of information processing and methods. Speech (SQL statement, Procedures, Functions, DML, DDL, Joins, TRANSACT SQL, SQL Server Database Administration Logins Identity used to connect to a SQL Server instance (create, alter, drop) Users Database user to log into SQL Server (create , drop) SQL Server Programming Functions Create and drop functions Procedures Create and drop stored procedures Literals (Constants) String, integer, decimal, and DateTime literals Declare Variables Declare variables and set variables Loops and Conditional Statements WHILE Loop, IF… ELSE statement Sequences (Autonumber) Create and drop sequences Comments within SQL (How to create comments within your SQL statement and etc.) about creating queries, modifying them, linking to multiple databases in different formats and complex analytical processing capabilities and thus remote work. The course consists of 12 lessons, which will be held twice a week.