facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from27.09GBP/ h

Introduction to SQL. Designed for managing data held in a relational database management system (RDBMS).

Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Being able to wrangle and extract data from these databases using SQL is an essential skill within the data industry and in increasing demand.

In this two-hour introduction to SQL, you'll get to know the theory and the practice through bite-sized videos and interactive exercises where you can put your new-found skills to the test. SQL is an essential language for building and maintaining relational databases, which opens the door to a range of careers in the data industry and beyond. You’ll start this course by covering data organization, tables, and best practices for database construction.

The second half of this course looks at creating SQL queries for selecting data that you need from your database. You’ll have the chance to practice your querying skills before moving on to customizing and saving your results. PostgreSQL and SQL Server are two of the most popular SQL flavors. You’ll finish off this course by looking at the differences, benefits, and applications of each. By the end of the course you’ll have some hands-on experience in learning SQL and the grounding to start applying it on projects or continue your learning in a more specialized direction.

Relational Databases
Before writing any SQL queries, it’s important to understand the underlying data. In this chapter, we’ll discover the role of SQL in creating and querying relational databases. Using a database for a local library, we will explore database and table organization, data types and storage, and best practices for database construction.

Querying
Learn your first SQL keywords for selecting relevant data from database tables! After practicing querying skills in a database of books, you’ll customize query results using aliasing and save them as views so they can be shared. Finally, you’ll explore the differences between SQL flavors and databases such as PostgreSQL and SQL Server.

Extra information

Bring your own Laptop

Location

Online via webcam

General info

Age:
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

I am Certified Professional ERP, WMS, Data Analytics Expert with extensive experience in IBM Cognos, Oracle BI, Microsoft Power BI, DAX and Python.
I specialize in handling and analyzing large datasets and am highly skilled in data visualization.

I am excited to help you get started on your project! Let's touch base and begin the process.

Education

SUPINFO International University, Paris – France
Master’s Degree, Computer Software Engineering
________________________________________________________________

Experience / Qualifications

• Digital Transformation Analytics/ Informatica/ Boomi/ Microsoft SSIS/ Python
• Project & Budget Management
• Business Intelligence (IBM Cognos, Oracle BI, Microsoft Power BI)
• ERP Implementation and Upgrades
• Business Process Analysis
• Troubleshooting and Problem Solving
• System Design and Development
• Networking and Active Directory group policy
• Vendor Management
• Procurement Management
• Database Management
• Project Management
• Process Automation
• Ecommerce & B2B
• Demand & Supply Chain Management
• Warehouse Management System
• Logistics distribution and routing solutions

Oracle University
• Oracle BI Analysis & Dashboard
• Oracle BI Publisher 11G R1
• ERP Foundation & Address Book
• ERP Financial Modules (General Accounting, Accounts Payable, Accounts Receivable, Fixed Assets)
• ERP Distribution Modules (Inventory Management, Procurement, Sales Order Management, Advance Pricing)
• ERP Enterprise Report Writer
• ERP One World CNC
• ERP One World System Administration
• ERP One World Workflow & Tools Management
IBM
• Cognos Application Development
• Cognos BI Powerplay Certification
• Cognos Impromptu Report Building
Microsoft
• Administrating Windows NT
• Supporting Windows NT Core Technologies
• Networking Essentials 1 & 2
• SQL Server System Administration
Infor
• WMS System Administration

Reviews (1)

