| "Beginners Guide to Developing SQL Queries for SQL Server" |
| "Microsoft SQL Server is robust relational database management system used by so many organizations of various sizes including top fortune 100 companies.SQL -Structural Query language is the language used to interrogate and manipulateMicrosoft SQL Server Databases.This course is a beginners course that will walk you through how to develop queriesto execute on and SQL Server Database.We will start by developing queries to :Retrieve data with SELECT Use Aliases Use Case Expressions Retrieve data from a view Eliminate duplicatesFilter data with equality filters Filter data with basic comparisons Filter data with string comparisons Filter data with logical comparisons Filter data with NULL comparisons Use order by clauseSort data by ascending order Sort data by multiple columns Add new records Update existing records Delete records There may be times when want to retrieve data from multiple tables and in coursewe will do that using: Inner joins Left outer joins Right Outer joins We will also be Summarising data with aggregate functions such as:COUNT SUM AVG MIN MAX Grouping data ORDER BY Clause SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases. You will gain the practical skills to choose the best query method to ensure accuracy and avoid common errors or pitfalls."
Price: 154.99 |
| "Introduction to SQL Server Profiler- (SQL Server DBA Tool)" |
| "SQL Server Profiler is a powerful tool that allows you to capture and analyse events, such as theexecution of a stored procedure, occurring within SQL Server. This information can be used to identifyand troubleshoot many SQL Server-related problems.if you are new to using Profiler, this introductory course is where you want to begin. Inthis course , we'll cover the basics of how Profiler works, its core terminology, and how to create andsave basic Profiler traces.One of the things that separate mediocre DBAs from exceptional ones is that exceptional DBAs know how to use the tools available to them effectively.The SQL Server Profiler can help DBA'S: Monitor the activity of the: SQL Server Database Engine Analysis Services -SSAS Integration Services -SSIS Reporting Services -SSRS Monitor and identify performance-related problems with front-end application, queries,T-SQL, transactions, and much more Monitor and identify SQL Server errors and warnings Audit user activity Analyse trace results by grouping or aggregating them Create your own custom traces, and save them, for use whenever you wish We will also cover profiler terminology like: Events Data columns Filters TraceAlso we will be working with traces and templates and learn: How to build custom traces from scratch How to Save Profiler traces to a SQL Server Table How to trace Analysis Services activityAfter the end of this course , you will know why Profiler is such an essential tool in the DBA's armoury, and will: Understand how Profiler works Be familiar with core Profiler terminology, such as events, data columns, filters and traces Understand the permissions required to use Profiler and how to start up Profiler Be able to create and control basic Profiler traces and then save a completed trace to a file."
Price: 124.99 |
| "Learn to code in Java from Scratch" |
| "Learning to code can be both fun and rewarding . Java is a useful ,robust and popular programming language to embark on that journey. The best way to learn programming is my doing and getting your hands dirty.This course is a practical Hands-on course with simple to follow videos that will not overwhelm a beginner programmer.Java is a case-sensitive, modern, general-purpose, object-oriented programming language. One of the reasons Java is so popular is that it is platform independent . You only need to write java code once and then run it on any platform be it mac, windows or Linux.You will learn about: Primitive Data Types Basic Data typesVariablesArraysWe will also build some projects with graphical user interfaces -GUIThe projects include:Digital ClockTemperature ConverterHeight ConverterWord Count ToolThis course will guide you through java basics, its core syntax, and the fundamentals of writing strong java code. I will show you how to install Java JDK and NetBeans IDE. Netbeans is a great IDE for developing in java, and then dive into the language itself. Along the way, we will cover topics such as:Declaring and initializing variables with a variety of data typesExploring Basic Arithmetic operatorsTroubleshoot Compile errorsControlling flow with conditional codeCreating MethodCreating Event Handler methodsUsing Component controls and changing their propertiesIf java is your first step into programming or adding it your existing skillset, these training videos will help you understand the language and use it to build your own great software."
Price: 154.99 |
| "How to generate SQL Insert / Update queries from Excel" |
| "As a database developer and administrator you will create queries frequently. Sometimes you also need to generate bulk SQL queries to insert or update multiple records; Microsoft Excel can be used to generate bulk queries that you can execute on a database server.SQL is the standard language used to interact with databases.In this course i will show you how to build SQL scripts from scratch step by step that you will use during the course to execute insert and update bulk tasks. The skills you will learn on this course will help you confidently approach any bulk SQL request task you in a live production environment."
Price: 39.99 |
| "How to Extract Data from Multiple Oracle Tables Using SQL" |
| "There are times when the data you need to extract from a database are spread across multiple tables and the way to combine the required data from multiple tables is via table joins. This beginners course will explain some of the types of table joins available in Oracle .A join is a query that combines rows from two or more tables or views. Oracle Database performs a join whenever multiple tables appear in the FROM clause of the query. The select list of the query can select any columns from any of these tables. If any two of these tables have a column name in common, then you must qualify all references to these columns throughout the query with table names to avoid ambiguity.There are certain conditions that has to be met before Joins can be implemented.Most join queries contain at least one join condition, either in the FROM clause or in the WHERE clause. The join condition compares two columns, each from a different table. To execute a join, Oracle Database combines pairs of rows, each containing one row from each table, for which the join condition evaluates to TRUE. The columns in the join conditions need not also appear in the select list.To execute a join of three or more tables, Oracle first joins two of the tables based on the join conditions comparing their columns and then joins the result to another table based on join conditions containing columns of the joined tables and the new table. Oracle continues this process until all tables are joined into the result.The types of joins we will cover include: Extracting data using Equi Join Extracting data using Non- Equi Join Extracting data using Cartesian Join Extracting data using Outer Join Extracting data using Self Join"
Price: 104.99 |
| "PostgreSQL For Beginners" |
| "PostgreSQL is commonly known as Postgres and it is also open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.The course also covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings. Topics include:Installing PostgreSQLVerify postgresql installationpostgresql INSERT StatementPostgres UNIQUE ConstraintsPostgres Truncate statementPostgres UPDATEPostgresql INNER JOINRemoving Duplicate RecordsPostgres LIKE OperatorPostgresql OR OperatorSorting Data Server serviceSequencesSchemaRetrieving all Data from TableQuery Data fro specific columnLoading sample databasePostgresql DELETE StatementPostgresql DATA TypesPostgresql CREATE Table StatementPostgresql SubQueryPostgresql UNION OperatorPostgreSQL ORDER BY clausePostgreSQL UNION ALL OperatorPostgreSQL GROUP BY clausePostgreSQL FULL OUTER JOINPostgreSQL CROSS JOINPostgreSQL combining AND OR OperatorPostgreSQL AND OperatorPostgreSQL BETWEEN OperatorPostgreSQL NATURAL JOIN OperatorPostgreSQL SELECT statementCRUD OperationsPostgreSQL EXCEPT OperatorCreate a Database with PG4ADMINCreate a Table with PG4ADMINPostgreSQL NOT OperatorPostgreSQL NOT BETWEEN OperatorPostgreSQL LIMIT OperatorPostgreSQL INTERSECT OperatorPostgreSQL Left JoinPostgreSQL IN OperatorPostgreSQL HAVING clauseComparison operatorsCast and OperatorsFiltering Data with WHERE clauseThis is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL ."
Price: 164.99 |
| "Introduction to Node.js for Beginners" |
| "Node.js is a very powerful JavaScript-based framework/platform built on Google Chrome's JavaScript V8 Engine.It is used to develop web and mobile applications.. Node.js is open source, completely free, and used by thousands of developers around the world. Node was built with JavaScript so it helps if you have some understanding of how JavaScript actually works.Also having some understanding of other web technologies such as HTML, CSS, AJAX is useful.This course is an absolute beginners course that will teach you some Node .js basic fundamentals.Node is quite popular and used by some big companies like eBay, General Electric, GoDaddy, Microsoft, PayPal, Uber, and Yahoo! just to name a few. By the end of this course you will have some basic understanding of Node.js. What You Will Learn Include:Downloading and Installing Node.jsDownload and install sublimetextSynchronous and AsynchronousCallbacksComponents of Nodejs ApplicationCreating your first Nodejs AppModules and PackagesNpmInstalling and using third-party packagesInstalling Express.jsCreating a simple Express AppExpress application generatorCreating and App with Express GeneratorPackage.json FileUnderstanding apps.js fileEditing dependenciesUsing Template engines with ExpressHow to start Node. js serverHow to stop Node.js ServerWhat is RoutingHow routing worksCloning Routing Functions"
Price: 124.99 |
| "How To Build A Facebook Messenger Chat Bot From Scratch" |
| "The latest craze in software interfaces is messenger bots, and Facebook has the largest chat platform by a long shot.In this course, Ill show you how to build your own Facebook Messenger Chat Bot using node js. Well use git to push and deploy our local JavaScript code to heroku cloud. We will be creating a package .json file and installing some dependencies that our chatbot app will need.If you dont already have one, you need to create a Facebook account and a facebook Page.The Facebook Page is the identity of your bot, including the name and image that appears when someone chats with it inside Facebook Messenger.In order to communicate with your bot, people will need to go through your Page.This is a hands-on practical course and what you will learn includes:What is HerokuCreating Heroku accountCreating a facebook page and app -Part 1Creating a facebook page and app -Part 2Creating Heroku app Creating .gitignore fileCreating function for bot to post messages -Part1Creating function for bot to post messages -Part2Creating a ProcfileCreating callback function for chatbot -part1Creating callbacl function for chatbot -part2Commiting changesUpdating npmCreating project directoryTesting your chatbotWhat is NodejsInstalling Heroku cliInitializing gitInitialzing package .json fileInstalling dependenciesDownload and install sublimeText EditorEditing package.json fileCreating index.js fileBy the end of this course you would have developed the skill to create a facebook message bot using git and heroku."
Price: 119.99 |
| "Retrieving Data from Oracle Database with SQL" |
| "Oracle database is one of the top and most widely used relational database management systems in the world .This beginners course will teach you how to retrieve data from an oracle database.We will start off by downloading and installing oracle database 11g express which is free to use. Then we will install TOAD which is a tool we will be using to connect to the oracle database and retrieve data.Topics we will cover in this course includes:Retrieving Data Using SELECT Statements Using FROM clause Using WHERE Clause for filtering data Using NOT Operator Using the LIKE Operator Using IS NULL Using ORDER BY Clause Using DISTINCT Using Describe Using and creating views Using Sub-Query Restricting and Sorting Data Using ORDER BY Clause Using GROUP BY and HAVING Clause Retrieving Data with Aggregate Functions Introduction to aggregate functions Using AVG function Using COUNT function Using MAX function Using MIN function Retrieving Data with Table Joins Introduction to Table Joins Using Equi Joins Using Non Equi Joins Using Cartesian Join Using Outer Join Using Self Join Retrieving Data with Analytic Functions Introduction to Analytic Functions The Syntax Partition By Clause First and Last Function Row number Functions Dense Rank Function Lag Function LEAD Function RANK Function Retrieving Data with SET Operators Using UNION ALL SET Operator UNION SET Operator Using INTERSECT Operator Using Minus Operator By the end of this course you will have enough skill to retrieve data from an oracle database."
Price: 109.99 |
| "Implementing a Data Warehouse with Microsoft SQL Server" |
| "This course describes how to implement a data warehouse solution. students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Target Audience: =>This course is intended for database professionalswho need to create and support a data warehousing solution. Primary responsibilities include:Implementing a data warehouse.Developing SSIS packages for data extraction, transformation, and loading.Enforcing data integrity by using Master Data Services.Cleansing data by using Data Quality Services.Prerequisites :Experience of working with relational databases, including:Designing a normalized database.Creating tables and relationships.Querying with Transact-SQL.Some exposure to basic programming constructs (such as looping and branching).An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.Students will learn how to :Deploy and Configure SSIS packages.Download and installing SQL Server 2014Download and attaching Adventureworks2014 databaseDownload and installing SSDTDownload and installing Visual studioDescribe data warehouse concepts and architecture considerations.Select an appropriate hardware platform for a data warehouse.Design and implement a data warehouse.Implement Data Flow in an SSIS Package.Implement Control Flow in an SSIS Package.Debug and Troubleshoot SSIS packages.Implement an ETL solution that supports incremental data extraction.Implement an ETL solution that supports incremental data loading.Implement data cleansing by using Microsoft Data Quality Services.Implement Master Data Services to enforce data integrity.Extend SSIS with custom scripts and components.Databases vs. Data warehousesChoose between star and snowflake design schemasExplore source dataImplement data flowDebug an SSIS packageExtract and load modified dataEnforce data qualityConsume data in a data warehouse"
Price: 124.99 |
| "Introduction to Data Binding on a Windows Form" |
| "Data binding in Windows Forms gives you the means to display and make changes to information from a data source in controls on the form. You can bind to both traditional data sources as well as almost any structure that contains data.In addition, you can bind any property of any control to the data source.In a Windows application, the easiest way to navigate through records in a data source is to bind a BindingSource component to the data source and then bind controls to the BindingSource. You can then use the built-in navigation method on the BindingSource such a MoveNext, MoveLast, MovePrevious and MoveFirst. Using these methods will adjust the Position and Current properties of the BindingSource appropriately. You can also find an item and set it as the current item by setting the Position property.You can connect your application to data by using the Data Source Configuration Wizard in Visual Studio. After you complete the wizard, you can drag data objects from the Data Sources Window onto your forms to create data-bound controls.This is an absolute beginners course to data binding on a windows forms application. You will learn from scratch how to create a windows form application project and connect to a database and create a dataset. Also you will learn how create data bound controls on your form to display and navigate data from the database. YoU will learn about using table adapters which is used to write SQL queries to populate your windows form.By the end of this course you should be able to bind data to a windows form."
Price: 94.99 |
| "Learn to code by creating 27 Projects" |
| "The best way for a beginner to learn how to code or program is by creating. In this beginner's course i will walk you through how to create 27 projects step by step using three different popular and modern programming languages. You will be learning how to code using C# ,Java and JavaScript.Some of the projects you will be creating in this practical hands on course include:Creating a functional calculatorCreating a digital clockCreating a word count toolCreating a Currency ConverterCreating a percentage tip calculatorCreating a contact form with local storageCreating a web browserCreating a Prime number generatorCreating a Random number generatorCreating a Music PlayerCreating a Paint drawing appCreating a Height conversion ToolCreating a Temperature conversion ToolCreating a Todo List AppCreating a Image Slider AppCreating a Screen saverCreating a Interactive Quiz gameCreating a Ping Pong GameCreating your own google mapsYou will be using a variety of development tools below to create the various projects.( The course will show you how to install these tools)A good text editor like Notepadd++ or Sublime text for JavaScript developmentJDK and NetBeans for developing projects with JavaMicrosoft Visual Studio for developing projects with C#By the end of this course you will have the confidence and skill to create mini projects and understand basic programming conceptsin C# , Java and JavaScript ."
Price: 194.99 |
| "Learn to code - HTML, CSS, and JavaScript" |
| "Learning to code can be both fun and rewarding. It is exciting to be able to write some code that gives the computer a bunch of tasks to perform.I always advise beginners to start with coding for the web to build their coding skills. The three technologies every web developer must know are :HTML : Used to create content CSS: Used to present the contentJavaScript : Used to create interactionThey are the building blocks of all websites and web based projects.This course will teach you the basics of these three technologies by creating A basic one page website project.A calculatorA Todo list appAn interactive quiz app.What You will learn:Coding ToolsInstalling web browsersPlanning a websiteDesigning a websiteChoosing assetsCreate HTML DocumentHTML AttributesMarkUp HTML TextCreate LinksWays to apply CSSCSS SelectorsCSS BOX ModelCSS Margin and PaddingCSS Background colorCSS Font PropertyWhere to add JavaScriptVariables and ArraysConditional statementsFunctionsData TypesOperatorsEventsCreate a calculatorCreate an interactive quizCreate a Todo List App"
Price: 74.99 |
| "Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)" |
| "SQL developers are expected to have a variety of skills that will enable them perform tasks such as: design, implementation and maintenance of structured query language (SQL) databases. They may work as database or web developers, depending on the specific position. SQL developers often spend many work hours seated in front of computers.As an SQL developer, you should have strong analytical, communication, and problem-solving skills. A knowledge of SQL servers, SQL Server Analysis Services -SSAS, SQL Server integration services (SSIS) and server reporting services (SSRS) is also important.This course is Hands-on and by the end of the course you will have experience of working with relational database management systems like Microsoft SQL Server .Some of what you will learn on the course includes following:How to implement a data warehouse solutionDebug and Troubleshoot SSIS packages.Cleansing data by using Data Quality Services.Extend SSIS with custom scripts and components.How to create ETL (Extract,Transform, Load) processHow to deploy SSIS PackageHow to create SSIS package using SQL Server Integration ServicesHow to download and install SQL Server Data ToolsHow to perform data analysis with SQL Server Analysis Server - SSASHow to create reports using SQL Server Reporting ServicesHow to download and install SQL ServerIntroduction to T-SQL basicsHow to implement Table JoinsUsing Aggregate functions"
Price: 194.99 |
| "27 Practical SQL Queries to solve Business Problems" |
| "The best way to build up your skills in any area is by practice. This course is a hands-on practical learn by doing course.SQL ( SQL -Structural Query language ) is one of the most popular and sort after skills in the IT industry. SQL Skills is so important especially with big data and data dependent businesses and applications from Facebook to our local banks.This course was designed with the beginner in mind. The course starts by walking you through how to setup a lab where you will download and install Microsoft SQL Server and the sample Northwind database.In this course we will solve 27 business related problem questions by building SQL queries to interrogate the database and produce the answers to solving the business problems.We will use the following while building our queries to solve the business problems :Retrieve data with SELECTUse AliasesUse Case ExpressionsEliminate duplicatesFilter data with equality filtersFilter data with basic comparisonsFilter data with string comparisonsFilter data with logical comparisonsFilter data with NULL comparisonsUse order by clauseSort data by ascending and descending orderUse Table joins to extract data from multiple tablesUse UNION operator to combine results of two or more SELECT StatementsAggregate functions to compute a single output valueGROUP BY Clause to group related dataBy the end of this course you will be would have gained enough skills to interrogate Database."
Price: 114.99 |
| "Git and GitHub Beginners crash course 2020" |
| "This course shows you how to use Git, the popular open-source version control software, to manage changes to source code and text files. The course is a beginners crash course that will teach you the basics of this popular open source version control system.Version control allows collaborative development which makes it easy for teams to work together on projects.The effective use of version control is important and a useful skill for developers to have in their tool kit.Git is a version control system which is like a series of snapshots of your code which can be referenced at any time.GitHub is a web based graphical interface where you can publish and host your Git repositories and collaborate with other people or teams. Git and GitHub has become the industry-standard version control and publishing platform . Git allows you to track changes and your development process and when used with GitHub it becomes an effective backup mechanism.This course is for absolute beginners and will introduce you to the basics of using a version control system called Git and a collaboration platform called GitHub . Although this course does not involve any programming students who have a basic knowledge of programming or simple HTML might find it easier to follow along . Also experience of using the command line might come in handy though not mandatory as the course is so basic anyone can follow along easily.What you will learn include how to :Install gitCommit files to repositoryWrite commit messagesUnderstand the Git three-tree architectureUnderstand git workflowTrack when files are added and modifiedCreate ignore file to exclude files and directoriesCreate remote repositoryCreate and merging branchesUnderstand HEADPull updatesPush updates"
Price: 134.99 |
| "Coding for Beginners: Using Ruby Programming language" |
| "Ruby is a dynamic, open source programming language with a focus on simplicity and productivity. It has an elegant syntax that is natural to read and easy to write.Ruby is seen as a flexible language, since it allows its users to freely alter its parts. Essential parts of Ruby can be removed or redefined, at will. Existing parts can be added upon.This course will teach you the basic fundamentals of the Ruby programming language.Topics covered include:Ruby GemsInstalling RubyInteracting with RubyArraysVariables and Variable scopeStringsRuby SymbolsRuby ConstantsLogical OperatorsComparison OperatorsArithmetic OperatorsRanges"
Price: 39.99 |
| "Build your own Instagram with Ruby on Rails from scratch" |
| "The best way to learn a programming language and a framework is by building something with it. We are going to build our own style type of Instagram app with authentication system to allow people to sign-up and join in order to post images.The app will also have the option for people to comment on posted images.The app has full CRUD (create,update,read ,delete) functionality.Ruby is a modern object oriented programming language, and Ruby on Rails is a popular and powerful frameworks for building web applications. Rails was built using Ruby and makes it much easier to develop web applications with Ruby. Some notable applications have been built using Ruby on Rails: They incudeBasecamp, Twitter, Shopify, Github, LivingSocial, Groupon, Hulu, Airbnb, Yellow Pages to just mention a few.. A google search will reveal much more..This course is for the absolute beginner to Ruby programming language and Rails framework.I will guide you through setting up your development environment. Then we will cover some basics of the Ruby programming language. We will also install git and touch on github which is used for version control.We will create a complete image sharingapplication like instagram from scratch using Rails and in the process build up your skills.Concepts we will cover while building our Instagram style appproject include:Creating a new rails projectUpdating gems using bundlerStarting rails serverCreating controllersCreating modelsAssociating modelscreating viewsGenerating modelsRunning migrationsCreating postsEditing postsReading postsDeleting postsAdding links to postsCreating commentsDeleting commentsCreating controller actionsSetting up routesAdding resources and automatically generating routesImplementing authentication systemImage uploadingAdding commentsAdding PaginationBy the end of this course you would have developed enough skills to be build other projects."
Price: 164.99 |
| "Learn Ruby and Rails: Build a blog from scratch step by step" |
| "Ruby is a modern object oriented programming language, and Ruby on Rails is a popular and powerful frameworks for building web applications. Rails was built using Ruby and makes it much easier to develop web applications with Ruby. Some notable applications have been built using Ruby on Rails: They incudeBasecamp, Twitter, Shopify, Github, LivingSocial, Groupon, Hulu, Airbnb, Yellow Pages to just mention a few.. A google search will reveal much more..This course is for the absolute beginner to Ruby programming language and Rails framework.I will guide you through setting up your development environment. Then we will cover some basics of the Ruby programming language. We will also install git and touch on github which is used for version control.We will create a complete blog application from scratch using Rails and in the process build up your skills.Concepts we will cover while building our blog project include:Creating a new rails projectUpdating gems using bundlerIllustration of MVC architectureStarting rails serverConditional statementsLoopsCreating controllersCreating modelsAssociating modelscreating viewsGenerating modelsRunning migrationsCreating postsEditing postsReading postsDeleting postsAdding links to postsCreating commentsDeleting commentsCreating controller actionsSetting up routesCreate formsUsing helpersAdding resources and automatically generating routesImplementing basic security-By the end of this practical course you would have developed enough skills to be creative and exapnd this project or build similar type of projects."
Price: 129.99 |
| "Angular4 for beginners: Learn from scratch" |
| "AngularJS is one of the most popular JavaScript framework available today for creating web applications. And now Angular 4 and TypeScript are bringing true object oriented web development to the mainstream, in a syntax that is strikingly close to Java 8. Angular 4 is the next version of Googles massively popular MV* framework for building complex applications in the browser (and beyond).This AngularJS 4 beginners course provides you the skills needed to create dynamic web applications. You will learn about some concepts of AngularJS.Angular allows your application to have an expanded HTML library. Learn to add behaviour to your HTML and speed up your applications responsiveness. Angular js is famous for creating single page application which is known as SPA. Angular developers are well in demand with recruiters.Who is This Course for?This course is aimed at absolute beginners who want learn about Angular Js.Beginner developersBeginner programmersPrerequisitesBasic Knowledge of HTMLBasic Knowledge of CSSBasic Knowledge of JavaScriptWhat You will learn:How to setup a development environment How to create a new project in angular 4How to generate componentsHow to nest componentsHow to use basic templatesHow to use interpolation with your templatesHow to define external HTML templatesHow to define inline HTML TemplatesHow to create arraysHow to use *ngFor directives to display objects of an arrayHow to use conditional statements with your templatesHow to interact with componentsHow to data bind"
Price: 124.99 |
| "Create a Basic Real-Time Chat App with Angular4 and Firebase" |
| "AngularJS is one of the most popular JavaScript framework available today for creating web applications. This beginners course provides you the skills needed to create dynamic web application using angular4.Firebase is database service that is used to provide backend functionality for applications big and small.Firebase has three types of plans including a free plan that allows you real time data download and upload limits and also storage facilities.Firebase on the free plan allow 100 simultaneous connections to your application.Firebase implementation in your application means you do not need to write any backend server code. It supports both web and mobile app deployments.In this beginner course we will be building a real time chat app with Angular 4 using firebase as a backend database server. Angular allows your application to have an expanded HTML library. Learn to add behaviour to your HTML and speed up your applications responsiveness.Who is This Course for?This course is aimed at absolute beginners who want learn about Angular Js.Beginner developersBeginner programmersPrerequisitesBasic Knowledge of HTMLBasic Knowledge of CSSBasic Knowledge of JavaScriptWhat You will learn:How to setup a development environmentHow to create a new project in angular 4How to generate componentsHow to nest componentsHow to use basic templatesHow to use interpolation with your templatesHow to define external HTML templatesHow to use *ngFor directives to display objects of an arrayHow to use conditional statements with your templatesHow to interact with componentsHow to data bindHow to connect to firebase from your appHow to store and work with objects in firebaseHow to save data to the firebase databaseHow to use firebase supported authenication providers"
Price: 119.99 |
| "Learn how to use chrome developer tools" |
| "The Chrome Developer Tools (DevTools for short), are a set of web authoring and debugging tools built into Google Chrome. The DevTools provide web developers deep access into the internals of the browser and their web application.You can Use the DevTools to efficiently track down layout issues, set JavaScript breakpoints, and get insights for code optimization. Every web developer should learn how to use the chrome developer tools to help troubleshoot web app issues and improve the performance of their web apps.All major browsers include developer tools, which enable developers to examine the code of a webpage or app, as well as run tests and evaluate metrics related to that code. Chrome Developer Tools (DevTools for short) is the industry standard.This course will show you how to explore the various tools within the chrome developer tools and equip you with an expanded toolbox for your day-to-day work. We will explore the most commonly used panels within the chrome devtools , including the Console, Elements panel, and Network panel. You learn the basic workflow to fix JavaScript related bugs.Topics include:Setting up your testing and debugging environmentHow to access the chrome devtoolsInstalling Live local serverDebugging JavaScript codeWorking with the Elements PanelWorking with the ConsoleUsing and exploring the Network PanelEmulating mobile devicesLive editing of the DOM elementsSetting up Persistence WorkspaceOpening source files in the Sources panelEditing the BOX-ModelAfter completing this course you will have the basic skills to explore and use the chrome devtools."
Price: 104.99 |
| "Learn how to convert excel data to XML from scratch" |
| "Introduction to basic excel-----------------------------------Microsoft Excel is a powerful tool essential for managingand presenting data in todays working environment.you will gain the knowledge and skills required tocreate and edit worksheets and use formulas .What You Will Learn Include:What is Office 365Setting up Office 365Excel 2016 user interfaceExploring the Excel RibbonCustomizing the Quick Access ToolbarKeeping Tabs on the RibbonEntering Data in ExcelUsing formulas for arithmetic tasksAdding and removing worksheetsResizing columns and rowsMaking worksbook read onlyAdd and remove columnsSharing workbook and tracking changesProtecting workbook and worksheetIntroduction to Basic XML-----------------------------------XML is a mark up language used to record data which isreadable to both people and also a range of software applications.XML is used extensively in the publishing world to filllayouts with content and enable people with no databasedevelopment skills to build data structures with ease.XML is a popular standard for exchanging data betweenapplications and organisations.This course will teach you the very basics of XMLfrom the syntax to document structure.What you will learn includes:How to write a proper XML syntaxHow to create your own custom tagsHow to set a root elementHow to create nested child elementsHow to create a document structureHow to use commentsYou will learn from scratch how to convert excel data into XML and alsohow to convert xml to excel."
Price: 89.99 |
| "Build 7 Useful Python Beginner Projects from Scratch" |
| "Python is a dynamic modern object -oriented programming language.It is easy to learn and can be used to do a lot of things both big and small.Python is what is referred to as a high level language.That means it is a language that is closer to humans than computer.It is also known as a general purpose programming language due to it's flexibility.Python did not get it's name from the snake but rather from the British comedygroup known as Monty Python.Python is object -oriented means it regards everything as an object.An object in the real world could be a person or a car.Python is an interpreted language that does not need to be complied likefor example java programming language.It is interpreted and run on the fly the same time.Python has been used in a lot of places like in creating games,for statistical data andvisualisation,speech and face recognition.Some of the biggest websites on this planet earth use python in one way or another. Examples inlude:GoogleYoutubeFacebookNasaDisneyPixarRedditPinterestInstagramSpotifySurvey MonkeyYahoo MapsThis course is a practical and hand on course where you will create 7 projects from scratchThe projects we will create together are:A Digital ClockA countdown timerA CalculatorA weight conversion toolA times tables generatorA Random number generatorA Number Guessing GameA Vowel removal programThe best way to learn a new programming language is by building something with it. By the end of this course you would have acquired some useful skills to get creative building more apps on your own.I look forward to welcoming you to the course."
Price: 124.99 |
| "Learn MongoDB from scratch: Absolute beginner's introduction" |
| "MongoDB is a document-oriented DBMS, with JSON-like objects comprising the data model, rather than RDBMS tables. MongoDB does not support joins nor transactions. However, it features secondary indexes, an expressive query language,atomic writes on a per-document level, and fully-consistent reads. MongoDB uses BSON, a binary object format similar to,but more expressive than JSON..MongoDB uses dynamic schemas. We can create collections without defining the structure,i.e. the fields or the types of their values, of the documents. You can change the structure of documents simply by adding new fields or deleting existing ones. Documents in a collection need unique set of fields.MongoDB database stores its data in collections not in tables The collections are the rough equivalent of RDBMS tables.A collection holds one or more documents, which corresponds to a record or a row in a relational database table, and each document has one or more fields, which corresponds to a column in a relational database table.As one of the NoSQL database engines, MongoDB is a pretty trendy product at the moment. MongoDB provides for a fairly permissive database experience (compared to that of a relational database). The MongoDB schema is dynamic, which allows you to insert data in a very flexible way.One of the key use cases for MongoDB is storing unstructured data, such as from sensor arrays.MongoDB can comfortably chomp away at large data streams, providing a resilient repository.What you will learnHow to setup your environment of a local mongoDB databaseHow to create a database in mongoDBHow to create a collection in mongoDBHow to drop a database in mongoDBHow to create a CRUD operations in mongoDBHow interact with mongoDB using pythonHow to combine collections in MongoDB"
Price: 134.99 |
| "Complete beginners introduction to SQL" |
| "SQL -Structural Query language is the language used to interrogate and manipulate Microsoft SQL Server Databases.SQL is one of the most in demand IT Skills and has been that way for quite a long time. Data growth is increasing and so also is the demand for professionals with SQL skills.This course is a complete beginners course for those who have had no exposure to SQL.It is a very basic and practical hands on course to introduce you to SQL.We will be using SQL Server as our database engine for this course.Microsoft SQL Server is robust relational database management system used by so manyorganizations of various sizes including top fortune 100 companies.In this course we will coverDownload and Install SQL ServerDatabase conceptsDownload sample databaseAttach sample databaseCreate a viewCreate a tableRetrieve and reading data from a database using SELECT StatementUpdating existing data in the databaseDeleting records from a databaseUse AliasesUse order by clauseSort data by ascending orderSort data by multiple columns Add new recordsUpdate existing recordsDelete recordsJoining TablesInner joins Left outer joinsRight Outer joinsSQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases."
Price: 104.99 |
| "Introduction to Web Development For Complete Beginners" |
| "Programming is the process of writing a set of instructions known as code for the computer to perform a task or series of task.Learning to program is a useful and enjoyable skill to have. Programming allows you to solve various types of problems. There are several programming languages that can be used to write computer programs.In this beginners course we will start with the basic front end languages which are HTML CSS and JAVASCRIPT. These three languages are collectively referred to as front end programming languages used to for web development and programming.If you are thinking of becoming a web developer or just curious about how to build websites HTML is thelanguage you will need to start with. Every website on the planet has been built structurally using HTML.A website is built using a variety of technologies such as HTML which is used to create the structure ;then you haveCSS or cascading style sheets which is used to style or make the website presentable;The third language you need is known as JavaScript which is responsible for the interactivity( This means the actions a visitor performs on a website e.g clicking on a button or completing a form) on the website .What You will Learn:Introduction to HTML BasicsIntroduction to CSS BasicsIntroduction to JavaScript BasicsProjects we will create together:CalculatorDigital ClockInteractive QuizImage sliderTip calculatorTodoListMath Addition GameThank you"
Price: 109.99 |
| "Docker for absolute beginners: Learn Docker from scratch" |
| "Docker is the next step beyond virtualization. A Docker image contains everything it needs to run, independent of the Linux server on which it lives: a copy of the operating system, a database, code, configuration files, dependencies, and so on. Images can also be packaged and shared with other Docker admins. A lot of companies large and small are using Docker to run complex systems with millions of users and hundreds of containers.This course is an absolute beginners introduction to Docker. You will the versy basics of Docker and some of it's concepts. You will learn the basics of Docker, including its containers, Dockerfiles (or base images), and capabilities for networking, how to build your own containers and images and also how to push your images onto Docker Hub remote repository and learn how to create and link containers so they can share data between them.Topics include:Installing Oracle VirtualboxInstalling Docker on UbuntuCreating containersCreating imagesDeleting containersDeleting imagesStarting and stopping containersLinking containersUnderstanding the Docker flowCreating a Repository on Docker HubRunning processes in containersManaging, networking, and linking containersIntroduction to Docker HubPushing images to Docker HubWorking with Docker images and registriesBuilding Dockerfiles"
Price: 114.99 |
| "Learn basic Linux Unix Commands from scratch" |
| "This is a very basic absolute beginners introductory course to Linux Unix.The course introduces you to how to use a LinuxUnix terminal and commands .You will learn how to install Linux in a virtual environment.The topics covered include:Installing Oracle VirtualboxInstalling UbuntuUsing some basic Linux commandsHow to add new usersHow to delete usersHow to change passwordsLinux file systemIntroduction to UnixFlavours of UnixParts of UnixThe KernelThe ShellUnix TerminalUnix is an operating system that is known for multi user and multitasking. Linux is a variant of Unix.It was created in the 1960's by group of engineers who worked at AT&T Bell research labs.UNIX has become kind of open source with different companies ,organisations and even individuals creating their own versions from the open source versions. Although there are different flavors of Unix they alsoshare common similarities hence knowing one flavor of Unix makes it easy to learn or pick up another variant of the operating system fairy quickly.Some of the popular variants of Unix operating system available include Solaris, Red Hat, Fedora ,Ubuntu,and Linux. There are several more this is just a brief mention of the varieties available. some of these variants can be installed both on servers and desktops or workstations.Unix operations are usually done using UNIX commands through a Unix terminal ,however there are some variants of Unix that has a friendly graphical user interface (GUI) like Microsoft windows operating systemIn this course we will be using Ubuntu's terminal to execute out Linux commandsTaking this course will give you a basic Unix skill that you can develop further.Welcome to"
Price: 74.99 |
| "React for absolute beginners" |
| "React.js is a an open-source JavaScript library for creating user interfacesReact adopts a component based approach in developing applications.Every react app can considered a component or a collection of components which can be re-usable.This course is for absolute beginners to react and will teach you from scratch what you need to know to begincreating react based applications. React is fun and easy to learn.React.js is designed to make the process of building modular, reusable user interface components simple and intuitive. With React you can design simple views for each state of an application. You can also use React to efficiently update and render components when your data changes. I will walk you through how to create react components from scratch, review components properties, and component state, as well as the foundational parent/child relationships within React.js. I will also take you through the lifecycle of components . You will be transpiling JSX code using babel which is an in browser transpiler that converts JSX code into readable format.What you will learn includes:Setting up a local react development environmentAccessing React Library via CDNUsing Creating a React App tool to create new react projectsAccessing Reaact from JSBINCreating React ComponentsCreating React Components in ES6Converting React functions to ES6 ClassUsing JSXEmbedding JSX as expressionsUsing propsUsing StateComponent life cycleCreating a React mortgage calculatorCreating a React Todo List AppCreating a React static tweet componentCreating a React countdown timerCreating a React digital clock"
Price: 144.99 |
