Get $1 credit for every $25 spent!

Essential Data Mastery Bundle

Ending In:
Add to Cart - $39
Add to Cart ($39)
$661
94% off
wishlist
(112)
Courses
7
Lessons
341
Enrolled
1,114

What's Included

Product Details

Access
Lifetime
Content
12 hours
Lessons
67

Projects in MongoDB: Learn MongoDB Building 10 Projects

Explore the World's Most Popular Cross Platform NoSQL Database

By Eduonix Learning Solutions | in Online Courses

MongoDB has quickly become one of the most popular NoSQL database solutions available, and will quickly enhance your ability to handle data with ease. With a document-based approach, MongoDB lets professionals model data however they prefer. While MySQL limits modeling to rows and columns, MongoDB is much more flexible, allowing developers to use a familiar programming language like Ruby, and a JSON format. What does this mean? Faster and more intuitive storage of data.
  • Utilize MongoDB to manage data more efficiently w/ over 67 lectures & 12 hours of content
  • Develop quickly w/ a document-based approach
  • Utilize JavaScript to communicate w/ MongoDB for faster development
  • Study best practices for NoSQL development
  • Get querying capabilities w/ the flexibility of storing data in an intuitive manner
Eduonix creates and distributes high-quality technology training content. Their team of industry professionals has been training manpower for more than a decade. They aim to teach technology the way it's used in the industry and professional world. They have a professional team of trainers for technologies ranging from Mobility, Web and Enterprise, and Database and Server Administration. 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!

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: all levels

Compatibility

  • Internet required

Course Outline

  • Introduction
    • Introduction
  • Customer Database Intro Project
    • Project Intro
    • MongoDB Installation & Setup
    • Inserting & Finding Customers
    • Updating & Removing Customers
    • Arrays & Embedded Data
  • Product Catalog REST API
    • Project Intro
    • Nodejs & Express Setup
    • Data Model & GET Requests - Basics
    • Data Model & GET Requests Part B
    • POST, PUT & DELETE Requests
  • TaskManager with JQuery & MongoLab
    • Project Intro
    • MongoLab Setup
    • Getting & Adding Categories Part A
    • Getting & Adding Categories Part B
    • Editing & Deleting Categories
    • Tasks CRUD
  • MeteorJS Photo Gallery
    • Project Intro
    • GridFS & Meteor Install
    • Uploading Photos
    • Viewing Photos
  • PHP Todo List
    • Project Intro
    • PHP Install & App Setup
    • Get & Display Todos Part A
    • Get & Display Todos Part B
    • Adding Todos
    • Updating & Deleting Todos
  • Invoicr MEAN app
    • Project Intro
    • Express Setup and Customer Model Part A
    • Express Setup and Customer Model Part B
    • Completing the Backend API
    • Angular Client Side Setup Part A
    • Angular Client Side Setup Part B
    • Displaying Customers and Invoices Part A
    • Displaying Customers and Invoices Part B
    • Adding Customers and Invoices
    • Editing & Removing Customers and Invoices
  • CDN Finder
    • Project Intro
    • Setting Up a Windows Environment Part A
    • Setting Up a Windows Environment Part B
    • Module Server Files
    • Module Client Files Part A
    • Module Client Files Part B
    • Formatting Views Part A
    • Formatting Views Part B
    • Search and Filter
  • AirFind Airport Finder
    • Project Intro
    • Express File Structure Part A
    • Express File Structure Part B
    • Backend API Routes Part A
    • Backend API Routes Part B
    • Frontend Airport Display Part A
    • Frontend Airport Display Part B
    • Search By State & Proximity
  • MongoChat with Socket.io
    • Project Intro
    • Server Websocket Events
    • Read Messages From Mongo Part A
    • Read Messages From Mongo Part B
    • Submit Messages From Client
  • SiteSearch Engine
    • Project Intro
    • Generating an Express App
    • Website Model and Add Function Part A
    • Website Model and Add Function Part B
    • Searching Websites
    • Adding and Searching Articles
  • Course Summary
    • Summary

