FavouritesAdd to Wish List
FavouritesAdd to Wish List
from19.00USD/ h

Database Systems: All Concepts of Graduate Level for CS Graduates

Database systems class is related to all concepts of database from zero to advance. We will discuss all related concepts of database, Normalization, Entity Relationship diagram, Transactions and also will practice of SQL queries on database like oracle, MYSQL, ms sql serve.

Location

Online via webcam

General info

Age:
Adults (18-64 years old)
Student level:
Beginner
Intermediate
Duration:
45 minutes
The class is taught in:English
This java class have all Concepts of java from basic to Object Oriented Programming and then Data Structures to Algorithm designer also. I will deliver lecture of 45 minutes and 5 days a week. Will assist you in assignments, projects, concepts and all related steps.

Ask a question

Send a message explaining your needs and Maham 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              Sunday at 0:00
1              Sunday at 1:00
2              Sunday at 2:00
3              Sunday at 3:00
4              Sunday at 4:00
5              Sunday at 5:00
6              Sunday at 6:00
7              Sunday at 7:00
8              Sunday at 8:00
9              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  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday 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  Friday 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  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15              
16              
17              
18              
19              
20              
21              
22  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
23            Saturday at 23:00  
from $19Online 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 March 2021
  • Google connected

Availability of a typical week

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


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

Alaa
Postgresql Computer Courses For Students and Professionals
Engineer in computer systems and networks with extensive professional experience in various essential sectors, offers courses on the Postgresql DBMS for students to strengthen the level or for professionals to use with Odoo or others ...

Marouane
Business intelligence, data warehouse, Etl, SQL server, star schema or snowflake, power bi
As 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.

Jerome
PhD in cognitive psychology and statistician teaches psychology, neurosciences and statistics
Experienced teacher in science and doctor in psychology and cognitive neurosciences graduated from the University of Strasbourg (holder of a master 2 in research in Biology and a professional master 2 in scientific communication), I offer private lessons in psychology (cognitive , social, developmental psychology, neuropsychology etc.), neurosciences as well as in statistics (theoretical and applied to experimental protocols) with a personalized methodology according to the needs and potentialities of each student. Thanks to a rigorous pedagogical approach, specific and adapted to each request, I offer effective methodological assistance (references available) to meet the expectations of the students and to achieve or even exceed the objectives set. My courses also include a coaching method to optimize the learning and training necessary to pass university exams in psychology, neuroscience and statistics (as well as your research dissertations and oral defenses with or without PowerPoint support). My courses are aimed at students (in psychology, neurosciences, medicine, etc.) wishing to optimize their performance and marks in exams and competitions. Schools, Universities and teaching institutes: Universities of Strasbourg and Paris 8, CNRS, Ecole Polytechnique, ESSEC Business School, ISTH, IONIS Education Group, EEEA, Institut Tocqueville etc.

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.

Ana Sofia
Python Programming for Data Science: From Beginners to Advanced
Presentation : Data Science and Data Analytics. Data Scientist in Banking for 3 years. A comprehensive course designed to equip you with the fundamental skills and knowledge needed to thrive in the dynamic field of data science using Python programming language. My classes offer a structured and hands-on approach to mastering Python's powerful tools and libraries for data manipulation, analysis, and visualization. Methodology : - Online course or presencial - Hands-on course with exercises and guidance to solve them - Presentations with theory and examples

Ana Cecilia
Statistics, Data Analysis, Math, Economics all levels
I am a Ph.D. student at the University of Luxembourg. For the past 4 years, I taught the University: statistics and probability theory to first-year students, and economics to 3th-year students. I really enjoy teaching. I am looking forward to helping students when they need reinforcement on different subjects, or anyone interested in learning the following topics: For maths: System of equations, derivatives, integrals, type of equations, etc. For statistics: Probability theory, descriptive statistics, regression analysis, multivariate analysis, hypothesis testing, and methods for causal inference. For young professionals: I have extensive experience in data analysis, data management, and statistical modeling. My class mixes both theoretical and practical parts using financial data as examples. If you are interested, just write me a message telling me what topics are you interested in learning.

Emna
[PYTHON - Data Science - AI] Learn Python & Data Science & Artificial Intelligence from beginner to advanced
You are a highschool student? You have a baccalaureate? You need help with Python (Algorithmic Programming). I am here to teach you ! I am certified from Python Institute (PCAP: Certified Associate in Python Programming) and I work with Python for more than 5 years. I am also a teacher and my students love the way I teach with (simple, clear and always funny)

Luis Angel
IT, Databases, Office Automation and Information Technologies
Dynamic and interactive learning methodology, development of educational material. Practical development of classes where the main actor is the student as the learning activities are developed in real time with the teacher's instructions.

