Categories
All Tutorials Mysql Tutorials

MySQL Database Management System using MySQL. MySQL for ALL!

MySQL Database Management System using MySQL. MySQL for ALL!

Learn MySQL Database Management System. Complete Database Management System in Mysql – Learn MySQL the easy way

What you’ll learn

MySQL Database Management System using MySQL. MySQL for ALL!

  • Learn how to use MySQL Database Administration
  • MySQL queries
  • MySQL databases updating
  • Learn how to use MySQL – Learn how to filter the data
  • Learn how to create MySQL databases

Requirements

  • There are no prerequisites to this class, other than a pc/mac, and a healthy appetite for learning new things

Description

MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it. It offers the power of a relational database in a package that’s easy to set up and administer, and this course will provide all the tools you need to get started.



In this course, you’ll learn methodically, systematically, and simply–in 50 short, quick lessons that will each take very little to complete.

The course is ideal for the inexperienced programmer interested in adding these skills to their toolbox. New coders who′ve made it through an online course or boot camp will also find great value in how this course builds on what you already know.

What you’ll learn:

1.  Setup a Package Manager

2. Setup Working Environment

3. Select, Keyword, Expressions and Functions

4. ORDER BY ASC and DESC

5. WHERE Clause, LIKE and IN Clauses

6. Insert and update data

7. Create and use database

8. Use tables, indexes, constraints

9. Date and time types and functions

10. Use triggers and transactions

11. Routines, Functions, Procedures

12. PDO

Who this course is for:

  • Any student wanting to learn about data management and MySQL programming.
  • Last updated 7/2019



Download Now
Content From: https://www.udemy.com/course/mysql-and-database-management/



Categories
All Tutorials Mysql Tutorials PHP Tutorials

PHP & MySQL – Certification Course for Beginners Course Catalog

PHP & MySQL – Certification Course for Beginners Course Catalog

Learn to Build Database Driven Web Applications using PHP & MySQL

What you’ll learn

PHP & MySQL – Certification Course for Beginners Course Catalog

  • PHP Variables, Syntax, Variable Scope, Keywords
  • Echo vs. Print and Data Output
  • PHP Strings, Constants, Operators
  • PHP Conditional Statements
  • Learn PHP Elseif, Switch, Statements
  • PHP Loops – While, For
  • PHP Functions
  • Learn PHP Arrays, Multidimensional Arrays, Sorting Arrays
  • Working with Forms – Post vs. Get
  • PHP Server Side – Form Validation
  • Creating MySQL Databases
  • Database Administration with PhpMyAdmin
  • Administering Database Users, and Defining User Roles
  • SQL Statements – Select, Where, And, Or, Insert, Get the Last ID
  • MySQL Prepared Statements and Multiple Record Insertion
  • PHP Isset
  • MySQL – Updating Records

Requirements

  • Basic Computer Skills

Description

Welcome to the PHP & MySQL Certification Course for Beginners.

This course offers a comprehensive guide to learning how to code in PHP. We also explore integrating MySQL Databases into your PHP Projects for dynamic, user-driven functionality.

We start with PHP basics, including variable declaration and data output. The lessons then transition into working with objects, conditional statements, loops, functions, arrays, form validation, sorting, and much more.

After the PHP Section, students learn to unleash the true power of dynamic page development with MySQL database integration. We start with table creation and user management. From there we progress into commonly used SQL statements for database administration. Students are also taught how to create database connections and to execute SQL statements directly from PHP scripts. Our coding style keeps script security, and execution efficiency in mind at all times.

If you are interested in embarking into the world of PHP Development with Database integration, don’t wait another second. Enroll today in this exciting new course.

Who this course is for:

  • Beginner developers who are interested in learning the foundations of PHP.
  • Students who want to integrate MySQL Databases into their PHP Web Applications.
  • Who wants to learn to code in PHP.
  • Students who want to learn how to execute SQL Statements, directly from PHP.
  • Last updated 7/2019




Download Now
Content From: https://www.udemy.com/course/php-mysql-certification-course-for-beginners/



SEE MORE COURSE: Learn JavaScript for Beginners Course Catalog

Categories
AJAX Tutorials All Tutorials Json Tutorial Mysql Tutorials PHP Tutorials

JSON AJAX data transfer to MySQL database using PHP Course Catalog

JSON AJAX data transfer to MySQL database using PHP Course Catalog

Create a dynamic input form that can add data and retrieve data from a MySQL database!​

What you’ll learn

JSON AJAX data transfer to MySQL database using PHP Course Catalog

  • learn to send data from the frontend to backend code
  • create dynamic input forms
  • update MySQL database content with AJAX
  • get MySQL content in JSON format
  • use MySQL data in javascript

