SQL Database Administrator!
Become a successful SQL analyst!
- Introduction
- Installation and getting started
- Case Study: Demo
- Fundamental SQL statements
- Restore and Back-up
- Selection commands: Filtering
- Selection commands: Ordering
- Alias
- Aggregate Commands
- Group By Commands
- Conditional Statement
- JOINS
- Subqueries
- Views and Indexes
- String Functions
- Mathematical Functions
- Date-Time Functions
- Pattern (String) Matching
- Data Type conversion functions
- User Access Control Functions
- Bonus Section: Nail that Interview!
- Performance tuning tips
- Bonus Section: Database Basics
- Supplementary Resources
- Obtain Your Certificate
- Get Your Insurance Now
- Feedback
Company Profile
At Knowledge Door, they provide a wide range of internationally recognized qualifications to industry standards, developed and supported by teaching and professional experts. They are partnered with some of the largest accreditors in the world, so wherever their students go and whatever they want to do, the certificates they provide are fully accepted by the industry.
Their course content is engaging and inventive, making students enjoy the experience and relish the opportunity to do more while ensuring that they have a clear vision of what they want to achieve once they have attained their qualifications.
Highlights
SQL Database Administrator
Pay QR39 instead of QR992
- This course will teach you how to manage SQL (Structured Query Language) databases such as MySQL, PostgreSQL, SQLlite and more
- SQL now is a great skill to have if you want to work as a data analyst, data scientist, BI developer, data engineer, database administrator or even a software developer/engineer, since all these jobs need to use databases and data in a daily basis
- Buying the course and planning to move? No problem! You can access the course from anywhere in the world
- You’ll be assessed as you progress throughout the course and you can easily track your progress in your user area
What You Will Learn:
- You will be able to select & filter data using SQL, fetch data for useful reports based on different requirements
- Manipulate data by adding new records & modifying or deleting existing ones
- Create & modify tables with setting constraints to columns
- Learn some of the most useful built-in functions in SQL, as well as data type conversion
- Join tables using different join types SQL provides
See below for course outline!
Fine Print
- Valid from 27 Aug – 27 Oct 2021
- Redemption period: 2 months from deal’s start date
- Refunds/cancellations are NOT permitted once the voucher has been redeemed
- One voucher per person
- May buy multiple vouchers as gifts
- Upon completion of the course, you will be eligible to a PDF certificate at the cost of £12; a hard copy can also be posted to your address (certificate fee and delivery charges apply)
- For information/inquiries, visit: https://knowledgedoor.co.uk/course/sql-database-administrator/ or contact via https://knowledgedoor.co.uk/get-in-touch/
- Internet access and audio required
- Not valid with other offers
- No cash value/No cash back/No refunds
How to Redeem:
- Go to https://knowledgedoor.co.uk/redeem-voucher/
- Fill in the form
- Click REDEEM NOW
- Start the course
Please see the terms for all deals here