Introduction of Course – Access Training

Definition of a database

Definition of an RDBMS

File extensions

Presentation of the interface

Present Access Objects

Practical Workshop: Creating an Access Database

Table Creation in Access

Create a table

Table creation methods

Data Sheets Mode

Creative mode

Different types of fields

Optimize the size of the fields

The basic tables

Motion tables

Practical workshop: create customer tables and products

Relational model

Introduction to modeling

Relationships 1-1

1-n relations

The relational schema of the base

Define relationships

Edit, delete relationships

Practical workshop: Creating a relationship model

Form Creation in Access

Create a form

Form creation methods

Form opening modes

Creating input forms

Creating consultation forms

Add an object to a form

Edit a form

Hands-on Workshop: Creating Seizure and Movement Forms

Creating queries

Simple queries

Criteria

Filters

queries with SQL

State creation
Create a state

State creation methods

State opening modes

State presentation tools

Introduction to SQL training

Definition of a database

Definition of a Database Management System

Define a relational model

Presentation of different SQL languages: LID, DML, LDD

Module 1: Course on LID

SELECT FROM
SELECT WHERE
SELECT ORDER
SELECT LIMIT
SELECT EXPR …
SELECT FROM JOIN
SELECT AGGR GROUP
SELECT AGGR GROUP HAVING

Module 2: Course on data manipulation (LMD)

Beginning of the DML
INSERT
INSERT SELECT
MULTI TABLE INSERT
UPDATE
UPDATE MULTI TABLE
DELETE
DELETE MULTI TABLE

Module 2: Course on the Basics of Data Definition (DDL)

CREATE TABLE
DROP TABLE
ALTER TABLE

Module 3: Theory

Indexes and types of indexes
FK constraints
Basic modeling, explanation of normal forms 1, 2 and 3
Natural key versus complex key

SQL part

Introduction to SQL training
Definition of a database

Definition of a Database Management System

Define a relational model

Tables and referential integrity

Practical workshop: Installing tools (wampserver and mysqlworkbench)

Understand modeling

Vocabulary of the relational model

Normal forms

Practical Workshop: Creating a Conceptual Data Model

The data definition language (LDD)

Creating tables: syntax

Data types

Types of constraints

Changing the definition of a table

Deleting a table

Introduction to views

Indexes

Transactions overview

Practical workshop: Setting up and modifying the structure of our database

Data manipulation language (DML)

Insertion of lines (INSERT)

Insert multiple rows

Insert from a SELECT

Updated with UPDATE

UPDATE with subqueries

Deletion of registration (DELETE)

Practical Workshop: Modifying the contents of our database

The data query language (LID)

Projection

Selection (or restriction)

The join

Sorting

Practical Workshop: Extraction of data meeting a defined need using restriction criteria, operations and sorting.

Advanced Use

GROUP BY and HAVING

Arithmetic functions

String functions

Transactions: COMMIT and ROLLBACK
Data access control: GRANT, REVOKE

PL / SQL part

Understand PL / SQL
Structure of a PL / SQL program block
Use the Declare Clause
Use the Begin Clause
Creating stored procedures and functions
Running Stored Procedures and Functions

What is cloud computing?
Understand AWS products, services and solutions
Services (processing, storage, Amazon VPC, database)
The basics of identifying AWS services
Security on AWS
Security on AWS – Understanding the Model
AWS architecture

– Principle of cloud architecture
– The pillars of AWS
– The various cloud infrastructure services including: EC2 and VPC, RDS, ElastiCache, S3, IAM, SQS and CloudFront

Different exercises would aim at creating a complete infrastructure that can host a small basic web project. The ultimate goal would be to be able to manually create a basic infrastructure in the cloud and use it. The course would also show the basics of CloudFormation but without digging into it, there would be a usable template that would represent the project mounted during the course.

Overview of Git

Present GitHub

Getting started

Install and configure Git
Using the command line
Make a first commit

Create a remote repository

Log in
Modify a remote repository
Go back

Team working

Commitment Management
Comparison
Using tags
Create and apply patches

The Branch System

Create branches
Merge branches

Go further

Graphical Interfaces for Git

Introduction to Git Training

Overview of Git

Present GitHub

Getting started

Install and configure Git
Using the command line
Make a first commit

Create a remote repository

Log in
Modify a remote repository
Go back

Team working

Commitment Management
Comparison
Using tags
Create and apply patches

The Branch System

Create branches
Merge branches

Go further

Graphical Interfaces for Git

Advanced Training Introduction: HTML5/CSS3, JavaScript/DOM + Responsive Design

Why HTML5?

Tag formatting