Mr. Samir is really at the top! His passion for teaching and his subject shines through in every lesson. He has a unique way of making lessons captivating and accessible, which facilitates learning and motivates his students to excel. He is always ready to help and provide additional explanations when necessary. His classes are not only informative but also incredibly inspiring. A real pleasure to have been his student!
Translated by Google. Click to view original.
Gain a 360° overview of exploring and using Power BI to build impactful reports. In this course, you’ll go from zero to hero as you discover how to use this popular business intelligence platform through hands-on exercises. Before diving into creating visualizations using Power BI's drag-and-drop functionality, you’ll first learn how to confidently load and transform data using Power Query and the importance of data models. You’ll also learn to drill down into reports and make your reports fully interactive. You've got the power! Getting Started with Power BI Discover how to navigate this intuitive tool and get to grips with Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view. You’ll also practice using Power Query Editor to prep your data for analysis. Transforming Data In this chapter, you'll learn how to shape and transform your data before the data analysis using Power Query Editor. Visualizing Data It’s time to power-up your business intelligence skills! Through hands-on exercises, you’ll learn how to change and format a wide range of visualizations, before moving on to sorting data and creating hierarchies—making it possible for you to drill into your reports. Filtering In the final chapter, you’ll discover how to filter the information in your reports by location and control how these filters interconnect and interact with other visuals in your report.
In this Excel course, you’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn how to manage tables and apply calculations to your data to provide new insights. You’ll learn about the many available functions in Excel that can help you to perform calculations, analyze data and, in some cases, automate tasks. We’ll finish this course by explaining the basics of using Excel to effectively communicate data through compelling visuals. You’ll explore the versatility of area, column, and pie charts to help tell a story to bring your analysis to life.
In our Introduction to Python course, you’ll learn about powerful ways to store and manipulate data, and helpful data science tools to begin conducting your own analyses. Python Basics An introduction to the basic concepts of Python. Learn how to use Python interactively and by using a script. Create your first variables and acquaint yourself with Python's basic data types. Python Lists Learn to store, access, and manipulate data in lists: the first step toward efficiently working with huge amounts of data. Functions and Packages You'll learn how to use functions, methods, and packages to efficiently leverage the code that brilliant Python developers have written. The goal is to reduce the amount of code you need to solve challenging problems! NumPy NumPy is a fundamental Python package to efficiently practice data science. Learn to work with powerful tools in the NumPy array, and get started with data exploration.
An excellent logistics system delivers the right product to your customer at the right price, so understanding logistics is critical to your success. In this course, instructor Samir shows you why logistics is important, what it is, and how logistics supports your company and your customers. Samir discusses how logistics must be effective and efficient. He explains steps to improve how a customer’s order is filled. The course covers both outbound and inbound logistics and also goes over reverse logistics. More money is spent on transportation than on all other logistics functions combined, so Samir specifically takes you through different modes of transportation and how they often work together. He also shares the four cost tradeoffs in warehousing and goes into specific cost-efficient and value-added distribution center activities. The course steps through how logistics supports your marketing strategy, cuts across departments, and touches your customers.

Ask a question

Send a message explaining your needs and Samir 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 -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday 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  Friday 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  Friday 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  Friday 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  Friday 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  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12              
13              
14              
15              
16              
17              
18              
19              
20              
21              
22              
23              
from £27.09Online via webcam

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 September 2023
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday 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  Friday 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  Friday 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  Friday 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  Friday 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  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12              
13              
14              
15              
16              
17              
18              
19              
20              
21              
22              
23              
from £27.09Online via webcam

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


Amin
Programming with Python, with C and database management (Introduction to machine learning)
Looking to master programming and become a skilled developer? In this course, you'll learn the basics of Python and other programming languages, as well as how to use them to build machine learning models. We also offer specialized assistance for students in programming and database management using SQL (CPGE students). Python is a powerful general-purpose language used in web development, data science, software prototyping, and more. Its simple and easy-to-use syntax makes it an excellent choice for beginners learning to program. Additionally, upon request, we offer courses in other programming languages such as C, R, and MATLAB. Classes can be conducted remotely or in person, and we tailor our instruction to meet individual or group needs. If you have any questions, feel free to contact us.

