SQL for beginners.
10 USD Zoal interface and SQL language.This is the goal of the 1st lab.Task to 1 Labe.Installation of Microsoft SQL Server
Creation of a database of education
Introduction of data to the Education database tables
The Labs 2.Mastering the skills of creating concepts, triggers and stored procedures with
Use of Visual Interface and SQL Language.-
Task to 2 labs
1 Creating Images in the Education Database
2 Creation of stored procedures in the Education database
3 Creating triggers in the Education database
The Laba 3
tasks to them.SQL Server Management Studio interface to manage the file structure of the database; to explore the file structure of the system database model used in the template to create user databases; to fix the technique of creating user databases by means of MS SQL- Server Management Studio; to fix the technique of creating user databases by means of Transact SQL (operators Create Database, Create Table, Alter Table); to master the technique of modifying the parameters of the file structure of user databases by means of MS SQL Server Management Studio; to master the technique of modifying the parameters of the file structure of the databases among the languages of Transact SQL Operator (Alter Database); to investigate the objects of the system of catalogues by means of Transact SQL (Create Table, AlterThe
The
The
The
The Lab 6.
Identifying the MS SQL Server authentication options;
to master the methods of creating a database by users
graphic interface and language (TransactSQL) tools;
to master the practices of verifying the access rights of the created users;
To obtain the receipts of disconnecting and inclusion of entrance names.
Applications 1
Client's review of cooperation with Aleksandr Keshman
SQL for beginners.It’s all quality and without mistakes.
Freelancer's review of cooperation with client
SQL for beginners.A very good customer, provided the most comprehensible task, the payment meets the requirements. Always in contact. I recommend cooperation.
-
3 days10 USD
1776 39 0 3 days10 USD
I do all my laboratory tasks. You need to clarify a couple of questions and you can go on to work. + Compulsory explanations for the work done
-
Winning proposal1 day10 USD
1563 88 11 6 Winning proposal1 day10 USD
I will do a task without any problems. He performed a lot of such works.
-
1 day10 USD
1793 20 0 1 day10 USD
I’m ready to do laboratory work, I’m going to start immediately.
I just wanted to know, do you need reports too?
We can discuss everything in any way convenient for you.
-
Вам необходима только результирующая бд или пояснительные записки к лб??
-
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 3 days 10 hours back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 3 days 13 hours back ∙ 19 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 5 days 4 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 6 days 10 hours back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 6 days 13 hours back ∙ 13 proposals |