Requirements

  • basic javascript
  • basic HTML CSS and PHP
  • desire to learn
  • computer access

Description

Create a dynamic input form that can add data and retrieve data from a MySQL database! Learn to create this project from Scratch

The instructor of this course is a web developer with over 15 years of experience working on hundreds of projects. Sharing real-world coding experience.

This course is ideal for anyone who wants to see multiple programming languages working together. The end product will be an HTML form the can submit data via AJAX to a MySQL database. Using JSON formatted data we display all of the MySQL table contents within our webpage.




JavaScript > AJAX > PHP > MySQL vs MySQL > PHP > JSON > JavaScript

Learn how to use HTML, CSS, JavaScript, Jquery, JSON, AJAX, PHP, MySQL together in one project.

Topics covered include

  • JavaScript Objects
  • JSON formatted data
  • JavaScript AJAX to retrieve data
  • PHP database connection
  • PHP arrays
  • MySQL database with PHPmyAdmin
  • MySQL query strings
  • CSS form and HTML
  • AJAX to PHP JSON formatted data
  • JQUERY AJAX

I know that not everyone prefers JavaScript for AJAX, so I also show you how to re-code the JavaScript AJAX to be JQUERY AJAX. Also, some tweaks and code updates are included. Also, I transform the old PHP data code to newer formats so that students can see the different ways of writing PHP.

All the source files and top resource links are included so that you too can work along with the code practice and learn better.

This course is full of amazing content you won’t see anywhere else.

Who this course is for:

JSON AJAX data transfer to MySQL database using PHP Course Catalog




Download Now
Content From: https://www.udemy.com/course/json-ajax-data-transfer-to-mysql-database-using-php/



Categories
All Tutorials Mysql Tutorials PHP Tutorials

Learn PHP and MySQL for Beginners the Easy Way – 13 Hours Course

Learn PHP and MySQL for Beginners the Easy Way – 13 Hours Course

Learn PHP and MySQL and get ready to take your web development skills to the next level!

What you’ll learn

Learn PHP and MySQL for Beginners the Easy Way – 13 Hours Course

  • By the end of the course, you will have a foundation of PHP and MySQL knowledge
  • Discover how to use PHP variables
  • How to debug PHP code
  • Learn how to read a configuration file
  • Discover the basics of using a PHP library
  • Common security threats
  • Understanding MySQL architecture and installation of MySQL
  • Learning database design
  • Administration of a database
  • Using indexing for database performance
  • Discover SQL for Developers
  • Understanding query analysis and optimization
  • Setting up replication in MySQL

Requirements

  • A text editor and a passion for learning.

Description

Discover how to use PHP and MySQL, a popular choice for developing powerful web applications!




These days, you’re nowhere without a website, so there’s a huge value to web development skills. PHP is one of the most widely-used scripting languages around, and this course will help you master the basics of the language so that you can build your website, or help refine your company’s.
Discover the power of PHP as you take your website development skills to the next level.

During the 6.5 hour PHP beginner course, discover the fundamental concepts beginner PHP developers need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics with coding examples that include exercise files so you get real hands-on practice.

Follow along as you learn the PHP syntax, development environment, and other basic concepts. Discover more advanced topics including database storage, object-oriented development, using the standard PHP library, and basic SQL language commands.

This course includes exercise example files, certificates of completion, and quiz.

During the 5.5-hour MySQL beginner course, discover the fundamental concepts beginner MySQL administrators need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics with practical examples that include exercise files so you get real hands-on practice.



Follow along as you learn how to install MySQL for the first time. Discover critical concepts for designing a database. Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring. Then get ready to take your MySQL skills to the next level as you learn SQL for developers, database replication, data encryption and more.

This course includes a certificate of completion and a quiz.

Who this course is for:

Learn PHP and MySQL for Beginners the Easy Way – 13 Hours Course




Download Now
Content From: https://www.udemy.com/course/learn-php-and-mysql-training-course/



Categories
AJAX Tutorials All Tutorials Javascript Tutorials Mysql Tutorials PHP Tutorials

JavaScript AJAX PHP mySQL create a Dynamic web Form project Course Catalog

JavaScript AJAX PHP MySQL create a Dynamic web Form project Course Catalog

Use JavaScript and PHP to create a database submission AJAX form. Project using JSON AJAX PHP MySQL JavaScript together

What you’ll learn

JavaScript AJAX PHP MySQL create a Dynamic web Form project Course Catalog

  • create dynamic web pages
  • use AJAX to access server content
  • use JavaScript to access the DOM
  • update HTML content via JavaScript
  • use jQUERY
  • use bootstrap

Requirements

  • desire to learn web development
  • HTML CSS JavaScript Experience
  • Basic Database experience

Description