View Full Curriculum


Access
Lifetime
Content
4 hours
Lessons
57

Learning SQL, MySQL & Databases Is Easy

Manipulate Data Like the Pros & Build Better Technology

By Will Ellerman | in Online Courses

Knowledge of SQL is an invaluable asset that can set you up for any tech-based career from web design to data analysis to quality assurance. Learn to store and manipulate data on multiple database systems from MySQL to Oracle for your own personal development, to start a new business, or to get a leg up on your coworker. You’ll be a competent database designer and query writer after watching these lectures.
  • Become a competent database designer & query writer w/ 57 lectures & 4 hours of content
  • Manipulate MySQL, SQL Server, Access, Oracle, Sybase, DB2 & other database systems w/ SQL
  • Master MySQL queries w/ an instructor that has managed databases at large companies
  • Advance your career w/ knowledge of databases
  • Add a valuable notch on your résumé when you complete the course
Wil Tru has built technology and marketing programs for Fortune 500 companies, top websites, and starts ups alike. He has over 10 years' experience in business technology and marketing. He has worked in house and consulted for over 100 companies including AutoZone, Business(dot)com, AngiesList, CafePress, AutoAnything, WD40, Google, and Adobe. 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!

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: all levels

Compatibility

  • Internet required

Course Outline

  • SQL, MySQL & Databases
    • Intro
    • SQLIntro
    • PHPMyAdmin
    • SQL
    • SELECT Statement
    • SELECT Distinct
    • SQL Where
    • And Or
    • Order By
    • Insert Into
    • Update
    • Delete
    • Injection
    • Injection Part 2
    • Injection Prevention
    • Top & Limit
    • Like & Not Like
    • Wild Cards
    • Between
    • Alias
    • Insert
    • Joins - Inner Join
    • Left Join
    • Left Join Cont.
    • Full Outer Join
    • Union
    • SelectInto
    • CreateDB
    • Create Table
    • Constraints
    • Unique
    • Primary Key
    • Foreign Key
    • Default
    • Drop
    • Alter
    • Auto Increment
    • View
    • Date
    • IsNull
    • Is Null2
    • DataTypes
    • AVG Function
    • Count Function
    • first Function
    • Last Function
    • MaxMin
    • SUM
    • GroupBy
    • HavingCount
    • Ucase
    • Ucase
    • Mid
    • Len
    • Round
    • Now
    • Format

View Full Curriculum


Access
Lifetime
Content
2 hours
Lessons
37

SQL Server Fast Track for Novices: Tables

The All-in-One Primer for Getting Up To Speed on SQL Server Database Tables

By Dave Merton | in Online Courses

So you have a basic understanding of SQL, but you're ready to take your skills to the next level? This in-depth course is the perfect place to start. Get up to speed on proper table design, creation, scripting, and management, and start executing simple TSQL statements. With real world examples of Stored Procedures, you'll understand the importance of production database development in your industry and beyond.
  • Take your SQL skills to the next level w/ over 37 lectures & 2 hours of content
  • Design, build, manage & maintain a wide variety of database tables
  • Learn to streamline functions like INSERT, UPDATE & DELETE
  • Access real world examples
  • Download included Stored Procedures
  • View several code examples of simultaneous techniques in action
  • Learn how mastering SQL Server can boost your career
Dave Merton is a software developer, troubleshooter, problem solver, software trainer, author, and entrepreneur. For the past 20 years, he's been designing high-end custom software. In addition to software development, Dave has personally instructed hundreds of individuals in programming. He has trained several persons in VB skills, one-on-one as well as in larger groups for both VB and SQL Server. 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!

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: all levels

Compatibility

  • Internet required

