Get $1 credit for every $25 spent!

Ultimate SQL Bootcamp

Ending In:
Add to Cart - $49
Add to Cart ($49)
$408
87% off
wishlist
(137)
Courses
9
Lessons
548
Enrolled
1,369

What's Included

Product Details

Access
Lifetime
Content
14 hours
Lessons
86

A SQL Server, ASP.NET, CSS, C# & jQuery Course

Combine the Power of Various Technologies to Produce Engaging Web-Based Software

By Tom Owsiak | in Online Courses

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
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.

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

Course Outline

  • Introduction: Get the Needed Software
    • Get SQL Server 2014 Express (7:53)
    • Get Microsoft Visual Studio Express 2013 for Web (2:59)
    • Configure the Layout of Panels in the Management Studio and Visual Studio (5:30)
    • Update VS with SQL Server Tools (1:46)
  • Querying Basics
    • Create a Table and Write a Simple Query and Display the Results (11:13)
    • Write a Query with a Where Restriction (6:55)
    • Write a Query with a Where and an Order By (7:31)
    • Using Between and Not Between
    • Aliasing Columns
    • Aliasing Computed Columns
    • Use The Query Designer
    • Make An ASP.NET Webpage with SQL Server
    • Group By
    • Having Clause
    • Select Into
    • Add Multiple Parameters to an ASP.NET Page
  • Table Manipulation
    • Table Creation and Data Insertion
    • Updating and Deleting Records
    • ASP.NET Page with Updating and Deleting
    • 1st Normal Form
    • Second Normal Form
    • Third Normal Form
  • Table Joins
    • Inner Join
    • Inner Joins with Editor Window and Where Statements
    • Left Join
    • Left Joins with Editor and Where Statment
    • Right Join
    • Right Joins with Query Editor and Filtering Conditions
    • Full Joins with The Query Editor
  • Build an ASP.NET Page With Multiple Tables and Controls
    • Generate the Tables in SQL Server with Query Editor and Select Into
    • Create the User Interface and Add Logic with C#
  • Create an XML Powered ASP.NET Page
    • Create a Table Suited For XML Output
    • Create a Page With a Control That Connects to the XML Table
  • Using SQL Server Functions and Operators
    • In Logical Operator
    • Like and And
    • Scalar Functions
    • Aggregate Functions
    • Understanding the Over Clause
  • Subqueries
    • Subqueries in Select Clauses
    • Subqueries in From
  • Stored Procedures and Programming Constructs
    • Write and Execute a Simple Stored Procedure
    • Add Parameters
    • Add IF/Else Blocks and Begin/End
    • Case and When Statements with Functions
    • While Blocks, Variables and Casting
    • Stored Procedures with Output Parameters
    • Try/Catch Error Handling
    • Call a Stored Procedure from an ASP.NET Page
    • Common Table Expressions
    • Comparing Values Between Records with the Lag Function
    • Using the Lead Function with Grouped Data and CTE's
    • CTE with Inner Join and Aggregating Functions
    • Nesting Functions and Pivoting Tables
  • User Defined Functions
    • Scalar Valued Functions
    • Table valued Functions
    • Table Variables
  • Triggers and Views
    • Write a View
    • Write a Trigger
  • Transactions
    • Begin Transaction and Committ Transcation
    • Rollback Transaction
    • Saving Transactions
  • Build a Simple, Secure Data Entry System with Validation and Trasactions
    • Make the Table, and Write the Stored Procedure
    • Add C# Code and Make a Simple Interface
    • Improve the Interface with Ajax, JQuery and CSS
    • Make One Small Change
  • Administration
    • Adding Logins and Users
    • Database Roles with Users
    • Backups, Restores, Detaching and Attaching
    • Importing Data From Excel
  • Make a Dashboard Website
    • Make the Names Table, Create a VS Project, Add JQuery and Make a Dashboard Contr
    • Add a Second Table with Nested While Loops
    • Add a Trigger and a Stored Procedure and Try the Results
    • Add a Grid View to Synchronize with the Details View
    • Add A Summary Table and a New Dashboard Control
    • Add Charting and Centralize Formatting Using a Style Sheet
    • Make the Panels Stay in Place with AJAX
    • Add A Trigger to Delete Records
    • Add a Panel for Adding New Sales Records
    • Add Theme Switching For Greater User Friendliness
    • Centralize JavaScript and JQuery Files and Add Improved Formatting and a Sticky
    • Add Saving to Local Storage in HTML 5 For a Better Sticky
    • Adding Validation
    • Printing GridViews to Printers, Google Drive, and the Cloud
    • Sticky with Keyup Function in JQuery
  • Misc
    • Adding, Altering and Dropping Stores Procedures
  • Conclusion
    • What To Do Next