Learn how to make a DYNAMIC WEB FORM that uses AJAX to pass data to MySQL. Learn how to make your HTML page content interact with the BACK-END code.

JavaScript comes to life, we show you all the building blocks you need to create your JavaScript interactive applications.

Source files included!!! No wasted time we get right to the point. Lots of extras to help you learn.

This course covers JavaScript and the fundamental code syntax. We show you the DOM and why it is essential for dynamic web content. Then jquery to save time and speed up the design process. JSON to transfer data between the front and back end code. Then PHP constructor code to interact with MySQL to bring data in from a web form.



No page refresh with AJAX form submission. Also, use AJAX to pull data from PHP in JSON format to output it on your webpage. This is a course that brings it all together how it works together. We also use bootstrap for styling.

Everything you need to learn about creating Dynamic JavaScript web applications is provided within this course.

  • no wasted time watching someone type
  • quick lessons get right to the point
  • fully covered topics with real-world examples
  • source files downloadable to work along
  • challenges and lessons
  • 30-day money-back guarantee
  • new course material added regularly
  • the trusted name in education since 2002
  • full HD easy to read source coding
  • quick response support to students
  • regular discussions

Who this course is for:

  • web developers
  • web designers
  • anyone who wants to learn more about JavaScript
  • anyone who wants to learn about AJAX
  • Who wants to see JSON in Action
  • Anyone who wants to build dynamic web pages
  • Anyone who wants to build a database interactive webform
  • Projects in HTML5 Course – Learn HTML5




Download Now
Content From: https://www.udemy.com/course/javascript-ajax-php-mysql-create-a-comment-submission-form/



Categories
All Tutorials Mysql Tutorials SQL Tutorials

SQL – MySQL for Data Analytics and Business Intelligence Course Catalog

SQL – MySQL for Data Analytics and Business Intelligence Course Catalog

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management

What you’ll learn

SQL – MySQL for Data Analytics and Business Intelligence Course Catalog

  • Become an expert in SQL
  • Learn how to code in SQL
  • Boost your resume by learning an in-demand skill
  • Create, design, and operate with SQL databases
  • Start using MySQL – the #1 Database Management System
  • Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
  • Adopt professionally tested SQL best practices
  • Gain theoretical insights about relational databases
  • Work with a sophisticated real-life database throughout the course
  • Get maximum preparation for real-life database management
  • Add data analytical tools to your skillset
  • Develop business intuition while solving tasks with big data
  • Study relational database management theory that you will need in your workplace every day
  • Learn how to create a database from scratch
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Be confident while working with constraints and relating data tables
  • Become a proficient MySQL Workbench user
  • Acquire top-notch coding techniques and best practices
  • Know how to answer specific business questions by using SQL’s aggregate functions
  • Handle complex SQL joins with ease
  • Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
  • Merge coding skills and business acumen to solve complex analytical problems
  • Become a proficient SQL user by writing flawless and efficient queries
  • Tons of exercises that will solidify your knowledge
  • The freedom to query anything you like from a database

Requirements

  • No prior experience is required. We will start from the very basics

Description

How important is database management in the age of big data and analytics?

It is really important.


How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.

How many people have these skills?

Not enough.

This is why now is the time to learn SQL and gain a competitive advantage in the job market. Remember, the average salary of a SQL developer is $92,000! That’s a lucrative career. SQL – MySQL for Data Analytics and Business Intelligence – Web Courses

How come?   

Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making.

Worried that you have no previous experience?

Not an issue. We will start with the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.



Why take this course in particular? Isn’t it like the rest of the SQL courses out there?

We would like to think it isn’t. Our team worked hard to create a course that is:

  • Easy to understand
  • Time-efficient and concise
  • Shows how SQL can be crucial for data analytics and business intelligence
  • Comprehensive – it covers several topics not shown in other SQL courses
  • Practical – it teaches you how to work with a real-life database
  • Corresponds to professional best practices
  • Taught in MySQL – The most popular SQL database management system
  • Contains plenty of downloadable exercises, course notes, and quiz questions

Others haven’t. However, no one provides such a variety of topics in one place.

We firmly believe this course is the best training material out there. It is a truly interactive experience preparing you for a real-life working environment. SQL – MySQL for Data Analytics and Business Intelligence Course Catalog

We love teaching

So far, over 210,000 students have enrolled in our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the best content for you, our students.



Our mission is to help you bridge the gap between theoretical knowledge taught at school and in universities and the practical application required at the workplace.

