Tag Archive: SQL

KEY FEATURES

This course is directed toward anybody interested in operating Microsoft SQL Server 2012 professionally. The Microsoft 70-461 exam is essential for any aspiring database administrators, implementers, system engineers, and developers, and this course will prepare you to ace the exam.

• Apply built-in scalar functions & ranking functions
• Combine datasets, design T-SQL stored procedures, optimize queries, & more
• Implement aggregate queries, handle errors, generate sequences, & explore data types
• Modify data by using INSERT, UPDATE, DELETE, & MERGE statements
• Create database objects, tables, views, & more

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

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

This course is aimed towards aspiring database professionals who would like to install, maintain, and configure database systems as their primary job function. You’ll prepare for the Microsoft 70-462 exam while becoming more efficient at securing and backing up databases.

• Audit SQL Server instances, back up databases, deploy a SQL Server, & more
• Configure additional SQL Server components
• Install SQL Server & explore related services
• Understand how to manage & configure SQL Servers & implement a migration strategy

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

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

This course is designed for aspiring Extract Transform Load (ETL) and Data Warehouse Developers who would like to focus on hands-on work creating business intelligence solutions. It will prepare you to sit and pass the Microsoft 70-463 certification exam.

• Master data using Master Data Services & cleans it using Data Quality Services
• Explore ad-hoc data manipulations & transformations
• Manage, configure, & deploy SQL Server Integration Services (SSIS) packages
• Design & implement dimensions, fact tables, control flow, & more

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

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

This course is designed for aspiring database professionals who design and build database solutions. These people are responsible for the creation of plans and designs for database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs.

• Explore data compression strategies, database models, high-availability solutions, & more
• Learn a maintenance strategy for database servers
• Discover management automation strategies
• Understand migration, consolidation, & upgrade strategies

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

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

This course is designed for aspiring business intelligence developers who would like to create BI solutions with Microsoft SQL Server 2012, including implementing multi-dimensional data models, OLAP cubs, and creating information displays used in business decision making.

• Work w/ large data sets across multiple database systems
• Develop cubes & Multi-dimensional Expressions (MDX) queries to support analysts
• Explore data model decisions
• Manage a reporting system, use report builder to create reports,& develop complex SQL queries for reports

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

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

This course is designed for aspiring business intelligence architects who would like to focus on the overall design of a BI infrastructure, including how it relates to other data systems.

• Learn BI Solution architecture & design
• Understand provisioning of software & hardware
• Explore Online Analytical Processing (OLAP) cube design
• Study performance planning, scalability planning, upgrade management, & more
• Maintain server health, design a security strategy, & more

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

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

This course is designed for aspiring database developers who would like to build and implement databases across an organization. Database developers create database files, create data types and tables, plan indexes, implement data integrity, and much more. All of which you’ll learn how to do in this Microsoft 70-464 course.

• Optimize & tune queries
• Create & alter indexes & stored procedures
• Maintain database integrity & optimize indexing strategies
• Design, implement, & troubleshoot security
• Work w/ XML Data
• Write automation scripts

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

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

The Microsoft SQL Server environment is one of the most preferred data management systems for companies in many different industries. Certified administrators are handsomely paid. This course will prepare you the Microsoft Certification Exam 70-764 which validates that you are able to administer a Microsoft SQL Server 2016 server.

• Access 105 lectures & 30.5 hours of content 24/7
• Learn how to administer a Microsoft SQL Server 2016 server
• Configure data access, permissions & auditing
• Perform encryption on server data
• Develop a backup strategy
• Restore databases & manage database integrity

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• 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

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

This course will prepare you for the Microsoft Certification Exam 70-765, which certifies that you can provision databases on Microsoft SQL Server 2016 and Microsoft Azure. If you’re looking to start a lucrative IT career installing and maintaining Microsoft SQL Server and Azure environments, this course is for you.

• Access 102 lectures & 22.5 hours of content 24/7
• Deploy a Microsoft Azure SQL database
• Plan for a SQL Server installation
• Deploy SQL Server instances
• Deploy SQL Server databases to Azure Virtual Machines
• Configure secure access to Microsoft Azure SQL databases

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• 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

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

Prep for success with unlimited access to expert video instruction and the tools you need to pass the Microsoft Certified Solutions Engineer exam. This globally-recognized benchmark for IT professionals validates your knowledge of database servers and business intelligence software, and tells potential employers that you are at the top in your field.