Salah Eddine
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is Welcome
Master Python with Personalized Courses Discover the art of programming with Python courses tailor-made to meet your specific needs. Whether you are a beginner, intermediate or professional, my lessons are suitable for all levels. Why Choose My Courses? Personalized Teaching Approach: Each course is tailored to your skill level and individual goals. Practical Experience: Learn by doing with real-world projects that build your understanding and skills. Ongoing Support: Get unlimited email support for any questions you have between sessions. As a Python expert, I have a passion for teaching and sharing my knowledge. My goal is to guide you effectively in your learning journey. Book Your First Lesson: Start your journey to Python mastery now by booking your first lesson. Whether you aspire to enter the development field or hone your existing skills, these courses are designed for you.

Mazuba
Introduction to Programming with Python Programming Language.
Learn programming fundamentals with Python, a beginner-friendly and versatile language. This class will guide you through the essentials of coding, building problem-solving skills, and understanding how programs work behind the scenes. Note: Students are encouraged to suggest specific topics or areas of interest they would like to focus on during the course. What You’ll Learn: Python basics: Syntax, variables, and control flow (if-else, loops). Understanding IDEs: Setting up and working with Python IDEs. Execution process: Interpreters, compilers, and how Python executes code. Introduction to modular programming with functions.

Atef
Computer programming and WEB development courses
I am pragmatic, so each course must solve one problem at a time. My classes are often in the form of pair-coding, we code together using an online code editor. Before starting our lessons, we will define together the topics to be covered. My classes are for everyone.

Oussama
Python Programming for All Levels: From Fundamentals to Advanced Libraries and Frameworks
What You Will Learn: Core Principles: Introduction to programming, algorithms, and data structures to build a strong foundation. Advanced Libraries and Frameworks: NumPy, Pandas, and Django to create web applications and perform efficient data analysis. Practical Projects: Real-world applications to strengthen your skills and build an impressive portfolio. How You Will Benefit: Students: Gain the necessary skills to excel in academic projects and lay the groundwork for your career. Self-Taught Learners: Avoid common mistakes and fast-track your progress with clear, hands-on guidance. Professionals: Enhance your skill set to meet industry demands and open up new career opportunities. Why Choose My Courses?: Personalized Approach: Each course is customized to your level and learning pace, ensuring tailored guidance and support. Theory and Practice: You’ll combine theoretical concepts with hands-on exercises for a comprehensive and lasting understanding. Solving Real-World Problems: Learn how to tackle the common challenges faced in programming, from debugging to performance optimization.

Baia
Front-end development(Html, Css, Javascript, Vue.js, React.js) by professional and experienced developer
Are you ready to craft stunning, interactive websites that captivate audiences and elevate user experiences? Look no further than my dynamic Front-End Development course. From mastering HTML, CSS, and JavaScript to harnessing the power of cutting-edge frameworks like React and Vue, you'll acquire the skills needed to build responsive, intuitive websites that stand out in today's competitive market. But it's not just about learning code—it's about cultivating creativity. My methods fosters a collaborative learning environment where you'll engage in real-world projects, tackle challenges head-on, and refine your design sensibilities to create visually stunning interfaces that leave a lasting impression. If you are stuck with your project, or you want to kearn high-income, future skills, my Front-End Development course is your gateway to success. Enroll now and embark on a journey towards a fulfilling and rewarding career in tech!" For further details, please don't hesitate to contact me!

Andrey
I will teach you or your child the basics of programming in Python
We will write Python codes in a coding environment. It is possible to use in any browser- you simply write a code, run it and save your work. During this lesson, we will learn how to perform input operation from keybord as well as output operations. We will also write small programs which repeat a block of code; that is, we will learn "for" and "while" loops.

Roy
Computer Programming for Beginners | Easy Webdesign with HTML, CSS and Javascript
Hello and welcome! Learn about some of the most common programming languages used online and make your own website! This class is well-suited for people who are interested in, want to start to learn, or already have some basics, of Web development and would like to hone their programming skills.