View Full Curriculum


Access
Lifetime
Content
6 hours
Lessons
55

SQL Database for Beginners

Master SQL Database Creation & Development with Guru Martin Holzke

By LearntoProgram | in Online Courses

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
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.

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

Course Outline

  • Relational Databases
    • What are Databases? (7:24)
    • What is the Role of Databases in Application Programming (7:56)
    • Tables and Relations (14:40)
    • Primary and Foreign Keys, and Other Constraints (12:00)
    • Chapter 1 Lab Exercise
  • SQL Querying
    • What is Querying (2:40)
    • The ANSI SQL Standard (3:59)
    • DML, DDL and More (5:07)
    • Common Query Tools (8:27)
    • Chapter 2 Lab Exercise
  • Your First Queries
    • The SELECT Statement (6:17)
    • Limiting Output Columns (4:57)
    • Formatting and Sorting Output (15:22)
    • Column Aliases (6:19)
    • Chapter 3 Lab Exercise
  • Filtering your Results
    • The WHERE Clause (4:57)
    • Creating a Filter Condition (7:19)
    • Multiple Filter Conditions (8:13)
    • More Filter Operations (11:21)
    • Chapter 4 Lab Exercise
  • Consolidating your Data
    • Counting Records (5:14)
    • Common Aggregate Functions: SUM, AVG, MIN, MAX (8:06)
    • Do's and Don'ts when Consolidating (8:38)
    • Union and Other Multiset Consolidations (10:57)
    • Chapter 5 Lab Exercise
  • Grouping your Data
    • The GROUP BY Clause (9:59)
    • The HAVING Clause (5:36)
    • Do's and Don'ts when Grouping (6:09)
    • Chapter 6 Lab Exercise
  • Joining Tables
    • Table Aliases (6:54)
    • Inner Joins (14:58)
    • Outer Joins (14:08)
    • Self Joins (8:00)
    • Complex Multi Table Joins (19:57)
    • Chapter 7 Lab Exercise
  • Subqueries
    • Filtering Using Subqueries (14:09)
    • The EXISTS Clause (6:49)
    • Subqueries as Alternatives to Joins (7:09)
    • Derived Tables (5:39)
    • Chapter 8 Lab Exercise
  • Manipulating your Data
    • The INSERT Statement (20:46)
    • The UPDATE Statement (12:50)
    • The DELETE Statement (6:26)
    • Chapter 9 Lab Exercise
  • Transaction Control
    • What are Transactions? (5:24)
    • Initiating a Transaction (4:17)
    • The COMMIT and ROLLBACK Commands (4:22)
    • Chapter 10 Lab Exercise
  • Creating Database Objects and Adding Business Logic
    • Creating Tables (16:39)
    • Creating and Using Views (9:15)
    • Developing and Calling Stored Procedures (10:41)
    • Implementing Triggers (9:25)
    • Chapter 11 Lab Exercise
    • Lab Solutions

View Full Curriculum


Access
Lifetime
Content
9 hours
Lessons
115

SQL Tutorial: Learn SQL with MySQL Database

Learn SQL & Database Development with the Experts

By Pradnyankur Nikam | in Online Courses

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
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.

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

