Oracle SQL for beginners Training Course

Duration

21 hours (usually 3 days including breaks)

Requirements

  • Computer literacy
  • Knowledge of any operating system

Overview

Listeners

This training is addressed for people starting to work with the SQL language in Oracle database

The course answer for questions:

  • How to build a query?
  • What possibilities have SQL?
  • What is a relational database?
  • What is the structure and SQL commands

Course Outline

Relational database models

  • The structure of a relational database
  • Connection types of tables
  • The normalization and denormalization database
  • Relational Operators

Download the data

  • Rules for writing SQL queries
  • The syntax for the SELECT
  • Selecting all columns
  • Inquiries from arithmetic operations
  • Aliases columns
  • Literals
  • Concatenation operator

Limiting results

  • The WHERE clause
  • Comparison operators
  • LIKE Condition
  • Prerequisite BETWEEN … AND
  • IS NULL condition
  • Condition IN
  • Boolean operators AND, OR and NOT
  • Many of the conditions in the WHERE clause
  • The order of the operators.
  • DISTINCT clause

Sorting Data

  • The ORDER BY clause
  • Sorting by multiple columns or expressions

SQL functions

  • The differences between the functions of one and multilines
  • Features text, numeric, date,
  • Explicit and implicit conversion
  • Conversion functions
  • Nesting functions
  • Viewing the performance of the functions – dual table
  • Getting the current date function SYSDATE
  • Handling of NULL values

Aggregating data using the grouping

  • Grouping functions
  • How grouping functions treat NULL values
  • Create groups of data – the GROUP BY clause
  • Grouping multiple columns
  • Limiting the function result grouping – the HAVING clause

Retrieving data from multiple tables

  • Types of connectors
  • The use NATURAL JOIN
  • Aliases tables
  • Joins in the WHERE clause
  • INNER JOIN Inner join
  • External Merge LEFT, RIGHT, FULL OUTER JOIN
  • Cartesian product

Subqueries

  • Place subqueries in the SELECT command
  • Subqueries single and multi-lineage
  • Operators Subqueries single-line
  • Features grouping in subquery
  • Operators Subqueries multi-IN, ALL, ANY
  • How NULL values ​​are treated in subqueries

Operators collective

  • UNION operator
  • UNION ALL operator
  • INTERSECT operator
  • MINUS operator

Insert, update, and delete data

  • INSERT command
  • Copy data from another table
  • UPDATE command
  • DELETE command
  • TRUNCATE command

Transactions

  • Commands COMMIT, ROLLBACK, and SAVEPOINT

DDL commands

  • The main database objects
  • Rules for naming objects
  • Creating tables
  • The data types available for columns
  • DEFAULT option
  • Option NULL and NOT NULL

Managing tables

  • Referential integrity CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE
  • Create a table by the query
  • Delete a table DROP TABLE
  • DESCRIBE command

Other schema objects

  • Sequences
  • Synonyms
  • Views

Python Django for Beginners with 2 Practical Projects

Learn Django Basics by Building Real Projects: Employee Directory and Todo App

Requirements

  • Basic Python, HTML

Description

If you are interested in learning how to build web applications with Django, this course is for you. In this course, you will learn the basics of web development using Django, a popular Python web framework. You will gain practical experience by building two real-world projects – an employee directory and a todo app.

The course is designed for beginners with little to no prior Django knowledge, as well as developers with experience in other programming languages who want to learn Django. By the end of the course, you will have a solid understanding of the Django framework and be able to build your own web applications using Django best practices.

The course is divided into modules that cover each aspect of building a Django web application. You will start by setting up your development environment and creating a new Django project. Then, you will learn how to define database models using Django’s Object-Relational Mapping (ORM) system and use Django’s built-in admin panel to manage data.

You will also learn how to create views and templates to render dynamic content and handle user input, also manage the data by performing the CRUD operations.

Throughout the course, you will be building two projects. The first project is an employee directory, which will allow you to manage employee data. The second project is a todo app, which will allow you to create and manage tasks, and mark tasks as completed or uncompleted. This course will also contain an assignment for you.

By the end of this course, you will have gained practical experience in building web applications with Django and be able to apply what you have learned to your own projects. So, don’t wait, ENROLL NOW.

Who this course is for:

  • Beginner programmers who want to learn how to build web applications using Python and Django
  • Developers with experience in other programming languages who want to transition to Python and Django
  • Students who are interested in pursuing a career in web development or software engineering
  • Anyone who wants to improve their knowledge of Django and build upon their existing Python skills
  • Individuals who have some experience with Django but want to review the basics and fill in any gaps in their knowledge.