Gaëlle
Code Your Way to Success: A Fun and Interactive Introduction to Programming for Kids
In this class, kids will learn the fundamentals of programming and computer science in a fun and engaging way, and discover how these hard and soft skills can be used in their personal and future professional lives. Through interactive lessons and hands-on projects, kids will explore the world of code and create their own digital creations. Throughout the course, they will: Learn the basic concepts and terminology of programming Experiment with different programming languages and platforms Create simple programs and apps using code Collaborate with peers and share their creations Develop problem-solving skills, logical thinking, and other valuable skills that will be useful in any field By the end of the class, your children will have the knowledge and confidence to continue exploring the exciting world of programming and computer science and will understand how code can be a powerful tool for achieving success in any field. They'll be able to choose the job they want in the future or even build their own company. So, join us and code your way to success!

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

Mouncef
Learn Python, Artificial intelligence with me until you become an expert
This Python course teaches you the basics of programming in Python, including variables, data types, operators, control structures (if, for, while), functions, and lists. You will also learn how to manipulate data with libraries such as Pandas and NumPy, create graphs and visualizations with Matplotlib and Seaborn, and even develop simple web applications with Flask or Django.

Yassine
Elevons l'Avenir : Quand Mathématiques et Informatique Unissent leurs Forces
En tant que tuteur passionné et expérimenté, je propose des cours sur mesure en mathématiques et en programmation informatique pour tous niveaux, des débutants aux avancés. Mon objectif est de transmettre des connaissances solides, tout en rendant l’apprentissage à la fois clair et motivant. Pourquoi me choisir ? Mon parcours : J’ai suivi une formation d’excellence en classes préparatoires scientifiques au LYDEX, classé parmi les 8 meilleurs établissements de classes préparatoires en France. Cette expérience rigoureuse m’a permis de développer des compétences approfondies en mathématiques et en informatique, ainsi qu’une méthode de travail structurée et efficace que je partage avec mes étudiants. Excellence académique : Une formation solide issue d’un des meilleurs environnements éducatifs. Expertise variée : --> Mathématiques : Algèbre, géométrie, analyse, probabilités, statistiques. --> Programmation : Python, Java, C++, algorithmes, développement web, bases de données. --> Approche pédagogique sur-mesure : Je m’adapte aux besoins spécifiques de chaque étudiant, que ce soit pour réussir un examen, approfondir des compétences ou accomplir un projet personnel. --> Expérience et résultats : J’ai accompagné de nombreux élèves et professionnels dans l’atteinte de leurs objectifs, en leur donnant les outils nécessaires pour exceller. Ma mission : Inspirer et guider mes étudiants vers l’excellence académique et professionnelle. Avec moi, chaque cours devient une opportunité de progresser et de prendre confiance en ses capacités. Contactez-moi dès maintenant pour commencer votre voyage vers la réussite !

Antoine
Marketing, Promotion, Digital Optimization and SEO
The course module is adapted to the student. You will earn: ▪️ An integrated digital marketing strategy based on your own organizational context. ▪️ Skills to effectively analyze and leverage data to make breakthrough data-driven decisions. ▪️ A future perspective on marketing and an overview of how to use emerging digital channels and technologies, such as artificial intelligence (AI) and chatbots, within your organization. ▪️ Accept the challenges and opportunities of disruptive technology in your digital marketing strategy.

Rob
Statistical analysis and machine learning course. R
Data scientist with +10 years of experience offers courses in statistical analysis and programming with R software (Rstudio, R commander). I teach general mastery of the R language as well as basic/advanced statistical concepts. Data analysis, descriptive statistics, mathematical models for predictions, regressions and machine learning. Survey analysis and web scraping. Serious and flexible schedule.

Vikash
1-to-1 Online Tutoring for Python, PHP, and Web Development
Master the art of web design and development with personalized 1-to-1 online tutoring in Python, PHP, and Other server side programming languages. Whether you're a beginner looking to build your first web project or an experienced developer aiming to refine your skills, our customized tutoring sessions are designed to help you achieve your goals. I really happy to teach people who will really want to part of my lesson. My teaching style is the step by step oriented. We will start from basic and move towards advanced topics. A very warm welcome my students on apprentus.com Wish you all the best.