Course Outline

  • Introduction
    • Lecture 1: Course Introduction (1:13)
    • Lecture 2: What is SQL? (2:23)
    • Lecture 3: Who should learn SQL? (2:17)
  • Setup a Testing Environment
    • Lecture 4: Install MySQL database server on Windows operating system (13:31)
    • Lecture 5: Install MySQL database server on Mac operating system (12:49)
    • Lecture 6: Install MySQL database server on Linux operating system (6:58)
    • Lecture 7: How to add a new database user and add privileges (10:04)
    • Lecture 8: MySQL Command Line Client shortcut for Windows users (6:40)
  • An Overview of SQL
    • Lecture 9: What is DBMS and RDBMS? (3:02)
    • Lecture 10: Difference between Database Engine, Database Server and Database Software (2:31)
    • Lecture 11: What is a database? How to create and use a database? (5:53)
    • Lecture 12: What is a database table? How to create and use a database table? (8:44)
    • Lecture 13: How to add the data rows to a database table? (7:19)
    • Lecture 14: Understand Keywords, Identifiers, Constants and Clauses (2:56)
    • Lecture 15: Learn about SQL Statements (1:30)
    • Lecture 16: Data Definition Language(DDL) and Data Manipulation Language(DML)? (2:34)
  • Important SQL Clauses (Data Manipulation Language)
    • Lecture 17: Create example databases, tables and data rows (10:50)
    • Lecture 18: Learn about SQL SELECT Clause (5:33)
    • Lecture 19: SQL SELECT DISTINCT Statement (5:16)
    • Lecture 20: Learn about SQL FROM Clause (3:10)
    • Lecture 21: Learn about SQL WHERE Clause (4:56)
  • Conditions and Operators (Data Manipulation Language)
    • Lecture 22: SQL True Condition (4:18)
    • Lecture 23: SQL False Condition (4:42)
    • Lecture 24: SQL AND Operator (5:59)
    • Lecture 25: SQL OR Operator (6:58)
    • Lecture 26: SQL IN Operator (5:09)
    • Lecture 27: SQL EXISTS Condition (7:49)
    • Lecture 28: SQL NOT IN or NOT EXISTS? Conditions (4:48)
    • Lecture 29: SQL Comparison Operators (4:17)
    • Lecture 30: SQL LIKE Operator (5:40)
    • Lecture 31: SQL BETWEEN Operator (4:35)
    • Lecture 32: SQL Numeric Operators (4:14)
    • Lecture 33: SQL Concatenation Operator (2:22)
    • Lecture 34: SQL Temporal Operator (1:59)
  • Data grouping, sorting, select and dates (Data Manipulation Language)
    • Lecture 35: Learn about SQL GROUP BY Clause (7:34)
    • Lecture 36: Learn about SQL HAVING Clause (5:45)
    • Lecture 37: Learn about SQL ORDER BY Clause (4:53)
    • Lecture 38: SQL LIMIT or TOP Clause (2:55)
    • Lecture 39: SQL Wildcards (4:56)
    • Lecture 40: SQL Aliases (6:05)
    • Lecture 41: SQL Dates (4:07)
  • Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
    • Lecture 42: Add the data rows in a table using INSERT INTO Statement (6:04)
    • Lecture 43: SQL INSERT INTO SELECT Statement (6:10)
    • Lecture 44: Update data rows using UPDATE Statement (7:10)
    • Lecture 45: Delete data rows using DELETE Statement (3:38)
    • Lecture 46: What is SQL Injection and How to secure a database? (5:49)
  • SQL JOINS (Data Manipulation Language)
    • Lecture 47: What are JOINS in SQL? Types of SQL JOINS (5:01)
    • Lecture 48: Learn about INNER JOIN in SQL (11:05)
    • Lecture 49: Learn about LEFT OUTER JOIN in SQL (7:31)
    • Lecture 50: Learn about RIGHT OUTER JOIN in SQL (7:32)
    • Lecture 51: Learn about FULL OUTER JOIN in SQL (3:52)
    • Lecture 52: Learn about CROSS JOIN in SQL (4:29)
    • Lecture 53: SQL UNION Operator (4:31)
    • Lecture 54: SQL VIEWS (8:12)
    • Lecture 55: Derived Tables or Inline Views (5:22)
  • SQL Functions
    • Lecture 56: Functions in SQL and Types of SQL functions (1:17)
    • Lecture 57: SQL COUNT() Function (6:02)
    • Lecture 58: SQL FIRST() Function (2:26)
    • Lecture 59: SQL LAST() Function (2:47)
    • Lecture 60: SQL SUM() Function (2:52)
    • Lecture 61: SQL MIN() Function (3:27)
    • Lecture 62: SQL MAX() Function (3:14)
    • Lecture 63: SQL AVG() Function (3:12)
    • Lecture 64: SQL UCASE() Function (2:27)
    • Lecture 65: SQL LCASE() Function (2:13)
    • Lecture 66: SQL MID() Function (2:51)
    • Lecture 67: SQL LEN() Function (2:25)
    • Lecture 68: SQL ROUND() Function (3:23)
    • Lecture 69: SQL FORMAT() Function (2:48)
    • Lecture 70: SQL SUBSTRING() Function (3:05)
    • Lecture 71: SQL COALESCE() Function (2:43)
    • Lecture 72: SQL CHAR_LENGTH() Function (2:45)
    • Lecture 73: SQL CAST() Function (3:41)
    • Lecture 74: SQL CASE() Function (6:25)
    • Lecture 75: SQL NULLIF() Function (6:12)
  • SQL Data Types
    • Lecture 76: What is data type in SQL? (2:04)
    • Lecture 77: Integer Numbers in SQL (Exact Values) (3:01)
    • Lecture 78: Fixed-Point Numbers in SQL (Exact Values) (3:30)
    • Lecture 79: Floating-Point Numbers in SQL (Approximate Values) (3:12)
    • Lecture 80: CHAR and VARCHAR in SQL (String Values) (2:47)
    • Lecture 81: NCHAR and NVARCHAR in SQL (String Values) (1:12)
    • Lecture 82: CLOB and BLOB in SQL (String Values) (0:57)
    • Lecture 83: DATE, TIME and TIMESTAMP in SQL (Temporal Values) (1:33)
  • Data Definition Language
    • Lecture 84: Learn how to create and display databases (4:11)
    • Lecture 85: Select and use existing database (2:45)
    • Lecture 86: Remove or delete database from database management system (2:57)
    • Lecture 87: Learn how to create the database table using right method (3:41)
    • Lecture 88: Modify or update the database table details (6:10)
    • Lecture 89: Remove or delete an existing table (2:16)
    • Lecture 90: Understand Constraints in SQL (1:00)
    • Lecture 91: NOT NULL Constraint in SQL (8:05)
    • Lecture 92: UNIQUE Constraint in SQL (6:46)
    • Lecture 93: PRIMARY KEY Constraint in SQL (3:23)
    • Lecture 94: FOREIGN KEY Constraint in SQL (10:32)
    • Lecture 95: CHECK Constraint in SQL (0:55)
    • Lecture 96: DEFAULT Constraint in SQL (4:19)
    • Lecture 97: AUTO INCREMENT or SEQUENCE in SQL (4:03)
  • Database Relationships
    • Lecture 98: Understand Database Relationship in SQL (1:43)
    • Lecture 99: One-to-One (1:1) Relationship in SQL (8:45)
    • Lecture 100: One-to-Many (1:M) Relationship in SQL (5:27)
    • Lecture 101: Many-to-Many (M:M) Relationship in SQL (7:08)
  • Database Normalization
    • Lecture 102: What is Database Normalization in SQL? (2:32)
    • Lecture 103: First Normal Form (1NF) in database normalization (1:14)
    • Lecture 104: Second Normal Form (2NF) in database normalization (1:30)
    • Lecture 105: Third Normal Form (3NF) in database normalization (1:19)
  • SQL Database Export and Import
    • Lecture 106: What is SQL Export and Import? (1:17)
    • Lecture 107: How to Export the database using SQL statement (8:32)
    • Lecture 108: How to Import the database using SQL statement (5:16)
  • MySQL Workbench
    • Lecture 109: What is MySQL Workbench? (5:14)
    • Lecture 110: Create a new user and connect to database using MySQL Workbench (4:20)
    • Lecture 111: Create, Alter, Drop database using MySQL Workbench (3:38)
    • Lecture 112: Create, Alter, Drop table using MySQL Workbench (7:34)
    • Lecture 113: Insert, Read, Update, Delete data rows using MySQL Workbench (4:19)
    • Lecture 114: Database Export and Import using MySQL Workbench (8:07)
  • Thank You!
    • Lecture 115: Thank You! (1:20)

