Tag Archive: database

December 11, 2019   /   by Marco   /   , , , , , , ,

SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP

SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP

If you have multiple databases hosted on VestaCP the easiest way I found to backup all the databases is to use a script. The first thing you need to do is create a backup account in mySQL that has view only access to all the databases. CREATE USER ‘backupuser’@’localhost’ IDENTIFIED BY ‘xxx’; GRANT SELECT, SHOW […]

read more

March 19, 2019   /   by Marco   /   , , , , ,

HOW TO FIX DELETING A TABLE THAT DOESN’T EXIST

HOW TO FIX DELETING A TABLE THAT DOESN’T EXIST

In my mySQL database I noticed that there was a table missing from phpmyadmin. I tried creating the table but mySQL reported that it already exist (it was a ghost table). I tried using mysqlcheck to repair the database and it came back saying it the table didn’t exist. I then tried to create the table and […]

read more

February 2, 2017   /   by Marco   /   , , , , , , , , , , ,

Database Administration with Microsoft SQL Server and Oracle SharePoint for $39

Database Administration with Microsoft SQL Server and Oracle SharePoint for $39

Learn How to Implement & Manage Corporate Data Infrastructure & Make Your Resume Leap
Expires March 11, 2017 23:59 PST
Buy now and get 98% off

KEY FEATURES

Corporate environments rely on the smooth management and interchange of data to succeed on a day to day basis. To do this, many businesses rely on Microsoft SQL Server and Oracle Sharepoint. In this course, you’ll learn all the essentials to administering these systems in a corporate environment, giving you a leg up towards high-paying jobs in the IT sector.

  • Access 6 comprehensive courses 24/7
  • Write basic transact-SQL queries for Microsoft SQL
  • Maintain a Microsoft SQL Server 2012 database
  • Learn how to create a data warehouse in SQL Server 2012
  • Understand how to query a SQL Server
  • Discover core & advanced solutions of Oracle Sharepoint Server 2013

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming, mobile streaming
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

e-courses4you’s mission is to provide forward thinking training with you in mind. Whether you want to advance up the career ladder, are looking to start a new job, are thinking about a home based business or want to improve your general health and fitness, e-courses 4 you, will deliver you training to improve EVERY aspect of your life.

Their courses are provided by leading experts in their fields. Celebrity partners include Brian Tracy, Tony Robbins, and Stephen Covey and their business packages are partnered by Microsoft to bring you content which is not just average but outstanding!

For more details on this course and instructor, click here.

read more

February 2, 2017   /   by Marco   /   , , , , , , , , , ,

SQL Database MasterClass: Go from Pupil to Master for $19

SQL Database MasterClass: Go from Pupil to Master for $19

Get Immediate Hands-On Experience Working with Databases
Expires June 07, 2021 23:59 PST
Buy now and get 62% off

KEY FEATURES

Do you want to master SQL, and start making more money with each paycheck? Even the lowest payed SQL developers make upwards of $60,000 per year, and this course will teach you the skills necessary to rock out SQL Statements, Views, Stored Procedures, and more.

  • Study database design w/ 50 lectures & 6 hours of content
  • Design a database from scratch & understand the thought process behind it
  • Building on basic SQL skills w/ more technique
  • Learn techniques that even you average DBA doesn’t fully understand
  • Study SQL Statements, Views, Stored Procedures, Triggers, User Defined Functions & more
  • Add essential SQL skills to your resume
  • Build the database back-end for an application

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Compatibility

  • Internet required

THE EXPERT

Bill Sims has spent his life teaching others how to be better developers and master the art of software engineering. He has designed many enterprise-level applications as well as iOS and Android applications. The skills he teaches in his courses are the same skills that he uses every day to do everything from running his teams to consulting on projects. In his career, he has found classes like this to be helpful in advancing his career, and he hopes to drive you to the next level in your own career.

For more details on this course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

read more

January 13, 2017   /   by Marco   /   , , , , , ,

HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASE

HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASE

One of the websites I manage Digital Signage Blog was not displaying correctly (posts were not displaying, menu was missing links to the categories and only displaying pages) and after some investigation, I discovered one of the database tables (the categories table – wp_term_taxonomy) was corrupted. I attempted to repair the database by using these instructions […]

read more

January 12, 2017   /   by Marco   /   , , , , , , , , , ,

Oracle Database 12c Administration Training Bundle for $49

Oracle Database 12c Administration Training Bundle for $49