Course content

4 sections • 21 lectures • 1h 54m total length

Python 101: Unlock Program Skills – From Novice to Expert

Program in an Internet browser, learn Python for 4 hours!

Requirements

  • There are no specific prerequisites. You need a web browser, basic computer skills and the Internet.
  • Install Chrome 18+, Firefox 11+ or Safari 6+ browser. No Internet Explorer.

Description

The course teaches the basic skills of the Python programming language.

To start learning, you need a modern Internet browser, Internet access and the desire to learn new things!

You will learn the following amazing topics about the Python language!

1. Python in Web Browser

Learn how to write, run and save programs on Python directly in your web browser!
For programming in the Python language in a web browser, you will use the codeskulptor site.
Share links to programs you create with colleagues and friends, save links to programs and program files. You do not need to install any additional programs on your computer.

2. Basics of Python Programming Language

Learn to do simple rhyme operations using the Python language. Learn how to output and enter data in Python. You will get knowledge about what are integers, floating-point numbers, strings. You will learn to perform operations with integer numbers, floating-point numbers and strings.

3. Functions, Modules and Control Structures

Learn how to create functions. Learn to use functions as objects for other functions. Create comments and lines of documentation that will help you understand the code for you and other people.
Exceptions in Python

4. Dictionaries, Lists, Tuples and other operations

Create dictionaries, lists (even entire “libraries”!) From numbers and text.

You will learn how to generate large numbers and text arrays simply by their “key”. You will learn how to perform operations with lists, dictionaries and tuples.

5. Tests to verify the knowledge. Example programs.

Universe of Programming is waiting for you. Get started now!

Who this course is for:

  • The course approach for all students who want to start learning the language Python and start programming.
  • Beginners in programming
  • Willing to improve programming skills
  • Who wishes to learn a new programming language Python
  • Improve their productivity and effectivity
  • Who wants to make programming easy and intelligent!

Course content

5 sections • 31 lectures • 4h 43m total length

Python – A course for absolute beginners

From installation through virtualenvironments and the best choice of IDE-s and text editors to 2 sample projects.

Requirements

  • Basic python knowledge and any platform of your choice.

Description

Hello,

My name is Daniel, I’m a pythonista at heart. My goal with this course is to summarize up what I have learnt over the years and possibly get you started more easily with python as I did back then. This course if for absolute beginners with no prior experience to python. The demos work on any platform of your choosing be it Windows/Linux or even MAC. This course starts with a sample installation to prepare your environent and guides you through the best possible choice of IDE-s and text editors. There is also some demo for getting you started with the development process and there are two example projects I have realized in python.

Who this course is for:

  • Anyone who is willing to take a deep dive into python.

Course content

1 section • 10 lectures • 49m total length

Python : Basics you should learn for beginners

Learn the step by step Installation process of Python & Pycharm IDE in detailed

Requirements

  • Computer with internet connection

Description

Hi and welcome to this course,

Python is one of the most popular programming languages in the world, huge companies like google uses it for google search engines and in mission critical applications.

And python is the No 1 Programming language and a great choice for machine learning, data science and AI. To get high paying jobs and to boost up your career, Python is a good option for you.

In this course you will learn how to get started with Python and how to easily install and setup Python on your laptop irrespective on the operating system you use.

In this course you are going to start with downloading process and learn how to find right python version for your OS.

we not only install python, once we are done installing we are going to test the installation process as well by writing a sample python program.

– Python installation on window

– Testing the installation process on Windows Command prompt

– Python installation on Mac OS

– Testing the installation process on Mac Terminal

Disclaimer : Downloaded Lectures are only for reference do not use them or share them to others or do not use for commercial purposes, any miss-use of Course Data & Lectures is a punishable offence & illegal and would be prosecuted legally.

Who this course is for:

  • Beginners or Freshers to Programming language or Python

Course content

2 sections • 5 lectures • 31m total length

Free Python 101 Class Beginners Bootcamp Intro to Python NYC

Python Programming for Beginners Course for your weekends – BREAK THE CODE! From Zero to Hero to Super Hero!

Requirements

  • All you need is an Microsoft Account or an AWS account (both free). You need a browser to login to Azure to run the code or Anacond Installed
  • No programming experience needed although a mind to break the code is needed.
  • Be able to read Python code with confidence without fear with an open mind !
  • Become from Zero to Hero to Super Hero

Description