So, why do you need to enroll in this course and learn SQL?

  1. Salary/Income. As we pointed out earlier, learning SQL is a great opportunity. There is a significant surge in demand for skills revolving around database management, database administration, and business analysis relying on data. Companies will pay top dollars for specialists who have such know-how
  2. The profession of the future. In the years to come, data will only grow in importance and size. Therefore, it is great to pick up a skill that will likely increase in demand over the years to come
  3. Analytical reasoning. Programming languages are a great way to train your mind. Furthermore, understanding a business task and looking for its solution through writing code can be really interesting and stimulating once you become familiar with the basics

What about certificates? Do you provide a certificate?

Upon completion of the course, you will be able to download a certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.

Sounds awesome, right?

So, what are you waiting for? Click the “Take this course” button, and let’s begin this journey together!

Who this course is for:

SQL – MySQL for Data Analytics and Business Intelligence – Course Catalog




Download Now
Content From: https://www.udemy.com/course/sql-mysql-for-data-analytics-and-business-intelligence/



Categories
All Courses Javascript Tutorials Mysql Tutorials PHP Tutorials

Make a Google search engine clone: JavaScript PHP and MySQL Course Site

Make a Google search engine clone: JavaScript PHP and MySQL Course Site

Learn JavaScript, PHP, and MySQL by building your own search engine from scratch! A COMPLETE walkthrough!

What you’ll learn

Make a Google search engine clone: JavaScript PHP and MySQL Course Site

  • Create a search engine
  • Create a web crawler

Requirements

  • No prior knowledge is required but basic HTML/programming knowledge is advised.

Description

Do you want to become an expert in JavaScript, PHP, and MySQL?





Do you want to build a real search engine just like Google?

If so, you’re in the right place! This course will guide you step by step in creating your own Google clone COMPLETELY from scratch.

We’re talking about the kind of website that will amaze anybody that sees it.

Okay, so what’s the course about?

I will personally guide you, step by step, in creating your own search engine just like Google complete with:

  • Site search
  • Image search
  • Complete pagination system
  • Image full-screen preview
  • And much more!

Whether you are a complete beginner* or an experienced programmer, this course will be massively beneficial to you.

Why should I take the course?

In the programming world, the “big 4” often consists of Google, Microsoft, Facebook, and Amazon. To get a job at any of these companies, you absolutely MUST know the essentials: HTML, CSS, PHP, JQuery, JavaScript and MySQL.





If you take this course, you will have nothing to worry about because we use all of these skills extensively!

Project portfolio:

The site you create in this course will be the highlight of your project portfolio! Any potential employer who sees this project on your resume will want to hear all about it. The reason? They know that a project like this means you’re familiar with the wide range of technical skills they need their employees to know.

Fun!

Finally, this project is a lot of fun and I know you’ll have a great time implementing your own unique ideas as well as the ones we implement together. What are you waiting for?

*You don’t need any experience to take this course, however, a basic understanding of HTML would be great. I will explain everything as I go, but some things I spent more time on than others.




I don’t spend a huge amount of time on the absolute lowest level basics e.g. what is HTML. So if you have absolutely no experience programming, you are absolutely fine to take this course, just ask me to explain things further if you would like a more detailed explanation 🙂

Who this course is for:

Make a Google search engine clone: JavaScript PHP and MySQL Course Site





Download Now (part 1)
Content From: https://www.udemy.com/course/google-search-engine-clone/
Download Now (part 2)



Categories
All Tutorials Java Tutorials MongoDB Mysql Tutorials React and Redux Tutorials SQL Tutorials

Java Programming for Complete Beginners Course Catalog

Java Programming for Complete Beginners Course Catalog

Learn Java Programming with 200+ code examples. For Absolute Java Beginners! Start Learning Java Programming Now!

What you’ll learn

Java Programming for Complete Beginners Course Catalog

  • You will Learn Java the MODERN WAY – Step By Step – With 200 HANDS-ON Code Examples
  • You will Understand the BEST PRACTICES in Writing High-Quality Java Code
  • Will Solve a Wide Range of Hands-on Programming EXERCISES with Java
  • You will Learn to Write AWESOME Object-Oriented Programs with Java
  • You will Acquire ALL the SKILLS to demonstrate an EXPERTISE with Java Programming in Your Job Interviews
  • Will learn ADVANCED Object-Oriented Programming Concepts – Abstraction, Inheritance, Encapsulation, and Polymorphism

Requirements

  • You have an attitude to learn while having fun 🙂
  • You have ZERO Programming Experience and Want to Learn Java

Description

Zero Java Programming Experience? No Problem.

Java is one of the most popular programming languages. Java offers both object-oriented and functional programming features.

We take a hands-on approach using a combination of JShell and Eclipse as an IDE to illustrate more than 200 Java Coding Exercises, Puzzles and Code ExamplesThis course assumes no previous ( beginner ) programming or Java experience. If you’ve never programmed a computer before, or if you already have experience with another programming language and want to quickly learn Java, this is a perfect course for you. Java Programming for Complete Beginners Course Catalog

