Learn SQL scripts, stored procedures, stored functions

من 83.69 AED /س

In this class I start with teaching simple SQL like joins, cte functions etc. Later we will jump to advance sql like writing stored procedures, stored functions etc. Also I will cover very basic database designing concepts. Like the approach how to design good data base depending on the volume, performance etc.

المكان

عبر الانترنت من ألمانيا

السن

الأطفال (7-12 سنة)

شباب (13-17 سنة)

الكبار (18-64 سنة)

الكبار (65 سنة فأكثر)

مستوى الطالب

مبتدئ

المدة

60 دقيقة

الدرس يدور باللغة

الإنجليزية

الهندية

مهارات

Sql

الجاهزية في الأسبوع العادي

(GMT -05:00)

نيويورك

على الانترنت عبر كاميرا ويب

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Learn Programming from basics to advance python, c#, vba etc.

110.12 AED /س

You can learn programming basics, object oriented programming basics. For beginners start with basic programming concepts and then gradually advancing to advance real world projects based on advance modelling approached or based AI ML solutions.

66.07 AED /س

This course will be focusing on the programming basics. Student can choose his choice of language to learn like python, c#, vb.net or vba. This course will focus base constructs of programming like functions, classes, conditional, decision, repetitive constructs etc.

إقرأ المزيد

عرض المزيد

Omar

4.0

(1)

vous voulez apprendre :

A utiliser la base de données : *
- la création de la base de données (LDD); (Débutant)
- la manipulation des données de la base de données (LMD);(Débutant)
- le contrôle de données de la base de donnes ( LCD); (intermédiaire)

La programmation au niveau de la base de données (PLSQL) (Trigger/Cursor...).(intermédiera).

Extraire des donnes a partir d'un texte ou bien une cahier de charge pour créer une schéma de base de donnes qui respecte les règle de merise ou bien un diagramme de classe pour le cas de l'UML.
=Merise;(Débutant)
=UML;(Débutant)
Les déférente diagramme (Dg de cas d'utilsation , Dg d'activité..);

*vous pouvez choisir entre les systèmes de gestion de base de données (SGBDR) suivant :
==>SQL SERVER
==>SQL ORACLE
==>MySQL

Ibrahim

4.0

(1)

This course provides a step-by-step overview and instructions that help you get started with the SQL language. We use MSSQL, but you can use this course to get started with understanding data structures and techniques for all SQL engines including Access, Oracle and MySQL. We show you how to create SQL statements including SELECT, DELETE, UPDATE and INSERT. Then, we show you how to create and design tables. We show you how to create stored procedures, which allow you to run the same SQL statement multiple times without reprogramming your database. Finally, we show you how to use cursors, use transactions to preserve data integrity, and creating views for larger data sets.

Zakaria

4.0

(1)

Graduate in IT management, with at least two years of experience as an IT trainer.

I offer support courses and my private lessons in SQL programming and database management (analysis, design, etc.).

Beheddine

4.0

(1)

I offer courses in spring and .Net frameworks,
java, php and c # courses
basic web development technologies such as html, css and javascript
relational and non-relational database and NoSQL SQL (MongoDB) courses

a PC and IDE

Mohamed

4.0

(1)

good morning,
You'll want to save more on SQL!
You can use the SQL assignment that you can't compile!
With my money, I want you to use SQL, so you can use the appropriate database to download it.
All is well
Create your own donation base or interface with the donation bases
Log SQL pool requests around plusieurs tables

Houssem

4.0

(1)

Afin d'améliorer vos compétences ou de découvrir dès le début le domaine de bases de données relationnelles, langage SQL et Administration Bases de Données, il vous faut un expert dans ce domaine ainsi que dans le domaine éducatif en général, en mettant à votre disposition des cours bien intégrés et bien structurés avec des exercices théoriques et pratiques:
- La sélection simple (SELECT)
- Fonctions de ligne et fonctions de groupe
- Regroupement
- Jointure
- Sous requête simple
- Sous requête corrélée
- Algèbre relationnelle
- Etc.

Abir

4.0

(1)

In this class, you will have an overview of basic computing in general and also in SQL language, Merise
My goal is to keep students challenged, but not overwhelmed. I assign homework after every lesson and provide periodic progress reports.
You will learn quickly and easily

Abdelhak

4.0

(1)

Hello everyone, I am delighted to be here today to introduce myself as a trainer.
As a computer engineer with over 15 years of experience, I have worked in various industry sectors.
During my career, I have developed solid programming skills especially in SQL and PL/SQL language, and I am passionate about sharing my knowledge with you and putting my professional experience and technical skills to good use in this role .

Database:
- SQL, PL/SQL
- Oracle, PostgreSQL, MySQL

Aliou

4.0

(1)

Découvrez notre formation pratique en adminisatration de base de données MySQL.
Apprenenez à maîtriser le langage SQL pour une administration efficace des bases de données MySQL et devenez un expert dans la description, l'insertion, la modification et la suppression des données dans une base de données relationnelles
À l'issue de cette formation, vous serez capable de créer des bases de données, les décrire en créant des tables et relations avec le langage LDD et les manipuler avec des insertions, mise à jour ou suppression de données sous le langage LMD.

Oubaid

4.0

(1)

This course will allow you to acquire SQL skills for data analysis and management.

During this course, you will have the opportunity to use and manipulate the most well-known SQL features such as joins, subqueries, aggregation functions, filter and grouping clauses, as well as transactions. Finally, the methodology is based on familiarization with SQL syntax and the practice of acquired skills through real-world projects.

SQL is one of the world's most widely used languages for relational database management, and it is essential for efficiently manipulating and extracting data in many fields, including data science and business intelligence.

Hamdi

4.0

(1)

In this lesson, students will be introduced to Structured Query Language (SQL), the standard language used to manage and retrieve data from relational databases. They will learn how to perform basic queries such as INSERT, SELECT, UPDATE, and DELETE. They will also cover how to use control clauses such as WHERE, ORDER BY, and JOIN to search for and organize information. By the end of the lesson, students will be able to create simple SQL queries to read and modify data in databases.

Mohamed

4.0

(1)

Dive into the world of SQL databases with this comprehensive course designed for learners of all levels. Whether you are new to databases or seeking to expand your expertise to advanced concepts like distributed systems, this course has you covered.

What You can Learn:
- Fundamentals of relational databases and SQL syntax.
- Designing robust databases using normalization and entity relationships.
- Writing complex queries, joins, and subqueries.
- Database optimization techniques for performance tuning.
- Implementing stored procedures, triggers, and views.
- Managing transactions and ensuring data integrity.
- Understanding and working with distributed database systems like Distributed PostgreSQL

Ayoub

4.0

(1)

SQL (Structured Query Language) is the cornerstone of working with databases and a must-have skill for anyone pursuing a career in data analytics, software development, or database management. This class is designed to take you from the fundamentals of SQL to advanced querying techniques.

You’ll start with the basics: understanding databases, writing simple queries, and learning how to retrieve, filter, and sort data. As you progress, you'll master advanced topics such as joins, subqueries, functions, and optimizing query performance. Real-world exercises will give you hands-on experience with actual datasets, preparing you to solve business challenges with ease.

Whether you’re a beginner or looking to enhance your skills, this course provides a practical approach to learning SQL in a structured and engaging way. Let’s unlock the power of databases together!

Graduate in IT management, with at least two years of experience as an IT trainer.

I offer support courses and my private lessons in SQL programming and database management (analysis, design, etc.).

ضمان المدرس المناسب

اتصل بShalini