HTML, CSS, XHTML, XML, HTML5 standards

The W3C and validators

Encoding logic, ISO-8859-1, UTF-8,..

Basic Concepts Review

Tag types

Style rule syntax

CSS positioning (relative, absolute, float, display)

Practical Workshop: Create an XHTML/CSS site

Transition to HTML5

Syntax, new doctype, and tools

Structure and semantics

Div and span

New HTML5 tags

Practical Workshop: Rebuild our site using HTML5/CSS3

Multimedia Tags

Insert an image (<figure> tag)

Insert a video (<video> tag)

Insert audio (<audio> tag)

Browser compatibility

Practical Workshop: Use JavaScript to control audio and video objects

Forms

New types for <input>

New attributes

New elements <output>

Form validations in HTML5

Practical Workshop: Create an HTML5 form

Drawing: Dynamic Image Creation with JavaScript

Canvas tag

SVG

Drawing shapes (rectangle, circle, etc.)

Colors, fills, gradients

Practical Workshop: Enhance video playback with a progress bar

Geolocation

Overview

Positioning (latitude, longitude)

CSS3

Overview

Syntax, CSS3 prefixes

Rounded corners

Drop shadows

Text-Shadow

Box-shadow

Linear gradients

font-face

Attribute selectors

CSS3: Transformations, Transitions, and Animations

Rotation

Translation

Animations

Practical Workshop: Animate various element properties

Introduction to JavaScript

JavaScript Basics

Core JavaScript concepts

Event handling

Dynamic CSS management

Practical Workshop: Validate fields in our contact form

Document Object Model

What is the DOM?

Node concept

Node hierarchy (DOM Tree)

Relation properties

State properties

Node access methods

Firefox DOM Inspector

Modify HTML content

Modify HTML element styles

Practical Workshop: Create a photo gallery

Responsive Design

Principles

CSS 3 Media Queries

Practical Workshop: Create a multi-platform site (smartphone, tablet, etc.)

Using Bootstrap

Introduction to Bootstrap

Bootstrap installation

Grid system for positioning

Layouts

Responsive Design

Practical Workshop: Create a page using Bootstrap

Bootstrap Components

Dropdown menus

Navigation bars

Breadcrumbs

Introduction to Java Training

Establishment of the development environment
Java programming syntax

Structure of a .java file

Primitive type variable and operator

Comment and document code

The conditions in the code: if / else, ….

Comparison and logic operators

The tables

Buckles

Class method

Object-oriented programming

Goal

OOP comparison and procedural language

Class and object

Methods and attributes

Relationships between classes

Interface concept

Abstract class

Practical Workshop: Class Designs and Linking Classes

Exceptions in the Java language

Principle of an exception

Manipulate exceptions

Java input / output management

Package java.io

Operator reading / writing

Format: binary, text

Character set and encoding

Collections & Files

Presentation of the collections

Iterate on collections

Log Management: java.util.logging

Reading and writing files

Using buffers

Practical workshop: Manipulation of object collections

Java and databases

Principle of the JDBC API

Connect to a database

Retrieve data from a database

Link database data with Java objects

Insert data into the database

Introduction to Python Course

Create your first Python script

Python Syntax

Types and assignment
Calculations, operations
Comments in python
Inputs / outputs
Pass, while, for statements
Range function
Strings
Functions and predefined functions
Files-open a file
Files-Read / Write a file

Practical workshop: Multiple examples

Error handling / Exception

Know the errors
Lift exceptions
Management with try / except

Master the data structures

The lists
The dictionaries
The tuples
Use slices
The enumerate () function
The items () method

Practical Workshop: List as Stack, List as Queue

Modules and Packages

Standard modules
Creating a module
Import a module
Create a Package
Create an executable file

Practical workshop: Writing and testing a module

The basics of the object in Python

Create a first class
encapsulation
Special methods
Function with variable arguments
Errors and Exceptions

Hands-on workshop: creating classes and getting in touch

Database

Install a driver
Insert, delete, modify data in database

Practical Workshop: Application with SQLite

tool

Install the Anaconda distribution

Python for scientific computing: Numpy

Introduction to Numpy
Create ndarray objects
Data selection
Add, edit, delete items
Use numpy functions
Enter exit

Manipulating data with Pandas

Series objects
DataFrames objects
Data selection
Aggregation functions
Merge, Join, Remodeling
Use lambda functions
Make a dynamic crossover (Pivot Table)
Manipulate excel data (csv) and json

Visualize data with Matplotlib

2D curve display
Point cloud display
Histogram display
Web API

Request to an API
Get the answer
Treat the answer
Application: API Twitter, analyze and visualize in time
->