In more than 250 Steps, we explore the most important Java Programming Language Features

  • Basics of Java Programming – Expressions, Variables, and Printing Output
  • Java Operators – Java Assignment Operator, Relational and Logical Operators, Short Circuit Operators
  • Java Conditionals and If Statement
  • Methods – Parameters, Arguments, and Return Values
  • Object-Oriented Programming – Class, Object, State, and Behavior
  • Basics of OOPS – Encapsulation, Abstraction, Inheritance, and Polymorphism
  • Basics about Java Data Types – Casting, Operators and More
  • Java Built-in Classes – BigDecimal, String, Java Wrapper Classes
  • Conditionals with Java – If Else Statement, Nested If Else, Java Switch Statement, Java Ternary Operator
  • Loops – For Loop, While Loop in Java, Do While Loop, Break and Continue
  • Immutability of Java Wrapper Classes, String and BigDecimal

******* What You Can Expect from Every in28Minutes Course *******

in28Minutes created 20 Best Selling Courses providing Amazing Learning Experiences to 250,000 Learners across the world.

Introduction to Java Programming with Jshell using Multiplication Table

00 – Getting Started with Programming
01 – Introduction to Multiplication Table challenge
02 – Launch JShell
03 – Break Down Multiplication Table Challenge
04 – Java Expression – An Introduction
05 – Java Expression – Exercises
06 – Java Expression – Puzzles
07 – Printing output to console with Java
08 – Printing output to console with Java – Exercise Statements
09 – Printing output to console with Java – Exercise Solutions
10 – Printing output to console with Java – Puzzles
11 – Advanced Printing output to console with Java
12 – Advanced Printing output to console with Java – Exercises and Puzzles
13 – Introduction to Variables in Java
14 – Introduction to Variables in Java – Exercises, and Puzzles
15 – 4 Important Things to Know about Variables in Java

Introduction to Method with Multiplication Table

00 – Section 02 – Methods – An Introduction
01 – Your First Java Method – Hello World Twice and Exercise Statements
02 – Introduction to Java Methods – Exercises and Puzzles
03 – Programming Tip – Editing Methods with JShell
04 – Introduction to Java Methods – Arguments and Parameters (Java Programming for Complete Beginners Course Catalog)
05 – Introduction to Java Method Arguments – Exercises
06 – Introduction to Java Method Arguments – Puzzles and Tips
07 – Getting back to Multiplication Table – Creating a method
08 – Print Multiplication Table with a Parameter and Method Overloading
09 – Passing Multiple Parameters to a Java Method
10 – Returning from a Java Method – An Introduction
11 – Returning from a Java Method – Exercises
12 – Methods – Section Review

Introduction to Java Platform

00 – Section 03 – Overview Of Java Platform – Section Overview
01 – Overview Of Java Platform – An Introduction – java, javac, bytecode and JVM
02 – Java Class and Object – First Look
03 – Create a method in a Java class
04 – Create and Compile Planet.java class
05 – Run Planet class with Java – Using a main method
06 – Play and Learn with Planet Class
07 – JDK vs JRE vs JVM

Introduction to Eclipse – First Java Project

01 – Creating a New Java Project with Eclipse
02 – Your first Java class with Eclipse
03 – Writing Multiplication Table Java Program with Eclipse
04 – Adding more methods for Multiplication Table Program
05 – Programming Tip 1: Refactoring with Eclipse
06 – Programming Tip 2: Debugging with Eclipse
07 – Programming Tip 3: Eclipse vs JShell – How to choose?

Introduction To Object-Oriented Programming

00 – Introduction to Object-Oriented Programming – Section Overview
01 – Introduction to Object-Oriented Programming – Basics
02 – Introduction to Object-Oriented Programming – Terminology – Class, Object, State, and Behavior
03 – Introduction to Object-Oriented Programming – Exercise – Online Shopping System and Person
04 – Create a Motor Bike Java Class and a couple of objects
05 – Exercise Solutions – Book class and Three instances
06 – Introducing State of an object with speed variable
07 – Understanding the basics of Encapsulation with Setter methods
08 – Exercises and Tips – Getters and Generating Getters and Setters with Eclipse
09 – Puzzles on this and initialization of member variables
10 – First Advantage of Encapsulation

Primitive Data Types And Alternatives

