Hamid
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    from14.00EUR/ h

    oracle sql and plsql or general sql language in english

    This practical introduction to SQL training course is for those who need to to be competent extracting data from, and updating data in, relational database servers like Microsoft SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL using ANSI standard Structured Query Language (SQL). In order to master the syntax of the language, the course is highly practical in nature - attendees learn by doing. The focus throughout is on coding SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are made available online for each attendee.

    Extra information

    bring your own laptop

    Location

    At teacher's location: Rue Henri Grenier, 1350 Orp-Jauche, Belgium

    |
    Use ⊞+wheel to zoom!
    +

    General info

    Age:
    Teenagers (13-17 years old)
    Adults (18-64 years old)
    Seniors (65+ years old)
    Student level:
    Beginner
    Intermediate
    Advanced
    Duration:
    30 minutes
    45 minutes
    60 minutes
    90 minutes
    120 minutes
    The class is taught in:English, Arabic

    About Me

    hello
    im hamid
    i looking for someone to help me to speak french language course or i can help you to speak arabic , teaching you oracle sql/plsql or if you want to practice your english with me

    Ask a question

    Send a message explaining your needs and Hamid will reply soon:
    The more detail, the better.
    Ex. "Hi, when are you available to meet for a lesson?"

    Availability of a typical week

    (GMT -04:00) New York
    MonTueWedThuFriSatSun
    0              
    1              
    2  Monday at 2:00  Tuesday at 2:00  Wednesday at 2:00  Thursday at 2:00    Saturday at 2:00  Sunday at 2:00
    3  Monday at 3:00  Tuesday at 3:00  Wednesday at 3:00  Thursday at 3:00    Saturday at 3:00  Sunday at 3:00
    4  Monday at 4:00  Tuesday at 4:00  Wednesday at 4:00  Thursday at 4:00    Saturday at 4:00  Sunday at 4:00
    5  Monday at 5:00  Tuesday at 5:00  Wednesday at 5:00  Thursday at 5:00    Saturday at 5:00  Sunday at 5:00
    6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00    Saturday at 6:00  Sunday at 6:00
    7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00    Saturday at 7:00  Sunday at 7:00
    8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00    Saturday at 8:00  Sunday at 8:00
    9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00    Saturday at 9:00  Sunday at 9:00
    10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00    Saturday at 10:00  Sunday at 10:00
    11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00    Saturday at 11:00  Sunday at 11:00
    12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00    Saturday at 12:00  Sunday at 12:00
    13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00    Saturday at 13:00  Sunday at 13:00
    14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00    Saturday at 14:00  Sunday at 14:00
    15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00    Saturday at 15:00  Sunday at 15:00
    16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00    Saturday at 16:00  Sunday at 16:00
    17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00    Saturday at 17:00  Sunday at 17:00
    18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00    Saturday at 18:00  Sunday at 18:00
    19              
    20              
    21              
    22              
    23              
    from 14€At teacher's location

    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 July 2018
    • Phone number verified
    • Google connected

    Availability of a typical week

    (GMT -04:00) New York
    MonTueWedThuFriSatSun
    0              
    1              
    2  Monday at 2:00  Tuesday at 2:00  Wednesday at 2:00  Thursday at 2:00    Saturday at 2:00  Sunday at 2:00
    3  Monday at 3:00  Tuesday at 3:00  Wednesday at 3:00  Thursday at 3:00    Saturday at 3:00  Sunday at 3:00
    4  Monday at 4:00  Tuesday at 4:00  Wednesday at 4:00  Thursday at 4:00    Saturday at 4:00  Sunday at 4:00
    5  Monday at 5:00  Tuesday at 5:00  Wednesday at 5:00  Thursday at 5:00    Saturday at 5:00  Sunday at 5:00
    6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00    Saturday at 6:00  Sunday at 6:00
    7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00    Saturday at 7:00  Sunday at 7:00
    8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00    Saturday at 8:00  Sunday at 8:00
    9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00    Saturday at 9:00  Sunday at 9:00
    10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00    Saturday at 10:00  Sunday at 10:00
    11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00    Saturday at 11:00  Sunday at 11:00
    12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00    Saturday at 12:00  Sunday at 12:00
    13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00    Saturday at 13:00  Sunday at 13:00
    14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00    Saturday at 14:00  Sunday at 14:00
    15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00    Saturday at 15:00  Sunday at 15:00
    16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00    Saturday at 16:00  Sunday at 16:00
    17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00    Saturday at 17:00  Sunday at 17:00
    18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00    Saturday at 18:00  Sunday at 18:00
    19              
    20              
    21              
    22              
    23              
    from 14€At teacher's location

    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


    Brahim
    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

    Zara
    Power BI, data analysis, Data science and deep learning algorithms
    I'm an IT engineer, with double master in software engineering ad 6 year do teaching experience. I'am found of english, french languages and IT development teanching. Giving private courses arround the world , is what I love doing in my free time for keeping me socially active! I love giving languages' courses in a new ways of pedagogy and for any students' age : Songs, projects, Poetry, Presentations, films etc.. As for teaching IT developement, my pedagogy is always teaching by practical projects and tutorials. Such as. developping games and usefull virtual services or application, depends of the technology we work on. Be ready for your best english and IT experience with me , it's not like any old way of teaching methodologies! Don't hesitate to reach out for me , if you wish to give it a try! I'll be the very happy to give more than I can to get you to your hopes.

    Mohamed
    N+, Linux, Java, C/C++, Dart, Database, CEH, Security
    Java 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.

    Abdelatif
    Training in business intelligence
    I am a data expert, and I offer you a complete 8-hour training course in business intelligence (Data analyst). The training will be organized as follows: - Courses (summary slides) to master the life cycle of a business intelligence project (ETL, data integration, modeling, reporting) - Theoretical exercises on modeling business intelligence problems (star diagram, snowflake diagram). - practical case study using SQL server tools: SSIS, SSAS, SSRS - reports with QlikView

    Adel
    Computer and programming tutor UAE IT teacher and collecting computer materials
    Teaching 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

    Pavan
    Java, oracle , software design principles, Reactive programming
    I am a working professional and I can best teach you basics of programming with real world examples. I can also teach best industry standard principles and help to improve ur knowledge .Also help to clear technical interviews and coding practise.

    Enrique
    Oracle Data Base (Essentials / Advanced) + Assessment on demand
    Oracle RDBMS architecture, Oracle engine, instances, schemas, roles, privileges, users, resources, quotas, tablespaces, segments, redo logs, archive log, tables, partitions, indexes, constraints, views, materialized views, job queues, virtual data base , distributed data base, data guard, rman, compression & encryption, data types, triggers, special administration packages, PL/Sql, data pump, import/export, Sqlldr, external tables, dynamic Sql, V$ views, Enterprise manager, Sql Developer, directories, Sql tuning, execution plan, tkprof, LOB management, XML & Json drivers, dynamic Sql, Data base modeling, Star schema, Snowflake schema, integrity checks, Data quality, Data versioning.

    Adedigba
    Web Design and Data Analytics: Building Effective and Responsive Websites and Understanding and Analyzing Complex Data Sets
    This class is designed to provide students with a foundational understanding of web design principles and techniques. The course will cover a variety of topics including HTML, CSS, layout design, color theory, typography, and responsive design. Students will learn how to create a website from scratch, starting with the basic structure of an HTML document, and then adding styling and layout using CSS. They will also explore the design principles that are essential to creating an effective and aesthetically pleasing website, such as color schemes, typography, and spacing. The class will involve a combination of lectures, discussions, and hands-on exercises to help students develop their design skills. Students will be required to complete several projects throughout the course, including designing a simple website and creating a responsive design that works on multiple devices. By the end of the class, students will have gained the skills and knowledge necessary to create functional and visually appealing websites that are optimized for a variety of devices and platforms. This class is ideal for anyone who wants to learn the basics of web design, including individuals interested in creating their own personal or professional websites, as well as designers and developers who want to expand their skillset.

    Rene Soto
    SQL-PLSQL Oracle Server- Level SQL Basic-Medium-Advance PLSQL Basic-Medium-Advance
    Oracle developed by Oracle Corporation is the most popular relational database system (RDBMS). Not only Oracle is a RDBMS, but also provides functionality for Cloud, Document Store, Graph DBMS, Key-value storage, BLOG, and PDF Storages. Recently. Oracle just announced an autonomous feature that allows databases to be intelligent and self-managed. Oracle database is a relational database (RDBMS). Relational databases store data in a tabular form of rows and columns. Column of a database table represents the attributes of an entity and rows of a table store records. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database. One characteristic of an RDBMS is the independence of physical data storage from logical data structures. In Oracle Database, a database schema is a collection of logical data structures or schema objects. A database user owns a database schema, which has the same name as the user name. Schema objects are user-created structures that directly refer to the data in the database. The database supports many types of schema objects, the most important of which are tables and indexes. A schema object is one type of database object. Some database objects, such as profiles and roles, do not reside in schemas. Database Rank 1 Oracle 1268.84 2 MySQL 1154.27 3 Microsoft SQL Server 1040.26 4 PostgreSQL 466.11 5 MongoDB 387.18 6 IBM Db2 179.85 7 Redis 149.01 8 Elasticsearch 143.44 9 Microsoft Access 141.62 10 SQLite 126.8 ...

    Mohammad
    Information technology - computer course - database course
    Computer science is the study of algorithmic processes, computational machines and computation itself. As a discipline, computer science spans a range of topics from theoretical studies of algorithms, computation and information to the practical issues of implementing computational systems in hardware and software.