Add to Wish List
Add to Wish List
from48.17CAD/ 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.
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 LaptopLocation
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 – FranceMaster’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?"
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 C$48.17Online via webcam
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 September 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 C$48.17Online 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
You are here
Similar classes
Amin
Statistical Analysis with Python and R (Rstudio) - Intro to Data ScienceBy delving deep into the practical applications of statistics and data science, this course is designed to set you up for success.
Learn from real-world examples: Instead of spending hours on theoretical material and trying to relate it to practical issues, we will focus solely on applied statistics. Programming will allow you to apply theory to real-world problems, equipping you with the knowledge and skills you need to succeed.
We won’t be spending hours solving math problems by hand for reinforcement, as this isn’t school. Instead, we’ll use cutting-edge methods and code libraries that leverage the latest software releases to maximize productivity and efficiency.
If you have any further questions, please do not hesitate to contact us.
Salah Eddine
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is WelcomeMaster 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.
Mohammed Shan
Computer Science Fundamentals and Exam Preparation📌 What You’ll Learn:
✅ Core Computer Science concepts (Operating Systems, Databases, Networks)
✅ Data Structures & Algorithms (Sorting, Searching, Graphs, Trees, etc.)
✅ Exam preparation (GCSE, A-Level, University courses)
✅ Hands-on problem-solving
🖥️ Teaching Style:
I provide interactive lessons with clear explanations, real-world examples, and coding exercises to ensure conceptual clarity. Sessions are structured based on individual learning needs, whether for academic success or competitive exam prep.
📅 Class Format:
Mode: Online (Zoom/Google Meet)
Duration: Flexible scheduling
Group & 1-on-1 sessions available
Materials provided: Notes, problem sets, practice questions
Hamza
Maîtrisez Python avec un Expert en Programmation et Data ScienceDécouvrez la puissance de Python avec un formateur expérimenté en informatique !
Je suis Hamza, un développeur passionné et mentor chevronné avec une vaste expérience dans l'enseignement de la programmation. Mon approche pédagogique unique vous permettra d'acquérir rapidement des compétences solides en Python, tout en découvrant ses applications concrètes dans le monde professionnel.
Ce que vous apprendrez :
Fondamentaux de Python (variables, structures de contrôle, fonctions)
Programmation orientée objet avancée
Analyse et visualisation de données avec pandas et matplotlib
Développement d'interfaces graphiques avec PyQt
Projets pratiques inspirés de cas réels en entreprise
Pourquoi me choisir ?
Plus de 5 ans d'expérience en formation et mentorat
Méthode pédagogique adaptée à tous les niveaux
Approche hands-on basée sur des projets concrets
Passion contagieuse pour le code et l'innovation technologique
Que vous soyez débutant cherchant à vous lancer dans la programmation ou professionnel souhaitant monter en compétences, ce cours vous ouvrira de nouvelles perspectives passionnantes dans le monde du développement logiciel et de la data science.
Rejoignez-moi pour un voyage captivant au cœur du langage de programmation le plus polyvalent et demandé du marché !
Réservez maintenant et faites le premier pas vers la maîtrise de Python. Votre carrière en tant que développeur Python commence ici !
Oussama
Python Programming for All Levels: From Fundamentals to Advanced Libraries and FrameworksWhat 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.
Brahim
Introduction to Relational Database and SQL Language by practiseModule 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
Younes
Scratch, Roblox: Code for Fun - A Fun Adventure for Kids and Beginners!With Scratch and Roblox, programming becomes child's play! Learn how to create animations, games, and interactive stories using colorful, easy-to-manipulate blocks of code. No complex language here, just a visual and intuitive approach to make learning as fun as possible.
Whether you are a parent wanting to introduce your children to the language of programming or a beginner curious to discover the world of coding, this training is suitable for all ages. No prerequisites necessary, just a dose of curiosity and a desire to have fun while learning.
As a trainer, I am committed to creating a caring and creative learning environment. I will use teaching methods adapted to each child, promoting positive interaction and encouraging the free expression of creativity. The goal is to make each lesson an engaging and enriching experience.
Antonio
Marketing, Promotion, Digital Optimization, and SEOThe 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.
Alper
[Beginners Welcome] Game Development, Game Design and Games SoftwareLearn how to make games from scratch! (All ages welcome)
Game development is a very fun way to get involved in computer programming, while allowing you to create games from scratch just like the ones you enjoy playing.
This class will teach you how to develop a simple video game from the ground up, and will allow you to create a game from scratch that you can then build upon. I will teach you the basics of how game development works and walk you through the process of implementing game mechanics that are commonly found on popular games.
Mouad
Support course in Python (For all levels, CPGE)Passionate about programming, we offer Python support courses adapted to all levels, from beginner to advanced. These courses are aimed at students in preparatory classes for grandes écoles (CPGE) as well as anyone wishing to acquire solid programming skills.
The lessons cover the essential foundations of Python with a clear and accessible teaching approach. Whether you are new to programming or want to deepen your knowledge, you will benefit from structured and progressive teaching.
With a focus on concrete concepts and practical examples, these courses aim to strengthen your skills in a tangible way. You will be guided through the nuances of Python, gaining a deep understanding that will benefit you both in your studies and in your future career.
Join us to explore the fundamentals of Python programming and progress to more advanced levels. Together, we will build a solid foundation and develop the skills needed to succeed in the dynamic world of computer programming.
Mazuba
Introducion to Programming with C++ Programming Language.Take a deeper dive into programming with C++, a language known for its speed and versatility. This class focuses on understanding how code interacts closely with the hardware and teaches the principles of efficient and effective programming.
What You’ll Learn:
C++ basics: Syntax, variables, data types, and operators.
Setting up C++ IDEs: Compilers and linkers.
How C++ code is compiled, linked, and executed.
Memory management and pointers: An introduction to dynamic memory.
Mathieu
Wordpress private lesson - From beginner to expertWith 7 years of experience as a developer in a Factory, I now develop Wordpress websites for large groups.
In the training program, you will learn to:
- Install, configure, and deploy WordPress sites
- Develop custom Wordpress themes and plugins
- Use powerful tools like ACF Pro, Gravity Forms, WPML, AIOS Security, WP rocket...
- Create custom post types and tailor-made taxonomies
- Develop pages using the right methods in HTML, CSS, Javascript & PHP
- Administer and manage a site database
- Contribute to the good natural referencing (SEO) of your site
- Use WP-Cli to speed up the maintenance of your sites
- Use Docker to containerize your local/prod projects and facilitate their management
- Administer your WP sites the right way
- And much more...
For any questions, you can contact me by PM.
See you soon,
Matthew
Matías
Private coding / programming lessons with pythonPython is one of the best, if not the best, language to start learning programming. It is also one of the most widely used languages today, especially in cutting-edge areas such as machine learning.
This popularity means that Python is constantly evolving. It offers a wide range of tools and libraries, which are free and very varied.
As an aeronautical engineer, I like to share my knowledge and derive satisfaction from it by teaching and motivating others.
I'm used to working with people of different ages. I believe in the importance of segmenting learning, visualizing progress, setting concrete goals and practicing regularly.
Beyond these general principles, there is no magic rule or method. Some approaches work with some students but not with others. Adaptation to individual needs is therefore the main objective of private lessons. So I will do my best to find what motivates and helps my student.
Abdallah
Programming and Coding Lessons, Adults, Kids( Python, HTML, CSS, Java Script, MySQL, Dart and Flutter, C++, C#, ) Offline Egypt and OnlineAfter Completing Our Course:
- High Earning Potential: Skilled programmers are in high demand, commanding competitive salaries across various industries.
- Versatile Career Opportunities: Open doors to careers in software development, data science, web development, game design, and more.
- Cutting-Edge Skills: Stay ahead in the fast-evolving tech landscape by mastering the most popular and widely used programming languages and frameworks.
- Innovation and Creativity: Enhance your ability to create innovative solutions, develop new technologies, and contribute to exciting projects.
- Problem-Solving Abilities: Strengthen your logical thinking and problem-solving skills, essential for tackling complex technical challenges.
- Career Advancement: Stand out in the job market with a robust programming skill set, increasing your chances of career advancement and promotions.
- Lifelong Learning: Cultivate a mindset of continuous improvement and lifelong learning, staying relevant and adaptable in your career.
**Programming and Coding Lessons for All Ages**
Unlock the world of coding with our comprehensive programming and coding lessons designed for both adults and kids. Whether you're a beginner or looking to enhance your skills, our courses cover a wide range of programming languages and technologies to suit your needs.
**Course Offerings:**
- **Python**: Learn the fundamentals of programming with one of the most versatile and popular languages.
- **HTML & CSS**: Build and style your own websites from scratch.
- **JavaScript**: Add interactivity to your web projects and enhance user experience.
- **MySQL**: Master database management and SQL queries.
- **Dart & Flutter**: Create beautiful, natively compiled applications for mobile, web, and desktop from a single codebase.
- **C++**: Dive into the world of object-oriented programming and system-level coding.
- **C#**: Develop robust applications with this powerful language used in a variety of industries.
**Class Formats:**
- **Offline Classes in Egypt**: Join us in person for hands-on learning and direct interaction with our experienced instructors.
- **Online Classes**: Participate from anywhere in the world with our flexible online courses, designed to fit your schedule.
**Who Can Join?**
- **Adults**: Whether you're looking to start a new career, enhance your current skills, or simply explore a new hobby, our classes are perfect for you.
- **Kids**: Our engaging and interactive lessons make learning to code fun and accessible for younger students.
**Why Choose Us?**
- **Experienced Instructors**: Learn from industry professionals with years of teaching and real-world experience.
- **Comprehensive Curriculum**: Our courses are designed to provide a solid foundation and advanced knowledge in various programming languages.
- **Flexible Learning Options**: Choose between offline and online classes to suit your lifestyle and learning preferences.
Join us today and start your journey into the exciting world of programming and coding with the expert instructor Abdallah!
========================================
Comment:
Looking to master programming and become a skilled developer?
In this course, you will learn the basics and tools to manipulate coding and programming languages as well as using them to build machine learning models. We also provide assistance to students specializing in programming and database management using SQL
Under special request, we provide courses on other programming languages.
If you have any further questions, feel free to contact us.
Coding is a powerful general-purpose programming methods. It is used in web development, data science, software prototyping, etc. Fortunately for beginners, Coding has a simple and easy to use syntax. This makes Python a great language for learning programming for beginners.
In this course, you will learn the basics and tools for manipulating python as well as its use to build machine learning models. We also provide assistance to students specializing in python programming and database management using SQL
If you have any further questions, please do not hesitate to contact us.
Wissam
Android: Programming mobile applications using Android StudioDoctor trainer in IT teaches you step by step how to design mobile applications for the Android system: Interface screen, access and storage of data, access to system services, management of notifications, Reading sensors, design of widgets, optimization.
Notes: I teach the course, and I also support you at the development level (proposals, advice, debugging errors).