Introduction to SQL
If You search then Introduction to SQL is best choice, Buy it now for Price is 69.00
Learn the key concepts of Structured Query Language (SQL) , and gain a solid working knowledge of this powerful and universal database programming language
In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques
First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure
Next, you'll discover how to use SQL to filter retrieved data and how to use SQL to sort and retrieve data from tables
You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns
You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries
In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements
We'll also cover how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables
You'll discover how transaction processing, constraints, and indexes are implemented in SQL
And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL
By the end of this course, you'll have a solid working knowledge of structured query language
You'll feel confident in your ability to write SQL queries to create tables
retrieve data from single or multiple tables
delete, insert, and update data in a database
and gather significant statistics from data stored in a database
Course Revised February 2016
Related Product Introduction to SQL
Grammar Refresher
Whatever your goals, a grasp of English grammar will help you refine your communication skills
You'll explore the basics of English grammar-like sentence structure and punctuation-and more advanced concepts-like logic and clarity
Along the way, a patient hands-on instructor will always support you
Have some fun with grammar lessons that include a touch of humor, straightforward, accessible examples, and lots of interactive exercises
Reacquaint yourself with old rules, meet some new ones, and discover your own grammatical strengths
Benefits of Instructor-Led Courses: Two lessons are released each week, so you never feel overwhelmed with your workload Access an expert instructor to reinforce your learning and get feedback Learn from your peers and engage in weekly discussion forums
Price : 69.00
Intermediate Oracle
Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran
PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL)
This course will give you the skills you need to write powerful and flexible programs using that language
You'll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions
Then, you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing
By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.
Price : 65.00
Creating WordPress Websites
Learn how to create attractive, sophisticated blogs and websites-without any coding! WordPress is the world's most popular website publisher, powering more than 25% of all sites on the Internet
WordPress is an easy-to-use solution that will help you put your site on the Web in far less time than by coding, and at a much lower cost than hiring a professional
In these lessons, you'll get hands-on experience with this powerful tool as you create your own WordPress.org site and blog
You'll find out how to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features
You'll discover the ease of using WordPress design themes to express your creativity, and you'll see how much fun it is to be part of the vibrant WordPress online community
In addition to mastering the technical elements of WordPress, you'll learn how to organize a blog or website, create appealing content, keep your site secure, and achieve better positions on search engine results pages
By the end of this course, you'll be able to confidently use WordPress to create a blog or a personal, business, or organizational website
The WordPress.org version covered in this class is the platform the pros use
While it normally requires a paid hosting account, this course includes a totally free, no obligation SiteGround hosting account for three months, along with a private place on the Web for practice
Course Revised June 2016
Price : 65.00
Publish and Sell Your E-Books
Indie authors are becoming overnight sensations in the New York Times and USA Today, on Amazon, and well, everywhere e-books are sold, proving there's no longer a stigma to self-publishing
In some genres self-published e-books even outsell those from traditional publishers, because readers are looking for new authors and stories that aren't written using a formula
And if you're in business, an e-book can be your new business card and play an important part in your content marketing plans
If you can use a word processor, have a book written-or have an idea for one-and want to see your name in print, you just might have what it takes to succeed in self-publishing
This six-week long course introduces you to everything you need to know to do a professional job of turning your manuscript into your dream-come-true, a book that will help you make money on the Internet, whether you want to self-publish a novel, a nonfiction book, or a picture book
You'll learn how to format your e-book and get it ready to sell through bookstores like Amazon and Apple
By the end of the course, you could have your e-book published in over 100 countries worldwide and available to libraries and book clubs! Whether you're a first-timer or have already put out an e-book or two, this course puts you inside the publishing industry, sharing the tricks of the trade used by traditional publishers to make sure their books are in the best position to be found by readers
You'll meet a dozen other writers just like you, who've made it big self-publishing e-books
Plus, you'll have a Market and Make Money assignment with each lesson, to walk you through the basics of developing a plan to sell your e-books
This course and its follow-up, Introduction to Internet Writing Markets, take you step-by-step through publishing your own e-books and building your writer's platform or brand, to be successful selling them
Take the first step to publishing success, and sign up today! Course Revised December 2015
Price : 9.00