• Watch full motion video & audio
• Engage with proven learning methodologies & the latest technology
• Learn with the advanced self-study format & enhanced user controls
• Query & administer Microsoft SQL servers
• Implement a data warehouse with Microsoft SQL
• Create data models & reports
• Design business intelligence solutions
• Gain the skills to qualify for a business intelligence & reporting engineer job

PRODUCT SPECS

Details & Requirements

• License deadline: redeem within 60 days of purchase
• Restrictions: exam vouchers not included
• Once you are ready for your exam, you can make an appointment to take the official exam at any Prometric Testic Centre (www.prometric.com), located worldwide.
• Length of access to all courses: 1 year
• Access options: web streaming, mobile streaming
• Experience level required: all level

Includes the following five courses:

• Microsoft 70-461: Querying Microsoft SQL Server 2012 Certification Training Course
• Microsoft 70-462: Administering Microsoft SQL Server 2012 Databases Certification Training Course
• Microsoft 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 Certification Training Course
• Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 Certification Training Course
• Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Certification Training Course

Compatibility

• Desktop computer with the latest version Internet browser

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies, and development services. iCollege is a collaborative venture between XpertSkills and XpertEase Software. The synergistic result of the joint venture enable them to provide sophisticated, innovative, relevant, flexible, and cost-effective learning solutions. Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

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

KEY FEATURES

The digital world and business world are one in the same these days, and SQL is quickly becoming an essential tool for day-to-day operations. Learn to extract and manipulate data using SQL, so you can easily report and answer important questions as efficiently and accurately as possible. This course is packed with readings, trainer presentations, and exercises for mastering this essential language, from basic database concepts to advanced queries.

• Dive into the history of SQL & understand database fundamentals
• Utilize SQL to build applications or generate business reports
• Apply SQL to all major databases
• Study potential differences between databases
• Understand how relational databases work
• Learn to write queries for extracting data from multiple tables

PRODUCT SPECS

Details & Requirements

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

Compatibility

• Internet required
• SQL

THE EXPERT

Webucator provides onsite and online training on technologies such as Microsoft ASP.NET, XML, Windows, Java, Adobe Flash, HTML5, JavaScript, Dreamweaver, and much more. Webucator has trained more than 55,000 students from over 13,000 organizations. 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!

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.

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!

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.

KEY FEATURES

The Microsoft Certified Solutions Expert (MCSE): Data Platform certification demonstrates that you have the broad set of skills needed to build and administer enterprise-scale data solutions both on premises, or in Cloud environments. This certification will make you eligible for many high-paying database analyst and database designer positions. Through this certification training bundle, you’ll learn all the skills and knowledge you need to pass the five exams (Microsoft 70-461 through Microsoft 70-465) needed to obtain this elite certification.

• Access 5 courses w/ study materials for MCSE SQL Server Certification
• Learn how to build effective enterprise-scale data solutions
• Gain expertise on administering various SQL server databases
• Understand data warehousing & designing database solutions for SQL servers
• Develop the skills you need to earn an industry-leading certification

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: 12 months
• 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 level

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services. iCollege is a collaborative venture between XpertSkills and XpertEase Software. The synergistic result of our joint venture enable us to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions. Our collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

The Microsoft Certified Solutions Expert (MCSE): Data Platform certification demonstrates that you have the broad set of skills needed to build and administer enterprise-scale data solutions both on premises, or in Cloud environments. This certification will make you eligible for many high-paying database analyst and database designer positions. Through this certification training bundle, you’ll learn all the skills and knowledge you need to pass the five exams (Microsoft 70-461 through Microsoft 70-465) needed to obtain this elite certification.

• Access 5 courses w/ study materials for MCSE SQL Server Certification
• Learn how to build effective enterprise-scale data solutions
• Gain expertise on administering various SQL server databases
• Understand data warehousing & designing database solutions for SQL servers
• Develop the skills you need to earn an industry-leading certification

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: 12 months
• 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 level

Compatibility

• Internet required

THE EXPERT

iCollege is a leading international provider of E-Learning courses, learning technologies and development services. iCollege is a collaborative venture between XpertSkills and XpertEase Software. The synergistic result of our joint venture enable us to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions. Our collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

KEY FEATURES

Business Intelligence seems like a pretty important concept for companies to pursue, right? Yes, right. Business intelligence analysts and reporting engineers represent the front lines of data crunching for businesses and play pivotal roles in business decisions. In this course, you’ll learn how to implement Microsoft SQL Server 2012 effectively in an enterprise environment and become an essential member of any business development team.