Become a Well-Paid Oracle Database Administrator with These 37 Hours of Training
Expires March 13, 2017 23:59 PST
Buy now and get 97% off

Intro to SQL

KEY FEATURES

SQL is one of the top tools for database management on Earth, and an important skill in many industries that can help your resume stand out. In this course, you’ll learn the basics of writing Oracle SQL statements, honing the skills that allow developers, database administrators and end-users to write queries against single and multiple tables, manipulate data in tables and take advantage of Oracle supplied row functions. It’s the first step toward mastering this invaluable tool.

  • Access 26 lectures & 6 hours of content 24/7
  • Learn how to access database data w/ a basic SELECT statement
  • Access data from more than one table
  • Manipulate database data
  • Decide where best to use Oracle-supplied functions in place of user-written code

PRODUCT SPECS

  • Length of time users can access this course: 1 year
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

At GogoTraining, their mission is to help you master the world by unlocking your full potential. They do that by working with technology masters to create curriculum paths in key technologies. These paths allow you to jump in at the level that is right for you so you can master the technology. For more details on this course and instructor, click here.

Advanced SQL

KEY FEATURES

This course will take your SQL knowledge to an advanced level, helping you to query and manipulate data more effectively within a database. You’ll discuss advanced querying and reporting techniques like using SET operators, writing hierarchical queries, and using the flashback query feature. By course’s end, you’ll be working with databases like a pro and have a highly employable skill.

  • Access 26 lectures & 7 hours of content 24/7
  • Combine SQL result sets into a single result set using SET operators
  • Access data from a previous point in time using the flashback query feature
  • Combine multiple SQL statements into one statement
  • Create various database objects

PRODUCT SPECS

  • Length of time users can access this course: 1 year
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

At GogoTraining, their mission is to help you master the world by unlocking your full potential. They do that by working with technology masters to create curriculum paths in key technologies. These paths allow you to jump in at the level that is right for you so you can master the technology. For more details on this course and instructor, click here.

Oracle 11g PL/SQL Programming Part 1

KEY FEATURES

PL/SQL is Oracle’s proprietary database language, used by many companies around the world to manage mass amounts of data. Over this course, you’ll get your first introduction to this powerful language, learning how to create PL/SQL blocks of application code that can be shared by multiple users, forms, reports, and data management applications. This comprehensive course will serve as the foundation for your understanding of some of Oracle’s top tools.

  • Access 18 lectures & 5 hours of content 24/7
  • Describe the features & syntax of the PL/SQL language
  • Use PL/SQL programming constructs & conditionally control code flow
  • Understand the Simple loop, While loop, & For loop
  • Handle runtime errors
  • Run both pre-defined & user-defined exceptions
  • Design & execute PL/SQL anonymous block

PRODUCT SPECS

  • Length of time users can access this course: 1 year
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

At GogoTraining, their mission is to help you master the world by unlocking your full potential. They do that by working with technology masters to create curriculum paths in key technologies. These paths allow you to jump in at the level that is right for you so you can master the technology. For more details on this course and instructor, click here.

Oracle 12c: Database Administration I Part 1

KEY FEATURES

Oracle provides some of the leading database management tools on Earth, and in this comprehensive course you’ll get a full-scale introduction to using and administering databases with Oracle software. You will explore how an Oracle Database applies ‘cloud computing’ to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients, and develop the skills to manage this computing in enterprise environments.

  • Access 22 lectures & 5 hours of content 24/7
  • Explain Oracle’s architectural components
  • Demonstrate how to use Oracle’s universal installer & configuration assistants
  • Identify the different interfaces to an Oracle database
  • Define Oracle’s Multitenant environment
  • Explain how to use schema & user management tools
  • Contrast the different techniques for importing data to an Oracle database & exporting data from an Oracle database
  • Describe PL/SQL declarations, code and exceptions

PRODUCT SPECS

  • Length of time users can access this course: 1 year
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

At GogoTraining, their mission is to help you master the world by unlocking your full potential. They do that by working with technology masters to create curriculum paths in key technologies. These paths allow you to jump in at the level that is right for you so you can master the technology. For more details on this course and instructor, click here.

Oracle 12c: Database Administration I Part 2

KEY FEATURES