Course Outline

  • The Basics
    • COURSE INTRODUCTION
    • SECTION DESCRIPTION
    • Table Types
  • Table Design and Management
    • SECTION DESCRIPTION
    • Table Design and Naming Convention
    • How to Create Setup Tables - SSMS
    • How to Alter Table Schema - SSMS
    • How to Alter Table Schema - Command Line TSQL
  • INSERT Records
    • SECTION DESCRIPTION
    • INSERT RECORDS - SSMS
    • INSERT RECORDS - SSMS - NOT NULL Fields
    • INSERT RECORDS - SSMS - Handling NOT NULL Fields with Default Va
    • INSERT RECORDS - TSQL
    • INSERT RECORDS - TSQL - Default Values
    • INSERT RECORDS - STORED PROCEDURE
    • INSERT RECORDS - STORED PROCEDURE AND DEFAULT VALUES
  • UPDATE Records
    • SECTION DESCRIPTION
    • UPDATE RECORDS - SSMS GUI
    • UPDATE RECORDS - VIA TSQL (2:48)
    • UPDATE RECORDS - TSQL SCRIPT
    • UPDATE RECORDS - STORED PROCEDURE (4:14)
  • DELETE Records
    • SECTION DESCRIPTION
    • DELETE RECORDS - SSMS GUI
    • DELETE RECORDS - VIA TSQL
    • DELETE RECORDS - TSQL SCRIPT
    • DELETE RECORDS - STORED PROCEDURE
  • INSERT & DELETE Advanced
    • SECTION DESCRIPTION
    • INSERT and DELETE - Part 1 of 5 - SSMS
    • INSERT and DELETE - Part 2 of 5 - TSQL
    • INSERT and DELETE - Part 3 of 5 - IDENTITY INSERT
    • INSERT and DELETE - Part 4 of 5 - SELECT INTO
    • INSERT and DELETE - Part 5 of 5 - DBCC CheckIdent
  • Scripting
    • SECTION DESCRIPTION
    • Scripting - Part 1 of 4 - Table Creation Script - SSMS
    • Scripting - Part 2 of 4 - Data Insertion Script
    • Scripting - Part 3 of 4 - Using a Script as a Template
    • Scripting - Part 4 of 4 - Specialty Stored Procedure

View Full Curriculum


Access
Lifetime
Content
5.5 hours
Lessons
56

Taming Big Data with MapReduce & Hadoop

Analyze Large Amounts of Data w/ Today's Top Big Data Technologies

By Sundog Software | in Online Courses

Big data is hot, and data management and analytics skills are your ticket to a fast-growing, lucrative career. This course will quickly teach you two technologies fundamental to big data: MapReduce and Hadoop. Learn and master the art of framing data analysis problems as MapReduce problems with over 10 hands-on examples. Write, analyze, and run real code along with the instructor– both on your own system, and in the cloud using Amazon's Elastic MapReduce service. By course's end, you'll have a solid grasp of data management concepts.
  • Learn the concepts of MapReduce to analyze big sets of data w/ over 56 lectures & 5.5 hours of content
  • Run MapReduce jobs quickly using Python & MRJob
  • Translate complex analysis problems into multi-stage MapReduce jobs
  • Scale up to larger data sets using Amazon's Elastic MapReduce service
  • Understand how Hadoop distributes MapReduce across computing clusters
  • Complete projects to get hands-on experience: analyze social media data, movie ratings & more
  • Learn about other Hadoop technologies, like Hive, Pig & Spark
Frank Kane spent 9 years at Amazon and IMDb, developing and managing the technology that automatically delivers product and movie recommendations to hundreds of millions of customers, all the time. Frank holds 17 issued patents in the fields of distributed computing, data mining, and machine learning. In 2012, Frank left to start his own successful company, Sundog Software, which focuses on virtual reality environment technology, and teaching others about big data analysis. 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!

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: all levels

Compatibility

  • Internet required