00 – Primitive Data Types in Depth – Section Overview
01 – Basics about Java Integer Data Types – Casting, Operators and More
02 – Java Integer Data Types – Puzzles – Octal, Hexadecimal, Post and Pre increment
03 – Java Integer Data Types – Exercises – BiNumber – add, multiply and double
04 – Java Floating-Point Data Types – Casting, Conversion, and Accuracy
05 – Introduction to BigDecimal Java Class (Java Programming for Complete Beginners Course Catalog)
06 – BigDecimal Puzzles – Adding Integers
07 – BigDecimal Exercises – Simple Interest Calculation
08 – Java Boolean Data Type – Relational and Logical Operators
09 – Java Boolean Data Type – Puzzles – Short Circuit Operators
10 – Java Character Data Type char – Representation and Conversion

Conditionals

00 – Conditionals with Java – Section Overview
01 – Introduction to If Else Statement
02 – Introduction to Nested If Else
03 – If Else Statement – Puzzles
05 – If Else Problem – How to get number 2 and choice from the user?
06 – If Else Problem – Implementing with Nested If Else
07 – Java Switch Statement – An introduction
08 – Java Switch Statement – Puzzles – Default, Break and Fall Through
09 – Java Switch Statement – Exercises – isWeekDay, name of the month, nameOfDay
10 – Java Ternary Operation – An Introduction
11 – Conditionals with Java – Conclusion

Loops

00 – Java Loops – Section Introduction
01 – Java For Loop – Syntax, and Puzzles
02 – Java For Loop – Exercises Overview and First Exercise Prime Numbers
03 – Java For Loop – Exercise – Sum Upto N Numbers and Sum of Divisors
04 – Java For Loop – Exercise – Print a Number Triangle
05 – While Loop in Java – An Introduction
06 – While Loop – Exercises – Cubes and Squares up to limit
07 – Do While Loop in Java – An Introduction
08 – Do While Loop in Java – An Example – Cube while the user enters positive numbers
09 – Introduction to Break and Continue
10 – Selecting Loop in Java – For vs While vs Do While

Reference Types

00 – Java Reference Types – Section Introduction
01 – Reference Types – How are they stored in Memory?
02 – Java Reference Types – Puzzles
03 – String class – Introduction and Exercise – Print each word and char on a new line
04 – String class – Exercise Solution and Some More Important Methods
05 – Understanding String is Immutable and String Concat, Upper Case, Lower Case, Trim methods
06 – String Concatenation and Join, Replace Methods
07 – Java String Alternatives – StringBuffer and StringBuilder
08 – Java Wrapper Classes – An Introduction – Why and What?
09 – Java Wrapper Classes – Creation – Constructor and valueOf
10 – Java Wrapper Classes – Auto Boxing and a Few Wrapper Constants – SIZE, BYTES, MAX_VALUE, and MIN_VALUE

Arrays and ArrayLists

00 – Introduction to Array and ArrayList – Section Introduction with a Challenge
01 – Understanding the need and Basics about an Array
02 – Java Arrays – Creating and Accessing Values – Introduction
03 – Java Arrays – Puzzles – Arrays of Objects, Primitive Data Types, toString, and Exceptions
04 – Java Arrays – Compare, Sort and Fill
05 – Java Arrays – Exercise – Create Student Class – Part 1 – Total and Average Marks
06 – Java Arrays – Exercise – Create Student Class – Part 2 – Maximum and Minimum Mark
07 – Introduction to Variable Arguments – Need
08 – Introduction to Variable Arguments – Basics
09 – Introduction to Variable Arguments – Enhancing Student Class
10 – Java Arrays – Using Person Objects and String Elements with Exercises

Object-Oriented Programming Again

00 – Object-Oriented Programming – Level 2 – Section Introduction
01 – Basics of Designing a Class – Class, Object, State and Behavior
02 – OOPS Example – Fan Class – Deciding State and Constructors
03 – OOPS Example – Fan Class – Deciding Behavior with Methods
04 – OOPS Exercise – Rectangle Class (Java Programming for Complete Beginners Course Catalog)
05 – Understanding Object Composition with Customer Address Example
06 – Understanding Object Composition – An Exercise – Books and Reviews
07 – Understanding Inheritance – Why do we need it?
08 – Object is at top of Inheritance Hierarchy
09 – Inheritance and Overriding – with toString() method
10 – Java Inheritance – Exercise – Student and Employee Classes
11 – Java Inheritance – Default Constructors and super() method call
12 – Java Inheritance – Puzzles – Multiple Inheritance, Reference Variables, and instanceof

Collections

01 – Java Collections – Section Overview with Need For Collections
02 – List Interface – Introduction – Position is King
03 – List Interface – Immutability and Introduction of Implementations – ArrayList, LinkedList, and Vector
04 – List Interface Implementations – ArrayList vs LinkedList
05 – List Interface Implementations – ArrayList vs Vector
06 – List Interface – Methods to add, remove and change elements and lists
07 – List and ArrayList – Iterating around elements
08 – List and ArrayList – Choosing iteration approach for printing and deleting elements
09 – List and ArrayList – Puzzles – Type Safety and Removing Integers
10 – List and ArrayList – Sorting – Introduction to Collections sort static method
11 – List and ArrayList – Sorting – Implementing Comparable Interface in Student Class
12 – List and ArrayList – Sorting – Providing Flexibility by implementing Comparator interface