• Access 5 comprehensive training modules 24/7
• Get a free Microsoft Cloud Computing Certification
• Work w/ large datasets across multiple platforms
• Build Online Analytical Processing cubes & support structures like pivot tables
• Design business intelligence solutions that meet current & future performance & scalability needs
• Use Excel Services & Sharepoint Reporting integration to improve data analysis

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: 12 months
• Access options: web streaming, mobile streaming
• Certification of completion included
• Experience level required: all levels
• Limit: 1 for you, unlimited as gifts
• Redemption deadline: redeem your code within 30 days of purchase
• Course log-in details and instructions will be emailed to you within 3 working days of redemption
• Free technical support available 24/5 via email, telephone and online chat
• No software included
• Browser settings need to be changed when using a Mac. For more information, click here.

Compatibility

• Windows 7, 8
• Mac
• iOS
• Android
• Internet Explorer 8 or later
• Google Chrome
• Safari 6 or later
• Mozilla Firefox

THE EXPERT

e-Careers comprises of passionate and talented educationalists who support over 325,000 students all over the world. The institution consists of around 200 individuals, who all specialize in their own aspects of combining education with technology. e-Careers has established relationships with many awarding bodies, instructors and educational institutions to bring its students training and qualifications in an e-Learning format. For more details on this course and instructor, click here.

KEY FEATURES

Why is it beneficial to learn SQL, SQL Server, and Visual Studio? To build applications today, a programmer must know how to combine the power of various technologies to produce next level software. The focus of this course is SQL, but along the way, you’ll also learn to use Microsoft Visual Studio and build a real dashboard system powered by SQL, C#, AJAX, CSS, HTML, and jQuery. Enroll today, and learn how to give yourself a great competitive advantage in the job market.

• Learn essential technologies w/ 86 lectures & 14 hours of instruction
• Learn to write queries w/ Microsoft Management Studio & Microsoft Visual Studio Query Editor
• Create database-connected web pages using SQL & XML Data Sources
• Get color PDF’s for many of the lessons for easy reference
• Learn the basics of database connecting code using C#
• Get exposure to modern language features like Lag/Lead
• Build a dashboard system w/ SQL Server, ASP Web Forms, C# & jQuery

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

THE EXPERT

Tom Owsiak is a Web, Math, Stats., and Physics Expert with eight years’ experience as a teacher of mathematics, physics, statistics, and programming. He worked for five years as a database programmer using various technologies such as .NET, Clipper, SQL, SQL Server, SAS, Excel, and many related technologies.

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

KEY FEATURES

Have you started learning about SQL databases, only to get stuck trying to teach yourself? In this thorough and easy-to-follow course, LearnToProgram’s database expert Martin Holzke shows you how to achieve success. From the very first lesson, you’ll learn how to correctly structure your database, how to author efficient SQL statements and clauses, and how to manage your SQL database for scalable growth.

• Learn SQL from scratch w/ over 55 lectures & 6.5 hours of content
• View the the ins & outs of database management
• Become a better web, game or mobile app developer
• Understand databases & start creating tables
• Understand database relationships
• Begin writing queries to extract data
• Use common query tools
• Work with the Select Statement & the WHERE clause
• Limit, format & source output

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

THE EXPERT

Martin Holzke’s programming career started while studying Physics in the late 1980’s when he took on an offer to learn to program at Philips instead of the more common student jobs. Once graduated, he started his own business developing applications and systems as a freelance IT Consultant which he does to this day. His 25+ years’ journey continues to take him through a vast array of technologies, methodologies and languages like OOP, UML, C++, .NET, ADF, PHP, Zend, Oracle and SQL to name just a few.

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

KEY FEATURES

Start learning SQL with practical examples, and you’ll be working with tons of popular database systems like MySQL and PostgreSQL in no time. This course will teach you how exactly SQL works so you can start to master effective database design overall. These SQL skills have the power to open immense career opportunities from working as a database administrator in IT to working from home as a freelancer.

• Learn database installation & SQL fundamentals
• Study Data Manipulation Language Clauses, Various Conditions and Operators, Data Filtering & more
• Understand SQL Data Types in more detail
• Study the MySQL Workbench, a unified visual tool for database development
• Study SQL Joins, SQL functions & SQL data types
• Understand database relationships & normalization
• master database export & import

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

THE EXPERT

Pradnyankur Nikam is a freelance PHP and WordPress developer from Pune, Maharashtra, India. He has more than seven years of practical experience working in web designing & development, SEO (Search Engine Optimization), SMO (Social Media Optimization), Online Marketing and more. He designs web applications for clients using HTML5, CSS3, JavaScript, JQuery, Ajax, PHP, MySQL, and WordPress. He’s also familiar with Java and Android application development.

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