Course Outline

  • Introduction
    • Introduction
  • Getting Started
    • Installing Enthought Canopy
    • Installing MRJob
    • Downloading the MovieLens Data Set
    • Run Your First MapReduce Job
  • Understanding MapReduce
    • MapReduce Basic Concepts
    • Walkthrough of Rating Histogram Code
    • Understanding How MapReduce Scales / Distributed Computing
    • Average Friends by Age Example: Part 1 (3:04)
    • Average Friends by Age Example: Part 2
    • Minimum Temperature By Location Example
    • Maximum Temperature By Location Example
    • Word Frequency in a Book Example
    • Making the Word Frequency Mapper Better with Regular Expressions
    • Sorting the Word Frequency Results Using Multi-Stage MapReduce Jobs
    • Activity: Design a Mapper and Reducer for Total Spent by Customer (2:54)
    • Activity: Write Code for Total Spent by Customer
    • Compare Your Code to Mine. Activity: Sort Results by Amount Spent
    • Compare your Code to Mine for Sorted Results.
    • Combiners
  • Advanced MapReduce Examples
    • Example: Most Popular Movie
    • Including Ancillary Lookup Data in the Example
    • Example: Most Popular Superhero, Part 1 (4:22)
    • Example: Most Popular Superhero, Part 2 (6:31)
    • Example: Degrees of Separation: Concepts
    • Degrees of Separation: Preprocessing the Data
    • Degrees of Separation: Code Walkthrough
    • Degrees of Separation: Running and Analyzing the Results
    • Example: Similar Movies Based on Ratings: Concepts
    • Similar Movies: Code Walkthrough
    • Similar Movies: Running and Analyzing the Results
    • Learning Activity: Improving our Movie Similarities MapReduce Job
  • Using Hadoop and Elastic MapReduce
    • Fundamental Concepts of Hadoop
    • The Hadoop Distributed File System (HDFS)
    • Apache YARN (4:20)
    • Hadoop Streaming: How Hadoop Runs your Python Code
    • Setting Up Your Amazon Elastic MapReduce Account
    • Linking Your EMR Account with MRJob (3:40)
    • Exercise: Run Movie Recommendations on Elastic MapReduce
    • Analyze the Results of Your EMR Job
  • Advanced Hadoop and EMR
    • Distributed Computing Fundamentals
    • Activity: Running Movie Similarities on Four Machines
    • Analyzing the Results of the 4-Machine Job
    • Troubleshooting Hadoop Jobs with EMR and MRJob, Part 1
    • Troubleshooting Hadoop Jobs, Part 2
    • Analyzing One Million Movie Ratings Across 16 Machines, Part 1
    • Analyzing One Million Movie Ratings Across 16 Machines, Part 2
  • Other Hadoop Technologies
    • Introducing Apache Hive
    • Introducing Apache Pig
    • Apache Spark: Concepts
    • Spark Example: Part 1
    • Spark Example: Part 2
    • Congratulations! (0:41)
  • Where to Go from Here
    • New Lecture

View Full Curriculum


Access
Lifetime
Content
1.5 hours
Lessons
13

Collect, Extract & Use Online Data Quickly and More Easily

Save Time & Advance Your Career with Data Management Skills

By Kathleen Farley | in Online Courses

Once you’ve got the data basics down, it’s time you learn to extract the data you need, when you need it. Learn how with Kathleen Farley’s course, which takes you through hands-on exercises and real world examples. With 13 short tutorials that teach you a variety of data extraction methods, you’ll be able to efficiently collect useful information in the correct formats with the best tools available.
  • Study a variety of data extraction methods w/ 13 lectures & 1.5 hours of content
  • Take screenshots & PDFs of any website
  • Use OCR to extract text from scanned documents or images
  • Quickly take text from website to spreadsheet
  • Create organized tables from web data
  • Take advantage of relational databases by collecting the data you need
  • Automate online data retrieval tasks without writing code
  • Collect & extract data in the formats you need
  • Access course material when you want a refresher w/ lifetime access
Kathleen Farley is a computer geek, teacher, learner, vinyl junkie, hockey fan, and recovering non-profit executive. Occasionally she breaks (and fixes) computers. Not necessarily in that order. The Montreal-born technologist trained as an audio engineer before moving to Hamilton, Canada in 2007. She now runs Maisonneuve Music, a Hamilton-based independent record label. She's also the co-founder of Audiohackr, a startup that helps indie musicians, producers, and DIY labels make the most of technology. Kathleen produces technology training videos under the moniker Robobunnyattack! For more details on this course and instructor, click here.

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: all levels