Noshima
Foundation of Data Science -- For Beginners students.
Hi Students, Foundation of Data Science is for complete Beginners. This course is In-depth knowledge and hands-on tools to use and work with different kinds of data. Gaining practical experience across the data science pipeline by acquiring proficiency in the data science coding language R. Foundations of Data Science is for those who work with both structured – spreadsheets and data tables – and unstructured data and who need to understand how to automate data to gain insights, contribute to strategic discussions and make data-driven decisions. With my Course you’ll gain a broad understanding of the tools and techniques used to work with data. 1. What is Data: Learn about data types, structures and frameworks 2. Interacting with Data: Understanding how data is used and how to use data 3. Where Data comes from: The processes for acquiring and sharing Data 4. Storing & Structuring Data: Working with different types of databases and data sets 5. Cleaning Data: Working with messy or incomplete data sets 6. Analyzing Data: Gaining insights with data science techniques and tools 7. Visualizing Data: Best practices and tools for data visualization and presentation 8. Machine Learning & Artificial Intelligence: How data is used by machines 9. Working as a Data Scientist: What do data scientists really do? 10. Data & Society: Ethics and the uses of data in society

Andrea
PhD graduate Data Science, Data Analysis, Quantitative Methods, Python, Matlab, Statistical Packages/Software, Stata, R, Database, SQL, Ora
SERVICES I can offer my assistance with Data Analysis, Data Science, Quantitative Methods, Analysis, Statistical Modelling, Forecast, Regression, Coding, Python, Matlab, Excel statistical software and packages such as Stata, R and Database languages such as SQL, Oracle, MySql and other Business-related subjects (with coding and programming if you are interested in it). I understand that there are different kinds of learning methods, so as long as you can find your style and the appropriate method, I believe that you can get twice the result with half the effort. I have been told to be good at breaking down complex statistical and modelling concepts, explaining them in diagrams, and also relating them to their uses in our daily lives. I can help you to understand statistics, econometrics, linear regression, forecast modelling, statistical modelling, quantitative methods, as well as introducing you to the fast-growing field of Data Analysis and Data Science. I can teach how to use Python, Matlab, Stata, R, Sas, R, Excel, SQL, Oracle, MySql and many more. - Statistics - Machine Learning - Deep Learning - Probability - Linear Regression - Statistical Modelling - Analysis - Data Analysis/Science - Modelling - Forecasting model - Time Series Analysis - Quantitative Methods - Python - Matlab - Stata - R - Sas - Excel EXPERIENCE AND EDUCATION - PhD graduate in Finance, with 5 years of research experience and scientific contribution in the field of empirical asset pricing with focus on equity factor models, machine learning for asset pricing, regime switching models, sentiment analysis, and portfolio construction - Freelance tutor and consultant in Finance, Data Science, Python, Statistics, and Econometrics for 3 years with 1500+ hours delivered to 150+ students and customers internationally - Former financial analyst with 4 years of experience in design and realization of prototypes of several financial algorithms of a proprietary software for portfolio management, analysis, and consulting - Experienced in written and oral communication to various audiences, from academic students to financial industry leaders and professionals through reviewing, editing, teaching, consulting, and oral presentations - Former University Teaching Assistant, strong analytical background with extensive classroom and online teaching experience, MSc in Quantitative Finance, Bachelor of Science in Economics and Finance - Excellent material available including slides, videos, tutorials and reading material. Extensive experience in research methods and software including Python, Jupyter notebook, Matlab, Sas, Stata, R, SQl/Oracle and Excel. - I thoroughly enjoy helping others, as my patience and friendly nature makes it easier to be in an educational environment. - I have learnt to adapt to different needs and learning styles according to the student, in order to optimise their success in turning their weaknesses into strengths. - I'm patient, friendly and understanding. I am proficient in research and development and it’s my day to day work. I am a photography enthusiast and an insatiable learner. GREETINGS My goal is also to inspire further study that will lead to an interesting and successful career. If you need further information about myself or my services, please do not hesitate to contact me. Feel free to send me a message and I'd be happy to give you an informal consultation. Thank you for looking at my profile and hope to hear from you soon, Andrea

Ray
Data Science Course (specialised course on Artificial Intelligence)
Specialized course to become a data scientist. I have found a student who wants me to tutor him how to become a data scientist and he has asked me to set up an account on this, so here I am. This course will go through the fundamentals of AI.

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

Emna
The basics of computer science, programming for beginners, students or adults wanting to change their field
I give basic computer science courses for primary school, high school, university students or for people who want to change their field and start computer science from scratch. Html, css, javascript, database, algorithmic. During the first session we discuss with the participant and prepare the program according to their needs. And during the second session we install together what is necessary for the course.

Mouadh
🎉 PyFun: Comprehensive Programming from Basics to Advanced for Everyone!
Unlock the power of Python and elevate your programming skills with our comprehensive Python Tutoring course. Python is a versatile and widely-used programming language that's ideal for beginners and valuable for seasoned developers. This course is your roadmap to mastering Python's intuitive syntax and its powerful libraries. With personalized tutoring, you'll gain hands-on experience in coding, debugging, and deploying your own Python projects. Our tailored approach ensures that you'll be adept at thinking like a programmer, ready to tackle any coding challenge. Transform your ideas into reality and become a proficient programmer with the skills that are in high demand across countless industries.