Expounding on your Oracle education, this course will teach you how to install, administer, and maintain an Oracle 12c database in an effective and efficient manner. You’ll explore performance monitoring, database security, backup and recovery techniques, and much more.

  • Access 17 lectures & 4 hours of content 24/7
  • Discuss Oracle’s password security & database auditing features
  • Configure Oracle’s default user account features
  • Learn how to establish, tune & monitor Oracle’s Shared Server configuration
  • Explain how to manually & automatically monitor the performance of an Oracle database
  • Describe how to use Oracle’s advisors to help tune & monitor database performance.
  • Show how to tune & administer Oracle’s database undo management
  • Discover how Oracle detects & resolves locking conflicts

PRODUCT SPECS

  • Length of time users can access this course: 1 year
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

At GogoTraining, their mission is to help you master the world by unlocking your full potential. They do that by working with technology masters to create curriculum paths in key technologies. These paths allow you to jump in at the level that is right for you so you can master the technology. For more details on this course and instructor, click here.

Oracle 12c: Database Administration II Part 1

KEY FEATURES

Pushing your Oracle database administration expertise to a more advanced level, this course will focus primarily on backup and recovery operations. You’ll learn how to utilize Oracle’s new FLEX ASM technology, as well as its 12 tuning features. Knowing how to perform these operations will give you a leg up in the job market.

  • Access 24 lectures & 5 hours of content 24/7
  • Define Oracle’s Multitenant architecture
  • Manage container databases
  • Use Oracle’s FLEX ASM
  • Understand the ASM architecture & Oracle’s cloud file systems
  • Create, use & administer a recovery catalog
  • Perform RMAN backups & fast incremental backups
  • Identify critical & non-critical losses

PRODUCT SPECS

  • Length of time users can access this course: 1 year
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

At GogoTraining, their mission is to help you master the world by unlocking your full potential. They do that by working with technology masters to create curriculum paths in key technologies. These paths allow you to jump in at the level that is right for you so you can master the technology. For more details on this course and instructor, click here.

Oracle 12c: Database Administration II Part 2

KEY FEATURES

In this final, advanced Oracle training, you’ll iron down your database management skills with Oracle 12c and be prepared to earn professional certifications that will help you land high paying jobs. You’ll learn how to perform Oracle’s flashback technology, recycle bin, flashback data archives, and utilize Oracle’s tuning tools such as AWR, SQL Tuning Advisor and SQL Access Advisor.

  • Access 31 lectures & 5 hours of content 24/7
  • Perform flashback database recovery
  • Configure flashback data archives
  • Tune backup & recovery operations
  • Use Oracle’s SQL Tuning Advisor & SQL Access Advisor
  • Implement Oracle’s Advanced Memory Management
  • Create metrics thresholds, alerts & AWR reports
  • Use Oracle’s Automatic Segment Space Management

PRODUCT SPECS

  • Length of time users can access this course: 1 year
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

At GogoTraining, their mission is to help you master the world by unlocking your full potential. They do that by working with technology masters to create curriculum paths in key technologies. These paths allow you to jump in at the level that is right for you so you can master the technology. For more details on this course and instructor, click here.

read more

Database Administration with Microsoft SQL Server and Oracle SharePoint for $47

Learn How to Implement & Manage Corporate Data Infrastructure & Make Your Resume Leap
Expires March 11, 2017 23:59 PST
Buy now and get 98% off

KEY FEATURES

Corporate environments rely on the smooth management and interchange of data to succeed on a day to day basis. To do this, many businesses rely on Microsoft SQL Server and Oracle Sharepoint. In this course, you’ll learn all the essentials to administering these systems in a corporate environment, giving you a leg up towards high-paying jobs in the IT sector.

  • Access 6 comprehensive courses 24/7
  • Write basic transact-SQL queries for Microsoft SQL
  • Maintain a Microsoft SQL Server 2012 database
  • Learn how to create a data warehouse in SQL Server 2012
  • Understand how to query a SQL Server
  • Discover core & advanced solutions of Oracle Sharepoint Server 2013

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming, mobile streaming
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

THE EXPERT

e-courses4you’s mission is to provide forward thinking training with you in mind. Whether you want to advance up the career ladder, are looking to start a new job, are thinking about a home based business or want to improve your general health and fitness, e-courses 4 you, will deliver you training to improve EVERY aspect of your life.

Their courses are provided by leading experts in their fields. Celebrity partners include Brian Tracy, Tony Robbins, and Stephen Covey and their business packages are partnered by Microsoft to bring you content which is not just average but outstanding!

For more details on this course and instructor, click here.

read more

Microsoft SQL Server Database Administration Certification Training for $39

The Comprehensive Prep You Need to Become a Database Administrator
Expires June 02, 2017 23:59 PST
Buy now and get 96% off