Generics

01 – Introduction to Generics – Why do we need Generics?
02 – Implementing Generics for the Custom List
03 – Extending Custom List with a Generic Return Method
04 – Generics Puzzles – Restrictions with extends and Generic Methods
05 – Generics and WildCards – Upper Bound and Lower Bound

Introduction to Functional Programming

01 – Introduction to Functional Programming – Functions are First-Class Citizens
02 – Functional Programming – First Example with Function as Parameter
03 – Functional Programming – Exercise – Loop a List of Numbers
04 – Functional Programming – Filtering – Exercises to print odd and even numbers from List
05 – Functional Programming – Collect – Sum of Numbers in a List
06 – Functional Programming vs Structural Programming – A Quick Comparison
07 – Functional Programming Terminology – Lambda Expression, Stream and Operations on a Stream
08 – Stream Intermediate Operations – Sort, Distinct, Filter and Map
09 – Stream Intermediate Operations – Exercises – Squares of First 10, Map String List to LowerCase and Length of String
10 – Stream Terminal Operations – 1 – max operation with Comparator

Introduction to Threads And Concurrency

01 – Introduction to Threads and MultiThreading – Need for Threads
02 – Creating a Thread for Task1 – Extending Thread Class
03 – Creating a Thread for Task2 – Implement Runnable Interface
04 – Theory – States of a Thread
05 – Placing Priority Requests for Threads
06 – Communication between Threads – join method
07 – Thread utility methods and synchronized keyword – sleep, yield
08 – Need for Controlling the Execution of Threads
09 – Introduction to Executor Service
10 – Executor Service – Customizing number of Threads
11 – Executor Service – Returning a Future from Thread using Callable
12 – Executor Service – Waiting for completion of multiple tasks using invoke
13 – Executor Service – Wait for only the fastest task using invokeAny
14 – Threads and MultiThreading – Conclusion

Introduction to Exception Handling

01 – Introduction to Exception Handling – Your Thought Process during Exception Handling
02 – Basics of Exceptions – NullPointerException and StackTrace
03 – Basics of Handling Exceptions – try and catch
04 – Basics of Handling Exceptions – Exception Hierarchy, Matching and Catching Multiple Exceptions
05 – Basics of Handling Exceptions – Need for finally
06 – Basics of Handling Exceptions – Puzzles
07 – Checked Exceptions vs Unchecked Exceptions – An Example
08 – Hierarchy of Errors and Exceptions – Checked and Runtime
09 – Throwing an Exception – Currencies Do Not Match Runtime Exception
10 – Throwing a Checked Exception – Throws in method signature and handling
11 – Throwing a Custom Exception – CurrenciesDoNotMatchException
12 – write less code with Try with Resources – New Feature in Java 7
13 – Basics of Handling Exceptions – Puzzles 2
14 – Exception Handling – Conclusion with Best Practices

Files and Directories

01 – List files and folders in Directory with Files list method
02 – Recursively List and Filter all files and folders in Directory with Step Files walk method and Search with find method
03 – Read content from a File – Files read all lines and lines methods
04 – Writing Content to a File – Files write method
05 – Files – Conclusion

Who this course is for:

  • You have ZERO programming experience and want to learn Java Programming
  • You are a Beginner at Java Programming and want to Learn to write Great Java Programs
  • Learn the Basics of Object-Oriented Programming with Java
  • You want to learn the Basics of Functional Programming with Java
  • Content From: https://www.udemy.com/course/java-programming-tutorial-for-beginners/
  • Object Oriented Programming for beginners
  • Last updated 1/2020

Java Programming for Complete Beginners Course Catalog

Download Tutorial (Size: 4.2 GB)

Categories
All Tutorials MongoDB Mysql Tutorials React and Redux Tutorials SQL Tutorials

Microsoft AZ-301 Certification: Azure Architect Design 2020 Course Catalog

Microsoft AZ-301 Certification: Azure Architect Design 2020 Course Catalog

Be able to advise customers and translate business requirements into Azure solutions by taking the AZ-301 exam!

What you’ll learn

Microsoft AZ-301 Certification: Azure Architect Design 2020 Course Catalog

  • Learn how to design and architect Azure solutions