View Full Curriculum


Access
Lifetime
Content
14 hours
Lessons
67

From 0 To 1: Heavy Lifting with SQL & Databases

Become a SQL Pro -- Conduct Exercises Using MySQL & SQLite

By Loony Corn | in Online Courses

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
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.

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

Course Outline

  • Introduction To Databases
    • Data Is A Big Deal
    • Why Do We Need A Database?
    • MySQL - Installed and Introduced (Mac OS X)
    • Setting up MySQL and the Workbench (Mac OS X) (12:47)
    • MySQL Server and Workbench installed (Windows) (6:31)
    • Entities And Attributes - Things And Stuff Which Describe Them
    • Identifying Entities Using Keys
    • The Entity Relationship (E-R) Model - Entities And Attributes
    • Relationships - What Connects Entities
    • Cardinality Of Relationships
    • The Entity Relationship (E-R) Model - Relationships
    • Mapping E-R Theory to the world of databases
  • Going From Relations To Database Tables
    • Introducing The SELECT Statement
    • Columns Have Data Types
    • Quotes and NULLS - Avoid The Gotchas
    • Simple Examples
    • More Simple Examples
    • Using the Like Operator
    • Between, In and Not In
    • A Multi-Column Select
    • Working with Dates (MySQL As Example)
  • Creating Tables And Inserting Data Into Them
    • Creating Database, Use Database and Create Table
    • Column Subtleties: Null, Primary Key and Auto-Increment
    • An Example - Sales Data
    • Insert Table - Examples
    • More Insert Table Examples
    • Referential Integrity Introduced
    • Creating a Database and Using It
    • An Involved Bulk Loading Example
  • Back To Retrieving Data - More Advanced Queries Using Group By
    • Aggregation Operators Introduced
    • The Group By Clause
    • More Group By Examples
    • Order By
    • Limit
    • Count and Count Distinct
  • Joins - Don't Let Them Intimidate You! They're All Fuzzy And Nice
    • Introduction To SQL Joins
    • Cross Joins aka Cartesian Joins
    • Inner Joins
    • Left Outer Joins
    • Right, Full Outer Joins, Natural Joins, Self Joins
    • Having
  • Subqueries: Layering The Cake
    • Subqueries Introduced
    • Union, Union All, Intersect and Except.
    • Query-In-A-Query (13:53)
    • Inserting Via Subqueries
    • Use A Subquery To Populate A Table
    • Outer Join And Inner Join: A Little Test
  • Constraints
    • Not NULL constraints
    • Primary Keys (9:43)
    • Foreign Key Constraints
    • Deletes and Updates With Foreign Key Constraints
    • Check Constraints
  • Somewhat More Advanced Concepts
    • Indices
    • Stored Procedures
    • Triggers
    • Transactions
    • Handle with Care: Update and Delete
    • Handle with Care: Alter and Drop
    • Views, Temporary Tables, and User Priviliges
  • Table Design: Theory And Practice
    • Practical Tips for Table Designs that you won't regret!
    • More Practical Design Tips
    • Normal Forms - Friends Once You Know Them
  • Putting It Together: Database Programming In Python
    • Interfacing with Databases from Python
    • SQLite works right out of the box
    • Build a database of Stock Movements - I
    • Build a database of Stock Movements - II
    • Build a database of Stock Movements - III