KEY FEATURES

SQL Server is the foundation of the Microsoft data platform, and a leader in the deployment and management of industry databases both in-house and in the cloud. It enables enhanced in-memory performance, provides for faster transactions and queries than disk-based relational databases, and offers real-time operational analytics. In this comprehensive training course, you’ll learn everything you need to pass the Microsoft SQL Server 70-464, 70-465, 70-411 and 70-412 certification exams. Through lectures, activities, and study guides, you’ll soon be qualified for high-paying Microsoft database management positions.

  • Access 49 lectures & 42 hours of content 24/7
  • Discover database infrastructure design w/ SQL Server
  • Understand disaster recovery principles & how to be the company hero
  • Learn cloud data solutions to increase data efficiency
  • Use labs, games & activities to supplement your learning & put your knowledge into practice
  • Study offline any time w/ printable study guides

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: 1 year
  • Access options: web streaming, mobile streaming, downloadable for offline viewing
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Microsoft SQL Server certification exams not included

Compatibility

  • Internet required

THE EXPERT

LearnSmart has served the technology community with high-quality certification and skills training since 1997. LearnSmart has grown rapidly as a leading provider for individuals and corporations, serving clients from a broad range of Fortune 500 companies, as well as universities, government institutions and the armed forces. For more details on this course and instructor, click here.

read more

October 30, 2016   /   by Marco   /   , , , , , , , , ,

Database Administration Super Bundle for $59

Database Administration Super Bundle for $59

86 Hours of Training to Put You On the Path to Building Databases & Analyzing Data Professionally
Expires September 19, 2024 23:59 PST
Buy now and get 97% off

NoSQL – MongoDB Developer

KEY FEATURES

NoSQL databases have grown in popularity recently due to their immense scalability, availability, and fault tolerance. NoSQL helps analysts work with high volume and disparate data types by efficiently handling unstructured, messy, and unpredictable data. To work in data-driven business these days, you need a background in NoSQL, and this is where to start.

  • Access 32 lectures & 6 hours of content 24/7
  • Learn the basic NoSQL concepts & terms
  • Understand the NoSQL design approach & explore Test Cases
  • Install MongoDB & learn how to use it
  • Discover data aggregation techniques in NoSQL
  • Use Node.js & MongoDB to create web applications

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

Introduction to MySQL

KEY FEATURES

MySQL is the most popular open source SQL database management system, allowing users to effectively manage data and design robust, efficient databases. In this course, you’ll learn everything you need to start using MySQL in web, cloud, and embedded applications. If you have any interest in developing apps, it’s important to have a good handle on relational databases, and this is an excellent place to start.

  • Access 9 lectures & 2 hours of content 24/7
  • Discuss what a database is & how they are used
  • Learn to create a well structure database
  • Use all tools in MySQL to effectively manage table
  • Perform practical examples in MySQL to fortify your knowledge

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

MongoDB – The NoSQL Database for Cloud and Desktop Computing

KEY FEATURES

MongoDB is a NoSQL database that makes the integration of data in certain types of applications easier and faster. Being able to effectively use MongoDB can make your web apps more dynamic and user-friendly. In this crash course, you’ll learn everything you need to start working with MongoDB.

  • Access 16 lectures & 3 hours of content 24/7
  • Learn about installing MongoDB, the data model, & working w/ data
  • Discuss GridFS, PHP & MongoDB, & Python & MongoDB
  • Create a blog application w/ the PHP Driver
  • Explore database administration, optimization, replication, & sharding

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

Informatica: A Complete Practical Guide on Informatica and DAC

KEY FEATURES

Informatica is a service that delivers enterprise data integration and management software powering analytics for big data and the cloud. Dynamic Access Control, or DAC, comprises Informatica PowerCenter Workflows as the active component to control the interface workflows. These tools make data integration significantly easier for corporate environments, and companies will pay handsomely for Informatica pros. This course will help you become one of them.

  • Access 99 lectures & 18 hours of content 24/7
  • Learn in detail about dimensions & functions of Informatica
  • Discuss normalization & ETL tools
  • Become familiar w/ the Informatica Architecture
  • Study the Powercenter client tool & Source Definition Overview
  • Understand Designer & workflow manager

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

Visual Analytics Using Tableau Comprehensive Course

KEY FEATURES