Requirements

  • Azure Solution Architects who advise stakeholders and translates business requirements into secure, scalable, and reliable solutions.
  • This role requires managing how decisions in each area affect an overall solution. Candidates must be proficient in Azure administration, Azure development, and DevOps, and have expert-level skills in at least one of those domains.
  • Candidates should have advanced experience and knowledge across various aspects of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data management, budgeting, and governance.

Description

In order to understand core architect technologies, Skylines Academy will lead you through a series of sections, modules, and demos to prepare you for taking, and ultimately passing, the Microsoft Azure AZ-301 exam.

This course curriculum is as follows:

  • Determine Workload Requirements
  • Design Identity Management
  • Design a Data Solution
  • Establish Business Continuity
  • Design Deployment and Migrations
  • Design and Infrastructure Strategy
  • Example Designs

Lectures will educate you on the fundamental terms and principles of the Azure platform and demos will enable you with a hands-on experience using scenarios to empower you in the real world.

Welcome to the Skylines Academy AZ-301 course! We’re happy you’re joining us!

Note: If you took the AZ-300 course, there will be some overlap. There is a lot to repeat around subjects covered in AZ-300 to make sure you have the basis on core technologies that align with the curriculum. Where possible, I try to make the distinction but you will find that we need to cover core infrastructure topics again before moving onto design elements.

Who this course is for:

  • Azure Architects
  • IT Administrators
  • Content From: https://www.udemy.com/course/microsoft-az-301-certification-azure-architect-design/
  • Investment Banking Course 2020
  • Last updated 1/2020

Microsoft AZ-301 Certification: Azure Architect Design 2020 Course Catalog

Download Tutorial (Size: 3.5 GB)

Categories
All Tutorials MongoDB Mysql Tutorials React and Redux Tutorials SQL Tutorials

MongoDB – The Complete Developer’s Guide 2020 Course Catalog

MongoDB – The Complete Developer’s Guide 2020 Course Catalog

Master MongoDB Development for Web & Mobile Apps. CRUD Operations, Indexes, Aggregation Framework – All about MongoDB!

What you’ll learn

MongoDB – The Complete Developer’s Guide 2020 Course Catalog

  • Use MongoDB to its full potential in future projects
  • Write efficient and well-performing queries to fetch data in the format you need it
  • Use all features MongoDB offers you to work with data efficiently

Requirements

  • General web development or mobile development knowledge will help you but is not a must-have
  • You can use any operating system – Windows, macOS, Linux, it’ll all work!

Description

MongoDB is one of the most important NoSQL databases you can work with these days. It’s extremely popular and MongoDB developers are in high demand.

No matter if you’re building web applications, mobile applications or any other kind of application or if you’re a data scientist – you’ll need to work with data. Storing data, querying it efficiently and minimizing complexities whilst optimizing performance are crucial tasks.

In this course, you’ll learn all about MongoDB from scratch. MongoDB – The Complete Developer’s Guide 2020 Course Catalog

In detail, you’ll learn:

  • … how to install and use MongoDB locally and in the cloud (MongoDB Atlas)
  • … how to perform CRUD (Create, Read, Update, Delete) operations on MongoDB databases
  • … learn how to filter for data efficiently
  • … how to work with both the Mongo Shell and drivers (e.g. Node.js driver)
  • … how to increase performance by using indexes (and how to use the right indexes!)
  • … what replica sets and sharding are
  • … how to use MongoDB Atlas – the cloud solution offered by MongoDB
  • … how to use the serverless platform (Stitch) offered by MongoDB
  • … and much more!

This course is a hands-on course – you’ll learn by writing code/ commands. We’ll work on a wide variety of example data and use-cases and by the end of the course, you’ll have all the knowledge you need to work with MongoDB in your next project!

This course is for you:

  • … if you’re brand-new to MongoDB and databases in general
  • … if you got some basic database or even MongoDB experience – in this course, there are different entry points you can choose from!
  • … you are a web or mobile app (or desktop app) developer who considers using MongoDB
  • … if you’re working in a team that considers using MongoDB (or already does use it)
  • … if you are primarily using SQL-based databases so far and you want to explore the most popular NoSQL alternative

This course is NOT for you:

  • … if you’re looking for a guide on administrating MongoDB servers => This course focuses on the commands/ queries you write, it’s NOT an administration course. I will show (in detail) how to deploy a ready-to-use cloud MongoDB solution that follows best practices though.

Who this course is for:

  • Developers or data scientists who plan on (or are already) working with MongoDB
  • Everyone who’s interested in NoSQL databases
  • Both beginner and advanced MongoDB users who want to explore all the core features
  • Content From: https://www.udemy.com/course/mongodb-the-complete-developers-guide/
  • The Ultimate Excel Programmer Course
  • Last updated 11/2019

MongoDB – The Complete Developer’s Guide 2020 Course Catalog

Download Tutorial (Size: 5.5 GB)