Compatibility

  • Internet required
  • Spreadsheet software such as Microsoft Excel, LibreOffice, or OpenOffice

Course Outline

  • Introduction
    • Course overview
  • Screenshots and print-friendly PDFs
    • How to take a screenshot of an entire webpage (part 1)
    • How to take a screenshot of an entire webpage (part 2)
    • How to convert any webpage to a print-friendly PDF
  • Optical Character Recognition (OCR)
    • How to extract text from images using Google Drive
    • How to extract tabular data and other text from an image using onlineOCR.net
  • Extracting tabular data from webpages
    • How to paste without formatting on a Mac or a PC
    • How to extract tabular data from a web page into a spreadsheet
    • How to extract tabular data from a web page into LibreOffice
  • Extracting non-tabular data from webpages
    • How to extract structured data from a webpage using TheWebMiner
  • Automating data retrieval
    • How to automate data retrieval tasks using IFTTT
  • Conclusion
    • Course review

View Full Curriculum


Access
Lifetime
Content
6 hours
Lessons
70

Beginner's Guide to PostgreSQL

Nail Down the Basics of Database Concepts on Your Road to PostgreSQL Enlightenment

By Miguel Alho | in Online Courses

With an ever-increasing focus on big data and cloud-based initiatives, it's time you learn to work effectively with data. Start the route to PostgreSQL expertise with this extremely approachable beginner’s guide. You’ll learn basic database concepts like creating tables and manipulating data—a great baseline to use with any modern database systems—before moving on to using the open-source relational database PostgreSQL. You’ll get all the nitty-gritty on what SQL is, and how to use it in real world applications.
  • Gain an understanding of database concepts w/ 70 lectures & 6 hours of instruction
  • Learn the written language used to communicate w/ databases
  • Get a step-by-step look at how a database is structured
  • Learn how to install PostgreSQL
  • Insert & manipulate data w/ PostgresSQL
  • Write SQL queries
  • Get an introduction to data w/ an approachable class meant for all levels
Miguel Alho, developer and owner of Miguel Alho-Multimedia, runs a web-based software development company (mainly .NET based) building HRIS (Human Resource Information Systems) software for HR teams. He’s also been employed as a teacher to seventh and eighth graders in Tech. Ed. classes, and voluntarily accepts 12th grade internships of IT students through local schools. He is experienced with developing customized software, service, and database solutions for businesses. 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!

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: beginner

Compatibility

  • Internet required

Course Outline

  • Introduction
    • An Introduction to the Course (2:19)
    • Database Overview
    • Identities in database tables (2:45)
    • Normalization
    • Relationships
    • Relationship Quiz
    • Relationship Types
    • Relationship Types Quiz
    • Database Management Systems
    • PostgreSQL features
    • PostgreSQL Windows Installation
  • Database Usage Basics
    • Connecting to Database Server with pgAdmin III
    • Configuring PostgreSQL to Accept External Connections
    • Creating Databases
    • Creating Tables
    • Inserting and viewing data in pgAdmin III
    • DataTypes Intro
    • Numeric DataTypes in PostgreSQL
    • Serial Datatypes For Row Ids
    • Character Types
    • The Date Datatype
    • The time datatype
    • Timestamps
    • The boolean datatype
    • NULL Values
    • Requirements
    • Car Repair Shop DB Requirements
    • Designing the repair shop database Pt1
    • Designing the repair shop database Pt2
    • Designing the repair shop database Pt3 - choosing datatypes
    • Car Repair Shop DB Table and Column Definitions
    • Building the Database - Part 1
    • Applying constraints to table columns
    • Creating relationships between tables in pgAdmin III
    • Creating the remaining tables
    • Users and Privileges
    • Backup and Restore in PostgreSQL with pgAdmin III
  • SQL in PostgreSQL
    • Introduction to SQL
    • The CREATE TABLE command
    • The CREATE TABLE command with constraints PT 1
    • The CREATE TABLE command with constraints pt.2
    • Script: First Two Create Table commands
    • The CREATE TABLE command with foreign keys PT 1
    • The CREATE TABLE command with foreign keys PT 2
    • Scripts: Create Tables with Foreign keys
    • CREATE TABLE quiz
    • Drop Table
    • The Alter Table command
    • Script: Drop And Alter Table commands
    • Insert Into SQL Command
    • Insert scripts used in the previous video
    • The Update Statement
    • Update Script file
    • The DELETE FROM Statement
    • Deletes with cascades
    • Script: Delete from commands for the previous videos
    • The TRUNCATE command
    • Truncate Script
    • Filling the database with data
    • Full Db Script
    • The SELECT command
    • pgAdmin III's Graphical Query Builder
    • The WHERE clause (PT I)
    • The WHERE clause (PT 2) - BETWEEN and IN
    • The WHERE clause (PT 3) - IS [NOT] NULL
    • The WHERE clause (PT 4) - LIKE and ILIKE
    • The WHERE clause - using the graphical query builder
    • The WHERE Clause Command Script
    • The LIMIT and OFFSET clauses
    • QUIZ - Limits and Offests
    • The ORDER BY clause
    • Order By commands
    • Aggregate functions - Count, Max, Min, Avg
    • Joins tables in a query through relationships