Python is a very popular programming language used by companies like Google, Facebook, Amazon, Microsoft, etc. Python is used for all variety of things like building websites using Django Python, web scraping, data analysis, machine learning, and natural language processing using Python. Python allows you to code fast, building complex applications with minimum lines of code and use existing libraries and use cloud infrastructure resulting true use of Infra on Cloud and code that is 5 times less than Java and 10 times less than C++ / C#. Python 101 Beginners Coding Boot-camp Class for Analytics. Python Programming for Beginners Course: Python 101 Intro to Python. Python 101 Bootcamp is build up based on the Python classes for Analytics taken in NYC, New York by Shivgan Joshi. Having taught at various bootcamps in NYC and gathering feedback from students this course addresses all the major topics you need to get started for Python Anlytics  if you have never programmed.

  1. Create Azure Notebook Account
  2. Downloading Python Anaconda to your laptop
  3. Intro to common terminology for running Python (AWS, Jupyter, Azure Notebook)
  4. Hello World Practice, Variables, data types, functions, loops
  5. Print Hello World Azure Notebooks & Anaconda Book and Content  Functions (Arguments and Return) Loops (For While) If else  List/Dictionary Nested Loops with if else   
  6. Over 100 code snippets to learn the same concept from different angle and poses

Who this course is for:

  • Begineers who would like to use Python for Analytics should start with this Python 101 Bootcamp Course
  • Anyone one who also thinks to be a python hero and want to become super hero
  • If you thought programming is not for your and want to give a last try!
  • Python is a very popular programming language used by companies like Google, Facebook, Amazon, Microsoft, etc. Python is used for all variety of things like building websites using Django Python, web scraping, data analysis, machine learning, and natural language processing using Python. Python allows you to code fast, building complex applications with minimum lines of code and use existing libraries and use cloud infrastructure resulting true use of Infra on Cloud and code that is 5 times less than Java and 10 times less than C++ / C#.

Course content

7 sections • 40 lectures • 2h 42m total length

Python For Beginners – Learn Python Completely From Scratch

Learn The Basics of Python From Scratch

Requirements

  • Have Access To a Computer and Internet Connection

Description

Welcome to the course!

In this course you will learn the basics of Python completely from scratch!

This course is designed to provide you with a basic introduction of Python and get Python setup and running on your computer ASAP.  You will be slowly be building your own scripts as you learn more along the way throughout this course!

In this course you will learn how to do the following:

  • Setup and install Python in Visual Studio Code effortlessly
  • Learn how to create your very first Python script!
  • How to work inside the python shell
  • How to debug scripts in Python
  • Python Variables
  • Python Data Types
  • Python conditional statements

…and more!

I regularly update the course on a daily basis and constantly add new lectures and course material!

If you are curious about Python and want to see if it’s the right language then this course is for you!

Look forward to seeing you enrolled!

Sincerely,

Robin Haney.

Who this course is for:

  • Beginner Web Developers or anyone new to Python
  • Completely New Programmers Are Welcome!

Course content

10 sections • 43 lectures • 2h 37m total length

python for beginners

Master the fundamentals of Python while working on various use cases in easy steps

Requirements

  • No programming experience needed – I’ll teach you everything you need to know
  • A Mac or PC computer with access to the internet
  • I’ll walk you through, step-by-step how to get all the software installed and set up
  • No paid software required – I’ll teach you how to use PyCharm

Description

Here is what you will get and learn by taking this Python Programming course:

  • When to use Python 2 and when to use Python 3.
  • How to install Python on Windows, Mac, and Linux.
  • How to prepare your computer for programming in Python.
  • The various ways to run a Python program on Windows, Mac, and Linux.
  • Suggested text editors and integrated development environments to use when coding in Python.
  • How to work with various data types including strings, lists, tuples, dictionaries, booleans, and more.
  • What variables are and when to use them.
  • How to perform mathematical operations using Python.
  • How to capture input from a user.
  • Ways to control the flow of your programs.
  • The importance of white space in Python.
  • How to organize your Python programs — Learn what goes where.
  • What modules are, when you should use them, and how to create your own.
  • How to define and use functions.
  • Important built-in Python functions that you’ll use often.
  • How to read from and write to files.
  • The difference between binary and text files.
  • Various ways of getting help and find Python documentation.
  • Practice exercises with solutions so you can start using what you learn right away.
  • A download that contains the scripts used in the presentations and lessons. You’ll be able to look at and experiment with everything you’re learning.
  • Quizzes after each section just to make sure you’re learning the most important aspects of Python programming

Who this course is for:

  • Python for beginners

Course content

2 sections • 11 lectures • 1h 42m total length