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.