View Full Curriculum


Access
Lifetime
Content
5.5 hours
Lessons
41

MySQL Database Training for Beginners

Design & Administer a MySQL Database from Scratch

By Simon Sez IT | in Online Courses

MySQL is an incredibly popular database solution utilized by companies worldwide - and mastering it is beneficial to anyone in the tech industry. Beginning with the fundamentals, this course will teach you to design and administer a database with practical lectures.
  • Master MySQL w/ over 41 lectures & 5.5 hours of content
  • Install MySQL & study the architecture
  • Discover critical concepts for designing a database
  • Administer a database by limiting access, creating users, performing database backup & monitoring performance
  • Learn SQL for developers, database replication, data encryption & more
  • Use indexing for database performance
  • Understand query analysis & optimization
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity - whether you're implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere. 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!

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: all levels

Compatibility

  • Internet required

Course Outline

  • Introduction
    • Course Outline and Intro to MySQL and Database
    • MySQL Architecture and Installation of MySQL
    • Installation Demo - Part 1
    • Installation Demo - Part 2
  • Database Design
    • Database Design
    • MySQL Workbench Download
    • Database Table and Constraints
    • Database Designing and Normalization - Part 1
    • Database Designing and Normalization - Part 2
    • Storage and Data Types
    • Data Types Demo
    • ACID and Transactions
    • Locks, Deadlocks, Isolation Levels and Logging
    • Isolation Levels and Locking Demo
    • Locking Mechanism Demo and MySQL ACID Support
  • Administration
    • Responsibilities of a Database Administrator
    • Creating a User and Limiting Access to a Database; Basic Maintainance Function
    • Protecting your Database; How to Perform Database Backup
    • Performance Monitoring
  • Indexing for Performance
    • InnoDB Indexing and Clustered vs. Unclustered Index
    • Query and Where Clause
    • Impact of Indexing on Database Performance
    • Performance Optimization
  • SQL for Developers
    • Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
    • Data Definition Language; How to Create Database Objects
    • SQL Select Statements
    • SQL Select Statements Demo
    • Joins
    • Combining Related Table Using Joins
    • Insert, Update and Delete Commands
    • Insert, Update, and Delete Commands Demo
  • Query Analysis and Optimization
    • Query Optimization
    • Query Optimization Demo
  • Data Replication
    • Database Replication
    • Setting Up Replication in MySQL
    • Data Encryption
    • Column-Level Database Encryption Demo
    • High Availability
  • Conclusion
    • Closing

View Full Curriculum



Terms

  • Instant digital redemption

15-Day Satisfaction Guarantee

We want you to be happy with every course you purchase! If you're unsatisfied for any reason, we will issue a store credit refund within 15 days of purchase.