SQL And Databases – Heavy Lifting

$99.00

Create, Customize & Retrieve Data From Database Management Systems Such as MySQL

Mode Of Learning: Online

Access Duration: 365 days

Category:

Description

Sifting through large masses of data doesn’t need to be painful, and SQL makes sure of that. This handy language lets you easily manage the contents a variety of databases, including MySQL, SQL Server, and more. You’ll learn to easily create tables, populate them, and retrieve their data, allowing you to make sense of any mass of information that really isn’t as unmanageable as you might think.

COURSE OVERVIEW

What’s Inside

  • Master SQL & general database management principles w/ 14 hours of content
  • Design & create tables, and fill them w/ data
  • Install, set up & create a database within MySQL
  • Learn powerful queries to extract exactly the information you need from MySQL & SQLite
  • Slice & dice data using the SQL Joins clause, subqueries, constraints & more
  • Master advanced database concepts: indices, triggers, transactions, etc.
  • Use Python to interface w/ databases

COURSE CONTENTS

TARGET AUDIENCE

Experience level required: all levels