View Full Curriculum


Access
Lifetime
Content
12 hours
Lessons
84

Learn Beginner PHP & MySQL the Easy Way

Get Ready to Take Your Web Development Skills to the Next Level

By Simon Sez IT | in Online Courses

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
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.

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

Access
Lifetime
Content
2 hours
Lessons
20

An Introduction to MySQL Database Development

A Practical “How-To" Approach to Working with MySQL

By EDUmobile Academy | in Online Courses

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
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.

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

Course Outline

  • Introduction and Installation
    • Installing MySQL (5:33)
    • Showing, Creating, and Using Databases (2:46)
    • Creating Tables, Inserting and Showing Data (6:26)
    • MySQL Data Types (12:47)
    • Creating an Auto Incrementing Primary Key (8:06)
  • MySQL Basic Query Statements
    • Describe Table Syntax (3:59)
    • Loading SQL Files into MySQL (6:55)
    • Select Query Syntax Introduction (6:34)
    • Select Query Demo (5:16)
  • MySQL Advance Statements
    • Update Query Syntax (3:15)
    • Mathematical Operations (6:06)
    • Distinct, Count, and Group by (4:02)
    • Table Relationships (7:47)
    • Intro to Joins (5:55)
  • MySQL Advanaced Statements Part 2
    • The Delete Query (4:36)
    • Types of Joins (6:04)
    • Joins Demo (4:36)
    • Creating and Using Views (2:43)
    • Setting up a Many to Many Relationship (4:36)
    • Demo of Many to Many Relationship (6:32)

