Tag: Bootcamp

Duration

35 hours (usually 5 days including breaks)

Requirements

• Familiarity with database management and database management systems

Audience

• Beginners
• Programmers
• Database admins

Overview

The SQL Development Bootcamp provides comprehensive lessons for SQL development. Topics covered include database design techniques, data manipulation, and simple and complex query methods.

This instructor-led, live training (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.

By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction to SQL Development Bootcamp

Overview of SQL Development

• Data and databases
• Database management systems (DBMS)
• SQL key concepts

Getting Started with SQL Databases

• Installing DBMS software
• Initial configuration
• Connecting existing databases
• Database development methodology

Exploring SQL Statement Fundamentals

• Data definition language statements
• Transaction control statements
• Session and system control statements
• Embedded SQL statements

Working with SQL Data

• Filtering data
• Comparison and logical operators
• Sorting data
• Row limiting clause
• Substitution variables
• Define and verify commands

Using Single Row, Group, Conversion, and General Functions

• Character functions
• Numeric and date functions
• Conversion functions
• Case and decode functions
• Distinct and null values
• Group by clauses
• Having clauses

Working with SQL Join Clauses

• Inner join
• Non-equijoin
• Outer join
• Cross join

Using Subqueries and SET Operators

• Single row subqueries
• Multi row and multi column subqueries
• SET operators
• Correlated subquery
• Data manipulation with subqueries

Creating Databases and Tables

• Data types
• Primary and foreign keys
• Constraints
• Table actions (create, insert, update, delete)
• Data dictionary views
• Conditional expressions

Working with Views, Sequences, Synonyms, and Indexes

• Creating and querying views
• Creating and modifying sequences
• Creating synonyms
• Creating indexes

Managing Schema Objects

• Constraints management
• Temporary tables
• External tables

Controlling User Access

• System privileges
• Object privileges
• Roles
• Revoking privileges

Managing Data in Different Time Zones

• Interval data types
• Time functions

Troubleshooting

Summary and Conclusion

Introductory Course on Programming with Python

Requirements

• No prior programming knowledge is required
• A computer and a desire to learn

Description

Become a Python Programmer and learn one of employer’s most requested skills of 2019! 

This course assumes no previous programming or Python experience. If  you’ve never programmed a computer before, or if you know another  programming language and want to learn Python, this course will teach  you how.

The goal of the course is to introduce students to Python Version 3.x programming.

Here is what you will get and learn by taking this Python Programming Bootcamp (2019)  course:

• How to work with various data types.
• What variables are and when to use them.
• The importance of white space in Python.
• Other.

Who this course is for:

• For Complete Programming Beginners
• Anyone who wants to learn Python

Course content

16 sections • 76 lectures • 2h 59m total length

Learn fundamentals of language of python

Building stronger foundations for learning futuristic technologies such as Machine Learning, Artificial Intelligence etc.

Understand and learn how to create your own efficient python basic programmes

Understand latest python 3

Requirements

• Not at All ! An absolute beginner can also start with the course very easily.
• A computer – Windows, Mac, and Linux are all supported.
• A great zeal to learn this new skill and apply very soon in practical world.

Description

Are you looking for exactly where to begin while learning Python? This course is specifically designed for the students who are genuine seekers for learning python language. The structure is prepared as follows so that it’s most convenient for any beginner to start with:

1. Firstly, I have created detailed Classroom Discussion sessions with my own handwriting so that you understand exactly all the fundamentals and concepts of python.

2. Secondly, Practice sessions of all the discussions have be prepared so that you understand the language better while coding in real life along with me.

3. Lastly, I have shared the practice files and resources to test, whether you have exactly understood whatever I tried to teach in classroom as well as practice sessions.

Most Importantly, It’s Worth your time.

The Structure and Contents of the course are listed in details for your reference before you start this Exciting Journey of Python Programming:

1. Introduction to World of Python

2. Basic Set-up for absolute beginner

3. Classroom Discussion About Strings

4. Practice of Strings Data Type

5. Classroom Discussion about Variables and Data Type

6. Practice of Variables and Data Type

7. Classroom Discussion about Numeric Operators

8. Practice of Numeric Operators

9. Classroom Discussion about Expressions and Operator Precedents

10. Practice of Expressions and Operator Precedents

11. Classroom Discussion about Indexing in Strings

12. Practice of Indexing in a String

13. Classroom Discussion about Slicing out of a String

14. Practice of Slicing out of a String

15. Classroom Discussion about Slicing with Negative Index Positions

16. Practice of Slicing with Negative Number Index

17. Classroom Discussion about Step-in with Strings

18. Practice of Step-in with Strings

19. Classroom Discussion about String Operators

20. Practice of String Operators

21. Classroom Discussion about String Replacements

22. Practice of String Replacements

23. and many more concepts….

Who this course is for:

• Beginner Python developer
• Beginner Python programmers
• Python skill learners
• Python enthusiasts

Course content

Analyze data quickly and easily with Python’s powerful pandas library!

Requirements

• A desktop computer (Windows, Mac, or Linux) capable of storing and running Anaconda. The course will walk you through installing the necessary free software.
• An internet connection capable of streaming videos.
• Ideally some Spreadsheet Basics/Programming Basics (not mandatory, the course guides you through the basics)

Description

Data Analysis with Pandas and Python offers 19+ hours of in-depth video tutorials on the most powerful data analysis toolkit available today. Lessons include:

• installing
• sorting
• filtering
• grouping
• aggregating
• de-duplicating
• pivoting
• munging
• deleting
• merging
• visualizing

and more!

Why learn pandas?

If you’ve spent time in a spreadsheet software like Microsoft Excel, Apple Numbers, or Google Sheets and are eager to take your data analysis skills to the next level, this course is for you!

Why should you learn Pandas?

The world is getting more and more data-driven. Data Scientists are gaining ground with $100k+ salaries. It´s time to switch from soapbox cars (spreadsheet software like Excel) to High Tuned Racing Cars (Pandas)!

Python is a great platform/environment for Data Science with powerful Tools for Science, Statistics, Finance, and Machine Learning. The Pandas Library is the Heart of Python Data Science. Pandas enables you to import, clean, join/merge/concatenate, manipulate, and deeply understand your Data and finally prepare/process Data for further Statistical Analysis, Machine Learning, or Data Presentation. In reality, all of these tasks require a high proficiency in Pandas! Data Scientists typically spend up to 85% of their time manipulating Data in Pandas.

Data Analysis with Pandas and Python introduces you to the popular Pandas library built on top of the Python programming language.

Pandas is a powerhouse tool that allows you to do anything and everything with colossal data sets — analyzing, organizing, sorting, filtering, pivoting, aggregating, munging, cleaning, calculating, and more!

I call it “Excel on steroids”!

Over the course of more than 19 hours, I’ll take you step-by-step through Pandas, from installation to visualization! We’ll cover hundreds of different methods, attributes, features, and functionalities packed away inside this awesome library. We’ll dive into tons of different datasets, short and long, broken and pristine, to demonstrate the incredible versatility and efficiency of this package.

Who this course is for:

• Everyone who want to step into Data Science. Pandas is Key to everything.
• Data Scientists who want to improve their Data Handling/Manipulation skills.
• Everyone who want to switch Data Projects from Excel to more powerful tools (e.g. in Research/Science)
• Investment/Finance Professionals who reached the limits of Excel.

Course content

1 section • 16 lectures • 1h 55m total length

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

Learn Python like a Professional Start from the basics and go all the way to creating your own applications

Requirements

• Beginners who have never programmed before.
• Programmers switching languages to Python.
• Intermediate Python programmers who want to level up their skills!

Description

Become a Python Programmer and learn one of the employer’s most requested skills for 2022!

This is the most comprehensive, yet straightforward, course for the Python programming language on Udemy! Whether you have never programmed before, already know basic syntax, or want to learn about the advanced features of Python, this course is for you! In this course, we will teach you Python 3.

This course will teach you Python in a practical manner, with every lecture comes to a full coding screencast and a corresponding code notebook! Learn in whatever manner is best for you!

We will start by helping you get Python installed on your computer, regardless of your operating system, whether it’s Linux, MacOS, or Windows, we’ve got you covered.

We cover a wide variety of topics, including:

• Command Line Basics
• Installing Python
• Running Python Code
• Strings
• Lists
• Dictionaries
• Tuples
• Sets
• Number Data Types
• Print Formatting
• Functions
• Scope
• args/kwargs
• Built-in Functions
• Debugging and Error Handling
• Modules
• External Modules
• Object Oriented Programming
• Inheritance
• Polymorphism
• File I/O
• Advanced Methods
• Unit Tests
• and much more!

Who this course is for:

• Beginners who have never programmed before.
• Programmers switching languages to Python.
• Intermediate Python programmers who want to level up their skills!

What will you Learn

• You will learn how to leverage the power of Python to solve tasks.
• You will be able to use Python for your own work problems or personal projects.
• Learn to use Python professionally, learning both Python 2 and Python 3!

Who this course is for:

• Developer
• DevOps Engineer
• Network Engineer

Course content

6 sections • 8 lectures • 1h 49m total length