Oracle Data Base (Essentials / Advanced) + Assessment on demand

This project-based course teaches Autodesk Revit and Building Information Modeling (BIM) and is taught by an experienced educator with experience in both online and in-person tutoring. Students will gain knowledge of BIM workflows, manage views and documentation, design and edit architectural elements, and navigate Revit. Participants will be able to create professional documentation and fundamental architectural models at the end of the program. The course is also customizable based on students needs and will be catered to what they are trying to achieve.

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

Course description: This comprehensive course is designed for architects, designers, engineers, and creatives who are passionate about 3D modeling and parametrics. You will learn to master Rhino 3D, a powerful 3D modeling software, as well as Grasshopper, a parametric plugin that allows you to generate complex shapes using visual programming. Course objectives: Learn how to use Rhino's basic and advanced tools to create accurate and detailed 3D models. Master the concepts of parametric modeling using Grasshopper to generate dynamic and adaptive shapes. Understand how Rhino and Grasshopper integrate to automate design processes and improve efficiency. Create real-world projects ranging from designing simple geometric shapes to complex, custom structures. Course content : Introduction to Rhino 3D: Interface, basic commands, and navigation in the 3D workspace. Advanced modeling techniques: Creation of surfaces, solids and networks of curves. Introduction to Grasshopper: Understanding the logic of visual programming and its applications in parametric design. Parametric Design: Using Grasshopper to create complex shapes based on variables and constraints. Practical application: Completing a complete project by combining Rhino and Grasshopper, from design to completion. Prerequisites: No specific prerequisites are necessary for this course. However, a basic knowledge of 3D design or modeling software is a plus. Target audience : Architects and designers wishing to deepen their skills in 3D modeling and parametric design. Engineers and technicians interested in design automation and the integration of digital solutions into their creative process. Methodology: The course combines theoretical explanations with practical exercises and case studies. Question-and-answer sessions and workshops will allow participants to work on personal projects throughout the training.

The amount of time required to book on the platform for rendering your ideas depends on the scale and level of detail of the render -------------------------------------------------- ----------- Depending on the needs of the student, the number of hours that must be booked by the platform to carry out the renderings and 3d modeling is calculated.

In this course, you will learn how to scan any object using Reality Capture software. This efficient and powerful software was first used for the preservation of archaeological objects and historical monuments, but is now used for video games, VFX and virtual reality, as it offers tools and results of a impressive quality, all in an easy-to-use interface. In this course, you will be able to learn: -How does photogrammetry work? -How to take suitable photos -How to prepare these photos for their use in the software -How to use these photos to reconstruct an object in 3D and apply a realistic texture to it -How to optimize scans for custom use (games, movies, etc.) Gradually, we will solidify these skills to learn how to build a library of highly realistic objects based on high resolution scans. It is also possible to present your projects to me and to obtain personalized help on them.

Engineer in Statistics and Econometrics graduated from the University of Strasbourg, holder of a master 2 of research in Statistics and Econometrics and an engineer degree Data Science. I have worked a lot on several projects in statistical data analysis and econometric models, I therefore offer detailed and depth courses in Statistical / Econometric Analysis. I help you in your modeling projects in Statistics / Econometrics and Data Science: - Advanced Statistics and Machine Learning Modeling - Bayesian econometrics - Multivariate Time Series Analysis and Forecasting - Statistical Methods in Econometrics - Semi and Non-parametric Econometrics - Modeling assistance (R / Python / Stata, ...) - Micro & Macro-econometric Evaluation of Public Policies

Je propose des cours complets en Power BI, analyse de données, science des données et algorithmes d'apprentissage profond, adaptés à tous les niveaux d'expérience. Mon approche pédagogique se concentre sur l'acquisition de compétences pratiques, vous permettant d'appliquer directement ce que vous apprenez dans des projets réels. Dans le cadre de mes cours de gestion de données, vous apprendrez à transformer vos données en visualisations interactives et informatives, en maîtrisant les techniques de création de tableaux de bord, de rapports et d'analyses visuelles. Vous découvrirez également comment connecter différentes sources de données et optimiser vos modèles pour des insights pertinents. En ce qui concerne l’analyse de données, vous développerez une compréhension approfondie des méthodes statistiques et analytiques, vous permettant de tirer des conclusions significatives à partir de vos données. Vous serez initié aux outils et aux techniques de manipulation des données, y compris l'utilisation de langages de programmation tels que Python, R, PowerBI ou TABLEAU. Dans le domaine de la science des données, nous explorerons les étapes clés du processus de data science, de la collecte et le nettoyage des données à la modélisation et à la validation des résultats. Vous serez également introduit aux algorithmes d’apprentissage profond, apprenant à construire et à entraîner des modèles neuronaux pour des applications variées, allant de la reconnaissance d'image à la prévision. Chaque cours est structuré autour de projets pratiques et de cas d’étude, afin de vous préparer à relever des défis réels en matière d’analyse et d’interprétation des données. Si vous êtes prêt à développer vos compétences en Power BI, analyse de données, science des données et apprentissage profond.