View Full Curriculum


Access
Lifetime
Content
2 hours
Lessons
26

SQL for Marketers

Learn How to Write SQL Queries & Conduct Data Analysis

By Justin Mares | in Online Courses

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
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.

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

Course Outline

  • Intro to SQL for Marketers
    • Welcome to Data Science with SQL for Marketers (1:44)
    • What is SQL? (3:13)
    • Your Test Database
    • SQL Querying Example (3:10)
    • Try This Now
    • Setting Up SQL Tools (1:30)
    • Using SQL Pro (4:38)
  • The Marketer's Guide to SQL
    • Table Structures, SELECT, FROM, and WHERE (4:52)
    • SELECT, FROM, and WHERE Challenge (0:35)
    • SELECT, FROM, and WHERE Challenge Answer (0:36)
    • The JOIN Statement (2:47)
    • JOIN Statement Challenge (0:24)
    • JOIN Challenge Answer (0:59)
    • Sorting and Limiting (1:55)
    • Sorting and Limiting Challenge (0:08)
    • Sorting and Grouping Challenge Answer (0:46)
    • Count and Additional Functions (1:57)
  • Tie it all Together
    • Exercise 1 (0:24)
    • Exercise 1 Answer (2:33)
    • Exercise 2 (0:15)
    • Exercise 2 Answer (2:10)
    • Exercise 3 (0:33)
    • Exercise 3 Answer (2:58)
    • Exercise 4 (0:18)
    • Exercise 4 Answer (2:14)
  • Conclusion
    • Conclusion (0:32)
    • New Lecture

View Full Curriculum


Access
Lifetime
Content
6 hours
Lessons
49

SQL Database MasterClass: Go from Pupil to Master

Get Immediate Hands-On Experience Working with Databases

By Bill Sims | in Online Courses

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
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.

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