Tableau is an extremely useful data analysis tool that allows you to visualize data efficiently. It connects easily to nearly any data source, from Microsoft Excel to web-based data, and creates visualizations without having to write a single line of code. Tableau is immensely useful, especially in corporate environments, for communicating data in a precise, accessible manner, which makes the demand for Tableau aficionados high.

  • Access 61 lectures & 11 hours of content 24/7
  • Understand the many options for connecting Tableau to data
  • Learn the Tableau interface & paradigm components
  • Discuss shelves, data elements, & proper terminology to create powerful visualizations
  • Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations & more

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

SSIS – SQL Server Integration Services

KEY FEATURES

Microsoft SQL Server Integration Services is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. SSIS also includes graphical tools and wizards for building and debugging packages. Through this training, you’ll gain the skills you need to use SSIS as a business intelligence tool, thereby greatly increasing your ability to score high paying data jobs.

  • Access 44 lectures & 8 hours of content 24/7
  • Discover SSIS tools & its advantages & disadvantages
  • Explore the various SSIS functions, like Aggregate Data transformation support, how to input data from database to text, & more
  • Learn how to use the data viewer using different viewing functions

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

Microsoft SQL Server – Novice to Ninja

KEY FEATURES

This course will introduce you to Microsoft SQL, and the most important concepts behind databases and the process of building them. You’ll gain a comprehensive overview of all the major components of the SQL Server product suite, and dive into relational DBMS. By course’s end, you’ll have a strong grasp of SQL, perhaps the most important data management language on earth.

  • Access 124 lectures & 23 hours 24/7
  • Install SQL Server & discuss database concepts w/ practical examples
  • Learn how to create & manage a database
  • Understand how to access data from a database using SQL
  • Maintain instances & databases, optimize & troubleshoot, manage data, & more
  • Implement database security & high availability

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

Regression Modeling with Minitab

KEY FEATURES

Regression modeling is one of the core tenets of predictive modeling, allowing you to build strong models to effectively predict outcomes. In this course, you’ll develop regression modeling skills across a variety of business sectors and domains. Learning these data modeling skills will be an excellent addition to your resume, and can help you nail a new, high-paying career.

  • Access 67 lectures & 12 hours of content 24/7
  • Introduce yourself to regression modeling
  • Understand how to identify independent variables & perform regression equations
  • Learn how to tabulate values & interpret data sets
  • Dive into basic multiple regressions & working w/ scatterplots

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

Minitab and Its Application to Predictive Modeling

KEY FEATURES

Minitab is among the leading developers in the world for statistical analysis software, as well as software for Six Sigma, lean, and other project management tools. Used by thousands of companies and universities throughout the world, Minitab software is perhaps most prominently used in predictive modeling. Through this course, you’ll learn how to apply Minitab to predictive modeling in different business sectors, thereby picking up a vital skill that can set your resume apart from the pack.

  • Access 16 lectures & 3 hours of content 24/7
  • Implement predictive modeling concepts w/ Minitab software
  • Become familiar w/ non-linear regression
  • Explore T-tests, standard deviation, means, & descriptive statistics
  • Understand behavior of customers, movements of the financial markets, & study practical examples in pharma & medicine

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner

Compatibility

  • Internet required

    THE EXPERT

    An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill-based education addressing the needs 500,000+ members across 40+ countries. Their unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the industry help participants achieve their goals successfully. All their training programs are job oriented skill based programs demanded by the industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. For more details on this course and instructor, click here.

read more

October 23, 2015   /   by Marco   /   , , , , , , , , , , , , ,

HOW TO SCHEDULE BACKUPS FOR WAMP FILES AND DATABASES

HOW TO SCHEDULE BACKUPS FOR WAMP FILES AND DATABASES

I managed to figure out a way to backup the WAMP files and databases by using the Windows Task Scheduler and a batch file. The batch file includes using mysqldump (already part of the WAMP install), 7-zip (a free open source compression tool) and gzip (for the database compression). BATCH FILE Let’s have a look […]

read more

February 23, 2015   /   by Marco   /   , , , , ,

How to disable synchronisation for a mySQL database table

How to disable synchronisation for a mySQL database table

In a previous post, I wrote an article on how to setup database replication using mySQL. I recently had to figure out a way to exclude a database table in the replication process and this is what I had to do: NOTE: I’m using WAMP as my website hosting software Open up the my.ini file under […]

read more

How do you delete all the pending comments in WordPress

I fyou get annoyed at all the spammed comments in your WordPress and want to delete all these in one go then there are two options available to delete all the pending comments in your WordPress website. One way is to go into the mysql database via phpadmin and use an SQL statement and delete […]

read more
  • 1
  • 2