Rhinoceros has become a major 3D Modeling tool in the architectural and design market. As an advanced user of Rhino who has been using it for more than 7 years, I enjoy its amazing capabilities that revolutionize previous 3D modeling tools by incorporating advanced tools and excelling in the organic realm. I've used it during my bachelor and master's university years to model my projects because of its speed and enormous capability. It excels in linear and curvy forms and combines the best of both worlds with its versatile commands and features. This class introduces you to this fascinating software step by step. I'll guide you from getting to know the basics till being able to model complex advanced structures.

Are you ready to unlock a world of creative possibilities and boost your career prospects? As a seasoned instructor with a proven track record of teaching 3D modeling using Rhino 3D, I bring extensive experience gained from years of instructing at three universities. Rhino 3D isn't just another software; it's a gateway to innovation across various industries, including architecture, product design, engineering, and it even offers exciting opportunities for DIY enthusiasts. Learning this powerful tool can not only enhance your skill set but also open doors to exciting career opportunities, allowing you to bring your imaginative designs to life. Join my classes, and let's embark on a transformative journey of skill development and professional growth together. Your career's next chapter starts here!

2D autocad and 3D Rhino softwares are very significant to master in order to express the spatial quality in different dimensions. The class will introduce the tools, commands and quick skills from the software meanwhile will solve all your questions about these softwares and make them into practice. The teacher has 15 years experience in practice with the softwares.

Blender is a free and open source 3D modeling and animation software. Increasingly used by major productions, it is a software suite on its own and it now rivals the industry biggest nouns. It allows you to carry out animation or visualization projects from A to Z: from the creation of complex objects or simulations, to texturing, animation, highlighting and rendering; not to mention motion tracking (VFX), video editing or game development tools. Whatever your level on Blender or your knowledge of 3D modeling, I suggest you develop your skills through concrete exercises allowing you to progress step by step. We can also start from the needs of your project, if you have one, in order to help you achieve your objectives more quickly. I have been using Blender since 2009 for both professional and personal projects and today it is above all out of passion that I offer to accompany you in mastering this software. Looking forward to seeing you in class!

Experienced Renewable Energy & Mechanical Engineer: Renewable Energy: - Fuel Cells/Electrolysers - Solar PV Engineering Projects. - Renewable Energy Projects - Energy System Modeling - Hybrid Power Plants with energy storage. - Matlab coding. I have a Masters in Sustainable Energy, specializing in Fuel Cells, Hydrogen Technology, and Solar PV. With in-depth understanding, modeling skills, and knowledge in these areas, I can provide expert guidance. Additionally, my Mechanical Engineering degree enables me to assist with subjects like thermodynamics, heat transfer, Mechanics, Physics, and Machine Design. Feel free to reach out for any support you need in these fields.

Whether you are a beginner, a designer or just curious to learn, go for it. Being self-taught is great to start with, but I learned that you also develop bad habits very easily. As a trainer, I'll give you access to Blender 3.x essentials training so we can focus on honing your skills in private lessons. My methodology is simple, it wants to be accessible and adapted to the learner, that's the whole point of a private course. Let's explore Blender 3.x together through an introductory or advanced course.

I specialized in Computational Chemistry for University and High School Levels. In the future, this field is promising for teachers who want to learn about visualization and chemical drawing software, such as Marvinsketch, Chemsketch, Avogadro, and so forth. The following are computational topics you may get from my lecture: 1. Basic on Linux Command 2. Basic scripting in python, R, and Fortran 3. Fundamental aspects of Computational Chemistry 4. Tutorial on computational chemistry software, e.g., DFTB+, NAMD, GROMACS, GAMESS, ORCA, Gaussian, and NWCHEM. 5. All simulations will be performed on your computer. Thus, I will guide you to install all of them.

You will learn the basics of modeling in a professional and scientific manner that will enable you to build three-dimensional models with ease and skill, such as: Buildings, aircraft, cars, furniture and various products for companies. And the consequences of this, including lighting, colors, and rendering (export), all of this in gradual, thoughtful, and scientific steps that put your foot firmly on the path to professionalism and mastery. These lessons feature continuous supervision and practical work that we will work on so that you can generalize these skills and tools to everything that comes to your mind. Due to my long experience, I can confirm that, through the first lessons, you will relate to modeling and the program on your next professional path.