KEY FEATURES

Most businesses use Excel as a basic tool for decision making and modeling, but what happens when you have too much data to use an Excel spreadsheet? It’s time to move to a database. This course will help you make the move without being intimidated by the new environment. You’ll dive deep into seemingly complex topics like joins, aggregate operators, and interfacing with databases.

• Study SQL in depth w/ 67 lectures & 14 hours of content
• Learn queries in detail & steer clear of career-limiting mistakes
• Get help from quirky learning tools: repetition, zooming out to remember the big picture, quizzes, a peppy soundtrack & art
• Study database fundamentals & “just enough” theory
• Explore large datasets & uncover insights
• Model & create a database for day-to-day use
• Interface with databases from a programming language such as Python
• Load data & use both GUI and a command line interface for database operations

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

THE EXPERT

Loonycorn is comprised of four individuals—Janani Ravi, Vitthal Srinivasan, Swetha Kolalapudi, and Navdeep Singh—who have honed their tech expertise at Google and Flipkart. The team believes it has distilled the instruction of complicated tech concepts into funny, practical, engaging courses, and is excited to be sharing its content with eager students.

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

KEY FEATURES

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

• Grow your MySQL skills w/ over 84 lectures & 12 hours of content
• Gain a solid foundation in PHP & MySQL
• Discover how to use PHP variables & debug PHP code
• Learn how to read a configuration file
• Discover the basics of using a PHP library
• Study common security threats
• Understand the MySQL architecture & installation process
• Learn database design & administration
• Use indexing for database performance

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

THE EXPERT

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.

KEY FEATURES

MySQL is a general purpose relational database management system (RDBMS) used mainly to provide a back-end database for web applications. In this course, we’ll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular. Unlike traditional courses that concentrate mainly on theory, this course takes a practical “how-to” approach to working with data.

• Learn to create databases & tables w/ 20 lectures & 2 hours of instruction
• Add data to a table w/ INSERT
• Read a table w/ SELECT
• Study how to use WHERE to filter data
• Use ORDER BY to sort data
• Read from multiple tables w/ JOINs
• Change data in a table w/ UPDATE
• Remove one or more rows of data from a table w/ the DELETE query
• Use a text file to load a database schema

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

THE EXPERT

The EDUmobile Academy was founded in 2008 as a bootstrapped initiative of Vishal Lamba, who has been actively involved in the technology space since 1989. They’re very passionate about creating courses that have world class standards, and providing heroic support to their community of learners. Every course is created by USA based, technologically qualified mentors, having an absolutely clear diction and command over spoken English. Over the years, they’ve provided guidance and training to a developer community of over 80,000.

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

KEY FEATURES

Take your marketing skills to new heights by mastering technical SQL data analysis. SQL allows you to better understand customer behavior so you can create targeted, data-driven marketing strategies. Marketers are not required to have the same SQL know-how as SQL developers, which is why this course focuses on the skills you need to be an in-demand technical marketer.

• Learn marketing SQL techniques w/ over 41 lectures & 4 hours of content
• Learn the initial setup process & basic concepts
• Study the six components that make up every SQL query
• Use SQL to query any database
• Get pre-built queries to extract info about your users
• Learn to find your most profitable users
• Run a cohort analysis

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

THE EXPERT

Justin Mares formerly ran growth at developer tools company Exceptional (acquired by Rackspace in March of 2013). While there, he taught himself how to become a technical marketer and use tools like SQL to run important analyses on customer data. He is also the co-author of Traction Book, which details how startups can get traction, and founded e-commerce company Kettle & Fire (which hit a multi-million dollar run rate in just a few months).

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

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

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.

KEY FEATURES

You may have heard the term LAMP, and WAMP is an equivalent Web stack for Windows operating systems. Together, Windows, Apache, MySQL, and PHP become the canvas on which amazing apps are developed. This course will teach you to create a database using WAMP and SQL so that you will be able to manage extremely large amounts of data with ease.

• Create a database using WAMP & SQL w/ 46 lectures & 3 hours of content
• Design a complex database for any line of business application
• Write complex SQL statements
• Manipulate a massive amount of data in milliseconds
• Understand what a relational database is
• Understand primary & foreign keys
• Study SQL statements, views, stored procedures, triggers & user-defined functions
• Install WAMP & MySQL

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

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.

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.