Add to Wish List
from29.00EUR/ h
Introduction to Relational Database and SQL Language by practise
Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys
Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE
- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints
- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation
Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE
- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server
Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions
- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls
Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN
- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows
Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values
- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING
Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows
- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows
Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause
- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys
Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE
- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints
- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation
Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE
- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server
Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions
- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls
Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN
- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows
Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values
- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING
Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows
- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows
Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause
- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views
Extra information
MySQL, Oracle, PostgreSQLLocation
Online via webcam
At teacher's location: ARD JOUABRI, Berrechid, Morocco
At student's location: Around Berrechid, Morocco
|
Use ⊞+wheel to zoom!
General info
Age: | Children (7-12 years old) Teenagers (13-17 years old) Adults (18-64 years old) Seniors (65+ years old) |
---|---|
Student level: | Beginner Intermediate Advanced |
Duration: | 60 minutes 90 minutes 120 minutes |
The class is taught in: | English, French, Arabic |
About Me
Computer engineer for more than 13 years with strong skills in java and all frameworks that revolve around java (Spring stack, Hibernate, JUnit, Maven, Eclipse, ....).Ingénieur en informatique depuis plus de 13 ans avec des compétences fort en java et tous les Framework qui tourne autour de java (stack Spring, Hibernate, JUnit, Maven, Eclipse, ....).
مهندس كمبيوتر لأكثر من 13 عامًا يتمتع بمهارات قوية في Java وجميع الأدوات التي تدور حول Java (Spring Stack ، Hibernate ، JUnit ، Maven ، Eclipse ، ....).
Education
2010 - Master's degree in computer software2008 - Degree in Mathematics and Computer Science
2006 - BAC+2 in Mathematics and Computer Science
2004 - Baccalaureate in Mathematics
Experience / Qualifications
FROM 2018 - TO Present : JAVA/JEE Team/Tech LeaderFROM 2015 - TO 2018 : JAVA/JEE study and development engineer
FROM 2011 - TO 2015 : JAVA/JEE study and development engineer
FROM 2010 - TO 2011 : JAVA/JEE study and development engineer
Do not deal with the manual with terms of reference statements and basic documents that cannot be obtained in order to avoid the MongoDB problem. Please include the connection to one of the MongoDB données base, comment on simple CRUD operations and sujets clés que l'agrégation, l'indexation, la mode des données et les Transaction.
1- Install MongoDB
2- Implement MongoDB
3- Use of documents and collectibles
4 - Leadership Committee
5- Execute CRUD commands (create, read, update, delete) avec mongo shell
6- Type the register in a MongoDB database
7- Reset the base to remonter specific documents depuis mongo shell.
8- Lagrégation
9- Indexing
10- Amending institutions and transactions
Course in standard java and/or entreprise java programming and/or frameworks used in the most java projects.
The course takes place in a theoretical course format, followed by small practical exercises and will be finalized by a mini-project that encompasses all that is seen in the course.
We use the n-tier architecture under heavy applications or web applications.
Ask a question
Send a message explaining your needs and Brahim will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 29€At teacher's location
from 29€Online via webcam
from 35€At student's home
100% Satisfaction Guarantee
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Online reputation
- Instructor since March 2023
- Phone number verified
- Google connected
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 29€At teacher's location
from 29€Online via webcam
from 35€At student's home
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Share
You are here
Similar classes
Oussama
Mastering Relational Database Management: Personalized Courses with SQL, DBSM, MySQL, and PostgreSQLI offer personalized courses that cover a wide range of topics, from the basics of relational database management to advanced data manipulation using query languages such as SQL and tools such as DBSM, MySQL, and PostgreSQL. My courses are tailored to the needs and learning styles of each student, and I am committed to helping my students achieve their individual learning goals.
Whether you are a beginner or looking to improve your skills, I can help you develop your relational database management skills and take your expertise in this field to the next level. I am excited to guide you through the world of relational database management and help you master the skills necessary to succeed in this field. Please do not hesitate to contact me for more information about my services and how I can help you achieve your relational database management goals.
Zora
Data science, Deep learning, Business intelligence, Data analysis, Visualisation des donnéesJe propose des cours complets en Power BI, analyse de données, science des données et algorithmes d'apprentissage profond, adaptés à tous les niveaux d'expérience. Mon approche pédagogique se concentre sur l'acquisition de compétences pratiques, vous permettant d'appliquer directement ce que vous apprenez dans des projets réels.
Dans le cadre de mes cours de gestion de données, vous apprendrez à transformer vos données en visualisations interactives et informatives, en maîtrisant les techniques de création de tableaux de bord, de rapports et d'analyses visuelles. Vous découvrirez également comment connecter différentes sources de données et optimiser vos modèles pour des insights pertinents.
En ce qui concerne l’analyse de données, vous développerez une compréhension approfondie des méthodes statistiques et analytiques, vous permettant de tirer des conclusions significatives à partir de vos données. Vous serez initié aux outils et aux techniques de manipulation des données, y compris l'utilisation de langages de programmation tels que Python, R, PowerBI ou TABLEAU.
Dans le domaine de la science des données, nous explorerons les étapes clés du processus de data science, de la collecte et le nettoyage des données à la modélisation et à la validation des résultats. Vous serez également introduit aux algorithmes d’apprentissage profond, apprenant à construire et à entraîner des modèles neuronaux pour des applications variées, allant de la reconnaissance d'image à la prévision.
Chaque cours est structuré autour de projets pratiques et de cas d’étude, afin de vous préparer à relever des défis réels en matière d’analyse et d’interprétation des données. Si vous êtes prêt à développer vos compétences en Power BI, analyse de données, science des données et apprentissage profond.
Eiad
Learn the profession of professional software development and marketing it onlineC# is the programming language approved by Microsoft, the leading software company in the world.
In the course, you will learn how to create complete programs such as managing a restaurant, company, law firm, point of sale, real estate management programs, clinics, institutes, universities, etc., so that you can sell and market software on the Internet and gain a strong career to support you in your professional life.
Mohamed
N+, Linux, Java, C/C++, Dart, Database, CEH, SecurityJava lessons include understanding the basics of programming, control flow, handling data, objects, and exceptions. Teaches user interface development and advanced concepts in Java programming.
Oracle Database lessons provide a comprehensive and in-depth understanding of data management concepts using the Oracle Database system. The course covers topics such as database design, managing tables and indexes, and advanced SQL queries. The program also includes studying security and data protection, optimization and performance improvement using various Oracle tools. Allows students to understand how to effectively create and maintain Oracle databases, as well as learn to use graphical data management tools and SQL commands to perform basic and advanced tasks.
Information security focuses on protecting information from cyber threats. Covers topics such as securing networks and data, penetration testing, and managing digital identities to enhance digital security.
Aaron
Power BI Essentials Course - Any Experience Level AcceptedDive into the world of data visualization with Power BI. This course is perfect for those looking to create compelling and insightful reports and dashboards. Gain hands-on experience in transforming raw data into meaningful visualizations that drive informed decision-making.
Samuel Oyakhilome Kwasi
Data Analytics Tutorials -- Join the Data Dive: Your Guide to Excel, SQL, Power BI and PythonExcel, SQL, and Python: Essential Tools for Data Analysts
As a data analyst, mastering Excel, SQL, and Python is crucial for effectively extracting, manipulating, and analyzing data. This comprehensive course is designed to equip you with the practical skills needed to excel in these essential tools.
Key areas of focus include:
Excel: Learn advanced Excel techniques, including data manipulation, pivot tables, and data visualization.
SQL: Gain proficiency in SQL for querying databases, extracting relevant data, and performing data analysis.
Python: Discover the power of Python for data analysis, including data cleaning, manipulation, and visualization using popular libraries like Pandas, NumPy, and Matplotlib.
Through hands-on exercises and real-world examples, you'll develop the confidence and expertise to tackle complex data analysis challenges and drive informed decision-making.
Elmehdi
I'm a developer coach with over 10 years of experience in website and database development. TitolayI'm a developer coach with over 10 years of experience in website and database development. Holding a professional license and several industry-recognized certifications, he is a MySQL expert and able to walk you through the most complex requests. As a coordinated and passionate website builder, I am able to share my knowledge and experience with over 100's of people to help achieve their development goals. Many renewable projects are experienced and able to deliver high quality results. If you are looking for a talented developer coach to help you with your MySQL demands, please feel free to contact me.”
Klevis
Computer science and programming courses (JavaScript, React, Angular, Java, Spring, SQL Server). Creation of web/native applications!!!Analyst-Programmer, I teach computer science and programming at all levels.
My teaching method is: simple, effective and very quickly learned by the students.
I take all the time necessary for the student to really understand the course. My goal is to simplify the material as much as possible during the explanation and I always use examples to facilitate understanding.
I never skip topics that I don't understand because during the time the student is learning, I too am learning something new!
Basel
Windows Server 2022 for network engineers and studentsI specialize in administering and teaching Windows Server 2022 Administration Fundamentals to small, medium, and large enterprises. My goal is to keep trainees constantly challenged to learn how to set up and manage servers efficiently without overwhelming them. I cover topics such as Active Directory management, DNS and DHCP configuration, and Virtual Machine setup. After each lesson, I provide hands-on assignments to ensure full understanding and provide periodic reports to track trainees’ progress.
This class is for aspiring IT administrators who want to learn how to set up and manage Windows Server 2022 effectively. The focus is on learning how to set up servers, optimize their performance, and provision virtual infrastructure for enterprises. If you are a beginner, don’t worry, all concepts are explained clearly from the beginning to ensure complete understanding.
Marouane
Business intelligence, data warehouse, Etl, SQL server, star schema or snowflake, power biAs a data scientist with in-depth expertise in artificial intelligence, machine learning, deep learning, time series and data mining, I put my skills at your disposal as a data engineer specializing in Business Intelligence within a large company. I offer you comprehensive training covering the entire Business Intelligence pipeline, from data collection to visualization.
During these sessions, you will learn:
• The conception and design of data warehouses adapted to your specific needs.
• Data models such as star schema and snowflake to optimize your data structure.
• Practical use of SQL Server as well as other SQL databases to efficiently manage your data.
• Advanced Extraction, Transformation and Loading (ETL) techniques with SSIS to automate processes.
• Creating interactive reports and impactful dashboards with Power BI and DAX or IBM Cognos.
In-depth presentations, based on solid practical experience and up-to-date theoretical knowledge, covering all aspects of the Business Intelligence pipeline.
Concrete and relevant examples, taken from real use cases, to illustrate theoretical concepts and facilitate their understanding.
Please feel free to contact me to discuss your specific needs and to schedule training sessions tailored to your schedule and goals. With this training, you will be ready to take full advantage of your data and make informed strategic decisions.
Joshua
Learn to program with fun and current projects!In this lesson we will be introduced to the fundamental concepts of programming in MySQL, Java and PHP. We'll start with MySQL and cover the basics of database technology, such as creating, reading, updating, and deleting data in a database. Then we'll move on to Java, where we'll discuss syntax, data structures, and control structures. Finally, we will discuss PHP, focusing on web programming and using PHP in conjunction with MySQL databases. By the end of this lesson, students will have a solid understanding of the fundamental concepts of programming in MySQL, Java, and PHP and how these technologies work together to create powerful web applications.
Usman
Data analysis class for anyone who wants to learn skills as excel, mysql, power bi, tableau, python and machine learningIn this class I will teach you data analysis skills right from the basics to the advance level, you might wonder why to choose me for tones of other teachers out there. It is because I will focus more on practice and exercise rather than theory and written part. This helps the student to gain the required knowledge about data analytics. Now I ask why learn data analytics, it is because it is a booming Carrer at the time and it's the correct time to learn and grab the opportunity. So, it is a great time to jump on the boat to learn more about data analytics and also excel in your job
Adel
Computer and programming tutor UAE IT teacher and collecting computer materialsTeaching all computer and programming subjects
Follow-up of university students in the UAE
In computer subjects, programming, IT and computer science
Java - C++ - C - C# - Visual basic - Matlab - Python
ICDL - Oracle - SQL
Java teacher - Python teacher - Office teacher - Database teacher - Information systems teacher
Teaching web page design
HTML - Java Script
Teaching office group
Word - Power point - Excel - Access - outlook
Teaching all programming languages with years of experience
All universities and all grades
To get the highest score in an easy and simple way
Abu Dhabi University, Al Ain University, Emirates University, College of Technology, Ajman University, University of Sharjah, Ras Al Khaimah University, Dubai University
College of Technology - Higher College of Technology
Computer and programming teacher
computer teacher in UAE
Computer teacher in Sharjah, Abu Dhabi, Al Ain, Ajman and Dubai
java programming teacher
python programming teacher
sql database tutor
ICDL Instructor and Trainer
Explanation of Microsoft office suite
Follow-up of all computer, programming, information systems and IT subjects at all stages of the university
Hamid
Query , Design and Implementation SQL Server DatabaseMy SQL Server class focuses on database management, covering the installation, configuration, and maintenance of SQL Server environments.
It includes writing SQL queries, optimizing performance, and ensuring data security.
Students learn to design, implement, and troubleshoot databases, gaining hands-on experience with SQL Server tools and features.
Jinu
Computer Science and Programming class for beginnersComputer Science is the study of algorithms, data structures, and the principles underlying the design of software and hardware systems. Programming, a key aspect of computer science, involves writing code to instruct computers. Students explore topics like algorithms, data analysis, artificial intelligence, and software development methodologies in this dynamic field.