Course Outline

  • Introduction to SQL
    • Intro to SQL a 101 Guide to Designing and Building Your First Database (5:28)
  • Lets Recreate a Video Course Database
    • Lets Talk About Tables And How They Are Used In SQL (1728:02)
    • What Would This Database Need If We Were Recreating A Video Course Site? (7:33)
    • Lets Make The Person Table (15:04)
  • Primary and Foreign Keys
    • How to Create Keys In SQL And Why (10:18)
    • Look What Keys Buy You (1:50)
  • Lets Fill In Our Datapoints
    • Adding Data To Your Database (11:35)
  • The Select
    • Select Statement In SQL (10:13)
    • The Anatomy of the Select Statement in SQL (3:45)
    • Select Exercises to Help You Learn SQL Faster (3:50)
    • What Else Can You Do WIth The Select (17:05)
    • Lets Talk About The Order By Clause In SQL (6:54)
    • Lets Talk About The Order By Clause In SQL (7:15)
    • Lets Discuss The Like and the In Statements (8:02)
    • Basic Database Analytics - Introducing Aggregate Functions (11:25)
    • More Complex Analytics: Group By Clause (7:48)
  • Sub-Queries
    • What Is A Subquery
  • Joins In SQL
    • The Beauty That Is Inner Joins (15:33)
    • Left Outer Joins The Tool That Saves (7:27)
  • User Defined Functions
    • Introduction to User Defined Functions (2:06)
    • Scalar Function (10:22)
    • Table Functions (4:52)
  • The View
    • Lets Talk About Views (5:24)
  • Stored Procedures The V8 of the SQL World
    • Our First Stored Procedure (6:39)
  • Insert Update Delete Statements in SQL
    • Insert Statements in SQL (2329:23)
    • Update Statements in SQL (5:47)
    • SQL Delete Statement (6:54)
  • Getting Real Deep in SQL
    • Adding Random Data To Play With (7:56)
  • Introducing the Pivot
    • Intro to Pivot and Unpivot (2:21)
    • Our First Example Of A Pivot (6:34)
  • Trouble Shooting and Optimizing Your Database
    • A Intro To SQL Profiler (7:25)
    • A How To On Optimizing Our Datbase (4:21)
    • Adding Our First Indexes To Our Database (9:40)
    • Create a Script to Index All Foreign Keys (25:41)
  • SQL Server Reporting Services SSRS
    • Installing SQL Report Builder 3.0 (1:52)
    • A Very Basic SSRS Report (2:44)
  • Random Tips That Make Life Easier
    • How To Use Templates For Quick Access To SQL (2:33)

View Full Curriculum


Access
Lifetime
Content
3 hours
Lessons
46

Complete WAMP & MySQL Course

Install WAMP & MySQL - Then Use the Tools Together to Create a Database

By Bill Sims | in Online Courses

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
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.

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

Course Outline

  • First Section
    • 1) intro (0:41)
    • 3) What is a Database? (1:35)
    • 4) What will this class cover? (0:47)
    • 5) Lets discuss a music festival (1:46)
    • 6) Look at these examples of Databases (1:42)
    • 7) Tools In Our Database Toolbox (3:10)
    • 8) Initial Discussion About Tables (5:38)
    • 9) Foreign Keys (1:49)
    • 10) Download WAMP (1:16)
    • 11) Needs Fixes Installing WAMP (3:41)
    • 12) Simple Tour Of PHPMyAdmin (1:24)
    • 13) Creating Our Database and First Table (5:14)
    • 14) Walk Through of PHP My Admin From a Database Standpoint (1:37)
    • 15) Creating Our Vendor And Customer Tables (5:47)
    • 16) Creating our first vendor and customer table (5:47)
    • 18) Filling out Our Data (8:26)
  • Second Section
    • 20) Fill Out Vendors (10:44)
    • 21) Insert 1 Record By Script (3:10)
    • 22) Massive Customer Import (4:38)
    • 23) Massive Import Script (4:38)
    • 24) Working Examples of a Select Statement (6:25)
    • 25) answers to those excercises (3:20)
    • 26) Order by Clause (3:30)
    • 27) Where Clause In Detail (4:56)
    • 28) The Like Statement (3:53)
    • 30) How to export and import data (2:15)
    • 31) Database Redesign (5:31)
    • 32) Lets do another Foreign Key (6:40)
  • Third Section
    • 33) Adding a band member table (8:09)
    • 35) Answer to exercise (0:53)
    • 36) The IN Statement (5:16)
    • 37) Using Rand Function to make random data (5:58)
    • 38) Create random demographic data (4:11)
  • Fourth Section
    • 39) What is a sub-query and how to use it (7:27)
  • Fifth Section
    • 40) SQL Exercise (1:09)
    • 42) Explanation of the exercise (2:17)
    • 43) Basic analytics using aggregate functions (1:51)
    • 45) Explanation of the analytics exercise (2:36)
  • Sixth Section
    • 46) Our first Group By (4:03)

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.